/// <summary>
/// InitData
/// </summary>
protected override void InitData()
{
_data = new EmployeeStandardCostsSetupTDS();
}
// /////////////////////////////////////////////////////////////////////////////////////////////////////
//
// STEP2 - SUMMARY
//
// ////////////////////////////////////////////////////////////////////////
// STEP2 - SUMMARY - METHODS
//
private void StepSummaryIn()
{
// Set instruction
Label instruction = (Label)this.Master.FindControl("lblInstruction");
instruction.Text = "Summary";
// Initialize summary
EmployeeStandardCostsSetupTDS dataSet = new EmployeeStandardCostsSetupTDS();
dataSet.StandardCostsSetup.Merge(standardCostsSetup, true);
EmployeeStandardCostsSetup model = new EmployeeStandardCostsSetup(dataSet);
tbxSummary.Text = model.GetSummary();
}
private void StepBeginProcessGrid()
{
if (ExistsDataModified())
{
EmployeeStandardCostsSetupTDS dataSet = new EmployeeStandardCostsSetupTDS();
dataSet.StandardCostsSetup.Merge(standardCostsSetup, true);
EmployeeStandardCostsSetup model = new EmployeeStandardCostsSetup(dataSet);
// update rows
foreach (GridViewRow row in grdCostSetup.Rows)
{
int employeeId = Int32.Parse(grdCostSetup.DataKeys[row.RowIndex].Values["EmployeeID"].ToString());
decimal? newBurdenFactor = null;
if (((TextBox)row.FindControl("tbxBourdenFactor")).Text != "")
{
newBurdenFactor = decimal.Round(decimal.Parse(((TextBox)row.FindControl("tbxBourdenFactor")).Text),1);
}
decimal? newUSHealthBenefitFactor = null;
if (((TextBox)row.FindControl("tbxUSHealthBenefitFactor")).Text != "")
{
newUSHealthBenefitFactor = decimal.Round(decimal.Parse(((TextBox)row.FindControl("tbxUSHealthBenefitFactor")).Text), 1);
}
decimal? newBenefitFactorCad = null;
if (((TextBox)row.FindControl("tbxBenefitFactorCad")).Text != "")
{
newBenefitFactorCad = decimal.Round(decimal.Parse(((TextBox)row.FindControl("tbxBenefitFactorCad")).Text), 2);
}
decimal? newBenefitFactorUsd = null;
if (((TextBox)row.FindControl("tbxBenefitFactorUsd")).Text != "")
{
newBenefitFactorUsd = decimal.Round(decimal.Parse(((TextBox)row.FindControl("tbxBenefitFactorUsd")).Text),2);
}
model.Update(employeeId, newBurdenFactor, newUSHealthBenefitFactor, newBenefitFactorCad, newBenefitFactorUsd);
}
standardCostsSetup = (EmployeeStandardCostsSetupTDS.StandardCostsSetupDataTable)model.Table;
Session["standardCostsSetup"] = standardCostsSetup;
hdfUpdate.Value = "yes";
}
}
// /////////////////////////////////////////////////////////////////////////////////////////////////////
//
// STEP1 - BEGIN
//
// ////////////////////////////////////////////////////////////////////////
// STEP1 - BEGIN - METHODS
//
private void StepBeginIn()
{
// Set instruction
Label instruction = (Label)this.Master.FindControl("lblInstruction");
instruction.Text = "Please provide job costing factors for each employee";
// Initiaize data
standardCostsSetup = new EmployeeStandardCostsSetupTDS.StandardCostsSetupDataTable();
// Load
EmployeeStandardCostsSetupTDS dataSet = new EmployeeStandardCostsSetupTDS();
EmployeeStandardCostsSetup model = new EmployeeStandardCostsSetup(dataSet);
model.LoadAll();
// Store tables
standardCostsSetup = (EmployeeStandardCostsSetupTDS.StandardCostsSetupDataTable)model.Table;
Session["standardCostsSetup"] = standardCostsSetup;
}
private void Save()
{
// process sections
EmployeeStandardCostsSetupTDS dataSet = new EmployeeStandardCostsSetupTDS();
dataSet.StandardCostsSetup.Merge(standardCostsSetup, true);
EmployeeStandardCostsSetup model = new EmployeeStandardCostsSetup(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 grdCostSetup.Rows)
{
try
{
EmployeeStandardCostsSetupTDS dataSet = new EmployeeStandardCostsSetupTDS();
dataSet.StandardCostsSetup.Merge(standardCostsSetup, true);
EmployeeStandardCostsSetupGateway model = new EmployeeStandardCostsSetupGateway(dataSet);
// Getting general information
int employeeId = Int32.Parse(grdCostSetup.DataKeys[row.RowIndex].Values["EmployeeID"].ToString());
// Verify BurdenRate
decimal? newBurdenFactor = decimal.Parse(((TextBox)row.FindControl("tbxBourdenFactor")).Text);
decimal? originalBurdenFactor = model.GetBourdenFactorOriginal(employeeId);
if (newBurdenFactor != originalBurdenFactor)
{
return true;
}
else
{
// Verify USHealthBenefitFactor
decimal newUSHealthBenefitFactor = decimal.Parse(((TextBox)row.FindControl("tbxUSHealthBenefitFactor")).Text);
decimal? originalUSHealthBenefitFactor = model.GetUSHealthBenefitFactorOriginal(employeeId);
if (newUSHealthBenefitFactor != originalUSHealthBenefitFactor)
{
return true;
}
else
{
// Verify BenefitFactorCad
decimal newBenefitFactorCad = decimal.Parse(((TextBox)row.FindControl("tbxBenefitFactorCad")).Text);
decimal? originalBenefitFactorCad = model.GetBenefitFactorCadOriginal(employeeId);
if (newBenefitFactorCad != originalBenefitFactorCad)
{
return true;
}
else
{
// Verify BenefitFactorUsd
decimal newBenefitFactorUsd = decimal.Parse(((TextBox)row.FindControl("tbxBenefitFactorUsd")).Text);
decimal? originalBenefitFactorUsd = model.GetBenefitFactorUsdOriginal(employeeId);
if (newBenefitFactorUsd != originalBenefitFactorUsd)
{
return true;
}
}
}
}
}
catch
{
return true;
}
}
return false;
}
