protected void btnSave_Click(object sender, EventArgs e)
{
//do insert or update
using (TravelConnection db = new TravelConnection())
{
busschedule_master objSchedule = new busschedule_master();
if (!String.IsNullOrEmpty(Request.QueryString["SCHEDULE_ID"]))
{
Int32 ScheduleId = Convert.ToInt32(Request.QueryString["SCHEDULE_ID"]);
objSchedule = (from s in db.busschedule_master
where s.SCHEDULE_ID == ScheduleId
select s).FirstOrDefault();
}
//populate the course from the input form
objSchedule.BUS_ID = Convert.ToInt32(ddlBus.SelectedValue);
objSchedule.DEPARTURE_TIME =Convert.ToDateTime(cldrDeparture.SelectedDate.ToLongDateString());
objSchedule.ARRIVAL_TIME= Convert.ToDateTime(cldrArrival.SelectedDate.ToLongDateString());
objSchedule.SEAT_AVAILABILITY = Convert.ToInt32(txtSeat.Text);
if (String.IsNullOrEmpty(Request.QueryString["SCHEDULE_ID"]))
{
//add
db.busschedule_master.Add(objSchedule);
}
//save and redirect
db.SaveChanges();
Response.Redirect("busschedule-info.aspx");
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
//do insert or update
using (TravelConnection db = new TravelConnection())
{
station_master objStation = new station_master();
if (!String.IsNullOrEmpty(Request.QueryString["STATION_ID"]))
{
Int32 STATION_ID = Convert.ToInt32(Request.QueryString["STATION_ID"]);
objStation = (from s in db.station_master
where s.STATION_ID == STATION_ID
select s).FirstOrDefault();
}
//populate the course from the input form
objStation.STATION_NAME = txtStation.Text;
if (String.IsNullOrEmpty(Request.QueryString["STATION_ID"]))
{
//add
db.station_master.Add(objStation);
}
//save and redirect
db.SaveChanges();
Response.Redirect("station-info.aspx");
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
//do insert or update
using (TravelConnection db = new TravelConnection())
{
bustype_master objBustype = new bustype_master();
if (!String.IsNullOrEmpty(Request.QueryString["BUSTYPE_ID"]))
{
Int32 BusTypeId = Convert.ToInt32(Request.QueryString["BUSTYPE_ID"]);
objBustype = (from t in db.bustype_master
where t.BUSTYPE_ID == BusTypeId
select t).FirstOrDefault();
}
//populate the course from the input form
objBustype.BUS_TYPE= txtBustype.Text;
if (String.IsNullOrEmpty(Request.QueryString["BUSTYPE_ID"]))
{
//add
db.bustype_master.Add(objBustype);
}
//save and redirect
db.SaveChanges();
Response.Redirect("bustype-info.aspx");
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
//do insert or update
using (TravelConnection db = new TravelConnection())
{
bus_master objBus = new bus_master();
if (!String.IsNullOrEmpty(Request.QueryString["BUS_ID"]))
{
Int32 BusId = Convert.ToInt32(Request.QueryString["BUS_ID"]);
objBus = (from t in db.bus_master
where t.BUS_ID == BusId
select t).FirstOrDefault();
}
//populate the course from the input form
objBus.BUS_NO = txtBusno.Text;
objBus.BUS_TYPE = Convert.ToInt32(ddlBustype.SelectedValue);
objBus.SOURCE_STATION = Convert.ToInt32(ddlSource.SelectedValue);
objBus.DESTINATION_STATION = Convert.ToInt32(ddlDestination.SelectedValue);
if (String.IsNullOrEmpty(Request.QueryString["BUS_ID"]))
{
//add
db.bus_master.Add(objBus);
}
//save and redirect
db.SaveChanges();
Response.Redirect("busmaster-info.aspx");
}
}
protected void grdBus_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
Int32 BusId = Convert.ToInt32(grdBus.DataKeys[e.RowIndex].Values["BUS_ID"].ToString());
using (TravelConnection db = new TravelConnection())
{
bus_master objBus = (from t in db.bus_master
where t.BUS_ID == BusId
select t).FirstOrDefault();
db.bus_master.Remove(objBus);
db.SaveChanges();
}
GetBus();
}
protected void grdStation_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
Int32 StationID = Convert.ToInt32(grdStation.DataKeys[e.RowIndex].Values["STATION_ID"].ToString());
using (TravelConnection db = new TravelConnection())
{
station_master objStaion = (from s in db.station_master
where s.STATION_ID == StationID
select s).FirstOrDefault();
db.station_master.Remove(objStaion);
db.SaveChanges();
}
GetStation();
}
