The Weird and The Wonderful

Now the most fascinating part is, that OP answered the question - twice...
I'm only regret, that this gem will vanish soon...

Skipper: We'll fix it.
Alex: Fix it? How you gonna fix this?
Skipper: Grit, spit and a whole lotta duct tape.

Kornfeld Eliyahu Peter wrote:
I'm only regret, that this gem will vanish soon...

That can be easily fixed Smile | :)

EDIT: Not that easily I guess... Copy/paste messes up the HTML a bit... Well, it's a pretty good impression anyway Smile | :)

Someone in QA wrote:
----Add.aspx-----

<%@ Page Title="" Language="C#" MasterPageFile="~/main.Master" AutoEventWireup="true" CodeBehind="Add.aspx.cs" Inherits="indianRailway.Add" %>
<asp:content id="Content1" contentplaceholderid="head" runat="server">

.auto-style1 {
text-align: left;
}
.auto-style3 {
font-size: xx-small;
}
.auto-style4 {
text-align: left;
}

<asp:content id="Content2" contentplaceholderid="ContentPlaceHolder1" runat="server">

EMPLOYEE DETAILS

Train No.

<asp:textbox skinid="abc" id="TextBoxTrainNo" runat="server" textmode="Number">
<asp:requiredfieldvalidator cssclass="popout" display="Dynamic" enableclientscript="false" id="RequiredFieldValidator1" runat="server" errormessage="Please specify" forecolor="Red" controltovalidate="TextBoxTrainNo">

Train Name

<asp:textbox skinid="abc" id="TextBoxTrainName" runat="server">
<asp:requiredfieldvalidator cssclass="validat" display="Dynamic" enableclientscript="false" id="RequiredFieldValidator2" runat="server" controltovalidate="TextBoxTrainName" errormessage="Please Specify" forecolor="Red">

Source Station

<asp:textbox skinid="abc" id="TextBoxSourceStation" runat="server">
<asp:requiredfieldvalidator cssclass="validat" display="Dynamic" enableclientscript="false" id="RequiredFieldValidator3" runat="server" controltovalidate="TextBoxSourceStation" errormessage="Please Specify" forecolor="Red">

Destination Station

<asp:textbox id="TextBoxDest" runat="server">
<asp:requiredfieldvalidator id="RequiredFieldValidator8" runat="server" controltovalidate="TextBoxDest" display="Dynamic" enableclientscript="False" errormessage="please specify" forecolor="Red">

Departure Time

<asp:textbox id="TextBoxDepart" skinid="abc" runat="server" textmode="Time">
<asp:requiredfieldvalidator cssclass="validat" display="Dynamic" enableclientscript="false" id="RequiredFieldValidator4" runat="server" controltovalidate="TextBoxDepart" errormessage="Please Specify" forecolor="Red">

Arrival Time

<asp:textbox skinid="abc" id="TextBoxArrival" runat="server" textmode="Time">
<asp:requiredfieldvalidator cssclass="validat" display="Dynamic" enableclientscript="false" id="RequiredFieldValidator5" runat="server" controltovalidate="TextBoxArrival" errormessage="Please Specify" forecolor="Red">

Available Days
(write days & use comma for seperation)

<asp:textbox id="TextBoxAvlbledays" runat="server">
<asp:requiredfieldvalidator cssclass="validat" display="Dynamic" enableclientscript="false" id="RequiredFieldValidator7" runat="server" controltovalidate="TextBoxAvlbledays" errormessage="Please Select" forecolor="Red" initialvalue="--Select--">

<asp:button text="Submit" id="Submit" runat="server" onclick="Submit_Click">

----Add.aspx.cs----

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using BLL;
using BllFactory;
using BO;
using BoFactory;
using Types;

namespace indianRailway
{
public partial class Add : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (Session["MySession"] == null)
{
((Button)Master.FindControl("Button1")).Visible = false;
((Label)Master.FindControl("Label1")).Visible = false;
string message = "Oops! for this you have to login...";
ScriptManager.RegisterStartupScript(this, this.GetType(), "redirect", "alert('" + message + "'); window.location='" + Request.ApplicationPath + "MainLogin.aspx';", true);

}
else
{
((Button)Master.FindControl("Button1")).Visible = true;
((Label)Master.FindControl("Label1")).Visible = true;
((Label)Master.FindControl("Label1")).Text = "welcome : " + Convert.ToString(Session["MySession"]);

}
}

