public int Adminlogin(Businessobjects.BusinessObjectsclass objbo) { if (objbo.Username == "Admin" && objbo.Password == "naveen") { return(1); } else { return(0); } #endregion }
public int DeleteDestinationpoint(Businessobjects.BusinessObjectsclass objbo) { SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString()); con.Open(); SqlCommand cmd = new SqlCommand("proc_deletedestinationpoint", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@did", objbo.Did); int i = cmd.ExecuteNonQuery(); return(i); }
public int Addbuspickuppoints(Businessobjects.BusinessObjectsclass objbo) { SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString()); con.Open(); SqlCommand cmd = new SqlCommand("proc_addbuspickuppoint", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@svno", objbo.Serviceno); cmd.Parameters.AddWithValue("@pid", objbo.pid); int i = cmd.ExecuteNonQuery(); return(i); }
public DataSet Bindpointsbasedonserviceno(Businessobjects.BusinessObjectsclass objbo) { SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString()); con.Open(); SqlCommand cmd = new SqlCommand("proc_bindpointsbasedonsvno", con); cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); cmd.Parameters.AddWithValue("@svno", objbo.Serviceno); da.Fill(ds, "destination"); return(ds); }
private void Bindpointsbasedonsvno() { Businessobjects.BusinessObjectsclass objbo = new Businessobjects.BusinessObjectsclass(); string s = DropDownList1.SelectedItem.ToString(); string[] s1 = s.Split('/'); objbo.Serviceno = s1[0].ToString(); Businesslogiclayer.Businesslogiclayerclass objbll = new Businesslogiclayer.Businesslogiclayerclass(); DataSet ds = objbll.Bindpointsbasedonserviceno(objbo); DropDownList2.DataSource = ds; DropDownList2.DataValueField = "dname"; DropDownList2.DataBind(); DropDownList3.DataSource = ds; DropDownList3.DataValueField = "dname"; DropDownList3.DataBind(); }
public int Addfaredestination(Businessobjects.BusinessObjectsclass objbo) { SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString()); con.Open(); SqlCommand cmd = new SqlCommand("proc_addfaredestination", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@svno", objbo.Serviceno); cmd.Parameters.AddWithValue("@fdid", objbo.Fdid); cmd.Parameters.AddWithValue("@fdeptime", objbo.Fdeptime); cmd.Parameters.AddWithValue("@tdid", objbo.Tdid); cmd.Parameters.AddWithValue("@tdeptime", objbo.Tdeptime); cmd.Parameters.AddWithValue("@fare", objbo.Fare); int i = cmd.ExecuteNonQuery(); return(i); }
protected void Button1_Click(object sender, EventArgs e) { foreach (GridViewRow row in GridView1.Rows) { CheckBox c1 = (CheckBox)row.FindControl("CheckBox1"); if (c1.Checked == true) { Label l1 = (Label)row.FindControl("Label1"); Businessobjects.BusinessObjectsclass objbo = new Businessobjects.BusinessObjectsclass(); objbo.Did = l1.Text.ToString(); string s = DropDownList1.SelectedItem.ToString(); string[] s1 = s.Split('/'); objbo.Serviceno = s1[0].ToString(); Businesslogiclayer.Businesslogiclayerclass objbll = new Businesslogiclayer.Businesslogiclayerclass(); objbll.AddbusDestinationpoints(objbo); } } }
protected void Button1_Click(object sender, EventArgs e) { Businessobjects.BusinessObjectsclass objbo = new Businessobjects.BusinessObjectsclass(); objbo.pid = txtpid.Text; objbo.pname = txtpname.Text; Businesslogiclayer.Businesslogiclayerclass objbll = new Businesslogiclayer.Businesslogiclayerclass(); int i = objbll.Addpickuppoint(objbo); if (i == 1) { Response.Write("ADDED"); txtpname.Text = ""; AutogeneratePid(); } else { Response.Write("FAILED"); } }
protected void Button1_Click(object sender, EventArgs e) { Businessobjects.BusinessObjectsclass objbo = new Businessobjects.BusinessObjectsclass(); objbo.Did = TextBox1.Text; objbo.Dname = TextBox1.Text; Businesslogiclayer.Businesslogiclayerclass objbll = new Businesslogiclayer.Businesslogiclayerclass(); int i = objbll.Adddestinationpoint(objbo); if (i == 1) { TextBox2.Text = ""; string s = objbll.AutogenerateDid(); TextBox1.Text = s; Response.Write("Record inserted"); } else { Response.Write("failed"); } }
public int EditBus(Businessobjects.BusinessObjectsclass objbo) { SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString()); con.Open(); SqlCommand cmd = new SqlCommand("proc_editbus", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@svno", objbo.Serviceno); cmd.Parameters.AddWithValue("@fromplace", objbo.Fromplace); cmd.Parameters.AddWithValue("@toplace", objbo.Toplace); cmd.Parameters.AddWithValue("@capacity", objbo.Capacity); cmd.Parameters.AddWithValue("@arrivaltime", objbo.Arrivaltime); cmd.Parameters.AddWithValue("@depaturetime", objbo.Depaturetime); cmd.Parameters.AddWithValue("@tagencyname", objbo.Travelagencyname); cmd.Parameters.AddWithValue("@bustype", objbo.bustype); int i = cmd.ExecuteNonQuery(); return(i); }
public int Addbus(Businessobjects.BusinessObjectsclass objbo) { int i = objdal.Addbus(objbo); return(i); }
public int Deletepickuppoint(Businessobjects.BusinessObjectsclass objbo) { int i = objdal.Deletepickuppoint(objbo); return(i); }
public int UpdateDestination(Businessobjects.BusinessObjectsclass objbo) { int i = objdal.UpdateDestination(objbo); return(i); }
public int DeleteDestinationpoint(Businessobjects.BusinessObjectsclass objbo) { int i = objdal.DeleteDestinationpoint(objbo); return(i); }
public int AddbusDestinationpoints(Businessobjects.BusinessObjectsclass objbo) { int i = objdal.AddbusDestinationpoints(objbo); return(i); }
public DataSet Bindpointsbasedonserviceno(Businessobjects.BusinessObjectsclass objbo) { DataSet ds = objdal.Bindpointsbasedonserviceno(objbo); return(ds); }
public int Editbus(Businessobjects.BusinessObjectsclass objbo) { int i = objdal.EditBus(objbo); return(i); }
public int DeleteBus(Businessobjects.BusinessObjectsclass objbo) { int i = objdal.DeleteBus(objbo); return(i); }
public int Addfaredestination(Businessobjects.BusinessObjectsclass objbo) { int i = objdal.Addfaredestination(objbo); return(i); }