protected void Button1_Click(object sender, EventArgs e)
{
Businessobjects.BusinessObjectsclass objbo = new Businessobjects.BusinessObjectsclass();
objbo.Serviceno = txtsvno.Text;
objbo.Fromplace = txtfplace.Text;
objbo.Toplace = txttoplace.Text;
objbo.Capacity = txtcapacity.Text;
objbo.Depaturetime = txtdeptime.Text;
objbo.Arrivaltime = txtarrivaltime.Text;
objbo.Travelagencyname = txtagencyname.Text;
objbo.bustype = ddlbustype.SelectedItem.Text;
Businesslogiclayer.Businesslogiclayerclass objbll = new Businesslogiclayer.Businesslogiclayerclass();
int i = objbll.Addbus(objbo);
if (i == 1)
{
Response.Write("BUS IS ADDED");
txtfplace.Text = "";
txttoplace.Text = "";
txtcapacity.Text = "";
txtdeptime.Text = "";
txtarrivaltime.Text = "";
txtagencyname.Text = "";
txtsvno.Text = objbll.AutogenerateSvno();
txtsvno.Text = objbll.AutogenerateSvno();
}
else
{
Response.Write("FAILED");
}
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
Businesslogiclayer.Businesslogiclayerclass objbll = new Businesslogiclayer.Businesslogiclayerclass();
Businessobjects.BusinessObjectsclass objbo = new BusinessObjectsclass();
Bindpointsbasedonsvno();
}
private void FillBusData()
{
Businesslogiclayer.Businesslogiclayerclass objbll = new Businesslogiclayer.Businesslogiclayerclass();
DataSet ds = objbll.Viewbus();
GridView1.DataSource = ds;
GridView1.DataBind();
}
private void FillDpoints()
{
Businesslogiclayer.Businesslogiclayerclass objbll = new Businesslogiclayer.Businesslogiclayerclass();
Businessobjects.BusinessObjectsclass objbo = new BusinessObjectsclass();
DataSet ds = objbll.ViewDpoints(objbo);
GridView1.DataSource = ds;
GridView1.DataBind();
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
Businessobjects.BusinessObjectsclass objbo = new Businessobjects.BusinessObjectsclass();
GridViewRow row = (GridViewRow)GridView1.Rows[e.RowIndex];
TextBox t1 = (TextBox)row.FindControl("txtsvno");
objbo.Serviceno = t1.Text;
TextBox t2 = (TextBox)row.FindControl("txtfplace");
objbo.Fromplace = t2.Text;
TextBox t3 = (TextBox)row.FindControl("txttplace");
objbo.Toplace = t3.Text;
TextBox t4 = (TextBox)row.FindControl("txtcapacity");
objbo.Capacity = t4.Text;
TextBox t5 = (TextBox)row.FindControl("txtarrtime");
objbo.Arrivaltime = t5.Text;
TextBox t6 = (TextBox)row.FindControl("txtdeptime");
objbo.Depaturetime = t6.Text;
TextBox t7 = (TextBox)row.FindControl("txttravelagencyname");
objbo.Travelagencyname = t7.Text;
TextBox t8 = (TextBox)row.FindControl("txtbustype");
objbo.bustype = t8.Text;
Businesslogiclayer.Businesslogiclayerclass objbll = new Businesslogiclayer.Businesslogiclayerclass();
int i = objbll.Editbus(objbo);
if (i == 1)
{
Response.Write("ROW UPDATED SUCCESSFULLY");
}
else
{
Response.Write("ROW UPDATING FAILED");
}
}
private void FillDpoints1()
{
Businesslogiclayer.Businesslogiclayerclass objbll = new Businesslogiclayer.Businesslogiclayerclass();
Businessobjects.BusinessObjectsclass objbo = new BusinessObjectsclass();
string s = DropDownList1.SelectedItem.ToString();
string[] s1 = s.Split('/');
objbo.Serviceno = s1[0];
DataSet ds = objbll.ViewDpoints(objbo);
DropDownList3.DataSource = ds;
DropDownList3.DataTextField = "dname";
DropDownList3.DataValueField = "did";
DropDownList3.DataBind();
ViewState["svno"] = objbo.Serviceno;
}
protected void Button1_Click(object sender, EventArgs e)
{
Businesslogiclayer.Businesslogiclayerclass objbll = new Businesslogiclayer.Businesslogiclayerclass();
Businessobjects.BusinessObjectsclass objbo = new BusinessObjectsclass();
objbo.Serviceno = ViewState["svno"].ToString();
objbo.Fdid = DropDownList2.SelectedValue.ToString();
objbo.Fdeptime = TextBox2.Text;
objbo.Tdid = DropDownList3.SelectedValue.ToString();
objbo.Tdeptime = TextBox3.Text;
objbo.Fare = double.Parse(TextBox1.Text);
int i = objbll.Addfaredestination(objbo);
if (i == 1)
{
Response.Write("Added");
}
}
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();
}
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);
}
}
}
private void BindSvno()
{
Businesslogiclayer.Businesslogiclayerclass objbll = new Businesslogiclayer.Businesslogiclayerclass();
SqlDataReader dr = objbll.Bindserviceno();
if (dr.HasRows)
{
while (dr.Read())
{
string svno = dr[0].ToString();
Session["svno"] = svno;
string fplace = dr[1].ToString();
string tplace = dr[2].ToString();
string s = svno + "/" + fplace + "/" + tplace;
DropDownList1.Items.Add(s);
}
}
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string svno = GridView1.DataKeys[e.RowIndex].Value.ToString();
Businessobjects.BusinessObjectsclass objbo = new Businessobjects.BusinessObjectsclass();
objbo.Serviceno = svno;
Businesslogiclayer.Businesslogiclayerclass objbll = new Businesslogiclayer.Businesslogiclayerclass();
int i = objbll.DeleteBus(objbo);
if (i == 1)
{
Response.Write("BUS DELETION SUCCESFULL");
}
else
{
Response.Write("FAILED");
}
}
protected void Login1_Authenticate(object sender, AuthenticateEventArgs e)
{
Businesslogiclayer.Businesslogiclayerclass objll = new Businesslogiclayer.Businesslogiclayerclass();
Businessobjects.BusinessObjectsclass objbo = new Businessobjects.BusinessObjectsclass();
objbo.Username = Login1.UserName;
objbo.Password = Login1.Password;
int i = objll.Adminlogin(objbo);
if (i == 1)
{
Response.Write("Valid User");
Response.Redirect("Addbus.aspx");
}
else
{
Login1.FailureText = "Invalid User";
}
}
protected void Page_Load(object sender, EventArgs e)
{
Businesslogiclayer.Businesslogiclayerclass objbll = new Businesslogiclayer.Businesslogiclayerclass();
txtsvno.Text = objbll.AutogenerateSvno();
}
