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));
}
