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 GetBusNo()
{
using (TravelConnection db = new TravelConnection())
{
var bus = (from b in db.bus_master
orderby b.BUS_NO
select b);
ddlBus.DataSource = bus.ToList();
ddlBus.DataBind();
}
}
protected void GetBusType()
{
using (TravelConnection db = new TravelConnection())
{
var busType = (from t in db.bustype_master
orderby t.BUS_TYPE
select t);
ddlBustype.DataSource = busType.ToList();
ddlBustype.DataBind();
}
}
protected void GetBus()
{
using (TravelConnection db = new TravelConnection())
{
var bus = (from b in db.bus_master
select new { b.BUS_ID, b.BUS_NO, b.bustype_master.BUS_TYPE , s1 = b.station_master.STATION_NAME, s2 = b.station_master1.STATION_NAME });
//append the current direction to the Sort Column
String Sort = Session["SortColumn"].ToString() + " " + Session["SortDirection"].ToString();
grdBus.DataSource = bus.AsQueryable().OrderBy(Sort).ToList();
grdBus.DataBind();
}
}
protected void GetStation()
{
using (TravelConnection db = new TravelConnection())
{
var stations = (from s in db.station_master
select new { s.STATION_ID, s.STATION_NAME });
//append the current direction to the Sort Column
String Sort = Session["SortColumn"].ToString() + " " + Session["SortDirection"].ToString();
grdStation.DataSource = stations.AsQueryable().OrderBy(Sort).ToList();
grdStation.DataBind();
}
}
protected void GetBusType()
{
using (TravelConnection db = new TravelConnection())
{
var bustype = (from t in db.bustype_master
select new { t.BUSTYPE_ID, t.BUS_TYPE});
//append the current direction to the Sort Column
String Sort = Session["SortColumn"].ToString() + " " + Session["SortDirection"].ToString();
grdBustype.DataSource = bustype.AsQueryable().OrderBy(Sort).ToList();
grdBustype.DataBind();
}
}
protected void GetStation()
{
//populate the existing course for editing
using (TravelConnection db = new TravelConnection())
{
Int32 StationID = Convert.ToInt32(Request.QueryString["STATION_ID"]);
station_master objStation = (from s in db.station_master
where s.STATION_ID == StationID
select s).FirstOrDefault();
//populate the form
txtStation.Text = objStation.STATION_NAME;
}
}
protected void GetBusType()
{
//populate the existing course for editing
using (TravelConnection db = new TravelConnection())
{
Int32 BustypeId = Convert.ToInt32(Request.QueryString["BUSTYPE_ID"]);
bustype_master objBustype = (from t in db.bustype_master
where t.BUSTYPE_ID== BustypeId
select t).FirstOrDefault();
//populate the form
txtBustype.Text = objBustype.BUS_TYPE;
}
}
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();
}
protected void GetBus()
{
//populate the existing course for editing
using (TravelConnection db = new TravelConnection())
{
Int32 BusId = Convert.ToInt32(Request.QueryString["BUS_ID"]);
bus_master objBus = (from t in db.bus_master
where t.BUS_ID == BusId
select t).FirstOrDefault();
//populate the form
txtBusno.Text = objBus.BUS_NO;
ddlBustype.SelectedValue = objBus.BUS_TYPE.ToString();
ddlSource.SelectedValue = objBus.SOURCE_STATION.ToString();
ddlDestination.SelectedValue = objBus.DESTINATION_STATION.ToString();
}
}
protected void GetBusSchedule()
{
//populate the existing course for editing
using (TravelConnection db = new TravelConnection())
{
Int32 ScheduleId = Convert.ToInt32(Request.QueryString["SCHEDULE_ID"]);
busschedule_master objSchedule = (from s in db.busschedule_master
where s.SCHEDULE_ID == ScheduleId
select s).FirstOrDefault();
//populate the form
ddlBus.Text = objSchedule.BUS_ID.ToString();
cldrDeparture.SelectedDate = Convert.ToDateTime(objSchedule.DEPARTURE_TIME.ToString());
cldrArrival.SelectedDate = Convert.ToDateTime(objSchedule.ARRIVAL_TIME.ToString());
txtSeat.Text = objSchedule.SEAT_AVAILABILITY.ToString();
}
}
protected void GetStation()
{
using (TravelConnection db = new TravelConnection())
{
var station = (from s in db.station_master
orderby s.STATION_NAME
select s);
ddlSource.DataSource = station.ToList();
ddlSource.DataBind();
ddlDestination.DataSource = station.ToList();
ddlDestination.DataBind();
}
}