Пример #1
0
        private void lkpEdtPaymentGroup_EditValueChanged(object sender, System.EventArgs e)
        {
            if (lkpEdtPayment.EditValue != null &&
                myPaymentCodeLookupBuilder != null &&
                lkpEdtPaymentGroup.EditValue != null &&
                myPaymentGroupCodeLookupBuilder != null &&
                lkpEdtPaymentGroup.EditValue.ToString() != "")
            {
                myPaymentCodeLookupBuilder.Refresh(lkpEdtPaymentGroup.EditValue.ToString());
                if (((DataTable)lkpEdtPayment.Properties.DataSource).Rows.Count == 1)
                {
                    lkpEdtPayment.ItemIndex = 0;
                    lkpEdtPayment.Properties.ForceInitialize();
                }

                lkpEdtIPP.Visible  = lkpEdtPaymentGroup.EditValue.ToString() == ACMSPOS2.PaymentGroupCode.IPP;
                lkpEdtIPP.Enabled  = lkpEdtIPP.Visible;
                label4.Visible     = lkpEdtIPP.Visible;
                myPaymentGroupCode = lkpEdtPaymentGroup.Text;
            }

            if (myIPPLookupEditBuilder != null && lkpEdtIPP.Text.Length > 0)
            {
                string cmdText = "Select A.strIPP From tblBank A Inner Join tblIPP B on A.strBankCode = B.strBankCode " +
                                 " Where B.nIPPID = @nIPPID ";

                int            ippID  = ACMS.Convert.ToInt32(lkpEdtIPP.Text);
                ACMSDAL.TblIPP sqlIPP = new ACMSDAL.TblIPP();
                DataTable      table  = sqlIPP.LoadData(cmdText, new string[] { "@nIPPID" }, new object[] { ippID });
                if (table.Rows.Count > 0)
                {
                    lkpEdtPayment.EditValue = table.Rows[0]["strIPP"];
                }
            }
        }
Пример #2
0
        public IPP()
        {
            configReader = new AppSettingsReader();
            connString = configReader.GetValue("Main.ConnectionString", typeof(string)).ToString();

            myIPP = new TblIPP();
            dtblPreset = myIPP.SelectAllIPPMembership();
        }
Пример #3
0
        private void lkpEdtIPP_EditValueChanged(object sender, System.EventArgs e)
        {
            if (myIPPLookupEditBuilder != null && lkpEdtIPP.Text.Length > 0)
            {
                string cmdText = "Select A.strIPP From tblBank A Inner Join tblIPP B on A.strBankCode = B.strBankCode " +
                                 " Where B.nIPPID = @nIPPID ";

                int            ippID  = ACMS.Convert.ToInt32(lkpEdtIPP.EditValue);
                ACMSDAL.TblIPP sqlIPP = new ACMSDAL.TblIPP();
                DataTable      table  = sqlIPP.LoadData(cmdText, new string[] { "@nIPPID" }, new object[] { ippID });
                if (table.Rows.Count > 0)
                {
                    lkpEdtPayment.EditValue = table.Rows[0]["strIPP"];
                }
            }
        }
Пример #4
0
        private void BindData()
        {
            dal.TblIPP IPP = new dal.TblIPP();
            DataTable dt = IPP.SelectAll();
            //cbReceipient
            ddlIPP.DataSource = dt;
            ddlIPP.ValueMember = "nIPPID";

            if (IPPId != "")
                ddlIPP.SelectedValue = IPPId;

            dal.TblReceiptPayment ReceiptPayment = new dal.TblReceiptPayment();
            dt = ReceiptPayment.SelectAll();
            //cbReceipient
            ddlReceipt.DataSource = dt;
            ddlReceipt.ValueMember = "nPaymentID";
            ddlReceipt.DisplayMember = "strReceiptNo";
        }
Пример #5
0
        private void frmIPP_Update_Load(object sender, System.EventArgs e)
        {
            dal.TblBank bnk = new dal.TblBank();
            DataTable   dt  = bnk.SelectAll();

            //cbReceipient
            ddlBank.DataSource  = dt;
            ddlBank.ValueMember = "strBankCode";


            dal.TblIPP IP = new dal.TblIPP();
            IP.NIPPID = Id;
            dt        = IP.SelectOne();

            ddlBank.SelectedValue = dt.Rows[0]["strBankCode"];
            CCNo.Text             = dt.Rows[0]["strCreditCardNo"].ToString();
            txtnMonths.Text       = dt.Rows[0]["nMonths"].ToString();
        }
Пример #6
0
        private void BindData()
        {
            dal.TblIPP IPP = new dal.TblIPP();
            DataTable  dt  = IPP.SelectAll();

            //cbReceipient
            ddlIPP.DataSource  = dt;
            ddlIPP.ValueMember = "nIPPID";

            if (IPPId != "")
            {
                ddlIPP.SelectedValue = IPPId;
            }

            dal.TblReceiptPayment ReceiptPayment = new dal.TblReceiptPayment();
            dt = ReceiptPayment.SelectAll();
            //cbReceipient
            ddlReceipt.DataSource    = dt;
            ddlReceipt.ValueMember   = "nPaymentID";
            ddlReceipt.DisplayMember = "strReceiptNo";
        }
