Esempio n. 1
0
        private void addNewBankButton_Click(object sender, EventArgs e)
        {
            dynamic d = new BankDetailsInfo();

            this.Visible = false;
            d.ShowDialog();
            this.Visible = true;
        }
Esempio n. 2
0
        private void createButton_Click(object sender, EventArgs e)
        {
            dynamic d = new BankDetailsInfo();

            this.Visible = false;
            d.ShowDialog();
            this.Visible = true;
            //this.Hide();
            //BankDetailsInfo afh=new BankDetailsInfo();
            //afh.Show();
        }
Esempio n. 3
0
        private BankDetailsInfo Get_Bank_Details_Values(DataRow dr)
        {
            BankDetailsInfo bank_details = new BankDetailsInfo();

            bank_details.Bank_Details_Id = Convert.ToInt32(dr["Bank_Details_Id"]);

            if (dr["Supplier_Id"] != DBNull.Value)
            {
                bank_details.Supplier_Id = Convert.ToInt32(dr["Supplier_Id"]);
            }

            if (dr["Customer_Id"] != DBNull.Value)
            {
                bank_details.Customer_Id = Convert.ToInt32(dr["Customer_Id"]);
            }

            bank_details.Bank_Name       = Convert.ToString(dr["Bank_Name"]);
            bank_details.Bank_Account_No = Convert.ToString(dr["Bank_Account_No"]);
            bank_details.Branch_Name     = Convert.ToString(dr["Branch_Name"]);
            bank_details.Ifsc_Code       = Convert.ToString(dr["Ifsc_Code"]);
            bank_details.Swift_Code      = Convert.ToString(dr["Swift_Code"]);
            bank_details.Rtgs_No         = Convert.ToString(dr["Rtgs_No"]);
            bank_details.Bank_Address    = Convert.ToString(dr["Bank_Address"]);
            bank_details.Bank_Code       = Convert.ToString(dr["Bank_Code"]);
            bank_details.Account_Code    = Convert.ToString(dr["Account_Code"]);
            bank_details.Is_Active       = Convert.ToBoolean(dr["Is_Active"]);
            bank_details.CreatedOn       = Convert.ToDateTime(dr["CreatedOn"]);
            bank_details.CreatedBy       = Convert.ToInt32(dr["CreatedBy"]);
            bank_details.UpdatedOn       = Convert.ToDateTime(dr["UpdatedOn"]);
            bank_details.UpdatedBy       = Convert.ToInt32(dr["UpdatedBy"]);
            bank_details.Bank_Name       = Convert.ToString(dr["Bank_Name"]); //

            bank_details.Vat = Convert.ToString(dr["Vat"]);
            if (dr["Currency_Id"] != DBNull.Value)
            {
                bank_details.Currency_Id = Convert.ToInt32(dr["Currency_Id"]);
            }
            if (dr["Payment_Term_Id"] != DBNull.Value)
            {
                bank_details.Payment_Term_Id = Convert.ToInt32(dr["Payment_Term_Id"]);
            }

            bank_details.Tax_Excemption_Code = Convert.ToString(dr["Tax_Excemption_Code"]);

            if (dr["Credit_limit"] != DBNull.Value)
            {
                bank_details.Credit_limit = Convert.ToInt32(dr["Credit_limit"]);
            }

            return(bank_details);
        }
Esempio n. 4
0
        private List <SqlParameter> Set_Values_In_Customer_Bank_Details(BankDetailsInfo bank_Details)
        {
            List <SqlParameter> sqlparam = new List <SqlParameter>();

            if (bank_Details.Bank_Details_Id != 0)
            {
                sqlparam.Add(new SqlParameter("@Bank_Details_Id", bank_Details.Bank_Details_Id));
            }
            sqlparam.Add(new SqlParameter("@Supplier_Id", bank_Details.Supplier_Id));
            sqlparam.Add(new SqlParameter("@Customer_Id", bank_Details.Customer_Id));
            sqlparam.Add(new SqlParameter("@Bank_Name", bank_Details.Bank_Name));
            sqlparam.Add(new SqlParameter("@Bank_Account_No", bank_Details.Bank_Account_No));
            sqlparam.Add(new SqlParameter("@Branch_Name", bank_Details.Branch_Name));
            sqlparam.Add(new SqlParameter("@Ifsc_Code", bank_Details.Ifsc_Code));
            sqlparam.Add(new SqlParameter("@Swift_Code", bank_Details.Swift_Code));
            sqlparam.Add(new SqlParameter("@Rtgs_No", bank_Details.Rtgs_No));
            sqlparam.Add(new SqlParameter("@Bank_Address", bank_Details.Bank_Address));
            sqlparam.Add(new SqlParameter("@Bank_Code", bank_Details.Bank_Code));
            sqlparam.Add(new SqlParameter("@Account_Code", bank_Details.Account_Code));
            sqlparam.Add(new SqlParameter("@Is_Active", bank_Details.Is_Active));
            if (bank_Details.Bank_Details_Id == 0)
            {
                sqlparam.Add(new SqlParameter("@CreatedBy", bank_Details.CreatedBy));
                sqlparam.Add(new SqlParameter("@CreatedOn", bank_Details.CreatedOn));
            }
            sqlparam.Add(new SqlParameter("@UpdatedOn", bank_Details.UpdatedOn));

            sqlparam.Add(new SqlParameter("@Vat", bank_Details.Vat));
            sqlparam.Add(new SqlParameter("@Currency_Id", bank_Details.Currency_Id));
            sqlparam.Add(new SqlParameter("@Payment_Term_Id", bank_Details.Payment_Term_Id));
            sqlparam.Add(new SqlParameter("@Tax_Excemption_Code", bank_Details.Tax_Excemption_Code));
            sqlparam.Add(new SqlParameter("@Credit_limit", bank_Details.Credit_limit));
            sqlparam.Add(new SqlParameter("@UpdatedBy", bank_Details.UpdatedBy));

            return(sqlparam);
        }
Esempio n. 5
0
 public void Update_Bank_Details(BankDetailsInfo bank_Details)
 {
     _sqlRepo.ExecuteNonQuery(Set_Values_In_Customer_Bank_Details(bank_Details), StoredProcedures.Update_Bank_Details_Sp.ToString(), CommandType.StoredProcedure);
 }
Esempio n. 6
0
 public void Update_Bank_Details(BankDetailsInfo bank_Details)
 {
     _customerRepo.Update_Bank_Details(bank_Details);
 }
Esempio n. 7
0
 public void Insert_Bank_Details(BankDetailsInfo bank_Details)
 {
     _customerRepo.Insert_Bank_Details(bank_Details);
 }