protected void btn_submit_Click(object sender, EventArgs e) { try { if (rc_financialPeriod.SelectedIndex <= 0) { BLL.ShowMessage(this, "Please Select Financial Period"); return; } DataTable dtGadeWiseData = GetGadeWiseAMount(); SMHR_LOANSETUP smhr_LoanSetup = new SMHR_LOANSETUP(); smhr_LoanSetup.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]); smhr_LoanSetup.LOANSETUP_GRIDDATA = dtGadeWiseData; smhr_LoanSetup.LOANSETUP_FINPERIODID = Convert.ToInt32(rc_financialPeriod.SelectedValue); smhr_LoanSetup.CREATEDBY = Convert.ToInt32(Session["USER_ID"]); // ### Need to Get the Session smhr_LoanSetup.CREATEDDATE = DateTime.Now; smhr_LoanSetup.LASTMDFBY = Convert.ToInt32(Session["USER_ID"]); // ### Need to Get the Session smhr_LoanSetup.LASTMDFDATE = DateTime.Now; switch (((Button)sender).ID.ToUpper()) { case "BTN_SUBMIT": smhr_LoanSetup.OPERATION = operation.Insert; if (BLL.set_LoanSetup(smhr_LoanSetup)) { BLL.ShowMessage(this, "Information Saved Successfully"); } else { BLL.ShowMessage(this, "Information Not Saved"); } break; default: break; } rc_financialPeriod.ClearSelection(); rc_financialPeriod.Text = string.Empty; RG_TrainingApproval.Visible = false; btn_submit.Visible = false; btn_Cancel.Visible = false; } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_LoanSetup", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
protected void lnk_Edit_Command(object sender, CommandEventArgs e) { try { rblConfigure.ClearSelection(); trLoanInterest.Visible = false; trConfig.Visible = true; trProcessType.Visible = false; trInsurance.Visible = false; LoadCombos(); LoadProject(); //to load project // LoadBU(); ClearControls(); DataTable dt; _obj_Smhr_Payitems = new SMHR_PAYITEMS(); //lbl_Request.Visible = true; _obj_Smhr_Payitems.PAYITEM_ID = Convert.ToInt32(Convert.ToString(e.CommandArgument)); lbl_PayItemID.Text = Convert.ToString(e.CommandArgument); dt = BLL.get_PayItems(_obj_Smhr_Payitems); if (dt.Rows.Count > 0) { //PAYITEM_LOAN_PROCESSTYPE rtxt_PayItemCode.Text = Convert.ToString(dt.Rows[0]["PAYITEM_PAYITEMNAME"]); rtxt_PayItemDesc.Text = Convert.ToString(dt.Rows[0]["PAYITEM_PAYDESC"]); rcmb_PayItemType.SelectedIndex = rcmb_PayItemType.Items.FindItemIndexByValue(Convert.ToString(dt.Rows[0]["PAYITEM_ITEMTYPE_ID"])); rcmb_PayItemMode.SelectedIndex = rcmb_PayItemMode.Items.FindItemIndexByValue(Convert.ToString(dt.Rows[0]["PAYITEM_ITEMMODE_ID"])); //rcmb_PayCalMode.SelectedItem.Text = Convert.ToString(dt.Rows[0]["PAYITEM_CALMODE"]); rcmb_PayCalMode.SelectedIndex = rcmb_PayCalMode.Items.FindItemIndexByText(Convert.ToString(dt.Rows[0]["PAYITEM_CALMODE"])); // rcmb_YTDType.SelectedIndex = rcmb_YTDType.Items.FindItemIndexByText(Convert.ToString(dt.Rows[0]["PAYITEM_YTD"])); //rbtn_ProcessingType.SelectedIndex = (Convert.ToString(dt.Rows[0]["PAYITEM_PROCESSTYPE"]).ToUpper() == "FALSE" ? 1 : 2); rbtn_ProcessingType.SelectedIndex = Convert.ToInt32(dt.Rows[0]["PAYITEM_PROCESSTYPE"]); //rblConfigure.SelectedIndex = (Convert.ToString(dt.Rows[0]["ALLOWANCE_CONFG_ID"]).ToUpper() == "FALSE" ? 1:0); rdt_PayItemStartDate.SelectedDate = Convert.ToDateTime(dt.Rows[0]["PAYITEM_STARTDATE"]); RNT_MinimumValue.Text = Convert.ToString(dt.Rows[0]["PAYITEM_MINIMUM_PERCENTAGE_VALUE"]); if (dt.Rows[0]["PAYITEM_ENDDATE"] == DBNull.Value) { rdtp_PayItemEnddate.SelectedDate = null; } else { rdtp_PayItemEnddate.SelectedDate = Convert.ToDateTime(dt.Rows[0]["PAYITEM_ENDDATE"]); } chk_PrintinPayRegister.Checked = Convert.ToBoolean(dt.Rows[0]["PAYITEM_PRINTINPAYREG"]); if (Convert.ToString(dt.Rows[0]["PAYITEM_ISBENEFITABLE"]) != "") { chk_Benfit.Checked = Convert.ToBoolean(dt.Rows[0]["PAYITEM_ISBENEFITABLE"].ToString()); } if (Convert.ToString(dt.Rows[0]["PAYITEM_ISTAXABLE"]) != "") { chk_Istaxable.Checked = Convert.ToBoolean(dt.Rows[0]["PAYITEM_ISTAXABLE"]); } if (Convert.ToString(dt.Rows[0]["PAYITEM_ISOA_INCLUDED"]) != "") { chk_Oaincluded.Checked = Convert.ToBoolean(dt.Rows[0]["PAYITEM_ISOA_INCLUDED"]); } if (Convert.ToString(dt.Rows[0]["PAYITEM_ISAFFECTLOP"]) != "") { chk_AffectLop.Checked = Convert.ToBoolean(dt.Rows[0]["PAYITEM_ISAFFECTLOP"]); } chk_Automatic.Checked = Convert.ToBoolean(dt.Rows[0]["PAYITEM_AUTOMATIC"]); chk_CTC.Checked = Convert.ToBoolean(dt.Rows[0]["PAYITEM_CTC"]); chk_IndividualPrint.Checked = Convert.ToBoolean(dt.Rows[0]["PAYITEM_INDIVIDUAL"]); //chk_PrintPaySlip.Checked = Convert.ToBoolean(dt.Rows[0]["PAYITEM_PRINTINPAYSLIP"]); if (Convert.ToString(dt.Rows[0]["PAYITEM_PRINTINPAYSLIP"]) != null) { chk_PrintPaySlip.Checked = Convert.ToBoolean(dt.Rows[0]["PAYITEM_PRINTINPAYSLIP"]); } if (dt.Rows[0]["PAYITEM_ISLOANVAILDATE"] != System.DBNull.Value) { chk_loanval.Checked = Convert.ToBoolean(dt.Rows[0]["PAYITEM_ISLOANVAILDATE"]); } if (dt.Rows[0]["PAYITEM_ISNULLIFY"] != System.DBNull.Value) { chkISNullify.Checked = Convert.ToBoolean(dt.Rows[0]["PAYITEM_ISNULLIFY"]); } /*if (dt.Rows[0]["PAYITEM_PROJECTID"] != System.DBNull.Value) * { * //rcmb_Project.SelectedIndex = Convert.ToInt32(dt.Rows[0]["PAYITEM_PROJECTID"]); * //rcmb_Project.SelectedIndex = rcmb_Project.Items.FindItemIndexByValue(Convert.ToString(dt.Rows[0]["PAYITEM_PROJECTID"])); * }*/ lbl_projectlist.Text = Convert.ToString(dt.Rows[0]["PAYITEM_PROJECTID"]); //for project listbox getCheckedItems(rlb_Project, lbl_projectlist); rtxt_AccountHead.Text = Convert.ToString(dt.Rows[0]["PAYITEM_ACCOUNTHEAD"]); rtxtVoteName.Text = Convert.ToString(dt.Rows[0]["PAYITEM_VOTENAME"]); lbl_Request.Text = Convert.ToString(dt.Rows[0]["PAYITEM_ACCOUNTHEAD"]); if (string.Compare(rcmb_PayItemMode.SelectedItem.Text, "Loan", true) == 0) { trProcessType.Visible = true; rb_loanprocesstype.SelectedIndex = rb_loanprocesstype.Items.FindItemIndexByValue(Convert.ToString(dt.Rows[0]["PAYITEM_LOAN_PROCESSTYPE"])); } else if (string.Compare(rcmb_PayItemMode.SelectedItem.Text, "Loan Interest", true) == 0) { LoadLoanInterest(); trProcessType.Visible = trLoanInterest.Visible = true; rb_loanprocesstype.SelectedIndex = rb_loanprocesstype.Items.FindItemIndexByText(Convert.ToString(dt.Rows[0]["PAYITEM_LOAN_PROCESS_TYPE"])); rcbLoanInterest.SelectedIndex = rcbLoanInterest.Items.FindItemIndexByValue(Convert.ToString(dt.Rows[0]["PAYITEM_LOAN_INTEREST"])); } else if (string.Compare(rcmb_PayItemMode.SelectedItem.Text, "Insurance", true) == 0) { trInsurance.Visible = true; rtxtTaxRelief.Text = Convert.ToString(dt.Rows[0]["PAYITEM_INSTAXRELIEF"]); } else { trProcessType.Visible = false; trInsurance.Visible = false; } } btn_Save.Visible = false; //code for security if (Convert.ToInt32(Session["WRITEFACILITY"]) == 2) { btn_Edit.Visible = false; } else { btn_Edit.Visible = true; } Rm_PayItem_page.SelectedIndex = 1; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), Guid.NewGuid().ToString(), "<script>OnAccountType();</script>", false); if (Convert.ToString(dt.Rows[0]["PAYITEM_ACCOUNTTYPE"]) != "" || dt.Rows[0]["PAYITEM_ACCOUNTTYPE"] != System.DBNull.Value) { ddl_AccountType.SelectedIndex = ddl_AccountType.Items.FindItemIndexByText(Convert.ToString(dt.Rows[0]["PAYITEM_ACCOUNTTYPE"])); } else { ddl_AccountType.SelectedIndex = 0; } if (Convert.ToString(dt.Rows[0]["PAYITEM_POSTINGPROFILE"]) != "") { txt_PostingProfile.Text = Convert.ToString(dt.Rows[0]["PAYITEM_POSTINGPROFILE"]); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), Guid.NewGuid().ToString(), "<script> document.getElementById('Posting_Profile').style.display = '';</script>", false); } else { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), Guid.NewGuid().ToString(), "<script> document.getElementById('Posting_Profile').style.display = 'none';</script>", false); } #region Check Loan Setup Data if (rcmb_PayItemMode.SelectedItem.Text == "Loan") { SMHR_LOANSETUP _obj_SMHRLOANSETUP = new SMHR_LOANSETUP(); _obj_SMHRLOANSETUP.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]); _obj_SMHRLOANSETUP.LOANSETUP_LOANTYPE_ID = Convert.ToInt32(lbl_PayItemID.Text); _obj_SMHRLOANSETUP.LOANSETUP_LOANPROCESSTYPE = rb_loanprocesstype.SelectedItem.Text; DataTable dtLS = BLL.GetLoanSetupData(_obj_SMHRLOANSETUP); if (dtLS.Rows.Count > 0) { BLL.ShowMessage(this, "You are not supposed to modify this Pay Item, because it is already in use in Loan module"); btn_Edit.Visible = false; } else { btn_Edit.Visible = true; } } #endregion } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_PayItemDefine", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }