protected void tkrsNonWorkingDays_AppointmentUpdate(object sender, AppointmentUpdateEventArgs e)
{
Page.Validate();
if (Page.IsValid)
{
int nonWorkingDayId = Convert.ToInt32(e.ModifiedAppointment.ID);
VacationsNonWorkingDaysInformation vacationsNonWorkingDaysInformation = new VacationsNonWorkingDaysInformation(vacationsNonWorkingDaysInformationTDS);
vacationsNonWorkingDaysInformation.Update(nonWorkingDayId, e.ModifiedAppointment.Subject);
// Store dataset
Session["vacationsNonWorkingDaysInformationTDS"] = vacationsNonWorkingDaysInformationTDS;
Session["nonWorkingDaysInformation"] = vacationsNonWorkingDaysInformationTDS.NonWorkingDaysInformation;
tkrsNonWorkingDays.DataBind();
}
else
{
e.Cancel = true;
}
}
private void UpdateDatabase()
{
DB.Open();
DB.BeginTransaction();
try
{
VacationsNonWorkingDaysInformation vacationsNonWorkingDaysInformation = new VacationsNonWorkingDaysInformation(vacationsNonWorkingDaysInformationTDS);
vacationsNonWorkingDaysInformation.Save();
vacationsNonWorkingDaysInformationTDS.AcceptChanges();
// Store dataset
Session["vacationsNonWorkingDaysInformationTDS"] = vacationsNonWorkingDaysInformationTDS;
Session["nonWorkingDaysInformation"] = vacationsNonWorkingDaysInformationTDS.NonWorkingDaysInformation;
DB.CommitTransaction();
}
catch (Exception ex)
{
DB.RollbackTransaction();
string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' '));
Response.Redirect(url);
}
}
protected void tkrsNonWorkingDays_AppointmentInsert(object sender, SchedulerCancelEventArgs e)
{
Page.Validate();
if (Page.IsValid)
{
string filterExpression = string.Format("Deleted = 0 AND StartDate = '{0}'", e.Appointment.Start);
DataRow[] drarray = vacationsNonWorkingDaysInformationTDS.NonWorkingDaysInformation.Select(filterExpression, "StartDate ASC", DataViewRowState.CurrentRows);
if (drarray.Length == 0)
{
VacationsNonWorkingDaysInformation vacationsNonWorkingDaysInformation = new VacationsNonWorkingDaysInformation(vacationsNonWorkingDaysInformationTDS);
vacationsNonWorkingDaysInformation.Insert(e.Appointment.Start, Int32.Parse(ddlWorkingLocation.SelectedValue), e.Appointment.Subject, false, Int32.Parse(hdfCompanyId.Value), false);
// Store dataset
Session["vacationsNonWorkingDaysInformationTDS"] = vacationsNonWorkingDaysInformationTDS;
Session["nonWorkingDaysInformation"] = vacationsNonWorkingDaysInformationTDS.NonWorkingDaysInformation;
tkrsNonWorkingDays.DataBind();
}
else
{
e.Cancel = true;
ScriptManager.RegisterStartupScript(Page, GetType(), "alert", "alert('You already have a non working day for this day please verify your data.');", true);
}
}
else
{
e.Cancel = true;
}
}