protected void Submit_Click(object sender, EventArgs e)
{
if (IsValid)
{
IboAdmin BoObj = BoFactory.BoFactoryAdmin.CreateInstanceOfBo();
BoObj.trainNo = Convert.ToInt64(TextBoxTrainNo.Text);
BoObj.trainName = TextBoxTrainName.Text;
BoObj.sourceStation = TextBoxSourceStation.Text;
BoObj.destinationStation = TextBoxDest.Text;

BoObj.departureTime = TextBoxDepart.Text;
BoObj.availableDyas = TextBoxAvlbledays.Text;
BoObj.arrivalTime = TextBoxArrival.Text;

IbllAdmin BllObj = BllFactory.BllFactoryAdmin.CreateInstanceOfBll();
long IdCatcher = BllObj.AddOfBll(BoObj);
if (IdCatcher == 0)
{

ScriptManager.RegisterStartupScript(this, this.GetType(), "redirect", "alert('Details not saved... Please try again with Complete & correct details '); window.location='" + Request.ApplicationPath + "Add.aspx';", true);

}

else
{

ScriptManager.RegisterStartupScript(this, this.GetType(), "redirect", "alert('Your details saved sucessfully, Please note your detail ID:" + IdCatcher + "'); window.location='" + Request.ApplicationPath + "Add.aspx';", true);

}
}

}
}
}

----main.Master----

<%@ Master Language="C#" AutoEventWireup="true" CodeBehind="main.master.cs" Inherits="indianRailway.main" %>

<title>
<asp:contentplaceholder id="head" runat="server">

.auto-style1 {
font-size: xx-large;
}
.auto-style2 {
font-size: small;
}

        yourconvenience.com
<asp:label id="Label1" runat="server" font-size="Small" text="Label" visible="False">
<asp:button id="Button1" runat="server" font-size="Small" onclick="Button1_Click" text="Sign Out" visible="False">

                                                                   Manage Everything Easily

<asp:menu id="Menu1" runat="server" backcolor="#333399" borderstyle="None" font-bold="True" font-italic="True" font-underline="False" forecolor="White" orientation="Horizontal" width="1350px">

<asp:menuitem text="Home" value="Home">
<asp:menuitem text="About Us" value="About Us">
<asp:menuitem text="Contact Us" value="Contact Us">
<asp:menuitem navigateurl="~/Add.aspx" text="Add New" value="Add New">
<asp:menuitem navigateurl="~/Manage.aspx" text="Manage Earlier " value="Manage Earlier ">

<asp:contentplaceholder id="ContentPlaceHolder1" runat="server">

copyrights reserved

----main.Master.cs----

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace indianRailway
{
public partial class main : System.Web.UI.MasterPage
{
protected void Page_Load(object sender, EventArgs e)
{

}

protected void Button1_Click(object sender, EventArgs e)
{
Session.RemoveAll();
Response.Redirect("MainLogin.aspx");
}
}
}

----MainLogin.aspx----

<%@ Page Title="" Language="C#" MasterPageFile="~/main.Master" AutoEventWireup="true" CodeBehind="MainLogin.aspx.cs" Inherits="indianRailway.MainLogin" %>
<asp:content id="Content1" contentplaceholderid="head" runat="server">

.table {
height:300px;
width:400px;
margin-top:20px;
}
td {
font-size:large;
background-color:wheat;
}
.button {
height:30px;
width:150px;
color:whitesmoke;
background-color:blue;
font-size:25px;

}
.button:hover {
color:whitesmoke;
background-color:green;
}
.textbox {
height:30px;
width:150px;
font-size:27px;
}
.auto-style18 {
width: 100%;
}
.auto-style19 {
font-size: x-large;
}
.auto-style20 {
height: 530px;
width: 667px;
}

<asp:content id="Content2" contentplaceholderid="ContentPlaceHolder1" runat="server">

Simply login to enjoy our services...

Login

                               Username:

<asp:textbox id="TextBox1" runat="server">

<asp:requiredfieldvalidator id="RequiredFieldValidator1" runat="server" controltovalidate="TextBox1" enableclientscript="False" errormessage="please enter correct username" display="Dynamic" font-size="Small" forecolor="Red">

                               Password:

<asp:textbox id="TextBox2" runat="server" textmode="Password">

<asp:requiredfieldvalidator id="RequiredFieldValidator2" runat="server" controltovalidate="TextBox2" enableclientscript="False" errormessage="please enter correct password" display="Dynamic" font-size="Small" forecolor="Red">

<asp:button id="Button1" runat="server" text="login" width="85px" onclick="Button1_Click1">

-------MainLogin.aspx.cs---------

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using BO;
using BoFactory;
using BLL;
using BllFactory;
using Types;

namespace indianRailway
{
public partial class MainLogin : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
Session.RemoveAll();
}

protected void Button1_Click1(object sender, EventArgs e)
{
if (IsValid)
{
IbllLogin BllObj = BllFactory.BllFactoryLogin.CreateInstanceOfBll();
IboLogin BoObj = BoFactory.BoFactoryLogin.CreateInstanceOfBo();
BoObj.name = TextBox1.Text.ToString();
BoObj.password = TextBox2.Text;
int i = BllObj.LoginCheckBll(BoObj);
if (i == 1)
{
Session["MySession"] = TextBox1.Text.ToString();
Response.Redirect("Add.aspx");
}
else
ScriptManager.RegisterStartupScript(this, this.GetType(), "redirect", "alert('Incorrect username or password...Please try again'); window.location='" + Request.ApplicationPath + "MainLogin.aspx';", true);

}
else
{
TextBox1.Style.Add("border", "solid 1px red");
TextBox2.Style.Add("border", "solid 1px red");
}
}
}
}

