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