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