----Manage.aspx----

<%@ Page Title="" Language="C#" MasterPageFile="~/main.Master" AutoEventWireup="true" CodeBehind="Manage.aspx.cs" Inherits="indianRailway.Manage" %>
<asp:content id="Content1" contentplaceholderid="head" runat="server">

<asp:content id="Content2" contentplaceholderid="ContentPlaceHolder1" runat="server">

<asp:panel height="490px" width="1200px" scrollbars="Horizontal" runat="server">
<asp:gridview id="GridView1" pagesize="15" horizontalalign="Center" verticalalign="Center" allowpaging="true" runat="server" autogeneratecolumns="False" cellpadding="4" forecolor="#333333" gridlines="None" onpageindexchanging="GridView1_PageIndexChanging" onrowcancelingedit="GridView1_RowCancelingEdit" onrowdeleting="GridView1_RowDeleting" onrowediting="GridView1_RowEditing" onrowupdating="GridView1_RowUpdating">

<asp:templatefield headertext="edit/delete">

<asp:linkbutton id="LinkButton3" commandname="Update" runat="server">Update
<asp:linkbutton id="LinkButton4" commandname="Cancel" runat="server">Cancel

<asp:linkbutton id="LinkButton1" commandname="Edit" runat="server">Edit
<asp:linkbutton id="LinkButton2" commandname="Delete" runat="server" onclientclick="return confirm('Are you sure you want to delete this?');">Delete

<asp:templatefield headertext="trainId" insertvisible="False" sortexpression="trainId">

<asp:label id="Label1" runat="server" text="<%# Eval("trainId") %>">

<asp:label id="Label11" runat="server" text="<%# Eval("trainId") %>">

<asp:templatefield headertext="trainNo" insertvisible="False" sortexpression="trainNo">

<asp:textbox id="TextBoxTrnO" runat="server" text="<%# Eval("trainNo") %>">

<asp:label id="Label111" runat="server" text="<%# Eval("trainNo") %>">

<asp:templatefield headertext="trainName" sortexpression="trainName">

<asp:textbox id="TextBoxTRnM" runat="server" text="<%# Eval("trainName") %>">

<asp:label id="Label2" runat="server" text="<%# Eval("trainName") %>">

<asp:templatefield headertext="sourceStation" sortexpression="sourceStation">

<asp:textbox id="TextBoxSorcStatn" runat="server" text="<%# Eval("sourceStation") %>">

<asp:label id="Label3" runat="server" text="<%# Eval("sourceStation") %>">

<asp:templatefield headertext="destinationStation" sortexpression="destinationStation">

<asp:textbox id="TextBoxDestStatn" runat="server" text="<%# Eval("destinationStation") %>">

<asp:label id="Label4" runat="server" text="<%# Eval("destinationStation") %>">

<asp:templatefield headertext="departureTime" sortexpression="departureTime">

<asp:textbox id="TextBoxDeprtTm" runat="server" text="<%# Eval("departureTime") %>">

<asp:label id="Label5" runat="server" text="<%# Eval("departureTime") %>">

<asp:templatefield headertext="availableDyas" sortexpression="availableDyas">

<asp:textbox id="TextBoxAvailbledays" runat="server" text="<%# Eval("availableDyas") %>">

<asp:label id="Label6" runat="server" text="<%# Eval("availableDyas") %>">

<asp:templatefield headertext="arrivalTime" sortexpression="arrivalTime">

<asp:textbox id="TextBoxArrvlTime" runat="server" text="<%# Eval("arrivalTime") %>">

<asp:label id="Label7" runat="server" text="<%# Eval("arrivalTime") %>">

<%--<asp:templatefield headertext="amount" sortexpression="amount">

<asp:textbox id="TextBoxAmt" runat="server" text="<%# Eval("amount") %>">

<asp:label id="Label8" runat="server" text="<%# Eval("amount") %>">

<asp:templatefield headertext="PreConditions" sortexpression="PreConditions">

<asp:textbox id="TextBoxPreconds" runat="server" text="<%# Eval("PreConditions") %>">

<asp:label id="Label9" runat="server" text="<%# Eval("PreConditions") %>">

<asp:templatefield headertext="PostConditions" sortexpression="PostConditions">

<asp:textbox id="TextBoxPostConds" runat="server" text="<%# Eval("PostConditions") %>">

<asp:label id="Label10" runat="server" text="<%# Eval("PostConditions") %>">

<asp:templatefield headertext="Remarks" sortexpression="Remarks">

<asp:textbox id="TextBoxRemarks" runat="server" text="<%# Eval("Remarks") %>">

