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(); }