示例#1
0
        protected void BtnUpdate_Click(object sender, EventArgs e)
        {
            try
            {
                A2ZACCSTATUSDTO UpDTO = new A2ZACCSTATUSDTO();
                UpDTO.AccStatusCode        = Converter.GetSmallInteger(txtcode.Text);
                UpDTO.AccStatusDescription = Converter.GetString(txtDescription.Text);

                int roweffect = A2ZACCSTATUSDTO.UpdateInformation(UpDTO);
                if (roweffect > 0)
                {
                    gvDetail();
                    dropdown();
                    clearinfo();
                    ddlAcStatus.SelectedValue = "-Select-";
                    BtnSubmit.Visible         = true;
                    BtnUpdate.Visible         = false;
                    txtcode.Focus();
                }
            }
            catch (Exception ex)
            {
                Page.ClientScript.RegisterStartupScript(this.GetType(), "scriptkey", "<script>alert('System Error.BtnUpdate_Click Problem');</script>");
                //throw ex;
            }
        }
示例#2
0
        protected void ddlAcStatus_SelectedIndexChanged(object sender, EventArgs e)
        {
            try
            {
                if (ddlAcStatus.SelectedValue == "-Select-")
                {
                    txtcode.Focus();
                    txtcode.Text        = string.Empty;
                    txtDescription.Text = string.Empty;
                    BtnSubmit.Visible   = true;
                    BtnUpdate.Visible   = false;
                }


                if (ddlAcStatus.SelectedValue != "-Select-")
                {
                    Int16           MainCode = Converter.GetSmallInteger(ddlAcStatus.SelectedValue);
                    A2ZACCSTATUSDTO getDTO   = (A2ZACCSTATUSDTO.GetInformation(MainCode));
                    if (getDTO.AccStatusCode > 0)
                    {
                        txtcode.Text        = Converter.GetString(getDTO.AccStatusCode);
                        txtDescription.Text = Converter.GetString(getDTO.AccStatusDescription);
                        BtnSubmit.Visible   = false;
                        BtnUpdate.Visible   = true;
                        txtDescription.Focus();
                    }
                    else
                    {
                        txtcode.Focus();
                        txtcode.Text        = string.Empty;
                        txtDescription.Text = string.Empty;
                        BtnSubmit.Visible   = true;
                        BtnUpdate.Visible   = false;
                    }
                }
            }
            catch (Exception ex)
            {
                Page.ClientScript.RegisterStartupScript(this.GetType(), "scriptkey", "<script>alert('System Error.ddlAcStatus_SelectedIndexChanged Problem');</script>");
                //throw ex;
            }
        }
示例#3
0
        protected void GetInfo()
        {
            try
            {
                Int64         AccNumber = Converter.GetLong(txtAccountNo.Text);
                A2ZACCOUNTDTO getDTO    = (A2ZACCOUNTDTO.GetInfoAccNo(AccNumber));

                if (getDTO.a > 0)
                {
                    CtrlAccStatus.Text = Converter.GetString(getDTO.AccStatus);
                    CtrlAccType.Text   = Converter.GetString(getDTO.AccType);


                    if (CtrlAccStatus.Text == "98")
                    {
                        txtAccountNo.Text = string.Empty;
                        txtAccountNo.Focus();
                        AccTransferedMSG();
                        return;
                    }

                    Int16           AccStat = Converter.GetSmallInteger(CtrlAccStatus.Text);
                    A2ZACCSTATUSDTO get3DTO = (A2ZACCSTATUSDTO.GetInformation(AccStat));
                    if (get3DTO.AccStatusCode > 0)
                    {
                        txtstat.Text = Converter.GetString(get3DTO.AccStatusDescription);
                    }

                    txtPartyCode.Text = Converter.GetString(getDTO.AccPartyNo);

                    txtAccType.Text          = Converter.GetString(CtrlAccType.Text);
                    ddlAccType.SelectedValue = Converter.GetString(CtrlAccType.Text);
                }
            }
            catch (Exception ex)
            {
                Page.ClientScript.RegisterStartupScript(this.GetType(), "scriptkey", "<script>alert('System Error.GetInfo Problem');</script>");
            }
        }
