protected bool loadObject()
{
EBenefitPlan obj = new EBenefitPlan();
bool isNew = WebFormWorkers.loadKeys(db, obj, DecryptedRequest);
if (!db.select(dbConn, obj))
{
return(false);
}
bool isERRP = obj.BenefitPlanERPaymentBaseMethod.Equals(Values.PAYMENT_BASE_RECURRING_BASIC_SALARY);
bool isERFA = obj.BenefitPlanERPaymentBaseMethod.Equals(Values.PAYMENT_BASE_FIXED_AMOUNT);
spanBenefitPlanERRP.Visible = isERRP;
spanBenefitPlanERFA.Visible = isERFA;
bool isEERP = obj.BenefitPlanEEPaymentBaseMethod.Equals(Values.PAYMENT_BASE_RECURRING_BASIC_SALARY);
bool isEEFA = obj.BenefitPlanEEPaymentBaseMethod.Equals(Values.PAYMENT_BASE_FIXED_AMOUNT);
spanBenefitPlanEERP.Visible = isEERP;
spanBenefitPlanEEFA.Visible = isEEFA;
bool isSpouseRP = obj.BenefitPlanSpousePaymentBaseMethod.Equals(Values.PAYMENT_BASE_RECURRING_BASIC_SALARY);
bool isSpouseFA = obj.BenefitPlanSpousePaymentBaseMethod.Equals(Values.PAYMENT_BASE_FIXED_AMOUNT);
spanBenefitPlanSpouseRP.Visible = isSpouseRP;
spanBenefitPlanSpouseFA.Visible = isSpouseFA;
bool isChildRP = obj.BenefitPlanChildPaymentBaseMethod.Equals(Values.PAYMENT_BASE_RECURRING_BASIC_SALARY);
bool isChildFA = obj.BenefitPlanChildPaymentBaseMethod.Equals(Values.PAYMENT_BASE_FIXED_AMOUNT);
spanBenefitPlanChildRP.Visible = isChildRP;
spanBenefitPlanChildFA.Visible = isChildFA;
Hashtable values = new Hashtable();
db.populate(obj, values);
binding.toControl(values);
return(true);
}
protected void calculateBenefit(object sender, EventArgs e)
{
int selBenefitPlanID = -1;
if (!int.TryParse(EmpBenefitPlanID.SelectedValue, out selBenefitPlanID))
{
selBenefitPlanID = -1;
}
if (selBenefitPlanID > 0)
{
EBenefitPlan benefitPlan = new EBenefitPlan();
benefitPlan.BenefitPlanID = selBenefitPlanID;
if (EBenefitPlan.db.select(dbConn, benefitPlan))
{
double erPremium = 0;
double eePremium = 0;
double spousePremium = 0;
double childPremium = 0;
DateTime rangeStartDate = AppUtils.ServerDateTime().Date;
DateTime rangeEndDate = AppUtils.ServerDateTime().Date;
if (benefitPlan.BenefitPlanERPaymentBaseMethod.Equals(Values.PAYMENT_BASE_RECURRING_BASIC_SALARY))
{
erPremium = AppUtils.Evaluate(getRPAmount(benefitPlan.BenefitPlanERPaymentCodeID, rangeStartDate, rangeEndDate).ToString("0.00") + " * " + benefitPlan.BenefitPlanERMultiplier);
}
else if (benefitPlan.BenefitPlanERPaymentBaseMethod.Equals(Values.PAYMENT_BASE_FIXED_AMOUNT))
{
erPremium = benefitPlan.BenefitPlanERAmount;
}
if (benefitPlan.BenefitPlanEEPaymentBaseMethod.Equals(Values.PAYMENT_BASE_RECURRING_BASIC_SALARY))
{
eePremium = AppUtils.Evaluate(getRPAmount(benefitPlan.BenefitPlanEEPaymentCodeID, rangeStartDate, rangeEndDate) + " * " + benefitPlan.BenefitPlanEEMultiplier);
}
else if (benefitPlan.BenefitPlanEEPaymentBaseMethod.Equals(Values.PAYMENT_BASE_FIXED_AMOUNT))
{
eePremium = benefitPlan.BenefitPlanEEAmount;
}
if (benefitPlan.BenefitPlanSpousePaymentBaseMethod.Equals(Values.PAYMENT_BASE_RECURRING_BASIC_SALARY))
{
spousePremium = AppUtils.Evaluate(getRPAmount(benefitPlan.BenefitPlanSpousePaymentCodeID, rangeStartDate, rangeEndDate) + " * " + benefitPlan.BenefitPlanSpouseMultiplier);
}
else if (benefitPlan.BenefitPlanSpousePaymentBaseMethod.Equals(Values.PAYMENT_BASE_FIXED_AMOUNT))
{
spousePremium = benefitPlan.BenefitPlanSpouseAmount;
}
if (benefitPlan.BenefitPlanChildPaymentBaseMethod.Equals(Values.PAYMENT_BASE_RECURRING_BASIC_SALARY))
{
childPremium = AppUtils.Evaluate(getRPAmount(benefitPlan.BenefitPlanChildPaymentCodeID, rangeStartDate, rangeEndDate) + " * " + benefitPlan.BenefitPlanChildMultiplier);
}
else if (benefitPlan.BenefitPlanChildPaymentBaseMethod.Equals(Values.PAYMENT_BASE_FIXED_AMOUNT))
{
childPremium = benefitPlan.BenefitPlanChildAmount;
}
EmpBenefitERPremium.Text = erPremium.ToString("0.00");
EmpBenefitEEPremium.Text = eePremium.ToString("0.00");
EmpBenefitSpousePremium.Text = spousePremium.ToString("0.00");
EmpBenefitChildPremium.Text = childPremium.ToString("0.00");
}
}
}
public static DataTable Export(DatabaseConnection dbConn, ArrayList empList, bool IsIncludeCurrentPositionInfo, bool IsShowDescription, bool IsIncludeSyncID, DateTime ReferenceDateTime)
{
DataTable tmpDataTable = new DataTable(TABLE_NAME);
tmpDataTable.Columns.Add(FIELD_EMP_NO, typeof(string));
if (IsIncludeCurrentPositionInfo)
{
ImportEmpPersonalInfoProcess.AddEmployeeInfoHeader(tmpDataTable);
ImportEmpPositionInfoProcess.AddEmployeePositionInfoHeader(dbConn, tmpDataTable);
}
tmpDataTable.Columns.Add(FIELD_EFFECTIVE_DATE, typeof(DateTime));
tmpDataTable.Columns.Add(FIELD_EXPIRY_DATE, typeof(DateTime));
tmpDataTable.Columns.Add(FIELD_BENEFIT_PLAN, typeof(string));
tmpDataTable.Columns.Add(FIELD_ER_PREMIUM, typeof(decimal));
tmpDataTable.Columns.Add(FIELD_EE_PREMIUM, typeof(decimal));
tmpDataTable.Columns.Add(FIELD_CHILD_PREMIUM, typeof(decimal));
tmpDataTable.Columns.Add(FIELD_SPOUSE_PREMIUM, typeof(decimal));
if (IsIncludeSyncID)
{
tmpDataTable.Columns.Add(FIELD_SYNC_ID, typeof(string));
}
foreach (EEmpPersonalInfo empInfo in empList)
{
if (EEmpPersonalInfo.db.select(dbConn, empInfo))
{
DBFilter filter = new DBFilter();
filter.add(new Match("EmpID", empInfo.EmpID));
filter.add(getCreateModifiedRecordsAfterDBTerm(ReferenceDateTime));
ArrayList list = EEmpBenefit.db.select(dbConn, filter);
foreach (EEmpBenefit empBenefit in list)
{
DataRow row = tmpDataTable.NewRow();
row[FIELD_EMP_NO] = empInfo.EmpNo;
if (IsIncludeCurrentPositionInfo)
{
ImportEmpPersonalInfoProcess.AddEmployeeInfo(dbConn, row, empInfo.EmpID);
ImportEmpPositionInfoProcess.AddEmployeePositionInfo(dbConn, row, empInfo.EmpID);
}
row[FIELD_EFFECTIVE_DATE] = empBenefit.EmpBenefitEffectiveDate;
row[FIELD_EXPIRY_DATE] = empBenefit.EmpBenefitExpiryDate;
EBenefitPlan benefitPlan = new EBenefitPlan();
if (benefitPlan.LoadDBObject(dbConn, empBenefit.EmpBenefitPlanID))
{
row[FIELD_BENEFIT_PLAN] = IsShowDescription ? benefitPlan.BenefitPlanDesc : benefitPlan.BenefitPlanCode;
}
row[FIELD_ER_PREMIUM] = empBenefit.EmpBenefitERPremium;
row[FIELD_EE_PREMIUM] = empBenefit.EmpBenefitEEPremium;
row[FIELD_CHILD_PREMIUM] = empBenefit.EmpBenefitChildPremium;
row[FIELD_SPOUSE_PREMIUM] = empBenefit.EmpBenefitSpousePremium;
if (IsIncludeSyncID)
{
row[FIELD_SYNC_ID] = empBenefit.SynID;
}
tmpDataTable.Rows.Add(row);
}
}
}
if (IsIncludeCurrentPositionInfo)
{
ImportEmpPositionInfoProcess.RetriveHierarchyLevelHeader(dbConn, tmpDataTable);
}
return(tmpDataTable);
}
