// /////////////////////////////////////////////////////////////////////////////////////////////////////
//
// STEP1 - BEGIN
//
// ////////////////////////////////////////////////////////////////////////
// STEP1 - BEGIN - AUXILIAR EVENTS
//
protected void ddlSelectAPeriod_SelectedIndexChanged(object sender, EventArgs e)
{
Page.Validate("Begin");
if (Page.IsValid)
{
StepBeginProcessGrid();
// Load
VacationsSetupTDS dataSet = new VacationsSetupTDS();
dataSet.VacationsSetup.Merge(vacationsSetup, true);
VacationsSetup model = new VacationsSetup(dataSet);
if (dataSet.VacationsSetup.Select(string.Format("Year = {0}", Int32.Parse(ddlSelectAPeriod.SelectedValue))).Length == 0)
{
// ... Load
model.LoadByYear(Int32.Parse(ddlSelectAPeriod.SelectedValue), Int32.Parse(hdfCompanyId.Value));
dataSet.VacationsSetup.Merge(vacationsSetup, true);
odsVacationsSetup.FilterExpression = string.Format("Year = {0}", Int32.Parse(ddlSelectAPeriod.SelectedValue));
}
else
{
odsVacationsSetup.FilterExpression = string.Format("Year = {0}", Int32.Parse(ddlSelectAPeriod.SelectedValue));
}
// Store tables
vacationsSetup = (VacationsSetupTDS.VacationsSetupDataTable)model.Table;
Session["vacationsSetup"] = vacationsSetup;
}
grdVacationsSetup.DataBind();
}
/// <summary>
/// InitData
/// </summary>
protected override void InitData()
{
_data = new VacationsSetupTDS();
}
// /////////////////////////////////////////////////////////////////////////////////////////////////////
//
// STEP2 - SUMMARY
//
// ////////////////////////////////////////////////////////////////////////
// STEP2 - SUMMARY - METHODS
//
private void StepSummaryIn()
{
// Set instruction
Label instruction = (Label)this.Master.FindControl("lblInstruction");
instruction.Text = "Summary";
// Initialize summary
VacationsSetupTDS dataSet = new VacationsSetupTDS();
dataSet.VacationsSetup.Merge(vacationsSetup, true);
VacationsSetup model = new VacationsSetup(dataSet);
tbxSummary.Text = model.GetSummary(Int32.Parse(ddlSelectAPeriod.SelectedValue));
}
private void StepBeginProcessGrid()
{
if (ExistsDataModified())
{
VacationsSetupTDS dataSet = new VacationsSetupTDS();
dataSet.VacationsSetup.Merge(vacationsSetup, true);
VacationsSetup model = new VacationsSetup(dataSet);
// update rows
foreach (GridViewRow row in grdVacationsSetup.Rows)
{
int year = Int32.Parse(grdVacationsSetup.DataKeys[row.RowIndex].Values["Year"].ToString());
int employeeId = Int32.Parse(grdVacationsSetup.DataKeys[row.RowIndex].Values["EmployeeID"].ToString());
double newVacationDays = double.Parse(((TextBox)row.FindControl("tbxVacationDays")).Text);
double newCarryOverDays = double.Parse(((TextBox)row.FindControl("tbxCarryOverDays")).Text);
model.Update(year, employeeId, newVacationDays, newCarryOverDays);
}
vacationsSetup = (VacationsSetupTDS.VacationsSetupDataTable)model.Table;
Session["vacationsSetup"] = vacationsSetup;
hdfUpdate.Value = "yes";
}
}
// ////////////////////////////////////////////////////////////////////////
// STEP1 - BEGIN - METHODS
//
private void StepBeginIn()
{
// Set instruction
Label instruction = (Label)this.Master.FindControl("lblInstruction");
instruction.Text = "Please provide paid vacation days information";
// Initiaize data
vacationsSetup = new VacationsSetupTDS.VacationsSetupDataTable();
// Load
VacationsSetupTDS dataSet = new VacationsSetupTDS();
VacationsSetup model = new VacationsSetup(dataSet);
model.LoadByYear(Int32.Parse(ddlSelectAPeriod.SelectedValue), Int32.Parse(hdfCompanyId.Value));
// Store tables
vacationsSetup = (VacationsSetupTDS.VacationsSetupDataTable)model.Table;
Session["vacationsSetup"] = vacationsSetup;
}
private void Save()
{
// process sections
VacationsSetupTDS dataSet = new VacationsSetupTDS();
dataSet.VacationsSetup.Merge(vacationsSetup, true);
VacationsSetup model = new VacationsSetup(dataSet);
// save to database
DB.Open();
DB.BeginTransaction();
try
{
model.Save(int.Parse(hdfCompanyId.Value));
DB.CommitTransaction();
}
catch (Exception ex)
{
DB.RollbackTransaction();
string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' '));
Response.Redirect(url);
}
}
private bool ExistsDataModified()
{
foreach (GridViewRow row in grdVacationsSetup.Rows)
{
try
{
VacationsSetupTDS dataSet = new VacationsSetupTDS();
dataSet.VacationsSetup.Merge(vacationsSetup, true);
VacationsSetupGateway model = new VacationsSetupGateway(dataSet);
// Getting general information
int year = Int32.Parse(grdVacationsSetup.DataKeys[row.RowIndex].Values["Year"].ToString());
int employeeId = Int32.Parse(grdVacationsSetup.DataKeys[row.RowIndex].Values["EmployeeID"].ToString());
// Verify vacation Days
double newVacationDays = double.Parse(((TextBox)row.FindControl("tbxVacationDays")).Text);
double originalVacationDays = model.GetVacationDaysOriginal(year, employeeId);
if (newVacationDays != originalVacationDays)
{
return true;
}
else
{
// Verify carryOver days
double newCarryOverDays = double.Parse(((TextBox)row.FindControl("tbxCarryOverDays")).Text);
double originalCarryOverDays = model.GetCarryOverDaysOriginal(year, employeeId);
if (newCarryOverDays != originalCarryOverDays)
{
return true;
}
}
}
catch
{
return true;
}
}
return false;
}