protected void btnReleaseHeldUpSalary_Click(object sender, EventArgs e)
{
try
{
if (GridViewSalaryList.Rows.Count < 0)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('No Held Up Salary in the list!')", true);
}
foreach (GridViewRow gvRow in GridViewSalaryList.Rows)
{
CheckBox rowChkBox = ((CheckBox)gvRow.FindControl("rowLevelCheckBox"));
Label lblEID = ((Label)gvRow.FindControl("lblEID"));
TextBox txttotalDeductDay = ((TextBox)gvRow.FindControl("txttotalDeductDay"));
string eid = lblEID.Text.ToString();
DateTime salaryMonth = Convert.ToDateTime(txtFromDate.Text);
var helduplist = aSalary_Proccess_BLL.GetAll_HeldUpList(txtFromDate.Text).ToList();
if (rowChkBox.Checked == true)
{
if (helduplist.Count > 0)
{
HRM_Pay_Salary _HRM_Pay_Salary = new HRM_Pay_Salary();
_HRM_Pay_Salary = _context.HRM_Pay_Salary.Where(c => c.EID == eid && c.Salary_Month == salaryMonth).First();
_HRM_Pay_Salary.Pay_Status = true;
_HRM_Pay_Salary.IsSalaryRelease = true;
_HRM_Pay_Salary.OCode = ((SessionUser)Session["SessionUser"]).OCode;
_HRM_Pay_Salary.Edit_Date = DateTime.Now;
_HRM_Pay_Salary.Edit_User = ((SessionUser)Session["SessionUser"]).UserId;
try
{
_context.SaveChanges();
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Process Successfully')", true);
GridViewSalaryList.DataSource = null;
GridViewSalaryList.DataBind();
}
catch (Exception ex)
{
throw ex;
}
}
}
else
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('No Data Found!')", true);
}
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true);
}
}
internal int DeletePaySalaryByEIDandMonth(string eid, DateTime salaryMonth)
{
using (var _context = new ERPSSLHBEntities())
{
HRM_Pay_Salary paysalary = _context.HRM_Pay_Salary.FirstOrDefault(x => x.EID == eid && x.Salary_Month == salaryMonth);
if (paysalary != null)
{
_context.HRM_Pay_Salary.DeleteObject(paysalary);
_context.SaveChanges();
}
return(1);
}
}
public int InsertPaySalary(HRM_Pay_Salary aHRM_Pay_Salary)
{
try
{
using (var _context = new ERPSSLHBEntities())
{
_context.HRM_Pay_Salary.AddObject(aHRM_Pay_Salary);
_context.SaveChanges();
return(1);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message.ToString());
}
}
internal int UpdateHeldupSalary(List <HRM_Pay_Salary> lstHRM_Pay_Salary)
{
try
{
foreach (HRM_Pay_Salary aHRM_Pay_Salary in lstHRM_Pay_Salary)
{
HRM_Pay_Salary obj = _context.HRM_Pay_Salary.First(x => x.PaySalary_ID == aHRM_Pay_Salary.PaySalary_ID);
obj.Pay_Status = aHRM_Pay_Salary.Pay_Status;
obj.IsSalaryHeldup = aHRM_Pay_Salary.IsSalaryHeldup;
obj.OCode = aHRM_Pay_Salary.OCode;
obj.Edit_User = aHRM_Pay_Salary.Edit_User;
obj.Edit_Date = aHRM_Pay_Salary.Edit_Date;
_context.SaveChanges();
}
_context.SaveChanges();
return(1);
}
catch (Exception)
{
throw;
}
}
protected void btnConfirm_Click(object sender, EventArgs e)
{
try
{
if (GridViewEMP_AT.Rows.Count == 0)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('No processed salary in the list!')", true);
return;
}
List <HRM_PaySalary_Temp> aHRM_PaySalary_Temp = new List <HRM_PaySalary_Temp>();
aHRM_PaySalary_Temp = aSalary_Proccess_BLL.GetSalaryTemp(((SessionUser)Session["SessionUser"]).OCode, Convert.ToDateTime(txtDateFrom.Text));
foreach (HRM_PaySalary_Temp salary_temp in aHRM_PaySalary_Temp)
{
HRM_Pay_Salary salaryPay = new HRM_Pay_Salary();
salaryPay.EmpId = salary_temp.EmpId;
salaryPay.EID = salary_temp.EID;
salaryPay.Worked_Day = salary_temp.Worked_Day;
salaryPay.Total_Day_Of_Month = salary_temp.Total_Day_Of_Month;
salaryPay.Over_Time = salary_temp.Over_Time;
salaryPay.OT_Compliance = salary_temp.OT_Compliance;
salaryPay.OT_Extra = salary_temp.OT_Extra;
salaryPay.Work_Holiday = salary_temp.Work_Holiday;
salaryPay.Other_Holiday = salary_temp.Other_Holiday;
salaryPay.Total_Leave = salary_temp.Total_Leave;
salaryPay.Salary_Month = salary_temp.Salary_Month;
salaryPay.Date_Processed = salary_temp.Date_Processed;
salaryPay.Total_Basic_New = salary_temp.Total_Basic_New;
salaryPay.Payable_Salary = salary_temp.Payable_Salary;
salaryPay.Total_Gross_Sal_Compliance = salary_temp.Total_Gross_Sal_Compliance;
salaryPay.Net_Payable_Compliance = salary_temp.Net_Payable_Compliance;
salaryPay.Total_Gross_Sal = salary_temp.Total_Gross_Sal;
salaryPay.Net_Payable = salary_temp.Net_Payable;
salaryPay.Total_Tax = salary_temp.Total_Tax;
salaryPay.Total_Bonus = salary_temp.Total_Bonus;
salaryPay.Total_LateDeduction_Cost = salary_temp.Total_LateDeduction_Cost;
salaryPay.Total_Leave_Cost = salary_temp.Total_Leave_Cost;
salaryPay.Total_Absent_Cost = salary_temp.Total_Absent_Cost;
salaryPay.Pay_Status = salary_temp.Pay_Status;
salaryPay.Edit_User = salary_temp.Edit_User;
salaryPay.Edit_Date = salary_temp.Edit_Date;
salaryPay.OCode = salary_temp.OCode;
salaryPay.OT_Rate = salary_temp.OT_Rate;
salaryPay.OT_Compliance_Amount = salary_temp.OT_Compliance_Amount;
salaryPay.OT_Extra_Amount = salary_temp.OT_Extra_Amount;
salaryPay.OT_Taka = salary_temp.OT_Taka;
salaryPay.Attendance_Bonus = salary_temp.Attendance_Bonus;
salaryPay.Total_Deduction = salary_temp.Total_Deduction;
salaryPay.Total_Compliance_Deduction = salary_temp.Total_Compliance_Deduction;
salaryPay.P = salary_temp.P;
salaryPay.L = salary_temp.L;
salaryPay.SL = salary_temp.SL;
salaryPay.CL = salary_temp.CL;
salaryPay.ML = salary_temp.ML;
salaryPay.AL = salary_temp.AL;
salaryPay.LWP = salary_temp.LWP;
salaryPay.Absent_Day = salary_temp.Absent_Day;
salaryPay.Absent_Deduction = salary_temp.Absent_Deduction;
salaryPay.TotalDeductDay = salary_temp.TotalDeductDay;
salaryPay.Other_Deduction = salary_temp.Other_Deduction;
salaryPay.Salary_Punishment = salary_temp.Salary_Punishment;
salaryPay.Night_Bill = salary_temp.Night_Bill;
salaryPay.Holiday_Bill = salary_temp.Holiday_Bill;
salaryPay.Total_Benifit = salary_temp.Total_Benifit;
salaryPay.Stamp = salary_temp.Stamp;
salaryPay.AdvanceDeduction = salary_temp.AdvanceDeduction;
salaryPay.IsSalaryHeldup = salary_temp.IsSalaryHeldup;
//delete previous proccessed dated data
//List<HRM_Pay_Salary> paySalaryBydate = aSalary_Proccess_BLL.GetPaySalaryByDate_ByEID(Convert.ToDateTime(txtDateFrom.Text), salaryPay.EID);
//if (paySalaryBydate.Count > 0)
//{
aSalary_Proccess_BLL.DeletePaySalaryByEIDandMonth(salaryPay.EID, Convert.ToDateTime(salaryPay.Salary_Month));
//}
aSalary_Proccess_BLL.InsertPaySalary(salaryPay); // insert salary proccessed data from temp to original table
aSalary_Proccess_BLL.DeleteSalaryTemp(salary_temp.PaySalary_Temp_ID); //delete temp table data
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Salary processed successfully')", true);
//txtDateFrom.Text = "";
txtDateTo.Text = "";
ddlRegion.ClearSelection();
ddlOffice.ClearSelection();
txtWeekend.Text = "";
txtWeekend1.Text = "";
txtWeekend2.Text = "";
txtTotalDay.Text = "";
txtHoliday.Text = "";
lblTotalPayable.Text = "";
GridViewEMP_AT.DataSource = null;
GridViewEMP_AT.DataBind();
}
// create voucher to temp table
//string OCODE = ((SessionUser)Session["SessionUser"]).OCode;
//string Edit_User = ((SessionUser)Session["SessionUser"]).UserId.ToString();
//string Company_Code = "CMP201507251";
//string ModuleName = "Payroll";
//string ModuleType = "Salary";
//string VoucherType = "JOURNAL";
//var row = aSalary_Proccess_BLL.GetTotalPayableByDate(Convert.ToDateTime(txtDateFrom.Text)).ToList();
//if (row.Count > 0)
//{
// var Total = row.First();
// aSalary_Proccess_BLL.Enter_VoucherDetailsForTotalSalary(OCODE, Company_Code, Edit_User, ModuleName, ModuleType, VoucherType, Convert.ToDecimal(Total.TotalPayable),"n/a");
//}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true);
}
}
internal int Enter_VoucherDetails(string OCODE, string Company_Code, string Edit_User, string ModuleType, string VoucherType, HRM_Pay_Salary aHRM_Pay_Salary)
{
try
{
decimal Amount = 0;
Amount = Convert.ToDecimal(Amount) + (Convert.ToDecimal(aHRM_Pay_Salary.Total_Gross_Sal));
var Amount_ = new SqlParameter("@Amount", Amount);
var ModuleType_ = new SqlParameter("@ModuleName", ModuleType);
var VoucherType_ = new SqlParameter("@VoucherType", VoucherType);
var Edit_User_ = new SqlParameter("@Edit_User", Edit_User);
var Company_Code_ = new SqlParameter("@Company_Code", Company_Code);
var OCode_ = new SqlParameter("@OCode", OCODE);
var ItemCode_ = new SqlParameter("@ItemCode", "00");
string SP_SQL = "Vch_Enter_AC_VoucherDetails_by_Module @Amount,@ModuleName,@VoucherType,@Edit_User,@Company_Code,@OCode,@ItemCode";
return(_context.ExecuteStoreCommand(SP_SQL, Amount_, ModuleType_, VoucherType_, Edit_User_, Company_Code_, OCode_, ItemCode_));
}
catch (Exception)
{
throw;
}
}
protected void bthHeldup_Click(object sender, EventArgs e)
{
try
{
if (GridViewSalaryList.Rows.Count == 0)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('No generated salary in the list!')", true);
return;
}
List <HRM_Pay_Salary> lstHRM_Pay_Salary = new List <HRM_Pay_Salary>();
foreach (GridViewRow gvRow in GridViewSalaryList.Rows)
{
//CheckBox rowChkBox = ((CheckBox)gvRow.FindControl("rowLevelCheckBox"));
HRM_Pay_Salary _HRM_Pay_Salary = new HRM_Pay_Salary();
//if (rowChkBox.Checked == true)
//{
CheckBox rowheldupCheckBox = ((CheckBox)gvRow.FindControl("rowheldupCheckBox"));
Label lblSalaryId = (Label)gvRow.FindControl("lblSalaryId");
_HRM_Pay_Salary.PaySalary_ID = Convert.ToInt16(lblSalaryId.Text);
if (rowheldupCheckBox.Checked == true)
{
_HRM_Pay_Salary.IsSalaryHeldup = true;
}
else
{
_HRM_Pay_Salary.IsSalaryHeldup = false;
}
_HRM_Pay_Salary.Pay_Status = false;
_HRM_Pay_Salary.OCode = ((SessionUser)Session["SessionUser"]).OCode;
_HRM_Pay_Salary.Edit_User = ((SessionUser)Session["SessionUser"]).UserId;
_HRM_Pay_Salary.Edit_Date = DateTime.Now;
lstHRM_Pay_Salary.Add(_HRM_Pay_Salary);
//}
}
int result = aSalary_Proccess_BLL.UpdateHeldupSalary(lstHRM_Pay_Salary);
if (result == 1)
{
//GridViewSalaryList.DataSource = null;
//GridViewSalaryList.DataBind();
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Processed Successfully')", true);
}
else
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Processing Faliure!')", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true);
}
}
protected void BtnSave_Click(object sender, EventArgs e)
{
try
{
if (GridViewSalaryList.Rows.Count == 0)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('No processed salray in the list!')", true);
return;
}
List <HRM_Pay_Salary> lstHRM_Pay_Salary = new List <HRM_Pay_Salary>();
foreach (GridViewRow gvRow in GridViewSalaryList.Rows)
{
//CheckBox rowChkBox = ((CheckBox)gvRow.FindControl("rowLevelCheckBox"));
HRM_Pay_Salary _HRM_Pay_Salary = new HRM_Pay_Salary();
//if (rowChkBox.Checked == true)
//{
CheckBox rowheldupCheckBox = ((CheckBox)gvRow.FindControl("rowheldupCheckBox"));
Label lblSalaryId = (Label)gvRow.FindControl("lblSalaryId");
_HRM_Pay_Salary.PaySalary_ID = Convert.ToInt32(lblSalaryId.Text);
if (rowheldupCheckBox.Checked == true)
{
_HRM_Pay_Salary.IsSalaryHeldup = true;
_HRM_Pay_Salary.Pay_Status = false;
}
else
{
_HRM_Pay_Salary.IsSalaryHeldup = false;
_HRM_Pay_Salary.Pay_Status = true;
}
_HRM_Pay_Salary.OCode = ((SessionUser)Session["SessionUser"]).OCode;
_HRM_Pay_Salary.Edit_User = ((SessionUser)Session["SessionUser"]).UserId;
_HRM_Pay_Salary.Edit_Date = DateTime.Now;
lstHRM_Pay_Salary.Add(_HRM_Pay_Salary);
//}
}
int result = aSalary_Proccess_BLL.UpdateHeldupSalary(lstHRM_Pay_Salary);
if (result == 1)
{
// // create voucher to temp table
// string OCODE = ((SessionUser)Session["SessionUser"]).OCode;
// string Edit_User = ((SessionUser)Session["SessionUser"]).UserId.ToString();
// string Company_Code = "CMP201507251";
// string ModuleName = "Payroll";
// string ModuleType = "Salary";
// string VoucherType = "JOURNAL";
// var row1 = aSalary_Proccess_BLL.GetTotalNetPayableByDate(Convert.ToDateTime(txtFromDate.Text)).ToList();
// var row2 = aSalary_Proccess_BLL.GetTotalHeldUpByDate(Convert.ToDateTime(txtFromDate.Text)).ToList();
// var row3 = aSalary_Proccess_BLL.GetTotalPayableByDate(Convert.ToDateTime(txtFromDate.Text)).ToList();
// var row4 = aSalary_Proccess_BLL.GetTotalTDSByDate(Convert.ToDateTime(txtFromDate.Text)).ToList();
// var row5 = aSalary_Proccess_BLL.GetTotalAdvanceByDate(Convert.ToDateTime(txtFromDate.Text)).ToList();
// var row6 = aSalary_Proccess_BLL.GetTotalStampByDate(Convert.ToDateTime(txtFromDate.Text)).ToList();
// if (row3.Count > 0)
// {
// var TotalPayable = row3.First();
// var netPayable = row1.First();
// var TDSPayable = row4.First();
// var HeldPayable = (row2.Count > 0 ? row2.First() : null);
// var AdvancePayable = row5.First();
// var StampPayable = row6.First();
// aSalary_Proccess_BLL.Enter_VoucherDetailsForTotalSalary(OCODE, Company_Code, Edit_User, ModuleName, ModuleType, VoucherType, Convert.ToDecimal(TotalPayable.Net_Payable), Convert.ToDecimal(netPayable.Net_Payable)
// , (HeldPayable == null ? 0 : Convert.ToDecimal(HeldPayable.Net_Payable))
// , Convert.ToDecimal(TDSPayable.TotalTax), Convert.ToDecimal(AdvancePayable.AdvanceDeduction), Convert.ToDecimal(StampPayable.Stamp), "n/a");
//}
/////
GridViewSalaryList.DataSource = null;
GridViewSalaryList.DataBind();
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Processed Successfully')", true);
}
else
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Processing Faliure!')", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true);
}
}
public int InsertPaySalary(HRM_Pay_Salary aHRM_Pay_Salary)
{
return(aSalaryProccess_DAL.InsertPaySalary(aHRM_Pay_Salary));
}
internal int Enter_VoucherDetails(string OCODE, string Company_Code, string Edit_User, string ModuleType, string VoucherType, HRM_Pay_Salary aHRM_Pay_Salary)
{
return(aSalaryProccess_DAL.Enter_VoucherDetails(OCODE, Company_Code, Edit_User, ModuleType, VoucherType, aHRM_Pay_Salary));
}