示例#4
0
        protected void BtnSubmit_Click(object sender, EventArgs e)
        {
            try
            {
                A2ZACCSTATUSDTO objDTO = new A2ZACCSTATUSDTO();

                objDTO.AccStatusCode        = Converter.GetSmallInteger(txtcode.Text);
                objDTO.AccStatusDescription = Converter.GetString(txtDescription.Text);

                int roweffect = A2ZACCSTATUSDTO.InsertInformation(objDTO);
                if (roweffect > 0)
                {
                    gvDetail();
                    txtcode.Focus();
                    clearinfo();
                    dropdown();
                }
            }
            catch (Exception ex)
            {
                Page.ClientScript.RegisterStartupScript(this.GetType(), "scriptkey", "<script>alert('System Error.BtnSubmit_Click Problem');</script>");
                //throw ex;
            }
        }
        public void GetAccInfo()
        {
            try
            {
                Int64         AccNumber = Converter.GetLong(txtAccNo.Text);
                A2ZACCOUNTDTO accgetDTO = (A2ZACCOUNTDTO.GetInfoAccNo(AccNumber));
                if (accgetDTO.a == 0)
                {
                    InvalidAccountNoMSG();
                    txtAccNo.Text = string.Empty;
                    txtAccNo.Focus();
                    return;
                }
                else
                {
                    CtrlAccStatus.Text = Converter.GetString(accgetDTO.AccStatus);

                    if (CtrlAccStatus.Text == "98")
                    {
                        txtAccNo.Text = string.Empty;
                        txtAccNo.Focus();
                        AccTransferedMSG();
                        return;
                    }


                    Int16           AccStat = Converter.GetSmallInteger(CtrlAccStatus.Text);
                    A2ZACCSTATUSDTO get0DTO = (A2ZACCSTATUSDTO.GetInformation(AccStat));
                    if (get0DTO.AccStatusCode > 0)
                    {
                        txtstat.Text = Converter.GetString(get0DTO.AccStatusDescription);
                    }



                    lblCuType.Text = Converter.GetString(accgetDTO.CuType);
                    lblCuNo.Text   = Converter.GetString(accgetDTO.CuNo);

                    txtCreditUNo.Text = (lblCuType.Text + "-" + lblCuNo.Text);


                    txtCULBMemNo.Text = Converter.GetString(accgetDTO.MemberNo);


                    CtrlAccType.Text = Converter.GetString(accgetDTO.AccType);

                    lblcls.Text = Converter.GetString(accgetDTO.AccAtyClass);

                    if (lblcls.Text == "7")
                    {
                        string input2  = txtAccNo.Text;
                        string paytype = input2.Substring(12, 4);

                        int           atyclass = Converter.GetInteger(lblcls.Text);
                        int           paycode  = Converter.GetInteger(paytype);
                        A2ZPAYTYPEDTO get1DTO  = (A2ZPAYTYPEDTO.GetInformation(atyclass, paycode));
                        if (get1DTO.PayTypeCode > 0)
                        {
                            lblAccTitle.Text = Converter.GetString(get1DTO.PayTypeDescription);
                            int           pcode   = Converter.GetInteger(paytype);
                            A2ZTRNCODEDTO get2DTO = (A2ZTRNCODEDTO.GetInformation99(pcode));
                            if (get2DTO.TrnCode > 0)
                            {
                                lblTrnCode.Text = Converter.GetString(get2DTO.TrnCode);
                            }
                        }
                    }
                    else
                    {
                        Int16         AccType = Converter.GetSmallInteger(CtrlAccType.Text);
                        A2ZACCTYPEDTO get3DTO = (A2ZACCTYPEDTO.GetInformation(AccType));
                        if (get3DTO.AccTypeCode > 0)
                        {
                            lblAccTitle.Text = Converter.GetString(get3DTO.AccTypeDescription);
                        }

                        int           AType   = Converter.GetInteger(CtrlAccType.Text);
                        A2ZTRNCODEDTO get4DTO = (A2ZTRNCODEDTO.GetInformation01(AType));
                        if (get4DTO.TrnCode > 0)
                        {
                            lblTrnCode.Text = Converter.GetString(get4DTO.TrnCode);
                        }
                    }


                    Int16        CType   = Converter.GetSmallInteger(lblCuType.Text);
                    int          CNo     = Converter.GetInteger(lblCuNo.Text);
                    A2ZCUNIONDTO get5DTO = (A2ZCUNIONDTO.GetInformation(CType, CNo));
                    if (get5DTO.NoRecord > 0)
                    {
                        hdnCashCode.Text = Converter.GetString(get5DTO.GLCashCode);

                        if (lblModule.Text == "06" && hdnCashCode.Text != lblCashCode.Text)
                        {
                            txtAccNo.Text     = string.Empty;
                            txtCreditUNo.Text = string.Empty;
                            txtCULBMemNo.Text = string.Empty;

                            txtAccNo.Focus();

                            AccessDeniedMSG();
                            return;
                        }


                        lblCuName.Text = Converter.GetString(get5DTO.CreditUnionName);
                    }

                    Int16        CUType  = Converter.GetSmallInteger(lblCuType.Text);
                    int          CUNo    = Converter.GetInteger(lblCuNo.Text);
                    int          MNo     = Converter.GetInteger(txtCULBMemNo.Text);
                    A2ZMEMBERDTO get6DTO = (A2ZMEMBERDTO.GetInformation(CUType, CUNo, MNo));
                    if (get6DTO.NoRecord > 0)
                    {
                        lblMemName.Text = Converter.GetString(get6DTO.MemberName);
                    }


                    if (lblcls.Text == "4")
                    {
                        DateTime dt0   = Converter.GetDateTime(accgetDTO.LastTrnDate);
                        string   date0 = dt0.ToString("dd/MM/yyyy");
                        tLastTrnDate.Text = date0;

                        if (tLastTrnDate.Text == "01/01/0001")
                        {
                            tLastTrnDate.Text = string.Empty;
                        }


                        DateTime dt12   = Converter.GetDateTime(accgetDTO.MatruityDate);
                        string   date12 = dt12.ToString("dd/MM/yyyy");
                        tMaturityDt.Text = date12;

                        if (tMaturityDt.Text == "01/01/0001")
                        {
                            tMaturityDt.Text = string.Empty;
                        }


                        tAccPeriod.Text = Converter.GetString(accgetDTO.Period);

                        tTotalDeposit.Text = Converter.GetString(String.Format("{0:0,0.00}", accgetDTO.TotDepositAmount));
                        tMthDeposit.Text   = Converter.GetString(String.Format("{0:0,0.00}", accgetDTO.DepositAmount));


                        DateTime TrnDate              = DateTime.ParseExact(lblProcDate.Text, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture);
                        Int16    CuType               = Converter.GetSmallInteger(lblCuType.Text);
                        int      CuNo                 = Converter.GetInteger(lblCuNo.Text);
                        Int16    Acctype              = Converter.GetSmallInteger(CtrlAccType.Text);
                        Int64    AccNo                = Converter.GetLong(txtAccNo.Text);
                        int      MemNumber            = Converter.GetInteger(txtCULBMemNo.Text);
                        A2ZPENSIONDEFAULTERDTO getDTO = (A2ZPENSIONDEFAULTERDTO.GetPensionDepInformation(TrnDate, CuType, CuNo, MemNumber, Acctype, AccNumber));
                        if (getDTO.CuType > 0)
                        {
                            tDueDepositAmt.Text = Converter.GetString(String.Format("{0:0,0.00}", (getDTO.DueDepositAmt)));

                            tUptoDate.Text = Converter.GetString(getDTO.UptoDate);
                        }
                    }
                }

                string    qry = "SELECT Id,AccNo,AccOpenDate,AccMatureDate,AccRenwlDate,AccPeriod,AccBalance,AccOrgAmt,AccPrincipal,AccIntRate,AccLoanSancAmt,AccLoanSancDate,AccDisbAmt,AccDisbDate,AccNoInstl,AccLoanInstlAmt,AccLoanLastInstlAmt,AccAtyClass,AccOldNumber,AccCertNo,AccFixedMthInt FROM A2ZACCOUNT where AccType ='" + CtrlAccType.Text + "' and CuType='" + lblCuType.Text + "' and CuNo='" + lblCuNo.Text + "' and  MemNo='" + txtCULBMemNo.Text + "' and  AccNo ='" + txtAccNo.Text + "'";
                DataTable dt  = DataAccessLayer.BLL.CommonManager.Instance.GetDataTableByQuery(qry, "A2ZCSMCUS");
                if (dt.Rows.Count > 0)
                {
                    //For Report Header Parameter class wise

                    // Loan Information

                    tAccBalance.Text          = Converter.GetString(dt.Rows[0]["AccBalance"]);
                    tAccLoanSancAmt.Text      = Converter.GetString(dt.Rows[0]["AccLoanSancAmt"]);
                    tAccLoanSancDate.Text     = Converter.GetString(dt.Rows[0]["AccLoanSancDate"]);
                    tAccDisbAmt.Text          = Converter.GetString(dt.Rows[0]["AccDisbAmt"]);
                    tAccDisbDate.Text         = Converter.GetString(dt.Rows[0]["AccDisbDate"]);
                    tAccNoInstl.Text          = Converter.GetString(dt.Rows[0]["AccNoInstl"]);
                    tAccLoanInstlAmt.Text     = Converter.GetString(dt.Rows[0]["AccLoanInstlAmt"]);
                    tAccLoanLastInstlAmt.Text = Converter.GetString(dt.Rows[0]["AccLoanLastInstlAmt"]);
                    tOpenDt.Text = Converter.GetString(dt.Rows[0]["AccOpenDate"]);
                    tClass.Text  = Converter.GetString(dt.Rows[0]["AccAtyClass"]);

                    // FOR A/C TYPE Class
                    int AccTypeClass = Converter.GetSmallInteger(tClass.Text);
                    if (AccTypeClass == 2 || AccTypeClass == 3)
                    {
                        //  tOpenDt.Text = Converter.GetString(dt.Rows[0]["AccOpenDate"]);

                        tMaturityDt.Text = Converter.GetString(dt.Rows[0]["AccMatureDate"]);
                        tRenewalDt.Text  = Converter.GetString(dt.Rows[0]["AccRenwlDate"]);

                        tAccPeriod.Text    = Converter.GetString(dt.Rows[0]["AccPeriod"]);
                        tOrgAmt.Text       = Converter.GetString(dt.Rows[0]["AccOrgAmt"]);
                        tPrincipleAmt.Text = Converter.GetString(dt.Rows[0]["AccPrincipal"]);
                        tOldAccount.Text   = Converter.GetString(dt.Rows[0]["AccOldNumber"]);
                        tAccCertNo.Text    = Converter.GetString(dt.Rows[0]["AccCertNo"]);
                    }

                    if (AccTypeClass == 2)
                    {
                        // Int Rate
                        tIntRate.Text = Converter.GetString(dt.Rows[0]["AccIntRate"]);
                    }


                    if (AccTypeClass == 3)
                    {
                        // Monthly Benefit
                        tAccFixedMthInt.Text = Converter.GetString(dt.Rows[0]["AccFixedMthInt"]);
                    }


                    // decimal b = Converter.GetDecimal(dt.Rows[0]["AccBalance"]);
                }
            }
            catch (Exception ex)
            {
                Page.ClientScript.RegisterStartupScript(this.GetType(), "scriptkey", "<script>alert('System Error.GetAccInfo Problem');</script>");
                //throw ex;
            }
        }