<asp:label id="Label12" runat="server" text="<%# Eval("Remarks") %>">

--%>

<headerstyle backcolor="#5D7B9D" font-bold="True" forecolor="White">

<selectedrowstyle backcolor="#E2DED6" font-bold="True" forecolor="#333333">

----Manage.aspx.cs----

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using BO;
using BoFactory;
using BLL;
using BllFactory;
using Types;

namespace indianRailway
{
public partial class Manage : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

if (Session["MySession"] == null)
{
((Button)Master.FindControl("Button1")).Visible = false;
((Label)Master.FindControl("Label1")).Visible = false;
string message = "Oops! for this you have to login...";
ScriptManager.RegisterStartupScript(this, this.GetType(), "redirect", "alert('" + message + "'); window.location='" + Request.ApplicationPath + "MainLogin.aspx';", true);

}
else
{
((Button)Master.FindControl("Button1")).Visible = true;
((Label)Master.FindControl("Label1")).Visible = true;
((Label)Master.FindControl("Label1")).Text = "welcome : " + Convert.ToString(Session["MySession"]);
}
if (!IsPostBack)
{
Bindgriddata();
}

}
public void Bindgriddata()
{
IbllAdmin BllObj = BllFactory.BllFactoryAdmin.CreateInstanceOfBll();
GridView1.DataSource = BllObj.ViewGridOfBll();
GridView1.DataBind();
}

protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{

}

protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView1.PageIndex = e.NewPageIndex;
Bindgriddata();
}

protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
GridView1.EditIndex = -1;
Bindgriddata();

}

protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
GridViewRow gvr = GridView1.Rows[e.RowIndex];
int id = Convert.ToInt32(((Label)gvr.FindControl("Label11")).Text);
IbllAdmin BllObj = BllFactory.BllFactoryAdmin.CreateInstanceOfBll();
int deleteCheck = BllObj.DeleteGridOfBll(id);
if (deleteCheck == 1)
{
Page.ClientScript.RegisterStartupScript(this.GetType(),
"alertkey", "alert('Record deleted sucessfully...');", false);
}

else
{
Page.ClientScript.RegisterStartupScript(this.GetType(),
"alertkey", "alert('Record not deleted');", false);
}
GridView1.EditIndex = -1;
Bindgriddata();
}

protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
GridView1.EditIndex = e.NewEditIndex;
Bindgriddata();
}

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
IboAdmin BoObj = BoFactory.BoFactoryAdmin.CreateInstanceOfBo();
GridViewRow gvr = GridView1.Rows[e.RowIndex];

BoObj.trainId = Convert.ToInt64(((Label)gvr.FindControl("Label1")).Text);
BoObj.trainNo = Convert.ToInt64(((TextBox)gvr.FindControl("TextBoxTrnO")).Text);
BoObj.trainName = (((TextBox)gvr.FindControl("TextBoxTRnM")).Text);
BoObj.sourceStation = ((TextBox)gvr.FindControl("TextBoxSorcStatn")).Text;
BoObj.destinationStation = ((TextBox)gvr.FindControl("TextBoxDestStatn")).Text;
BoObj.departureTime = (((TextBox)gvr.FindControl("TextBoxDeprtTm")).Text);
BoObj.arrivalTime = (((TextBox)gvr.FindControl("TextBoxArrvlTime")).Text);
BoObj.availableDyas = (((TextBox)gvr.FindControl("TextBoxAvailbledays")).Text);

IbllAdmin objbll = BllFactory.BllFactoryAdmin.CreateInstanceOfBll();
int CheckUpdate = objbll.UpdateGridOfBll(BoObj);

if (CheckUpdate == 1)
Page.ClientScript.RegisterStartupScript(this.GetType(),
"alertkey", "alert('Details have been updated sucessfully');", false);

else
Page.ClientScript.RegisterStartupScript(this.GetType(),
"alertkey", "alert('Please try again with complete & correct details');", false);

GridView1.EditIndex = -1;
Bindgriddata();
}
}
}

----TypesAdmin.cs----

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Types
{
public interface IboAdmin
{

long trainNo { get; set; }
string trainName { get; set; }
string sourceStation { get; set; }
string destinationStation { get; set; }
string departureTime { get; set; }
string arrivalTime { get;set;}
string availableDyas { get; set; }
long trainId { get; set; }
}
public interface IbllAdmin
{
long AddOfBll(IboAdmin BoObj);
List ViewGridOfBll();
int UpdateGridOfBll(IboAdmin BoObj);
int DeleteGridOfBll(int x);
}
public interface IdalAdmin
{
long AddOfDal(IboAdmin BoObj);
List ViewGridOfDal();
bool UpdateGridOfDal(IboAdmin BoObj);
bool DeleteGridOfDal(int Id);
}
}

-----TypesLogin.cs----

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Types
{
public interface IboLogin
{
string name { get; set; }
string password { get; set; }
}
public interface IbllLogin
{
int LoginCheckBll(IboLogin BoObj);
}
public interface IdalLogin
{
bool LoginCheckDal(IboLogin BoObj);
}
}

