protected void btnSaveActivity_Click(object sender, EventArgs e) { OnlineSchoolEntities km = new OnlineSchoolEntities(); SchoolInformation info = new SchoolInformation(); Schedual activity = new Schedual(); activity.type = int.Parse(ddlActivity.SelectedValue); activity.Name = txtActivityName.Text; activity.Time = Convert.ToDateTime(txtActivityTime.Text).TimeOfDay; activity.Period = new TimeSpan(0, int.Parse(txtPeriod.Text), 0); activity.SchoolId = info.getId(); km.Scheduals.Add(activity); km.SaveChanges(); lstActive.DataBind(); // lblmsg.Text = "تم اضافة النشاط"; lstActive.DataBind(); var nxt = activity.Time + activity.Period; txtActivityTime.Text = Convert.ToDateTime(nxt.ToString()).ToString("mm:ss tt"); txtActivityName.Text = ""; txtPeriod.Text = ""; ScriptManager.RegisterClientScriptBlock((sender as Control), this.GetType(), "openModal", "<script> addSuccess(' تمت اضافة النشاط بنجاح'); </script>", false); }
public ActionResult DeleteConfirmed(int id) { Schedual schedual = db.Scheduals.Find(id); db.Scheduals.Remove(schedual); db.SaveChanges(); return(RedirectToAction("Index")); }
public async Task <ActionResult> Create([Bind(Include = "DepartmentID,CourseID,semester,level")] Schedual schedual) { schedual.DepartmentID = db.Departments.Where(d => d.InstructorID.HasValue && d.InstructorID.Value == InstructorController.instructorNow) .Select(d => d.DepartmentID).Single(); if (ModelState.IsValid) { db.Scheduals.Add(schedual); await db.SaveChangesAsync(); return(RedirectToAction("Index")); } PopulateSemesterData(); ViewBag.department = new SelectList(db.Departments, "DepartmentID", "Name"); return(View(schedual)); }
public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Schedual schedual = db.Scheduals .Include(s => s.course) .Include(s => s.department) .Where(s => s.SchedualID == id.Value) .Single(); if (schedual == null) { return(HttpNotFound()); } return(View(schedual)); }
public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Schedual schedual = db.Scheduals .Include(s => s.course) .Include(s => s.department) .Where(s => s.SchedualID == id.Value) .Single(); if (schedual == null) { return(HttpNotFound()); } PopulateSemesterData(); ViewBag.department = new SelectList(db.Departments, "DepartmentID", "Name"); return(View(schedual)); }
public int Save(Schedual schedual) { const string sql = @"MERGE Flight.Schedual AS target " + @"USING (VALUES(@FlightNumber, @DepartureAirport, @ArrivalAirport, @DepartureTime, @ArrivalTime, @AddDays)) " + @"AS source(FlightNumber, DepartureAirport, ArrivalAirport, DepartureTime, ArrivalTime, AddDays) " + @"ON (target.FlightNumber = source.FlightNumber) " + @"WHEN NOT MATCHED THEN " + @"INSERT (FlightNumber, DepartureAirport, ArrivalAirport, DepartureTime, ArrivalTime, AddDays) " + @"VALUES (FlightNumber, DepartureAirport, ArrivalAirport, DepartureTime, ArrivalTime, AddDays);"; using (var dbOperator = new DbOperator(Provider, ConnectionString)) { dbOperator.AddParameter("FlightNumber", schedual.FlightNumber); dbOperator.AddParameter("DepartureAirport", schedual.DepartureAirport); dbOperator.AddParameter("ArrivalAirport", schedual.ArrivalAirport); dbOperator.AddParameter("DepartureTime", schedual.DepartureTime); dbOperator.AddParameter("ArrivalTime", schedual.ArrivalTime); dbOperator.AddParameter("AddDays", schedual.AddDays); return(dbOperator.ExecuteNonQuery(sql)); } }
public static bool AddSchedual(Schedual schedual) { var flightRepository = Factory.CreateFlightSchedualRepository(); return(flightRepository.Save(schedual) > 0); }