internal int SaveUserWiseBebefit(HRM_EmployeeWiseBenefit employeeWiseBenefitObj)
{
try
{
_context.HRM_EmployeeWiseBenefit.AddObject(employeeWiseBenefitObj);
_context.SaveChanges();
return(1);
}
catch (Exception ex)
{
throw ex;
}
}
internal int UpdateUserWiseBebefit(HRM_EmployeeWiseBenefit employeeWiseBenefitObj, string id)
{
int iD = Convert.ToInt16(id);
HRM_EmployeeWiseBenefit obj = _context.HRM_EmployeeWiseBenefit.First(x => x.employeeWiseBenefitId == iD);
obj.Amount = employeeWiseBenefitObj.Amount;
obj.BenefitTypeId = employeeWiseBenefitObj.BenefitTypeId;
obj.EffectiveDate = employeeWiseBenefitObj.EffectiveDate;
obj.EDIT_DATE = employeeWiseBenefitObj.EDIT_DATE;
obj.EDIT_USER = employeeWiseBenefitObj.EDIT_USER;
obj.OCODE = employeeWiseBenefitObj.OCODE;
_context.SaveChanges();
return(1);
}
protected void btnSaveEmployeeWiseBebefit_Click(object sender, EventArgs e)
{
try
{
HRM_EmployeeWiseBenefit employeeWiseBenefitObj = new HRM_EmployeeWiseBenefit();
employeeWiseBenefitObj.EID = drpEmployee.SelectedValue.ToString();
employeeWiseBenefitObj.BenefitTypeId = Convert.ToInt16(drpBenefitType.SelectedValue);
employeeWiseBenefitObj.Amount = Convert.ToDecimal(txtbxAmount.Text);
employeeWiseBenefitObj.EffectiveDate = Convert.ToDateTime(txtbxEffectiveDate.Text);
employeeWiseBenefitObj.EDIT_USER = ((SessionUser)Session["SessionUser"]).UserId;
employeeWiseBenefitObj.EDIT_DATE = DateTime.Now;
employeeWiseBenefitObj.OCODE = ((SessionUser)Session["SessionUser"]).OCode;
if (btnSaveEmployeeWiseBebefit.Text == "Update")
{
string id = bebefitId.Value;
int result = employeeBenefitbll.UpdateUserWiseBebefit(employeeWiseBenefitObj, id);
if (result == 1)
{
Response.Redirect("EmployeeWiseBenefitList.aspx");
}
}
else
{
employeeWiseBenefitObj.ResionId = Convert.ToInt16(ddlRegion.SelectedValue);
employeeWiseBenefitObj.OfficeId = Convert.ToInt16(ddlOffice.SelectedValue);
employeeWiseBenefitObj.DepartmentId = Convert.ToInt16(drpDepartment.SelectedValue.ToString());
int result = employeeBenefitbll.SaveUserWiseBebefit(employeeWiseBenefitObj);
if (result == 1)
{
//lblMessage.Text = "Data Save Successfully.";
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Save Successfully')", true);
}
}
btnSaveEmployeeWiseBebefit.Text = "Submit";
Response.Redirect("EmployeeWiseBenefitList.aspx");
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true);
}
}
internal int UpdateUserWiseBebefits(HRM_EmployeeWiseBenefit aHRM_EmployeeWiseBenefit, string E_ID, DateTime ExistEffictiveDate)
{
try
{
HRM_EmployeeWiseBenefit obj = _context.HRM_EmployeeWiseBenefit.FirstOrDefault(x => (x.EID == E_ID) && (x.EffectiveDate == ExistEffictiveDate));
obj.Amount = aHRM_EmployeeWiseBenefit.Amount;
obj.BenefitTypeId = aHRM_EmployeeWiseBenefit.BenefitTypeId;
obj.EffectiveDate = aHRM_EmployeeWiseBenefit.EffectiveDate;
//obj.Individual_Tax = aHRM_EmployeeWiseBenefit.Individual_Tax;
//obj.Company_Tax = aHRM_EmployeeWiseBenefit.Company_Tax;
obj.EDIT_DATE = aHRM_EmployeeWiseBenefit.EDIT_DATE;
obj.EDIT_USER = aHRM_EmployeeWiseBenefit.EDIT_USER;
obj.OCODE = aHRM_EmployeeWiseBenefit.OCODE;
_context.SaveChanges();
return(1);
}
catch (Exception ex)
{
throw ex;
}
}
protected void btn_Confirm_Clcik(object sender, EventArgs e)
{
try
{
List <HRM_EmployeeWiseBenefit> attendances = new List <HRM_EmployeeWiseBenefit>();
foreach (GridViewRow gvRow in grdview.Rows)
{
CheckBox rowChkBox = ((CheckBox)gvRow.FindControl("rowLevelCheckBox"));
HRM_EmployeeWiseBenefit aHRM_EmployeeWiseBenefit = new HRM_EmployeeWiseBenefit();
if (rowChkBox.Checked == true)
{
Label lblEID = ((Label)gvRow.FindControl("lblEID"));
TextBox txtbx = ((TextBox)gvRow.FindControl("txtbx"));
aHRM_EmployeeWiseBenefit.EID = lblEID.Text;
aHRM_EmployeeWiseBenefit.BenefitTypeId = Convert.ToInt32(drpBenefitType.SelectedValue);
aHRM_EmployeeWiseBenefit.ResionId = Convert.ToInt32(ddlRegion1.SelectedValue);
aHRM_EmployeeWiseBenefit.OfficeId = Convert.ToInt32(ddlOffice1.SelectedValue);
if (ddlDept1.SelectedItem.Text == "--Select--")
{
aHRM_EmployeeWiseBenefit.DepartmentId = 0;
}
else
{
aHRM_EmployeeWiseBenefit.DepartmentId = Convert.ToInt32(ddlDept1.SelectedValue);
}
//aHRM_EmployeeWiseBenefit.DepartmentId = Convert.ToInt32(ddlDept1.SelectedValue);
aHRM_EmployeeWiseBenefit.EffectiveDate = Convert.ToDateTime(txtDate.Text);
aHRM_EmployeeWiseBenefit.Amount = Convert.ToDecimal(txtbx.Text);
aHRM_EmployeeWiseBenefit.OCODE = ((SessionUser)Session["SessionUser"]).OCode;
aHRM_EmployeeWiseBenefit.EDIT_DATE = DateTime.Now;
aHRM_EmployeeWiseBenefit.EDIT_USER = ((SessionUser)Session["SessionUser"]).UserId;
DateTime ExistEffictiveDate = Convert.ToDateTime(txtDate.Text);
int Benefitid = Convert.ToInt32(drpBenefitType.SelectedValue);
attendances = employeeBenefitbll.Get_BenifitAmountByEID_Date(lblEID.Text, Benefitid, ExistEffictiveDate);
//HRM_EmployeeWiseBenefit E_ID_EDate = employeeBenefitbll.GetAmountByEID();
if (attendances.Count > 0)
{
string E_ID = lblEID.Text;
int result = employeeBenefitbll.UpdateUserWiseBebefits(aHRM_EmployeeWiseBenefit, E_ID, ExistEffictiveDate);
if (result == 1)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Updated Successfully')", true);
grdview.DataSource = null;
grdview.DataBind();
}
}
else
{
int result = employeeBenefitbll.SaveUserWiseBebefit(aHRM_EmployeeWiseBenefit);
if (result == 1)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Save Successfully')", true);
grdview.DataSource = null;
grdview.DataBind();
}
}
}
}
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('No Employee selected in the list!')", true);
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true);
}
}
internal int UpdateUserWiseBebefits(HRM_EmployeeWiseBenefit aHRM_EmployeeWiseBenefit, string E_ID, DateTime ExistEffictiveDate)
{
return(employeeBenefitdal.UpdateUserWiseBebefits(aHRM_EmployeeWiseBenefit, E_ID, ExistEffictiveDate));
}
internal int UpdateUserWiseBebefit(HRM_EmployeeWiseBenefit employeeWiseBenefitObj, string id)
{
return(employeeBenefitdal.UpdateUserWiseBebefit(employeeWiseBenefitObj, id));
}
internal int SaveUserWiseBebefit(HRM_EmployeeWiseBenefit employeeWiseBenefitObj)
{
return(employeeBenefitdal.SaveUserWiseBebefit(employeeWiseBenefitObj));
}