----BoAdmin.cs----

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Types;

namespace BO
{
public class BoAdmin : IboAdmin
{

public long trainNo { get; set; }
public string trainName { get; set; }
public string sourceStation { get; set; }
public string destinationStation { get; set; }
public string departureTime { get; set; }
public string arrivalTime { get; set; }
public string availableDyas { get; set; }
public long trainId { get; set; }

}
}

----BoLogin.cs----

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Types;

namespace BO
{
public class BoLogin:IboLogin
{
public string name { get; set; }
public string password { get; set; }
}
}

----BoFactoryAdmin.cs----

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Types;
using BO;

namespace BoFactory
{
public static class BoFactoryAdmin
{
public static IboAdmin CreateInstanceOfBo()
{

IboAdmin BoObj = new BoAdmin();
return BoObj;
}
}
}

----BoFactoryLogin.cs----

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Types;
using BO;

namespace BoFactory
{
public static class BoFactoryLogin
{
public static IboLogin CreateInstanceOfBo()
{

IboLogin BoObj = new BoLogin();
return BoObj;
}
}
}

-----BllAdmin.cs-----

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Types;
using DAL;
using DalFactory;
using BO;

namespace BLL
{
public class BllAdmin: IbllAdmin
{
public long AddOfBll(IboAdmin BoObj)
{
long IdCatcher;
IdalAdmin DalObj = DalFactory.DalFactoryAdmin.CreateInstanceOfDal();

IdCatcher = DalObj.AddOfDal(BoObj);
if (IdCatcher != 0)
return IdCatcher;
else
return 0;
}
public List ViewGridOfBll()
{
IdalAdmin DalObj = DalFactory.DalFactoryAdmin.CreateInstanceOfDal();
List list = new List();
list = DalObj.ViewGridOfDal();
return list;
}
public int UpdateGridOfBll(IboAdmin BoObj)
{
bool value;
IdalAdmin DalObj = DalFactory.DalFactoryAdmin.CreateInstanceOfDal();
value = DalObj.UpdateGridOfDal(BoObj);
if (value)
return 1;
else
return 0;
}
public int DeleteGridOfBll(int x)
{
bool value;
IdalAdmin DalObj = DalFactory.DalFactoryAdmin.CreateInstanceOfDal();
value = DalObj.DeleteGridOfDal(x);
if (value)
return 1;
else
return 0;
}
}
}

-----BllLogin.cs-----

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Types;

namespace BLL
{
public class BllLogin : IbllLogin
{
public int LoginCheckBll(IboLogin BoObj)
{
IdalLogin DalObj = DalFactory.DalFactroyLogin.CreateInstanceOfDal();
bool value;
value = DalObj.LoginCheckDal(BoObj);
if (value)
return 1;
else
return 0;
}
}
}

-----BllFactoryAdmin.cs-----

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using BLL;
using Types;

namespace BllFactory
{
public static class BllFactoryAdmin
{
public static IbllAdmin CreateInstanceOfBll()
{
IbllAdmin BllObj = new BllAdmin();
return BllObj;
}
}
}

-------BllFactoryLogin.cs-----

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using BLL;
using Types;

namespace BllFactory
{
public static class BllFactoryLogin
{
public static IbllLogin CreateInstanceOfBll()
{
IbllLogin BllObj = new BllLogin();
return BllObj;
}
}
}

----------DalAdmin.cs-------

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Types;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using BoFactory;

