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