void BindGridEmployeeSalaryByOffice() { try { string OCODE = ((SessionUser)Session["SessionUser"]).OCode; List <Salary_Viewer> empSalary = new List <Salary_Viewer>(); empSalary = aSalary_Proccess_BLL.Get_SalProccess_TempByOffice(Convert.ToDateTime(txtDateFrom.Text), Convert.ToInt16(ddlOffice.SelectedValue)).ToList(); if (empSalary.Count > 0) { GridViewEMP_AT.DataSource = empSalary.ToList(); GridViewEMP_AT.DataBind(); } else { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('No Data Processed!')", true); GridViewEMP_AT.DataSource = null; GridViewEMP_AT.DataBind(); } } catch (Exception ex) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true); } }
void BindGridEmployeeAttendanceById(string id) { string OCODE = ((SessionUser)Session["SessionUser"]).OCode; var row = objAtt_BLL.GetAllAttendance(OCODE).ToList(); var employee = row.Where(x => x.EID == id && x.Attendance_Date == Convert.ToDateTime(txtAttDate.Text)).ToList(); GridViewEMP_AT.DataSource = employee; GridViewEMP_AT.DataBind(); }
void BindGridEmployeeAttendance() { try { string OCODE = ((SessionUser)Session["SessionUser"]).OCode; //DateTime attDate = Convert.ToDateTime(txtAttDate.Text); using (ERPSSLHBEntities context = new ERPSSLHBEntities()) { if (context.HRM_ATTENDANCE.Count() > 0) { var row = objAtt_BLL.GetAllAttendance(OCODE).ToList(); if (row.Count > 0) { GridViewEMP_AT.DataSource = row.ToList(); GridViewEMP_AT.DataBind(); } } else { var obj = new List <HRM_ATTENDANCE>(); obj.Add(new HRM_ATTENDANCE()); // Bind the DataTable which contain a blank row to the GridView GridViewEMP_AT.DataSource = obj; GridViewEMP_AT.DataBind(); int columnsCount = GridViewEMP_AT.Columns.Count; GridViewEMP_AT.Rows[0].Cells.Clear(); // clear all the cells in the row GridViewEMP_AT.Rows[0].Cells.Add(new TableCell()); //add a new blank cell GridViewEMP_AT.Rows[0].Cells[0].ColumnSpan = columnsCount; //set the column span to the new added cell GridViewEMP_AT.Rows[0].Cells[0].HorizontalAlign = HorizontalAlign.Center; GridViewEMP_AT.Rows[0].Cells[0].ForeColor = System.Drawing.Color.Red; GridViewEMP_AT.Rows[0].Cells[0].Font.Bold = true; //set No Results found to the new added cell GridViewEMP_AT.Rows[0].Cells[0].Text = "NO RECORDS FOUND!"; } } } catch (Exception ex) { throw ex; } }
void BindGridAttendanceByEID() { try { string OCODE = ((SessionUser)Session["SessionUser"]).OCode; using (ERPSSLHBEntities context = new ERPSSLHBEntities()) { if (context.HRM_ATTENDANCE.Count() > 0) { var row = objAtt_BLL.GetAttendanceByEID(OCODE, txtEID.Text).ToList(); if (row.Count > 0) { GridViewEMP_AT.DataSource = row.ToList(); GridViewEMP_AT.DataBind(); } } else { var obj = new List <HRM_ATTENDANCE>(); obj.Add(new HRM_ATTENDANCE()); // Bind the DataTable which contain a blank row to the GridView GridViewEMP_AT.DataSource = obj; GridViewEMP_AT.DataBind(); int columnsCount = GridViewEMP_AT.Columns.Count; GridViewEMP_AT.Rows[0].Cells.Clear(); // clear all the cells in the row GridViewEMP_AT.Rows[0].Cells.Add(new TableCell()); //add a new blank cell GridViewEMP_AT.Rows[0].Cells[0].ColumnSpan = columnsCount; //set the column span to the new added cell GridViewEMP_AT.Rows[0].Cells[0].HorizontalAlign = HorizontalAlign.Center; GridViewEMP_AT.Rows[0].Cells[0].ForeColor = System.Drawing.Color.Red; GridViewEMP_AT.Rows[0].Cells[0].Font.Bold = true; //set No Results found to the new added cell GridViewEMP_AT.Rows[0].Cells[0].Text = "NO RECORDS FOUND!"; } } } catch (Exception ex) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true); } }
protected void btnUpdate_Click(object sender, EventArgs e) { try { string OCODE = ((SessionUser)Session["SessionUser"]).OCode; List <string> ShiftCodes = objAtt_BLL.GetAllShiftCode(OCODE).ToList(); foreach (string ashiftcode in ShiftCodes) { var result = objAtt_BLL.UpdateOT_ByDateandShift(Convert.ToDateTime(txtDateFrom.Text), Convert.ToDateTime(txtDateTo.Text), ashiftcode); if (result == 1) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('OT Processed Successfully')", true); BindGridEmployeeAttendance(); } else { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('OT Processing Failure!')", true); GridViewEMP_AT.DataSource = null; GridViewEMP_AT.DataBind(); } } //ot process log DateTime fromdate = Convert.ToDateTime(txtDateFrom.Text.Trim()); DateTime todate = Convert.ToDateTime(txtDateTo.Text.Trim()); Guid USERID = ((SessionUser)Session["SessionUser"]).UserId; var ParamempID1 = new SqlParameter("@DateFrom", fromdate); var ParamempID2 = new SqlParameter("@DateTo", todate); var ParamempID3 = new SqlParameter("@Edit_User", USERID); var ParamempID4 = new SqlParameter("@Edit_Date", DateTime.Now); var ParamempID5 = new SqlParameter("@OCODE", OCODE); string SP_SQL = "HRM_Insert_OTProcessLog @DateFrom, @DateTo, @Edit_User, @Edit_Date, @OCODE"; context.ExecuteStoreCommand(SP_SQL, ParamempID1, ParamempID2, ParamempID3, ParamempID4, ParamempID5); } catch (Exception ex) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true); } }
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); } }
private void BindGridForBankAdvice() { try { string OCODE = ((SessionUser)Session["SessionUser"]).OCode; List <BankAdviceRe> Bank1 = new List <BankAdviceRe>(); if (drpDepartment.SelectedValue != " " && txtDateFrom.Text != "" && txtEid_TRNS.Text == "") { string FormDate = txtDateFrom.Text.ToString(); //DateTime Todate = Convert.ToDateTime(txtDateFrom.Text.ToString()); string dptId = drpDepartment.SelectedValue.ToString(); List <BankAdviceRe> Bank2 = new List <BankAdviceRe>(); Bank2 = objAtt_BLL.GetBankAdviceByDepartmentId(OCODE, dptId, FormDate).ToList(); if (Bank2.Count > 0) { GridViewEMP_AT.DataSource = Bank2.ToList(); GridViewEMP_AT.DataBind(); } else { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('No Data Found!')", true); } } else if (txtDateFrom.Text != "" && txtEid_TRNS.Text != "") { string eid = txtEid_TRNS.Text.ToString(); string FormDate = txtDateFrom.Text.ToString(); //DateTime Todate = Convert.ToDateTime(txtDateFrom.Text.ToString()); List <BankAdviceRe> Bank3 = new List <BankAdviceRe>(); Bank3 = objAtt_BLL.GetBankAdviceByEid(OCODE, eid, FormDate).ToList(); if (Bank3.Count > 0) { GridViewEMP_AT.DataSource = Bank3.ToList(); GridViewEMP_AT.DataBind(); } else { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('No Data Found!')", true); } } else { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Select Item !')", true); //Bank1 = objAtt_BLL.GetBankAdviceAll(OCODE).ToList(); //if (Bank1.Count > 0) //{ // GridViewEMP_AT.DataSource = Bank1.ToList(); // GridViewEMP_AT.DataBind(); //} } } catch (Exception ex) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true); } }
protected void btnAttSubmit_Click(object sender, EventArgs e) { try { Attendance_BLL _attendancebll = new Attendance_BLL(); List <HRM_ATTENDANCE> attendances = new List <HRM_ATTENDANCE>(); foreach (GridViewRow gvRow in GridViewEMP_AT.Rows) { CheckBox rowChkBox = ((CheckBox)gvRow.FindControl("rowLevelCheckBox")); HRM_ATTENDANCE obj = new HRM_ATTENDANCE(); if (rowChkBox.Checked == true) { Label lblId = ((Label)gvRow.FindControl("lblId")); TextBox txtbxExtraOtAdd = ((TextBox)gvRow.FindControl("OTExtraAdd")); Label lblAttnDate = ((Label)gvRow.FindControl("lblAttnDate")); //Label lbltotalot = ((Label)gvRow.FindControl("lbltotalot")); //double totalOT = Convert.ToDouble(lbltotalot.Text); DateTime otDate = Convert.ToDateTime(lblAttnDate.Text); obj.ATTE_ID = Convert.ToInt32(lblId.Text); int AttId = Convert.ToInt32(obj.ATTE_ID); if (rdExtraOT.Checked) { obj.OT_ExtraAdd = Convert.ToInt32(txtbxExtraOtAdd.Text); // obj.OT_Total = totalOT + Convert.ToDouble(txtbxExtraOtAdd.Text); } else if (rdExtraOTDeduct.Checked) { obj.OT_Deduction = Convert.ToInt32(txtbxExtraOtAdd.Text); // obj.OT_Total = totalOT - Convert.ToDouble(txtbxExtraOtAdd.Text); } obj.OCode = ((SessionUser)Session["SessionUser"]).OCode; obj.Edit_Date = DateTime.Now; obj.Edit_User = ((SessionUser)Session["SessionUser"]).UserId; var result = objAtt_BLL.UpdateAttendanceOT(obj, AttId); if (result == 1) { //ot process string OCODE = Convert.ToString(((SessionUser)Session["SessionUser"]).OCode); string userId = Convert.ToString(((SessionUser)Session["SessionUser"]).UserId); objAtt_BLL.UpdateOT_ByShift_EID(otDate, otDate, hdnEmployeeShiftCode.Value, txtEid_AT.Text); //ot process log var ParamempID1 = new SqlParameter("@DateFrom", Convert.ToDateTime(otDate)); var ParamempID2 = new SqlParameter("@DateTo", Convert.ToDateTime(otDate)); var ParamempID3 = new SqlParameter("@Edit_User", userId); var ParamempID4 = new SqlParameter("@Edit_Date", DateTime.Now); var ParamempID5 = new SqlParameter("@OCODE", OCODE); string SP_SQL = "HRM_Insert_OTProcessLog @DateFrom, @DateTo, @Edit_User, @Edit_Date, @OCODE"; context.ExecuteStoreCommand(SP_SQL, ParamempID1, ParamempID2, ParamempID3, ParamempID4, ParamempID5); ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Update Successfully.')", true); // load grid DateTime fromdate = Convert.ToDateTime(txtfromDate.Text); DateTime toDate = Convert.ToDateTime(txtToDate.Text); var row = objAtt_BLL.GetAttendanceByEID(txtEid_AT.Text).Where(x => x.Attendance_Date >= fromdate && x.Attendance_Date <= toDate).ToList(); if (row.Count > 0) { GridViewEMP_AT.DataSource = row.ToList(); GridViewEMP_AT.DataBind(); } else { GridViewEMP_AT.DataSource = null; GridViewEMP_AT.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); } }
protected void btnSearch_Click(object sender, EventArgs e) { try { if (txtfromDate.Text == "") { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Input Date!')", true); } if (txtEid_AT.Text == "") { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Input E-ID!')", true); } string OCODE = ((SessionUser)Session["SessionUser"]).OCode; DateTime fromdate = Convert.ToDateTime(txtfromDate.Text); DateTime toDate = Convert.ToDateTime(txtToDate.Text); using (ERPSSLHBEntities context = new ERPSSLHBEntities()) { if (context.HRM_ATTENDANCE.Count() > 0) { var row = objAtt_BLL.GetAttendanceByEID(txtEid_AT.Text).Where(x => x.Attendance_Date >= fromdate && x.Attendance_Date <= toDate).ToList(); if (row.Count > 0) { GridViewEMP_AT.DataSource = row.ToList(); GridViewEMP_AT.DataBind(); } else { GridViewEMP_AT.DataSource = null; GridViewEMP_AT.DataBind(); } } else { var obj = new List <HRM_ATTENDANCE>(); obj.Add(new HRM_ATTENDANCE()); // Bind the DataTable which contain a blank row to the GridView GridViewEMP_AT.DataSource = obj; GridViewEMP_AT.DataBind(); int columnsCount = GridViewEMP_AT.Columns.Count; GridViewEMP_AT.Rows[0].Cells.Clear(); // clear all the cells in the row GridViewEMP_AT.Rows[0].Cells.Add(new TableCell()); //add a new blank cell GridViewEMP_AT.Rows[0].Cells[0].ColumnSpan = columnsCount; //set the column span to the new added cell GridViewEMP_AT.Rows[0].Cells[0].HorizontalAlign = HorizontalAlign.Center; GridViewEMP_AT.Rows[0].Cells[0].ForeColor = System.Drawing.Color.Red; GridViewEMP_AT.Rows[0].Cells[0].Font.Bold = true; //set No Results found to the new added cell GridViewEMP_AT.Rows[0].Cells[0].Text = "NO RECORDS FOUND!"; } } } catch (Exception ex) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true); } }