namespace DAL
{
public class DalAdmin :IdalAdmin
{
SqlConnection MyConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["sqlconnection"].ConnectionString);
public long AddOfDal(IboAdmin BoObj)
{
SqlCommand MyCommand = new SqlCommand();
MyConnection.Open();
MyCommand.Connection = MyConnection;
MyCommand.CommandText = "USP_INSERT_id";
MyCommand.CommandType = CommandType.StoredProcedure;
MyCommand.Parameters.AddWithValue("@trainNo", BoObj.trainNo);
MyCommand.Parameters.AddWithValue("@trainName ", BoObj.trainName);
MyCommand.Parameters.AddWithValue("@sourceStation", BoObj.sourceStation);
MyCommand.Parameters.AddWithValue("@destinationStation", BoObj.destinationStation);
MyCommand.Parameters.AddWithValue("@departureTime", BoObj.departureTime);
MyCommand.Parameters.AddWithValue("@arrivalTime", BoObj.arrivalTime);
MyCommand.Parameters.AddWithValue("@availableDays", BoObj.availableDyas);

MyCommand.Parameters.Add("@trainId", SqlDbType.Int).Value = BoObj.trainId;
MyCommand.Parameters["@trainId"].Direction = ParameterDirection.Output;

long IdCatcher = 0;
try
{
MyCommand.ExecuteNonQuery();

IdCatcher = long.Parse(MyCommand.Parameters["@trainId"].Value.ToString());
BoObj.trainId = IdCatcher;

}
catch (Exception e)
{
throw e;
}

finally
{
MyConnection.Close();
}
if (IdCatcher > 0)
return IdCatcher;
else
return 0;

}
public List ViewGridOfDal()
{
SqlCommand MyCommand = new SqlCommand();
MyCommand.Connection = MyConnection;
MyConnection.Open();
MyCommand.CommandText = "USP_VIEW_id";
MyCommand.CommandType = CommandType.StoredProcedure;
List list1 = new List();
SqlDataReader reader = MyCommand.ExecuteReader();
while (reader.Read())
{

IboAdmin BoObj = BoFactory.BoFactoryAdmin.CreateInstanceOfBo();
BoObj.trainId = Convert.ToInt32(reader["trainId"]);
BoObj.trainName = reader["trainName"].ToString();
BoObj.sourceStation = reader["sourceStation"].ToString();
BoObj.destinationStation= reader["destinationStation"].ToString();

BoObj.departureTime = (reader["departureTime"]).ToString();
BoObj.arrivalTime = (reader["arrivalTime"]).ToString();

BoObj.availableDyas = reader["availableDays"].ToString();
BoObj.trainNo = Convert.ToInt32( reader["trainNo"]);
list1.Add(BoObj);

}
MyConnection.Close();
return list1;

}
public bool UpdateGridOfDal(IboAdmin BoObj)
{
SqlCommand MyCommand = new SqlCommand();
MyCommand.Connection = MyConnection;
MyConnection.Open();
MyCommand.CommandText = "USP_UPDATE_id";
MyCommand.CommandType = CommandType.StoredProcedure;

MyCommand.Parameters.AddWithValue("@trainNo", BoObj.trainNo);
MyCommand.Parameters.AddWithValue("@trainName ", BoObj.trainName);
MyCommand.Parameters.AddWithValue("@sourceStation", BoObj.sourceStation);
MyCommand.Parameters.AddWithValue("@destinationStation", BoObj.destinationStation);
MyCommand.Parameters.AddWithValue("@departureTime", BoObj.departureTime);
MyCommand.Parameters.AddWithValue("@arrivalTime", BoObj.arrivalTime);
MyCommand.Parameters.AddWithValue("@availableDays", BoObj.availableDyas);
MyCommand.Parameters.AddWithValue("@trainId", BoObj.trainId);

MyCommand.ExecuteNonQuery();
MyConnection.Close();
return true;
}
public bool DeleteGridOfDal(int Id)
{
SqlCommand MyCommand = new SqlCommand();
MyCommand.Connection = MyConnection;
MyConnection.Open();
MyCommand.CommandText = "USP_DELETE_id";
MyCommand.CommandType = CommandType.StoredProcedure;
MyCommand.Parameters.AddWithValue("@trainId", Id);
MyCommand.ExecuteNonQuery();
MyConnection.Close();
return true;
}
}
}

---------DalLogin.cs-------

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Types;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using BoFactory;

namespace DAL
{
public class DalLogin :IdalLogin
{
public bool LoginCheckDal(IboLogin BoObj)
{

SqlConnection MyConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["sqlconnection"].ConnectionString);
SqlCommand MyCommand = new SqlCommand();
MyCommand.Connection = MyConnection;
MyConnection.Open();
MyCommand.CommandText = "USP_LOGIN_CHECK_id";
MyCommand.CommandType = CommandType.StoredProcedure;
SqlDataReader reader = MyCommand.ExecuteReader();
int flag = 0;
while (reader.Read())
{
if ((BoObj.name == Convert.ToString(reader["name"])) && (BoObj.password == Convert.ToString(reader["password"])))
{
flag = 1;
break;
}
else
{
flag = 0;
}
}
MyConnection.Close();
if (flag == 1)
return true;
else
return false;

}
}
}

---------DalFactoryAdmin.cs-----

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Types;
using DAL;

namespace DalFactory
{
public static class DalFactoryAdmin
{
public static IdalAdmin CreateInstanceOfDal()
{
IdalAdmin DalObj = new DalAdmin();
return DalObj;
}

}
}

------DalFactoryLogin.cs------

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Types;
using DAL;

namespace DalFactory
{
public static class DalFactroyLogin
{
public static IdalLogin CreateInstanceOfDal()
{
IdalLogin objdal = new DalLogin();
return objdal;
}
}
}

------Sqls----------

use anythingsaa
drop table trainDetails_id
create table trainDetails_id
(
trainId int identity(10000,1),
trainNo bigint,
trainName varchar(30),
sourceStation varchar(40),
destinationStation varchar(40),
departureTime varchar(28) ,
arrivalTime varchar(28) ,
availableDays varchar(200)
)

select * from

