internal int SaveAdvanceSalarySummery(HRM_AdvanceSalarySummary advanceSalarySummerybll)
{
try
{
_context.HRM_AdvanceSalarySummary.AddObject(advanceSalarySummerybll);
_context.SaveChanges();
return(1);
}
catch (Exception ex)
{
throw ex;
}
}
internal int UpdateAdvanceSlarySummery(HRM_AdvanceSalarySummary advanceSalarySummerybll, int adsalaryId)
{
try
{
HRM_AdvanceSalarySummary obj = _context.HRM_AdvanceSalarySummary.First(x => x.AdvanceSalaryId == adsalaryId);
obj.InstalmentAmount = advanceSalarySummerybll.InstalmentAmount;
obj.NoOfInstalment = advanceSalarySummerybll.NoOfInstalment;
obj.TotalAmount = advanceSalarySummerybll.TotalAmount;
obj.StartDate = advanceSalarySummerybll.StartDate;
obj.EndDate = advanceSalarySummerybll.StartDate;
obj.EDIT_DATE = advanceSalarySummerybll.EDIT_DATE;
obj.EDIT_USER = advanceSalarySummerybll.EDIT_USER;
obj.OCODE = advanceSalarySummerybll.OCODE;
obj.Remarks = advanceSalarySummerybll.Remarks;
_context.SaveChanges();
return(1);
}
catch (Exception)
{
throw;
}
}
internal int UpdateAdvanceSlarySummery(int adsalaryId, HRM_AdvanceSalarySummary advanceSalarySummerybll)
{
return(advanceDal.UpdateAdvanceSlarySummery(advanceSalarySummerybll, adsalaryId));
}
internal int SaveAdvanceSalarySummery(HRM_AdvanceSalarySummary advanceSalarySummerybll)
{
return(advanceDal.SaveAdvanceSalarySummery(advanceSalarySummerybll));
}
protected void btnSaveAdvance_Click(object sender, EventArgs e)
{
try
{
HRM_AdvanceSalarySummary advanceSalarySummerybll = new HRM_AdvanceSalarySummary();
List <HRM_AdvanceSalaryDetails> hrmAdvanceSalaryDetailes = new List <HRM_AdvanceSalaryDetails>();
if (ddlRegion.SelectedValue != "" && ddlOffice.SelectedValue != "" && drpDepartment.SelectedValue != "" && drpEmployee.SelectedValue != "")
{
advanceSalarySummerybll.OfficeId = Convert.ToInt16(ddlOffice.SelectedValue);
advanceSalarySummerybll.DepartmentId = Convert.ToInt16(drpDepartment.SelectedValue);
advanceSalarySummerybll.ResionId = Convert.ToInt16(ddlRegion.SelectedValue);
advanceSalarySummerybll.EID = txtEid_TRNS.Text;
advanceSalarySummerybll.InstalmentAmount = Convert.ToDecimal(txtbxInstalment.Text);
advanceSalarySummerybll.NoOfInstalment = Convert.ToInt16(txtbxNoofInslament.Text);
advanceSalarySummerybll.StartDate = Convert.ToDateTime(txtbxStartDate.Text);
advanceSalarySummerybll.TotalAmount = Convert.ToDecimal(txtbxTotalAmount.Text);
advanceSalarySummerybll.EndDate = Convert.ToDateTime(txtbxEndDate.Text);
advanceSalarySummerybll.EDIT_USER = ((SessionUser)Session["SessionUser"]).UserId;
advanceSalarySummerybll.EDIT_DATE = DateTime.Now;
advanceSalarySummerybll.OCODE = ((SessionUser)Session["SessionUser"]).OCode;
advanceSalarySummerybll.ASCode = getAdvanceSlaryCode();
advanceSalarySummerybll.Remarks = txtRemarks.Text;
}
else
{
//................HRM_AdvanceSalarySummary......................................//
advanceSalarySummerybll.EID = txtEid_TRNS.Text;
advanceSalarySummerybll.InstalmentAmount = Convert.ToDecimal(txtbxInstalment.Text);
advanceSalarySummerybll.NoOfInstalment = Convert.ToInt16(txtbxNoofInslament.Text);
advanceSalarySummerybll.StartDate = Convert.ToDateTime(txtbxStartDate.Text);
advanceSalarySummerybll.TotalAmount = Convert.ToDecimal(txtbxTotalAmount.Text);
advanceSalarySummerybll.EndDate = Convert.ToDateTime(txtbxEndDate.Text);
advanceSalarySummerybll.EDIT_USER = ((SessionUser)Session["SessionUser"]).UserId;
advanceSalarySummerybll.EDIT_DATE = DateTime.Now;
advanceSalarySummerybll.OCODE = ((SessionUser)Session["SessionUser"]).OCode;
advanceSalarySummerybll.ASCode = getAdvanceSlaryCode();
advanceSalarySummerybll.Remarks = txtRemarks.Text;
}
//................HRM_AdvanceSalaryDetails......................................//
DateTime begin = Convert.ToDateTime(txtbxStartDate.Text);
DateTime end = Convert.ToDateTime(txtbxEndDate.Text);
List <DateTime> dates = new List <DateTime>();
for (DateTime date = begin; date < end; date = date.AddMonths(1))
{
HRM_AdvanceSalaryDetails advanceSalaryDetils = new HRM_AdvanceSalaryDetails();
if (ddlRegion.SelectedValue != "" && ddlOffice.SelectedValue != "" && drpDepartment.SelectedValue != "" && drpEmployee.SelectedValue != "")
{
advanceSalaryDetils.OfficeId = Convert.ToInt16(ddlOffice.SelectedValue);
advanceSalaryDetils.DepartmentId = Convert.ToInt16(drpDepartment.SelectedValue);
advanceSalaryDetils.ResionId = Convert.ToInt16(ddlRegion.SelectedValue);
int month = date.Month;
int year = date.Year;
advanceSalaryDetils.Month = month;
advanceSalaryDetils.Year = year;
advanceSalaryDetils.EID = txtEid_TRNS.Text;
advanceSalaryDetils.TotalAmount = Convert.ToDecimal(txtbxTotalAmount.Text);
advanceSalaryDetils.InstalmentAmount = Convert.ToDecimal(txtbxInstalment.Text);
advanceSalaryDetils.NoOfInstalment = Convert.ToInt16(txtbxNoofInslament.Text);
advanceSalaryDetils.StartDate = Convert.ToDateTime(txtbxStartDate.Text);
advanceSalaryDetils.EndDate = Convert.ToDateTime(txtbxEndDate.Text);
advanceSalaryDetils.EDIT_USER = ((SessionUser)Session["SessionUser"]).UserId;
advanceSalaryDetils.EDIT_DATE = DateTime.Now;
advanceSalaryDetils.OCODE = ((SessionUser)Session["SessionUser"]).OCode;
advanceSalaryDetils.AdvanceDeduction = false;
advanceSalaryDetils.Remarks = txtRemarks.Text;
}
else
{
int month = date.Month;
int year = date.Year;
advanceSalaryDetils.Month = month;
advanceSalaryDetils.Year = year;
advanceSalaryDetils.EID = txtEid_TRNS.Text;
advanceSalaryDetils.TotalAmount = Convert.ToDecimal(txtbxTotalAmount.Text);
advanceSalaryDetils.InstalmentAmount = Convert.ToDecimal(txtbxInstalment.Text);
advanceSalaryDetils.NoOfInstalment = Convert.ToInt16(txtbxNoofInslament.Text);
advanceSalaryDetils.StartDate = Convert.ToDateTime(txtbxStartDate.Text);
advanceSalaryDetils.EndDate = Convert.ToDateTime(txtbxEndDate.Text);
advanceSalaryDetils.EDIT_USER = ((SessionUser)Session["SessionUser"]).UserId;
advanceSalaryDetils.EDIT_DATE = DateTime.Now;
advanceSalaryDetils.OCODE = ((SessionUser)Session["SessionUser"]).OCode;
advanceSalaryDetils.AdvanceDeduction = false;
advanceSalaryDetils.Remarks = txtRemarks.Text;
}
if (btnSaveAdvance.Text == "Update")
{
advanceSalaryDetils.ASCode = hiAdCode.Value;
}
else
{
advanceSalaryDetils.ASCode = getAdvanceSlaryCode();
}
hrmAdvanceSalaryDetailes.Add(advanceSalaryDetils);
}
if (btnSaveAdvance.Text == "Update")
{
int adsalaryId = Convert.ToInt16(hiadvanceSalaryId.Value);
int result = adavanceSalaryBll.UpdateAdvanceSlarySummery(adsalaryId, advanceSalarySummerybll);
if (result == 1)
{
string codeId = hiAdCode.Value.ToString();
int result1 = adavanceSalaryBll.UpdateAdvanceSalaryDetails(codeId, hrmAdvanceSalaryDetailes);
if (result1 == 1)
{
lblMessage.Text = "Data Update Successfully.";
}
}
}
else
{
int result = adavanceSalaryBll.SaveAdvanceSalarySummery(advanceSalarySummerybll);
if (result == 1)
{
int result1 = adavanceSalaryBll.SaveAdvanceSalaryDetails(hrmAdvanceSalaryDetailes);
if (result1 == 1)
{
lblMessage.Text = "Data Save Successfully.";
getAdvanceSlaryCode();
}
}
}
btnSaveAdvance.Text = "Submit";
Response.Redirect("EmployeeAdvanceSalaryList.aspx");
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true);
}
}
