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)); }