create procedure USP_INSERT_id
(
@trainId int out,
@trainNo bigint,
@trainName varchar(30),
@sourceStation varchar(40),
@destinationStation varchar(40),
@departureTime varchar(28) ,
@arrivalTime varchar(28) ,
@availableDays varchar(200)
)
as
begin
insert into trainDetails_id values (@trainNo,@trainName,@sourceStation,@destinationStation,@departureTime,@arrivalTime,@availableDays)
set @trainId=@@IDENTITY
end

create procedure USP_VIEW_id
as
begin
select * from trainDetails_id
end

execute USP_VIEW_id

create procedure USP_UPDATE_id
(
@trainId int,
@trainNo bigint,
@trainName varchar(30),
@sourceStation varchar(40),
@destinationStation varchar(40),
@departureTime varchar(28) ,
@arrivalTime varchar(28),
@availableDays varchar(200)
)
as
begin
update trainDetails_id set

trainNo=@trainNo,
trainName=@trainName,
sourceStation=@sourceStation,
destinationStation =@destinationStation,
departureTime=@departureTime,
arrivalTime=@arrivalTime,
availableDays=@availableDays
where trainId=@trainId
end

Create procedure USP_DELETE_id
(
@trainId int
)
as
begin
delete from trainDetails_id
where trainId=@trainId
end

--Admin--

create table Admin_id
(
name varchar(40),
password varchar(50)
)

select * from Admin_id

insert into Admin_id values ('ggf','hfgh')
insert into Admin_id values ('dssdd','dffd')

--create procedure usp_check
--@name varchar(40) ,
--@password int
--as
--begin
--select name,password
--from Admin1
--where name=@name and password=@password
--end

create procedure USP_LOGIN_CHECK_id
as
begin
select * from Admin_id
end

insert into Admin_id values ('df','dfdfd')

My blog[^]

C#

public class SanderRossel : Lazy<Person>
{
   public void DoWork()
   {
      throw new NotSupportedException();
   }
}

Kornfeld Eliyahu Peter wrote:
Now the most fascinating part is, that OP answered the question - twice...

There was a question somewhere???? OMG | :OMG:

--
"My software never has bugs. It just develops random features."

Oh, I didn't see this before taking a chainsaw to the fracking thing.

And he's reposted it a couple of times as well. I have a suspicion that he wants to be able to show that he has answered a question on CP either for a class or for a job interview.

modified 21-Dec-14 23:29pm.

Should just have replied "No".

PooperPig - Coming Soon

Or just "You missed a bit" Wink | ;)

Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...

:thud: :thud: :thud:

Please somebody help me counting layers.... Sigh | :sigh:

"When you don't know what you're doing it's best to do it quickly"- SoMad

This is an actual Cover Letter I received in response to a job posting for an experienced Web/Java Application Developer position...

Should I hire this guy to see how quickly he gets "quite fatigued by the repitition of coding exercises"?

Recruiting or Hiring Official:

Let me start off by saying that my degree in English can be a bit misleading. I imagine that it suggests that my writing skills are more than acceptable for most tasks; in that regard, it gives the correct impression. I also imagine that it suggests that I also have a high familiarity with various forms of literature; in that regard, it’s a bit less meaningful. Certainly, I have read a good deal of literature, but I have no particular specialization on the subject, and it’s definitely not why I ended up with a degree in English.

Instead, the aspects of my degree that are more relevant are those that require close attention to detail, analytical thinking, and cohesive argument-building using logic and organization. In fact, I started off my college career as a Computer Science major before realizing (quite belatedly after two years) that a number of factors made the major a poor fit. So instead of resigning myself to a career in programming — that I eventually learned “Computer Science” was an analogy for; that I had been studying since I was a high school freshman; that I was slowly being driven mad by debugging sessions; and that I was becoming quite fatigued by the repetition of coding exercises — I decided to fall back on my naturally strong aptitude for written language.

In hindsight, it might have been better to transition over to something still in the realm of information technology and services, but that didn’t occur to me at the time. I think my existing frustrations with the Computer Science program discouraged me from putting myself in a potentially similar scenario. That’s a bit of a shame, since I wonder how I would have fared in a more hardware-oriented learning environment or an environment related to software application but not design. For example, I’m still very quick about picking up software-usage skills (I’m working on practicing some SQL at the moment; it seems a competency in high demand among employers), and have built and maintained multiple computers on a home network (that’s what happens when you’re the most tech-savvy person around; I suspect my knowledge of hardware roughly equates to A+ certification, but I’ve never had a reason to be tested and maintain certification).

So at this point, I have a skill set very much in search of a purpose. I’ve never really had a specific career in mind, which is why I’m flexible about the specifics of the work I do — though I would prefer to put some of my particular competencies to good use, even if it is my more abstract abilities (critical thinking, problem solving, effective written communication, etc.) To that end, I try to be understanding about the hiring process from an employer’s point of view, and open-minded and flexible about potential hiring necessities (probationary periods, contract work, and potential temp-to-hire opportunities) to offset any perceived risk as the result of my admittedly somewhat limited employment history. I have complete confidence that, if given the opportunity, any investment a company or agency makes in me will result in exceptional returns with regards to performance.

