protected void DayPilotScheduler1_EventResize(object sender, DayPilot.Web.Ui.Events.EventResizeEventArgs e) { string id = e.Value; DateTime start = e.NewStart; DateTime end = e.NewEnd; string resource = e.Resource; string username = "******"; //Check weather session variable null or not if (Session["UserName"] != null) { //Retrieving UserName from Session username = (string)(Session["UserName"]); } else { //Do Something else } string message = null; if (!dbIsFree(id, start, end, resource)) { message = "The reservation cannot overlap with an existing reservation."; } else if (e.OldEnd <= DateTime.Today) { message = "This reservation cannot be changed anymore."; } else if (e.OldStart != e.NewStart) { if (e.OldStart < DateTime.Today) { message = "The reservation start cannot be changed anymore."; } else if (e.NewStart < DateTime.Today) { message = "The reservation cannot be moved to the past."; } } else { dbUpdateEvent(id, start, end, resource, username); //message = "Reservation updated."; } LoadResourcesAndEvents(); DayPilotScheduler1.UpdateWithMessage(message); }
protected void DayPilotScheduler1_EventResize(object sender, DayPilot.Web.Ui.Events.EventResizeEventArgs e) { #region Simulation of database update DataRow dr = table.Rows.Find(e.Id); if (dr != null) { dr["start"] = e.NewStart; dr["end"] = e.NewEnd; table.AcceptChanges(); } #endregion setDataSourceAndBind(); DayPilotScheduler1.Update(); }
protected void DayPilotScheduler1_EventResize(object sender, DayPilot.Web.Ui.Events.EventResizeEventArgs e) { string id = e.Value; DateTime start = e.NewStart; DateTime end = e.NewEnd; string resource = e.Resource; string message = null; if (!dbIsFree(id, start, end, resource)) { message = "The reservation cannot overlap with an existing reservation."; } else if (e.OldEnd <= DateTime.Today) { message = "This reservation cannot be changed anymore."; } else if (e.OldStart != e.NewStart) { if (e.OldStart < DateTime.Today) { message = "The reservation start cannot be changed anymore."; } else if (e.NewStart < DateTime.Today) { message = "The reservation cannot be moved to the past."; } else { dbUpdateEvent(id, start, end, resource); } } else { dbUpdateEvent(id, start, end, resource); //message = "Reservation updated."; } DayPilotScheduler1.DataSource = dbGetEvents(DayPilotScheduler1.StartDate, DayPilotScheduler1.Days); DayPilotScheduler1.DataBind(); DayPilotScheduler1.UpdateWithMessage(message); }
protected void DayPilotScheduler1_EventResize(object sender, DayPilot.Web.Ui.Events.EventResizeEventArgs e) { if ((e.OldStart < DateTime.Now && e.OldEnd < DateTime.Now) || (e.NewStart < DateTime.Now && e.NewEnd < DateTime.Now)) { DayPilotScheduler1.UpdateWithMessage("TimeOut!!! Event cannot be Resized"); } else if ((e.OldStart < DateTime.Now && e.OldEnd >= DateTime.Now) || (e.NewStart < DateTime.Now && e.NewEnd >= DateTime.Now)) { if (e.OldStart != e.NewStart) { DayPilotScheduler1.UpdateWithMessage("TimeOut!!! Event cannot be Resized!"); } else { using (SqlConnection con = new SqlConnection(Session[Session["TMLDealercode"] + "-TMLConString"].ToString())) { try { con.Open(); SqlCommand cmd = new SqlCommand("ResheduleTblJobAllotment", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@AllotID", e.Id); cmd.Parameters.AddWithValue("@BayID", e.Resource); cmd.Parameters.AddWithValue("@InTime", e.OldStart); cmd.Parameters.AddWithValue("@OutTime", e.NewEnd); cmd.Parameters.Add("@flag", SqlDbType.Int); cmd.Parameters["@flag"].Direction = ParameterDirection.Output; cmd.Parameters["@flag"].Value = 0; if (con.State != ConnectionState.Open) { con.Open(); } cmd.ExecuteNonQuery(); string msg = Convert.ToString(cmd.Parameters["@flag"].Value); switch (msg) { case "0": DayPilotScheduler1.UpdateWithMessage("Error in writing to database !"); break; case "1": DayPilotScheduler1.UpdateWithMessage("Allotment Rescheduled !"); break; case "2": DayPilotScheduler1.UpdateWithMessage("Technician not available !"); break; case "3": DayPilotScheduler1.UpdateWithMessage("Bay not available !"); break; case "4": DayPilotScheduler1.UpdateWithMessage("Vehicle is already assign to another Bay !"); break; case "5": DayPilotScheduler1.UpdateWithMessage("Promise Delivery Time is near to cross or already crossed !"); break; case "7": DayPilotScheduler1.UpdateWithMessage("Allotment In-Time is not Valid. !"); break; default: break; } } catch (Exception ex) { } } } } else { using (SqlConnection con = new SqlConnection(Session[Session["TMLDealercode"] + "-TMLConString"].ToString())) { try { con.Open(); SqlCommand cmd = new SqlCommand("ResheduleTblJobAllotment", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@AllotID", e.Id); cmd.Parameters.AddWithValue("@BayID", e.Resource); if (e.OldStart != e.NewStart) { cmd.Parameters.AddWithValue("@InTime", e.NewStart); } else { cmd.Parameters.AddWithValue("@InTime", e.OldStart); } if (e.OldEnd != e.NewEnd) { cmd.Parameters.AddWithValue("@OutTime", e.NewEnd); } else { cmd.Parameters.AddWithValue("@OutTime", e.OldEnd); } cmd.Parameters.Add("@flag", SqlDbType.Int); cmd.Parameters["@flag"].Direction = ParameterDirection.Output; cmd.Parameters["@flag"].Value = 0; if (con.State != ConnectionState.Open) { con.Open(); } cmd.ExecuteNonQuery(); string msg = Convert.ToString(cmd.Parameters["@flag"].Value); switch (msg) { case "0": DayPilotScheduler1.UpdateWithMessage("Error in writing to database !"); break; case "1": DayPilotScheduler1.UpdateWithMessage("Allotment Rescheduled !"); table.AcceptChanges(); break; case "2": DayPilotScheduler1.UpdateWithMessage("Technician not available !"); break; case "3": DayPilotScheduler1.UpdateWithMessage("Bay not available !"); break; case "4": DayPilotScheduler1.UpdateWithMessage("Vehicle is already assign to another Bay !"); break; case "5": DayPilotScheduler1.UpdateWithMessage("Promise Delivery Time is near to cross or already crossed !"); break; case "7": DayPilotScheduler1.UpdateWithMessage("Allotment In-Time is not Valid. !"); break; default: break; } } catch (Exception ex) { } } } DayPilotScheduler1.Update(); }