コード例 #1
0
    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");
        }
    }
コード例 #2
0
    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");
        }
    }