protected void rcmb_AttPeriodElement_SelectedIndexChanged(object o, RadComboBoxSelectedIndexChangedEventArgs e) { try { if (rcmb_AttPeriodElement.SelectedIndex > 0) { SMHR_EMPLOYEETRANSACTION _obj_smhr_emptrans = new SMHR_EMPLOYEETRANSACTION(); _obj_smhr_emptrans.EMPBNKTRN_BU_ID = Convert.ToInt32(rcmb_AttBusinessUnit.SelectedValue); _obj_smhr_emptrans.EMPBNKTRN_ORG_ID = Convert.ToInt32(Session["ORG_ID"]); _obj_smhr_emptrans.EMPBNKTRN_PERIOD_ID = Convert.ToInt32(rcmb_AttPeriod.SelectedValue); _obj_smhr_emptrans.EMPBNKTRN_PRDDTL_ID = Convert.ToInt32(rcmb_AttPeriodElement.SelectedValue); _obj_smhr_emptrans.OPERATION = operation.Select; DataTable dt_Details = BLL.get_EmpTrans(_obj_smhr_emptrans); if (dt_Details.Rows.Count != 0) { rg_Attendence.DataSource = dt_Details; rg_Attendence.DataBind(); rg_Attendence.Visible = true; for (int index = 0; index < rg_Attendence.Items.Count; index++) { if (rg_Attendence.Items[index]["STATUS"].Text == "1") { rg_Attendence.Items[index].Enabled = false; } } } else { BLL.ShowMessage(this, "No Records to Display"); rg_Attendence.DataSource = dt_Details; rg_Attendence.DataBind(); rg_Attendence.Visible = true; } } else { BLL.ShowMessage(this, "Select Period Element!"); rg_Attendence.DataSource = null; rg_Attendence.DataBind(); rg_Attendence.Visible = false; return; } } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "EmpTransDetails", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); return; } }
protected void btn_Save_Click(object sender, EventArgs e) { try { bool selected = false; int records_saved = 0; SMHR_EMPLOYEETRANSACTION obj = new SMHR_EMPLOYEETRANSACTION(); obj.EMPBNKTRN_BU_ID = Convert.ToInt32(rcmb_AttPeriod.SelectedItem.Value); obj.EMPBNKTRN_PRDDTL_ID = Convert.ToInt32(rcmb_AttPeriodElement.SelectedItem.Value); obj.CREATEDBY = Convert.ToInt32(Session["USER_ID"]); obj.CREATEDDATE = DateTime.Now; obj.EMPBNKTRN_ORG_ID = Convert.ToInt32(Session["org_id"]); obj.EMPBNKTRN_PERIOD_ID = Convert.ToInt32(rcmb_AttPeriod.SelectedItem.Value); obj.EMPBNKTRN_TRAN_STATUS = Convert.ToInt32(rcmb_AttPeriod.SelectedItem.Value); for (int k = 0; k < rg_Attendence.Items.Count; k++) { CheckBox chk = rg_Attendence.Items[k].FindControl("chckbtn_Select") as CheckBox; if (chk.Checked) { selected = true; //Label lbl_emp_id = rg_Attendence.Items[k].FindControl("EMP_ID") as Label; Label lbl_emp_id = rg_Attendence.Items[k].FindControl("lbl_Empid") as Label; Label lbl_bank_id = rg_Attendence.Items[k].FindControl("lbl_Bankid") as Label; RadNumericTextBox rnt = new Telerik.Web.UI.RadNumericTextBox(); rnt = rg_Attendence.Items[k].FindControl("RadNumericTextBox1") as RadNumericTextBox; obj.EMPBNKTRN_AMOUNT = Convert.ToDouble(rnt.Value); obj.EMPBNKTRN_BANK_DTLS_ID = Convert.ToInt32(lbl_bank_id.Text); obj.EMPBNKTRN_EMP_ID = Convert.ToInt32(lbl_emp_id.Text); obj.OPERATION = operation.Check; //if (Convert.ToString(BLL.check_EmpTrans(obj).Rows[0]["Count"]) != "0") DataTable dt_Exist = BLL.check_EmpTrans(obj); if (dt_Exist.Rows[0][0].ToString() != "0") { BLL.ShowMessage(this, "Employee with this combination Already Exists"); return; } obj.OPERATION = operation.Insert; if (BLL.set_EmpTrans(obj)) { records_saved += 1; } //multiple times same message will be displayed // BLL.ShowMessage(this, "Information Saved Successfully"); //else // BLL.ShowMessage(this, "Information Not Saved"); } } if (!selected) { BLL.ShowMessage(this, "Select Atleast One Employee"); return; } else { BLL.ShowMessage(this, "Total Records Saved Are:" + records_saved); } } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "EmpTransDetails", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); return; } }
protected void btn_Save_Click(object sender, EventArgs e) { try { bool selected = false; int records_saved = 0; SMHR_EMPLOYEETRANSACTION obj = new SMHR_EMPLOYEETRANSACTION(); obj.EMPBNKTRN_BU_ID = Convert.ToInt32(rcmb_AttBusinessUnit.SelectedItem.Value); obj.EMPBNKTRN_PRDDTL_ID = Convert.ToInt32(rcmb_AttPeriodElement.SelectedItem.Value); obj.CREATEDBY = Convert.ToInt32(Session["USER_ID"]); obj.CREATEDDATE = DateTime.Now; obj.EMPBNKTRN_ORG_ID = Convert.ToInt32(Session["org_id"]); obj.EMPBNKTRN_PERIOD_ID = Convert.ToInt32(rcmb_AttPeriod.SelectedItem.Value); obj.EMPBNKTRN_TRAN_STATUS = Convert.ToInt32(rcmb_AttPeriod.SelectedItem.Value); for (int k = 0; k < rg_Attendence.Items.Count; k++) { CheckBox chk = rg_Attendence.Items[k].FindControl("chckbtn_Select") as CheckBox; if (chk.Checked) { selected = true; //Label lbl_emp_id = rg_Attendence.Items[k].FindControl("EMP_ID") as Label; Label lbl_emp_id = rg_Attendence.Items[k].FindControl("lbl_Empid") as Label; Label lbl_bank_id = rg_Attendence.Items[k].FindControl("lbl_Bankid") as Label; RadNumericTextBox rnt = new Telerik.Web.UI.RadNumericTextBox(); rnt = rg_Attendence.Items[k].FindControl("RadNumericTextBox1") as RadNumericTextBox; obj.EMPBNKTRN_AMOUNT = Convert.ToDouble(rnt.Value); obj.EMPBNKTRN_BANK_DTLS_ID = Convert.ToInt32(lbl_bank_id.Text); obj.EMPBNKTRN_EMP_ID = Convert.ToInt32(lbl_emp_id.Text); obj.OPERATION = operation.Check; //if (Convert.ToString(BLL.check_EmpTrans(obj).Rows[0]["Count"]) != "0") DataTable dt_Exist = BLL.check_EmpTrans(obj); if (dt_Exist.Rows[0][0].ToString() != "0") { BLL.ShowMessage(this, "Employee with this combination Already Exists"); return; } _obj_smhr_payroll = new SMHR_PAYROLL(); _obj_smhr_payroll.MODE = 33; _obj_smhr_payroll.BUID = Convert.ToInt32(rcmb_AttBusinessUnit.SelectedItem.Value); _obj_smhr_payroll.EMP_ID = Convert.ToInt32(lbl_emp_id.Text); _obj_smhr_payroll.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]); _obj_smhr_payroll.PERIODDTLID = Convert.ToInt32(rcmb_AttPeriodElement.SelectedItem.Value); _obj_smhr_payroll.PERODID = Convert.ToInt32(rcmb_AttPeriod.SelectedItem.Value); DataTable dtPayrollCheck = BLL.get_PayDetails(_obj_smhr_payroll); if (Convert.ToString(dtPayrollCheck.Rows[0]["COUNT"]) != "0") { BLL.ShowMessage(this, "Payroll has not been approved yet"); } else { _obj_smhr_payroll.MODE = 34; DataTable dtPayroll = BLL.get_PayDetails(_obj_smhr_payroll); if (Convert.ToString(dtPayroll.Rows[0]["COUNT"]) != "0") { obj.OPERATION = operation.Insert; if (BLL.set_EmpTrans(obj)) { records_saved += 1; } } else { BLL.ShowMessage(this, "Payroll has not been processed for this month"); } } //obj.OPERATION = operation.Insert; //if (BLL.set_EmpTrans(obj)) // records_saved += 1; //multiple times same message will be displayed // BLL.ShowMessage(this, "Information Saved Successfully"); //else // BLL.ShowMessage(this, "Information Not Saved"); } } if (!selected) { BLL.ShowMessage(this, "Select Atleast One Employee"); return; } else { BLL.ShowMessage(this, "Total Records Saved Are:" + records_saved); SMHR_EMPLOYEETRANSACTION _obj_smhr_emptrans = new SMHR_EMPLOYEETRANSACTION(); _obj_smhr_emptrans.EMPBNKTRN_BU_ID = Convert.ToInt32(rcmb_AttBusinessUnit.SelectedValue); _obj_smhr_emptrans.EMPBNKTRN_ORG_ID = Convert.ToInt32(Session["ORG_ID"]); _obj_smhr_emptrans.EMPBNKTRN_PERIOD_ID = Convert.ToInt32(rcmb_AttPeriod.SelectedValue); _obj_smhr_emptrans.EMPBNKTRN_PRDDTL_ID = Convert.ToInt32(rcmb_AttPeriodElement.SelectedValue); _obj_smhr_emptrans.OPERATION = operation.Select; DataTable dt_Details = BLL.get_EmpTrans(_obj_smhr_emptrans); if (dt_Details.Rows.Count != 0) { rg_Attendence.DataSource = dt_Details; rg_Attendence.DataBind(); rg_Attendence.Visible = true; for (int index = 0; index < rg_Attendence.Items.Count; index++) { if (rg_Attendence.Items[index]["STATUS"].Text == "1") { rg_Attendence.Items[index].Enabled = false; } } } } } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "EmpTransDetails", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); return; } }