private void UpdateDatabase()
{
DB.Open();
DB.BeginTransaction();
try
{
double newTakenDays = double.Parse(tbxMax.Text) - double.Parse(tbxRemaining.Text);
VacationsInformationRequestsInformation vacationsInformationRequestsInformation = new VacationsInformationRequestsInformation(vacationsInformationTDS);
vacationsInformationRequestsInformation.SaveForEdit(newTakenDays);
VacationsInformationDaysInformation vacationsInformationDaysInformation = new VacationsInformationDaysInformation(vacationsInformationTDS);
vacationsInformationDaysInformation.Save();
vacationsInformationTDS.AcceptChanges();
// Store dataset
Session["vacationsInformationTDS"] = vacationsInformationTDS;
Session["vacationDaysInformation"] = vacationsInformationTDS.DaysInformation;
DB.CommitTransaction();
}
catch (Exception ex)
{
DB.RollbackTransaction();
string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' '));
Response.Redirect(url);
}
}
private void UpdateDatabase(string newState)
{
DB.Open();
DB.BeginTransaction();
try
{
VacationsInformationRequestsInformation vacationsInformationRequestsInformation = new VacationsInformationRequestsInformation(vacationsInformationTDS);
vacationsInformationRequestsInformation.Save();
vacationsInformationTDS.AcceptChanges();
Session["vacationsInformationTDS"] = vacationsInformationTDS;
SendMailEmployee(newState);
DB.CommitTransaction();
}
catch (Exception ex)
{
DB.RollbackTransaction();
string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' '));
Response.Redirect(url);
}
}
private void PostPageChanges()
{
VacationsInformationRequestsInformation vacationsInformationRequestsInformation = new VacationsInformationRequestsInformation(vacationsInformationTDS);
DataRow[] drarray;
drarray = vacationsInformationTDS.DaysInformation.Select("Deleted = 0", "StartDate ASC", DataViewRowState.CurrentRows);
// If there are no vacations
if (drarray.Length <= 0)
{
vacationsInformationRequestsInformation.Delete(Int32.Parse(hdfRequestId.Value));
}
else
{
// If there are vacations
vacationsInformationRequestsInformation.Update(Int32.Parse(hdfRequestId.Value), GetStartDate(), GetEndDate(), GetTotalPaidVacationDays(), tbxComments.Text, GetDetails());
}
// Store dataset
Session["vacationsInformationTDS"] = vacationsInformationTDS;
Session["vacationDaysInformation"] = vacationsInformationTDS.DaysInformation;
}
private void PostPageChanges(string newState)
{
VacationsInformationRequestsInformation vacationsInformationRequestsInformation = new VacationsInformationRequestsInformation(vacationsInformationTDS);
// Update grid rows
foreach (GridViewRow row in grdVacations.Rows)
{
int requestId = Int32.Parse(grdVacations.DataKeys[row.RowIndex].Values["RequestID"].ToString());
if (((CheckBox)row.FindControl("cbxSelected")).Checked)
{
if (newState == "Rejected")
{
string rejectReason = ((TextBox)row.FindControl("tbxRejectReason")).Text;
vacationsInformationRequestsInformation.UpdateVacationsForApproval(requestId, newState, rejectReason);
}
else
{
vacationsInformationRequestsInformation.UpdateState(requestId, newState);
}
}
}
// Store datasets
Session["vacationsInformationTDS"] = vacationsInformationTDS;
}