public static CustomList <OtherSalaryRule> GetAllOtherSalaryRule()
{
ConnectionManager conManager = new ConnectionManager(ConnectionName.HR);
CustomList <OtherSalaryRule> OtherSalaryRuleCollection = new CustomList <OtherSalaryRule>();
IDataReader reader = null;
const String sql = "select *from OtherSalaryRule";
try
{
conManager.OpenDataReader(sql, out reader);
while (reader.Read())
{
OtherSalaryRule newOtherSalaryRule = new OtherSalaryRule();
newOtherSalaryRule.SetData(reader);
OtherSalaryRuleCollection.Add(newOtherSalaryRule);
}
OtherSalaryRuleCollection.InsertSpName = "spInsertOtherSalaryRule";
OtherSalaryRuleCollection.UpdateSpName = "spUpdateOtherSalaryRule";
OtherSalaryRuleCollection.DeleteSpName = "spDeleteOtherSalaryRule";
return(OtherSalaryRuleCollection);
}
catch (Exception ex)
{
throw (ex);
}
finally
{
if (reader != null && !reader.IsClosed)
{
reader.Close();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
InitializeSession();
InitializeCombo();
}
else
{
Page.ClientScript.GetPostBackEventReference(this, String.Empty);
String eventTarget = Request["__EVENTTARGET"].IsNullOrEmpty() ? String.Empty : Request["__EVENTTARGET"];
if (eventTarget == "SearchOtherSalaryRole")
{
OtherSalaryRuleList = new CustomList <ASL.Hr.DAO.OtherSalaryRule>();
ASL.Hr.DAO.OtherSalaryRule searchOtherSalaryRule = Session[ASL.STATIC.StaticInfo.SearchSessionVarName] as ASL.Hr.DAO.OtherSalaryRule;
if (searchOtherSalaryRule.IsNotNull())
{
PopulateControls(searchOtherSalaryRule);
OtherSalaryRuleList.Add(searchOtherSalaryRule);
HourWisePaymentList = manager.GetAllHourWisePayment(searchOtherSalaryRule.RuleKey);
if (HourWisePaymentList.Count() != 0)
{
chkHourWisePayment.Checked = true;
}
}
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
CustomList <ASL.Hr.DAO.OtherSalaryRule> lstOtherSalaryRule = OtherSalaryRuleList;
if (lstOtherSalaryRule.Count == 0)
{
ASL.Hr.DAO.OtherSalaryRule newObj = new ASL.Hr.DAO.OtherSalaryRule();
lstOtherSalaryRule.Add(newObj);
}
SetDataFromControlToObject(ref lstOtherSalaryRule);
CustomList <HourWisePayment> lstHourWisePayment = HourWisePaymentList;
manager.SaveOtherSalaryRule(ref lstOtherSalaryRule, ref lstHourWisePayment);
this.SuccessMessage = (StaticInfo.SavedSuccessfullyMsg);
}
catch (SqlException ex)
{
this.ErrorMessage = (ExceptionHelper.getSqlExceptionMessage(ex));
}
catch (Exception ex)
{
this.ErrorMessage = (ExceptionHelper.getExceptionMessage(ex));
}
}
private void SetDataFromControlToObject(ref CustomList <ASL.Hr.DAO.OtherSalaryRule> lstOtherSalaryRule)
{
try
{
ASL.Hr.DAO.OtherSalaryRule oSR = lstOtherSalaryRule[0];
//ASL.Hr.DAO.OtherSalaryRule searchOtherSalaryRule = Session[ASL.STATIC.StaticInfo.SearchSessionVarName] as ASL.Hr.DAO.OtherSalaryRule;
//if (searchOtherSalaryRule.RuleKey != 0)
// oSR.RuleKey = searchOtherSalaryRule.RuleKey;
oSR.RuleName = txtOtherSalaryRuleName.Text;
oSR.Description = txtDescription.Text;
if (rdoPersonalAttn.Checked)
{
oSR.IsAttBased = rdoPersonalAttn.Checked;
}
else
{
oSR.IsAttBased = rdoInGeneral.Checked;
}
oSR.EffectedSalaryHeadID = ddlSalaryHead.SelectedValue;
oSR.SalaryHeadID = ddlSalaryHead1.SelectedValue;
if (rdoFixed.Checked)
{
oSR.IsFixed = rdoFixed.Checked;
}
else
{
oSR.IsFixed = rdoPercentage.Checked;
}
oSR.Amount = txtAmount.Text.ToDecimal();
// oSR.DayStatus=
string dayStatus = "";
if (chkP.Checked)
{
dayStatus = "'P'";
}
if (chkL.Checked)
{
if (dayStatus == "")
{
dayStatus = "'L'";
}
else
{
dayStatus = dayStatus + ",'L'";
}
}
if (chkA.Checked)
{
if (dayStatus == "")
{
dayStatus = "'A'";
}
else
{
dayStatus = dayStatus + ",'A'";
}
}
if (chkLV.Checked)
{
if (dayStatus == "")
{
dayStatus = "'LV'";
}
else
{
dayStatus = dayStatus + ",'LV'";
}
}
if (chkW.Checked)
{
if (dayStatus == "")
{
dayStatus = "'W'";
}
else
{
dayStatus = dayStatus + ",'W'";
}
}
if (chkPW.Checked)
{
if (dayStatus == "")
{
dayStatus = "'PW'";
}
else
{
dayStatus = dayStatus + ",'PW'";
}
}
if (chkPH.Checked)
{
if (dayStatus == "")
{
dayStatus = "'PH'";
}
else
{
dayStatus = dayStatus + ",'PH'";
}
}
if (chkLW.Checked)
{
if (dayStatus == "")
{
dayStatus = "'LW'";
}
else
{
dayStatus = dayStatus + ",'LW'";
}
}
if (chkH.Checked)
{
if (dayStatus == "")
{
dayStatus = "'H'";
}
else
{
dayStatus = dayStatus + ",'H'";
}
}
if (chkLH.Checked)
{
if (dayStatus == "")
{
dayStatus = "'LH'";
}
else
{
dayStatus = dayStatus + ",'LH'";
}
}
oSR.DayStatus = dayStatus;
if (ddlFixedPerDay.Checked)
{
oSR.DivisibleFactorType = 1;
}
else
{
oSR.DivisibleFactorType = 2;
}
//oSR.Factor=
if (rdoCalendar.Checked)
{
oSR.Factor = 1;
}
else if (rdoWorking.Checked)
{
oSR.Factor = 2;
}
else
{
oSR.Factor = 3;
}
if (chkExcludeWeekend.Checked)
{
oSR.IsWExclude = chkExcludeWeekend.Checked;
}
else
{
oSR.IsWExclude = false;
}
if (chkExcludeHoliday.Checked)
{
oSR.IsHExclude = chkExcludeHoliday.Checked;
}
else
{
oSR.IsHExclude = false;
}
if (txtDays.Text != "")
{
oSR.Days = Convert.ToDecimal(txtDays.Text);
}
string shiftID = "";
foreach (ShiftPlan sP in ShiftPlanList)
{
if (sP.IsChecked)
{
if (shiftID == "")
{
shiftID = "'" + sP.ShiftID.ToString() + "'";
}
else
{
shiftID = "," + shiftID + "'" + sP.ShiftID.ToString() + "'";
}
}
}
oSR.Shift = shiftID;
string leaveType = "";
foreach (LeavePolicyMaster lPM in LeaveTypeList)
{
if (lPM.IsChecked)
{
if (leaveType == "")
{
leaveType = "'" + lPM.LeavePolicyID.ToString() + "'";
}
else
{
leaveType = "," + leaveType + "'" + lPM.LeavePolicyID.ToString() + "'";
}
}
}
oSR.LeaveType = leaveType;
}
catch (Exception ex)
{
throw (ex);
}
}
private void PopulateControls(ASL.Hr.DAO.OtherSalaryRule oSR)
{
try
{
//ID = oSR.RuleKey;
txtOtherSalaryRuleName.Text = oSR.RuleName;
txtDescription.Text = oSR.Description;
if (oSR.IsAttBased)
{
rdoPersonalAttn.Checked = true;
//dayStatus.Style.Add("display", "inline-block");
}
else
{
rdoInGeneral.Checked = true;
}
ddlSalaryHead.SelectedValue = oSR.EffectedSalaryHeadID;
string[] items = oSR.DayStatus.Split(',');
for (int i = 0; i <= items.Count() - 1; i++)
{
switch (items[i])
{
case "'P'":
chkP.Checked = true;
break;
case "'L'":
chkL.Checked = true;
break;
case "'A'":
chkA.Checked = true;
break;
case "'LV'":
chkLV.Checked = true;
break;
case "'W'":
chkW.Checked = true;
break;
case "'PW'":
chkPW.Checked = true;
break;
case "'LW'":
chkLW.Checked = true;
break;
case "'H'":
chkH.Checked = true;
break;
case "'PH'":
chkPH.Checked = true;
break;
case "'LH'":
chkLH.Checked = true;
break;
default:
break;
}
}
if (oSR.Shift.IsNotNullOrEmpty())
{
chkConsiderspecificShift.Checked = true;
shift.Style.Add("display", "inline");
string[] shiftItems = oSR.Shift.Split(',');
foreach (ShiftPlan sP in ShiftPlanList)
{
for (int i = 0; i < shiftItems.Count(); i++)
{
if (shiftItems[i] == "'" + sP.ShiftID + "'")
{
sP.IsChecked = true;
}
}
}
}
if (chkLV.Checked)
{
specificLeave.Style.Add("display", "inline");
if (oSR.LeaveType.IsNotNullOrEmpty())
{
chkSpecificLeaveType.Checked = true;
string[] LeaveTypes = oSR.LeaveType.Split(',');
foreach (LeavePolicyMaster lPM in LeaveTypeList)
{
for (int i = 0; i < LeaveTypes.Count(); i++)
{
if (LeaveTypes[i] == "'" + lPM.LeavePolicyID + "'")
{
lPM.IsChecked = true;
}
}
}
Leave.Style.Add("display", "inline");
}
}
if (oSR.IsFixed)
{
rdoFixed.Checked = true;
}
else
{
rdoPercentage.Checked = true;
}
ddlSalaryHead1.SelectedValue = oSR.SalaryHeadID;
txtAmount.Text = oSR.Amount.ToString();
if (oSR.DivisibleFactorType == 1)
{
ddlFixedPerDay.Checked = true;
}
else
{
rdoCalculative.Checked = true;
}
if (oSR.Factor == 1)
{
rdoCalendar.Checked = true;
}
else if (oSR.Factor == 2)
{
rdoWorking.Checked = true;
}
else if (oSR.Factor == 3)
{
rdoFixed1.Checked = true;
}
if (oSR.Days.IsNotNull())
{
txtDays.Text = oSR.Days.ToString();
}
chkExcludeWeekend.Checked = oSR.IsWExclude;
chkExcludeHoliday.Checked = oSR.IsHExclude;
oSR.SetModified();
}
catch (Exception ex)
{
throw (ex);
}
}