protected void Button1_Click(object sender, EventArgs e)
{
clsroute objroute = new clsroute();
objroute.RouteNo = txtrouteno.Text;
objroute.RouteName = txtroutename.Text;
objroute.Source = txtsource.Text;
objroute.Destination = txtdestination.Text;
objroute.TotalDistance = int.Parse(txtdistance.Text);
objroute.Rate = int.Parse(txtrate.Text);
try
{
int result = objroute.InsertRoute();
if (result == 1)
{
lblmessage.Text = "Inserted Successfully";
lblmessage.ForeColor = Color.Green;
}
else if (result == 2)
{
lblmessage.Text = "RouteNo " + objroute.RouteNo + " Already Exits.Try again...";
}
}
catch (Exception err)
{
lblmessage.Text = err.Message.ToString();
}
}
protected void btnbussubmit_Click(object sender, EventArgs e)
{
clsroute objroute = new clsroute();
objroute.RouteNo = ddlrouteno.SelectedItem.Value;
objroute.DeleteRoute();
}
protected void Page_Load(object sender, EventArgs e)
{
//check the page is posted or not
if (!this.IsPostBack)
{
objroute = new clsroute();
DataSet ds = objroute.getAllRoute();
ddlrouteno.DataSource = ds.Tables[0];
//the table fieldname as hidden
ddlrouteno.DataValueField = "RouteNo";
ddlrouteno.DataBind();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
clsroute objroute = new clsroute();
objroute.RouteNo = ddlrouteno.Text;
objroute.RouteName = txtroutename.Text;
objroute.Source = txtsource.Text;
objroute.Destination = txtdestination.Text;
objroute.TotalDistance = int.Parse(txtdistance.Text);
objroute.Rate = int.Parse(txtrate.Text);
int result = objroute.EditRoute();
if (result >= 1)
{
lblmessage.Text = "record Is updated Successfully";
lblmessage.ForeColor = System.Drawing.Color.Green;
}
}
protected void Button2_Click(object sender, EventArgs e)
{
objroute = new clsroute();
String routeno = ddlrouteno.SelectedItem.Value;
DataSet ds = objroute.getRoutebyRouteNo(routeno);
if (ds.Tables[0].Rows.Count >= 1)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
txtroutename.Text = dr["RouteName"].ToString();
txtsource.Text = dr["Source"].ToString();
txtdestination.Text = dr["Destination"].ToString();
txtdistance.Text = dr["TotalDistance"].ToString();
txtrate.Text = dr["Rate"].ToString();
}
}
}