Пример #7
0
        public void AddNewIPP(string strBankCode, int nMonths,
			string strCreditCardNo, string strMerchantNo)
        {
            TblIPP sqlIPP = new TblIPP();
            DataTable table = sqlIPP.FillSchema("Select * from tblIPP");
            DataRow r = table.NewRow();
            r["StrMembershipID"] = StrMembershipID;
            r["DtDate"] = DateTime.Today.Date;
            r["StrBranchCode"] = StrBranchCode;
            r["StrBankCode"] = strBankCode;
            r["NMonths"] = nMonths;
            r["strCreditCardNo"] = strCreditCardNo;
            r["strMerchantNo"] = strMerchantNo;
            r["nIPPStatus"] = 3;

            table.Rows.Add(r);

            sqlIPP.SaveData(table);
        }
Пример #8
0
        private void DeleteUselessIPP(ACMSDAL.ConnectionProvider connProvider, ACMSLogic.POS pos)
        {
            DataRow[] rowListThatHaveIPP = pos.ReceiptPaymentTable.Select("nIPPID is not null", "", DataViewRowState.CurrentRows);

            if (rowListThatHaveIPP.Length > 0)
            {
                TblIPP sqlIPP = new TblIPP();
                sqlIPP.MainConnectionProvider = connProvider;

                DataTable table = sqlIPP.GetIPP(pos.StrMembershipID, pos.StrBranchCode);

                foreach (DataRow r in rowListThatHaveIPP)
                {
                    int nIPPID = ACMS.Convert.ToInt32(r["nIPPID"]);

                    DataRow[] rowToUpdate = table.Select("nIPPID = " + nIPPID.ToString());
                    if (rowToUpdate.Length > 0)
                    {
                        rowToUpdate[0]["nIPPStatus"] = 0;
                    }
                }

                DataRow[] rowListToDelete = table.Select("nIPPStatus = 3", "", DataViewRowState.CurrentRows);

                foreach (DataRow deleteRow in rowListToDelete)
                {
                    deleteRow.Delete();
                }

                sqlIPP.SaveData(table);
            }
        }
Пример #9
0
        private void lkpEdtPaymentGroup_EditValueChanged(object sender, System.EventArgs e)
        {
            if (lkpEdtPayment.EditValue != null &&
                myPaymentCodeLookupBuilder != null &&
                lkpEdtPaymentGroup.EditValue != null &&
                myPaymentGroupCodeLookupBuilder != null &&
                lkpEdtPaymentGroup.EditValue.ToString() != "")
            {
                myPaymentCodeLookupBuilder.Refresh(lkpEdtPaymentGroup.EditValue.ToString());
                if (((DataTable)lkpEdtPayment.Properties.DataSource).Rows.Count == 1)
                {
                    lkpEdtPayment.ItemIndex = 0;
                    lkpEdtPayment.Properties.ForceInitialize();
                }

                lkpEdtIPP.Visible = lkpEdtPaymentGroup.EditValue.ToString() == ACMSPOS2.PaymentGroupCode.IPP;
                lkpEdtIPP.Enabled = lkpEdtIPP.Visible;
                label4.Visible = lkpEdtIPP.Visible;
                myPaymentGroupCode = lkpEdtPaymentGroup.Text;
            }

            if (myIPPLookupEditBuilder != null && lkpEdtIPP.Text.Length > 0)
            {
                string cmdText = "Select A.strIPP From tblBank A Inner Join tblIPP B on A.strBankCode = B.strBankCode " +
                    " Where B.nIPPID = @nIPPID ";

                int ippID = ACMS.Convert.ToInt32(lkpEdtIPP.Text);
                ACMSDAL.TblIPP sqlIPP = new ACMSDAL.TblIPP();
                DataTable table = sqlIPP.LoadData(cmdText, new string[]{"@nIPPID"}, new object[]{ippID});
                if (table.Rows.Count > 0)
                {
                    lkpEdtPayment.EditValue = table.Rows[0]["strIPP"];
                }
            }
        }
Пример #10
0
        private void lkpEdtIPP_EditValueChanged(object sender, System.EventArgs e)
        {
            if (myIPPLookupEditBuilder != null && lkpEdtIPP.Text.Length > 0)
            {
                string cmdText = "Select A.strIPP From tblBank A Inner Join tblIPP B on A.strBankCode = B.strBankCode " +
                                " Where B.nIPPID = @nIPPID ";

                int ippID = ACMS.Convert.ToInt32(lkpEdtIPP.EditValue);
                ACMSDAL.TblIPP sqlIPP = new ACMSDAL.TblIPP();
                DataTable table = sqlIPP.LoadData(cmdText, new string[]{"@nIPPID"}, new object[]{ippID});
                if (table.Rows.Count > 0)
                {
                    lkpEdtPayment.EditValue = table.Rows[0]["strIPP"];
                }
            }
        }
Пример #11
0
 private void InitLookupEdit(int Id)
 {
     myIPP = new TblIPP();
     myIPP.NIPPID = Id;
     dtblIPPLookupEdit = myIPP.SelectOne();
 }
Пример #12
0
 private void Init()
 {
     myIPP = new TblIPP();
     myDataTable = myIPP.SelectAll();
 }
Пример #13
0
        private void frmIPP_Update_Load(object sender, System.EventArgs e)
        {
            dal.TblBank bnk = new dal.TblBank();
            DataTable dt = bnk.SelectAll();
            //cbReceipient
            ddlBank.DataSource = dt;
            ddlBank.ValueMember = "strBankCode";

            dal.TblIPP IP = new dal.TblIPP();
            IP.NIPPID = Id;
            dt = IP.SelectOne();

            ddlBank.SelectedValue = dt.Rows[0]["strBankCode"];
            CCNo.Text = dt.Rows[0]["strCreditCardNo"].ToString();
            txtnMonths.Text = dt.Rows[0]["nMonths"].ToString();
        }