Thank you for your time,

Quote:
I have a skill set very much in search of a purpose

Priceless

"Religion is the most malevolent of all mind viruses." - Arthur C. Clarke

Procrastination is the answer.

Wrong is evil and must be defeated. - Jeff Ello
(√-sh*t)²

Member 11323763 wrote:
decided to fall back on my naturally strong aptitude for written language.

1. Who told you that you had a strong aptitude for written language? Mother?
2. Don't quit your day job.
3. Don't call us, we'll call you.

Member 11323763 wrote:
that didn’t occur to me at the time

Lack of foresight. A weakness.

Member 11323763 wrote:
I’m working on practicing some SQL

"...working on practicing..."
Let's see I'm beginning to think about trying a little practice of sql.
Weakly worded for someone with strong aptitude in writing.
Try: I'm learning SQL now.

Desperation speaks louder than words and creates quite long cover letters. Smile | :)

What do you get when you cross a joke with a rhetorical question?
---
The metaphorical solid rear-end expulsions have impacted the metaphorical motorized bladed rotating air movement mechanism.
---
Do questions with multiple question marks annoy you???

What's my letter doing here. And why is it made fun off? Confused | :confused:

I thought it was a good read at least Laugh | :laugh:

My blog[^]

C#

public class SanderRossel : Lazy<Person>
{
   public void DoWork()
   {
      throw new NotSupportedException();
   }
}

Member 11323763 wrote:
Should I hire this guy to see how quickly he gets "quite fatigued by the repitition of coding exercises"?

Hire ? No !

As an act of Holiday Season kindness you might refer them to a local community mental health center, but check with your lawyers first, and be prepared to be stalked, harassed, etc.

«OOP to me means only messaging, local retention and protection and hiding of state-process, and extreme late-binding of all things. » Alan Kay's clarification on what he meant by the term "Object" in "Object-Oriented Programming."

How can you hire (or interview) someone when they have clearly stated they don't know what they want to do as a career. What role would you be interviewing them for?

For someone who claims to have good communication skills, this is a very poor covering letter. It doesn't tell us anything useful. It is dull and verbose and I'd drop it straight in the bin.

"There are two ways of constructing a software design: One way is to make it so simple that there are obviously no deficiencies, and the other way is to make it so complicated that there are no obvious deficiencies. The first method is far more difficult." - C.A.R. Hoare

Home | LinkedIn | Google+ | Twitter

"Web/Java Application Developer Cover Letter"

"So instead of resigning myself to a career in programming"

Their written English may be passable, however their reading ability needs some work.

“That which can be asserted without evidence, can be dismissed without evidence.”

― Christopher Hitchens

Member 11323763 wrote:
I suspect my knowledge of hardware roughly equates to A+ certification, but I’ve never had a reason to be tested and maintain certification

Excellent.

Elephant elephant elephant, sunshine sunshine sunshine

10600 lines of PHP.

Not a single class. Just a single endless function.

Countless parameters provide the only noticable structure:

if(isset($somemeaninglessvariable))
{
    // lots of spaghetti code
}
if(isset($someothermeaninglessvariable))
{
    // more spaghetti
}

The purpose of that thing: To provide the data access and something like application logic for an entire web application.

The last line:

return $result;

I don't want to know what happens if somebody would try to break this up into separate functions, not expecting the dependencies inside this little monstrosity.

The language is JavaScript. that of Mordor, which I will not utter here

This is Javascript. If you put big wheels and a racing stripe on a golf cart, it's still a f***ing golf cart.

"I don't know, extraterrestrial?"
"You mean like from space?"
"No, from Canada."

And yet, it works Laugh | :laugh:

That's what they all say, until one day a minor change lets the whole thing collapse.

The language is JavaScript. that of Mordor, which I will not utter here

This is Javascript. If you put big wheels and a racing stripe on a golf cart, it's still a f***ing golf cart.

"I don't know, extraterrestrial?"
"You mean like from space?"
"No, from Canada."

Ya, been there, done that Smile | :)

I use this add on to Visual Studio, VS.PHP...comes in handy for close encounters Smile | :)

CDP1802 wrote:
// more spaghetti

Enjoy the spaghetti while it lasts...nom nom...

Zen and the art of software maintenance : rm -rf *

Maths is like love : a simple idea but it can get complicated.

CDP1802 wrote:
10600 lines of PHP.

Not a single class. Just a single endless function.

Shoot to kill. Santa Vaca!!

There are only 10 types of people in the world, those who understand binary and those who don't.

1) Copy it all onto a floppy.
2) Attach plastic fangs.
3) Use as a Frisbee.

Et voilà! Your very own Flying Spaghetti Monster!

Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...

The FSM is a lie! All hail Jibbers Crabst[^]! Big Grin | :-D

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer