protected void btn_submit_Click(object sender, EventArgs e) { tbl_schedule sch = new tbl_schedule(); sch.sch_day = ddl_day.SelectedValue; sch.sch_date = Calendar_date.SelectedDate.ToString(); if (ddl_day.SelectedValue == "SUNDAY") { sch.sch_time = ddl_sun.SelectedValue; } if (ddl_day.SelectedValue == "MONDAY") { sch.sch_time = ddl_mon.SelectedValue; } if (ddl_day.SelectedValue == "TUESDAY") { sch.sch_time = ddl_tue.SelectedValue; } if (ddl_day.SelectedValue == "WEDNESDAY") { sch.sch_time = ddl_wed.SelectedValue; } if (ddl_day.SelectedValue == "THURSDAY") { sch.sch_time = ddl_thu.SelectedValue; } if (ddl_day.SelectedValue == "FRIDAY") { sch.sch_time = ddl_fri.SelectedValue; } if (ddl_day.SelectedValue == "SATURDAY") { sch.sch_time = ddl_sat.SelectedValue; } sch.sch_class = ddl_class.SelectedValue; sch.sch_class_name = ddl_class_name.SelectedValue; sch.sch_subject = txt_sub.Text; sch.sch_prof = txt_prof.Text; db.tbl_schedules.InsertOnSubmit(sch); db.SubmitChanges(); Response.Write("<script> alert('Your Schedule added Successfully ')</script>"); GridView1.Visible = true; }
protected void btn_add_Schedule_Click(object sender, EventArgs e) { bus_dbEntities db = new bus_dbEntities(); //Create new instance and assign values to columns tbl_schedule route = new tbl_schedule(); int source = int.Parse(Schedule_Source.SelectedValue.ToString()); int dest = int.Parse(Schedule_Destination.SelectedValue.ToString()); route.fk_route = (from x in db.tbl_route where x.route_source == source && x.route_destination == dest select x).ToList()[0].route_id; route.schedule_time = TimeSpan.Parse(Schedule_timming.SelectedItem.Text.ToString()); route.fk_bus = int.Parse(Schedule_bus.SelectedValue.ToString()); //Add instance in db db.tbl_schedule.Add(route); db.SaveChanges(); var lgs = (from x in db.tbl_route join y in db.tbl_station on x.route_source equals y.station_id join z in db.tbl_station on x.route_destination equals z.station_id select new { ID = x.route_id, Source = y.station_name, Destination = z.station_name }).ToList(); grid1.DataSource = lgs; grid1.DataBind(); }
partial void Deletetbl_schedule(tbl_schedule instance);
partial void Updatetbl_schedule(tbl_schedule instance);
partial void Inserttbl_schedule(tbl_schedule instance);