public List <VE_BankAccount> getBankAccountByCompanyCode(string CompanyCode) { VE_BankAccount _VeBankAccount = null; List <VE_BankAccount> _lstBankAccount = new List <VE_BankAccount>(); Dictionary <string, object> parameters = new Dictionary <string, object>(); parameters.Add("_companyCode", CompanyCode); var rows = _database.QuerySP("sps_getBankAccountByCompanyCode", parameters); foreach (var row in rows) { _VeBankAccount = new VE_BankAccount(); _VeBankAccount.bankAccountId = string.IsNullOrEmpty(row["BankAccountId"]) ? 0 : int.Parse(row["BankAccountId"]); _VeBankAccount.accountNumber = row["AccountNumber"]; _VeBankAccount.bankId = string.IsNullOrEmpty(row["BankId"]) ? 0 : int.Parse(row["BankId"]); _VeBankAccount.currency = row["Currency"]; _VeBankAccount.status = string.IsNullOrEmpty(row["Status"]) ? false : row["Status"].Equals("1") ? true : false; _VeBankAccount.balance = string.IsNullOrEmpty(row["Balance"]) ? 0 : decimal.Parse(row["Balance"]); _VeBankAccount.accounting = row["Accounting"]; _VeBankAccount.cash = row["Cash"]; _VeBankAccount.companyCode = row["CompanyCode"]; _VeBankAccount.AccountNumberCCI = row["AccountNumberCCI"]; _VeBankAccount.AccountType = row["AccountType"]; _VeBankAccount.bankShortName = row["BankShortName"]; _VeBankAccount.companyName = row["CompanyName"]; _lstBankAccount.Add(_VeBankAccount); } return(_lstBankAccount); }
public VE_BankAccount updateBankAccount(VE_BankAccount _VeBankAccount) { int filasAfectadas = 0; string strError_Mensaje = string.Empty; bool boResultado = false; Dictionary <string, object> parameters = new Dictionary <string, object>(); parameters.Add("_idBankAccount", _VeBankAccount.bankAccountId); parameters.Add("_acountNumber", _VeBankAccount.accountNumber); parameters.Add("_bankId", _VeBankAccount.bankId); parameters.Add("_currency", _VeBankAccount.currency); parameters.Add("_status", _VeBankAccount.status); parameters.Add("_balance", _VeBankAccount.balance); parameters.Add("_accounting", _VeBankAccount.accounting); parameters.Add("_cash", _VeBankAccount.cash); parameters.Add("_userAudit", _VeBankAccount.userAudit); parameters.Add("_accountNumberCCI", _VeBankAccount.AccountNumberCCI); parameters.Add("_companyCode", _VeBankAccount.companyCode); parameters.Add("_accountType", _VeBankAccount.AccountType); filasAfectadas = _database.ExecuteSP("spu_updateBankAccount", parameters); boResultado = (filasAfectadas > 0); if (boResultado) { return(_VeBankAccount); } return(null); }
public VE_BankAccount updateBalanceBankAccount(int paymentAuthId) { VE_BankAccount _VeBankAccount = null; int filasAfectadas = 0; string strError_Mensaje = string.Empty; bool boResultado = false; Dictionary <string, object> parameters = new Dictionary <string, object>(); parameters.Add("_PaymentAuthId", paymentAuthId); filasAfectadas = _database.ExecuteSP("spu_UpdateBalanceBankAccount", parameters); boResultado = (filasAfectadas > 0); if (boResultado) { return(_VeBankAccount); } return(null); }
public VE_BankAccount deleteBankAccount(VE_BankAccount _VeBankAccount) { int filasAfectadas = 0; string strError_Mensaje = string.Empty; bool boResultado = false; Dictionary <string, object> parameters = new Dictionary <string, object>(); parameters.Add("_idBankAccount", _VeBankAccount.bankAccountId); parameters.Add("_userAudit", _VeBankAccount.userAudit); filasAfectadas = _database.ExecuteSP("spd_deleteBankAccount", parameters); boResultado = (filasAfectadas > 0); if (boResultado) { return(_VeBankAccount); } return(null); }
public BE_PaymentAuthDetail CreatePaymentAuthDetail(BE_PaymentAuthDetail _BePaymentAuthDetail) { _database = new MySQLDatabase(connectionString); BE_PaymentAuthDetail _BePAD = new DA_Payment(_database).createPaymentAuthDetail(_BePaymentAuthDetail); List <VE_PaymentAuth> _lstVePaymentAuth = getPaymentsAuthById(_BePAD.paymentAuthId); List <VE_PaymentAuthDetail> _lstVePaymentAuthDetail = GetValueUserByPaymentAuthId(_BePAD.paymentAuthId); BL_Usuario _blUsuario = new BL_Usuario(); _blUsuario.connectionString = connectionString; List <VE_UserCompany> _lstVeUserCompany = _blUsuario.GetUserNameByCompanyCode(_lstVePaymentAuth[0].companyCode, _lstVePaymentAuth[0].paymentAuthId); if (_lstVeUserCompany.Count > 0) { if (_lstVePaymentAuthDetail.Count == _lstVeUserCompany[0].quantityAuth) { UpdatePaymentAuthStatus(2, _lstVePaymentAuth[0].paymentAuthId); } else { UpdatePaymentAuthStatus(1, _lstVePaymentAuth[0].paymentAuthId); } } List <VE_Payment> _lstVePayments = getPaymentsByAuthId(_BePAD.paymentAuthId); VE_PaymentAuthDetail _VePADUserAudit = GetUserAuditByPaymentAuthId(_BePAD.paymentAuthId); /* * int idMail = 4; * BE_Mail _BeMail = GetMailInfo(idMail);*/ foreach (VE_UserCompany _veUserCompany in _lstVeUserCompany) { foreach (VE_PaymentAuthDetail _vePaymentAuthDetail in _lstVePaymentAuthDetail) { if (_veUserCompany.quantityAuth != _lstVePaymentAuthDetail.Count) { if (_veUserCompany.userName != _vePaymentAuthDetail.userAudit) { string amounttotal = (_veUserCompany.amountTotal).ToString(); string paymentsQ = (_lstVePayments.Count).ToString(); string paid = (_BePAD.paymentAuthId).ToString(); //string paydate = (_lstVePaymentAuth[0].payDate).ToString(); /* * string body = _BeMail.bodyMail; * body = body.Replace("@FirstName", _veUserCompany.firstName); * body = body.Replace("@LastName", _veUserCompany.lastName); * body = body.Replace("@AmountTotal", amounttotal); * body = body.Replace("@PayDate", _lstVePaymentAuth[0].payDateFormat); * body = body.Replace("@PaymentsQ", paymentsQ); * body = body.Replace("@Generator", _vePaymentAuthDetail.userAudit); * body = body.Replace("@PAID", paid); * body = body.Replace("@Banco", _lstVePaymentAuth[0].bankName); * body = body.Replace("@shortBank", _lstVePaymentAuth[0].bankShortName); * body = body.Replace("@tipoMoneda", _lstVePaymentAuth[0].currency); */ //body = body.Replace("@n", "<br>"); //string body = "<em> HRTDASDASDASD!!</em>"; /* * if (_veUserCompany.authorize==1){ * * * BL_Mail _BlMail = new BL_Mail(); * try * { * * _BlMail.SendEmail("*****@*****.**", _veUserCompany.email, _BeMail.subjectMail, body); * } catch { } * }*/ } } else { BL_Bank _blBank = new BL_Bank(); _blBank.connectionString = connectionString; VE_BankAccount _updateBalaceBankAccount = _blBank.UpdateBalanceBankAccount(_lstVePaymentAuth[0].paymentAuthId); return(_BePaymentAuthDetail); } } } return(_BePaymentAuthDetail); }
public VE_BankAccount CreateBankAccount(VE_BankAccount _VeBankAccount) { _database = new MySQLDatabase(connectionString); return(new DA_Bank(_database).createBankAccount(_VeBankAccount)); }