public Stream getTxtPaymentAuth(int paymentAuthId, int _bankAccountId, ref string filename) { BL_Bank _blBank = new BL_Bank(); _blBank.connectionString = connectionString; BE_BankAccount _bankAccount = _blBank.GetBankAccountById(_bankAccountId); BE_Bank _bank = _blBank.GetBankById(_bankAccount.bankId); filename = _bank.bankShortName + "_" + _bankAccount.accountNumber; if (_bank.bankShortName == "INTERB") { return(getIBK(paymentAuthId, _bank.bankId, _bankAccountId, 0)); } else if (_bank.bankShortName == "BBVA") { return(getBBVA(paymentAuthId, _bank.bankId, _bankAccountId, 0)); } else if (_bank.bankShortName == "BCP") { return(getBCP(paymentAuthId, _bank.bankId, _bankAccountId, 0)); } else if (_bank.bankShortName == "BCSCTB") { return(getSCOTIA(paymentAuthId, _bank.bankId, _bankAccountId, 0)); } throw new ApplicationException("UNKNOWN_ERROR"); // return GetMDFile(vePaymentAuth.paymentAuthId, _bankAccountId); }
public BE_Payment RegisterClientPayment(BE_Payment _bePayment) { _database = new MySQLDatabase(connectionString); var mensaje = ""; BL_WorkFlow bL_WorkFlow = new BL_WorkFlow(); bL_WorkFlow.connectionString = connectionString; var bOK = bL_WorkFlow.NextWorkFlowStep(ref mensaje, 2, int.Parse(_bePayment.id), _bePayment.userName, false); if (bOK) { BE_Payment bE_Payment = new DA_Payment(_database).createPaymentSales(_bePayment); BL_Bank bL_Bank = new BL_Bank(); bL_Bank.connectionString = connectionString; BE_BankAccount bE_BankAccountAux = bL_Bank.updateBalanceBankAccountByInvoice(int.Parse(_bePayment.id), _bePayment.bankAccountId); return(bE_Payment); } else { throw new ApplicationException("Ud. no cuenta con los privilegios necesarios"); } }
private Stream getSCOTIA(int paymentAuthId, int bankId, int bankAccountId, int detraction) { DateTime hoy = DateTime.Now; string someString = ""; string druc = ""; //Ruc proveedor 11 string drsocial = ""; //Razon Social 60 string dnrofact = ""; //nro de factura 14 string dfecfact = ""; //Fech. fact. 8 YYYYMMDD string dmtopago = ""; //MOnto de pago 11 (2 decimales sin separador decimal) string dformapago = ""; //form de pago 1 (2 abono cta cte. / 3 cta ahorros, / 4 cta otro bco ) string dbcocodofi = ""; //Codigo de oficina 3 (obligatorio si forma de pago 2/3) string dbcocuenta = ""; //Cta de banco scotia 7 ( si es banco scotia obligatorio 2/3 , blanco si es 1/4) string dsinglepay = " "; // 1 string demail = someString.PadRight(30, ' '); // 30 string dcci = ""; // 20 string dfactoring = " "; // 1 (F) string dfecVctoFactoring = someString.PadRight(8, ' '); // 8 string dtransExte = " "; //1 VE_Payment auth = getPaymentsByAuthId(paymentAuthId)[0]; //context.PaymentAuth.Where(i => i.Id == Id).FirstOrDefault(); BL_Bank _blBank = new BL_Bank(); _blBank.connectionString = connectionString; BE_Bank bank = _blBank.GetBankById(bankId); //context.Bank.SingleOrDefault(b => b.Id == BankId); var bankaccount = _blBank.GetBankAccountById(bankAccountId); // context.BankAccount.SingleOrDefault(ba => ba.Id == BankAccountId); long hctrolcheck_tmp = Int64.Parse(bankaccount.accountNumber); var mimeType = "text/plain"; var FileBanco = "TMP" + paymentAuthId; var date_pay = Convert.ToDateTime(auth.payDate.ToString()).ToString("yyyyMMdd"); FileBanco = FileBanco + "-" + date_pay + ".TXT"; var source = ""; List <VE_Payment> payments = getPaymentsAuthBankAccountById(paymentAuthId, bankAccountId); //var payments = context.Payment.Where(p => (p.PaymentAuthId == Id && p.BankAccountId == BankAccountId)).ToList(); foreach (var payment in payments) // query executed and data obtained from database { druc = ""; //Ruc proveedor 11 drsocial = ""; //Razon Social 60 dnrofact = ""; //nro de factura 14 dfecfact = ""; //Fech. fact. 8 YYYYMMDD dmtopago = ""; //MOnto de pago 11 (2 decimales sin separador decimal) dformapago = ""; //form de pago 1 (2 abono cta cte. / 3 cta ahorros, / 4 cta otro bco ) dbcocodofi = ""; //Codigo de oficina 3 (obligatorio si forma de pago 2/3) dbcocuenta = ""; //Cta de banco scotia 7 ( si es banco scotia obligatorio 2/3 , blanco si es 1/4) dsinglepay = " "; // 1 demail = someString.PadRight(30, ' '); // 30 dcci = someString.PadRight(20, ' '); // 20 dfactoring = " "; // 1 (F) dfecVctoFactoring = someString.PadRight(8, ' '); // 8 dtransExte = " "; //1 druc = payment.customerRuc.PadRight(11, ' ').Substring(0, 11); //Número de documento del proveedor 12 25 123456789012 drsocial = RemoveAccents(payment.customerName).PadRight(60, ' ').Substring(0, 60); //Nombre del proveedor 75 40 Flávio Millioli //dnrofact = payment.NroComprobante.PadLeft(14,' '); //nro de factura 14 dnrofact = GetLast(payment.documentType.PadLeft(2, ' '), 2) + GetLast(payment.nroSerie.PadLeft(4, ' '), 4) + GetLast(payment.nroComprobante.PadRight(8, '0'), 8); dfecfact = payment.documentDate.ToString("yyyyMMdd"); List <string> CustomerAccount = new List <string>(); var _BankMasterId = ""; var _TipoCta = ""; var _CtaCargo = ""; var _CtaCargoInter = ""; int _tmphimportotal = Decimal.ToInt32(Math.Round(payment.amountPaymentFromBank, 2) * 100); dmtopago = LeadingZeros(_tmphimportotal.ToString(), 11); if (bankaccount.currency == "USD") { CustomerAccount = payment.customerBankAccountUsd.Split('|').ToList(); } else { CustomerAccount = payment.customerBankAccountPen.Split('|').ToList(); } try { _BankMasterId = CustomerAccount[0]; } catch { _BankMasterId = ""; } try { _TipoCta = CustomerAccount[1]; } catch { _TipoCta = ""; } //A ahorro, C corriente, M Maestra try { _CtaCargo = CustomerAccount[2]; } catch { _CtaCargo = ""; } try { _CtaCargoInter = CustomerAccount[3]; } catch { _CtaCargoInter = ""; } dformapago = "4"; //2 abono cta cte. / 3 cta ahorros, / 4 cta otro bco if (_TipoCta == "C") // { dformapago = "2"; } else if (_TipoCta == "A") { dformapago = "3"; } if (dformapago == "4") //if interbancario { dcci = LeadingRSpaces(_CtaCargoInter, 20); } else { dbcocodofi = _CtaCargo.Substring(0, 3); //Codigo de oficina 3 (obligatorio si forma de pago 2/3) dbcocuenta = GetLast(_CtaCargo, 7); //Cta de banco scotia 7 ( si es banco scotia obligatorio 2/3 , blanco si es 1/4) } source = source + druc + drsocial + dnrofact + dfecfact + dmtopago + dformapago + dbcocodofi + dbcocuenta + dsinglepay + demail + dcci + dfactoring + dfecVctoFactoring + dtransExte + "\r\n"; } return(ToStream(source)); }
private Stream getBBVA(int paymentAuthId, int bankId, int bankAccountId, int detraction) { string someString = ""; //someString.PadLeft(8, '0'); string hregtype = "750"; //Tipo de Registro string hctacargo = ""; //Cuenta de Cargo //string Max 20; string hmdacargo = ""; //Moneda de Cuenta de Cargo //string 3 string htamount = ""; //Importe a Cargar //string 15, zeros left, no decimales (x100) string hproctype = "A"; //Tipo de Proceso // string 1 string hdateproc = someString.PadLeft(8, ' '); //Fecha de Proceso // string 8 //vacio string htimeproc = someString.PadLeft(1, ' '); //Hora de proceso //string 1 //vacio string hid = ""; //Referencia //string 25 string hnroregs = ""; //Total de Registros 6, zero left string hvalidat = "S"; //Validación de Pertenencia string hcontrol = someString.PadLeft(15, ' '); //Valor de Control //string 15 //vacio string hindprod = someString.PadLeft(3, ' '); //Indicador de Proceso // string 3 //vacio string hdescrip = someString.PadLeft(30, ' '); //Descripción string 30 //vacio string hfiller = someString.PadLeft(20, ' '); //Descripción string 20 //vacio string dregtype = "002"; //Tipo de Registro 3 string ddoctype = "R"; //DOI - Tipo 1 //RUC string ddocnumb = ""; //DOI - Número 12 string dtipabono = ""; //Tipo de abono 1 // ??? string dctabono = ""; //Número de cuenta de abono 20 // ??? string drazonsoc = ""; //Nombre de Beneficiario 40 string dmtopagar = ""; //Importe a Abonar 15 string dtipdoc = ""; //Tipo de Documento 1 string dnrodoc = ""; //Número de Documento 12 string daboagrup = "N"; //Abono Agrupado 1 string dreferen = someString.PadLeft(40, ' '); //Referencia 40 //vacio string dindaviso = "E"; //Indicador de Aviso 1 string dmedaviso = someString.PadLeft(50, ' '); //Medio de Aviso 50 //vacio string dcontacto = someString.PadLeft(30, ' '); //Persona de Contacto 30 string dindicont = someString.PadLeft(2, ' '); //Indicador de Proceso 2 string ddescrip = someString.PadLeft(30, ' '); //Descripción 30 string dfiller = someString.PadLeft(18, ' ');; //Filler 18 VE_Payment auth = getPaymentsByAuthId(paymentAuthId)[0]; //context.PaymentAuth.Where(i => i.Id == Id).FirstOrDefault(); BL_Bank _blBank = new BL_Bank(); _blBank.connectionString = connectionString; BE_Bank bank = _blBank.GetBankById(bankId); //context.Bank.SingleOrDefault(b => b.Id == BankId); var bankaccount = _blBank.GetBankAccountById(bankAccountId); // context.BankAccount.SingleOrDefault(ba => ba.Id == BankAccountId); //Filling out header variables hctacargo = bankaccount.accountNumber + someString.PadLeft(20, ' '); hctacargo = hctacargo.Substring(0, 20); hmdacargo = bankaccount.currency; //Moneda de Cuenta de Cargo //string 3 decimal _htamount = 0; //context.Payment.Where(p => (p.PaymentAuthId == Id && p.BankAccountId == BankAccountId)).Sum(p => p.AmountPaymentFromBank); foreach (VE_Payment _vePayment in getPaymentsAuthBankAccountById(paymentAuthId, bankAccountId)) { _htamount += _vePayment.amountPaymentFromBank; } int _tmphtamount = Decimal.ToInt32(Math.Round(_htamount, 2) * 100); htamount = LeadingZeros(_tmphtamount.ToString(), 15); //Importe a Cargar //string 15, zeros left, no decimales (x100) var _hid = paymentAuthId.ToString(); hid = LeadingRSpaces(_hid, 25); //Referencia //string 25 List <VE_Payment> _lstPayment = getPaymentsAuthBankAccountById(paymentAuthId, bankAccountId); int _hnroregs = _lstPayment.Count(); hnroregs = LeadingZeros(_hnroregs.ToString(), 6); //Total de Registros 6, zero left var mimeType = "text/plain"; var FileBanco = "TMP" + paymentAuthId; var date_pay = Convert.ToDateTime(auth.payDate.ToString()).ToString("yyyyMMdd"); FileBanco = FileBanco + "-" + date_pay + ".TXT"; var payments = _lstPayment; var source = hregtype + hctacargo + hmdacargo + htamount + hproctype + hdateproc + htimeproc + hid + hnroregs + hvalidat + hcontrol + hindprod + hdescrip + hfiller + "\r\n"; foreach (var payment in payments) // query executed and data obtained from database { var _ddocnumb = payment.customerRuc; ddocnumb = LeadingRSpaces(_ddocnumb, 12); List <string> CustomerAccount = new List <string>(); if (bankaccount.currency == "USD") { CustomerAccount = payment.customerBankAccountUsd.Split('|').ToList(); } else { CustomerAccount = payment.customerBankAccountPen.Split('|').ToList(); } var _BankMasterId = ""; var _TipoCta = ""; var _CtaCargo = ""; var _CtaCargoInter = ""; try { _BankMasterId = CustomerAccount[0]; } catch { _BankMasterId = ""; } try { _TipoCta = CustomerAccount[1]; } catch { _TipoCta = ""; } try { _CtaCargo = CustomerAccount[2]; } catch { _CtaCargo = ""; } try { _CtaCargoInter = CustomerAccount[3]; } catch { _CtaCargoInter = ""; } dtipabono = "I"; //Interbancario if (bank.bankMasterId == _BankMasterId) { dtipabono = "P"; //Interbancario } if (dtipabono == "P") { //dctabono = "0011" + dctabono = LeadingRSpaces(_CtaCargo, 20); } else { dctabono = LeadingRSpaces(_CtaCargoInter, 20); } drazonsoc = LeadingRSpaces(RemoveAccents(payment.customerName), 40); int _dmtopagar = Decimal.ToInt32(Math.Round(payment.amountPaymentFromBank, 2) * 100); dmtopagar = LeadingZeros(_dmtopagar.ToString(), 15); //Importe a Cargar //string 15, zeros left, no decimales (x100) dtipdoc = "F"; //Fact if (payment.documentType == "01") { dtipdoc = "F"; //Fact } else if (payment.documentType == "03") { dtipdoc = "B"; //Bol } else if (payment.documentType == "07") { dtipdoc = "N"; //Nota de credito } dnrodoc = LeadingRSpaces(payment.documentId, 12); //Número de Documento 12 source = source + dregtype + ddoctype + ddocnumb + dtipabono + dctabono + drazonsoc + dmtopagar + dtipdoc + dnrodoc + daboagrup + dreferen + dindaviso + dmedaviso + dcontacto + dindicont + ddescrip + dfiller + "\r\n"; } return(ToStream(source)); }
private Stream getBCP(int paymentAuthId, int bankId, int bankAccountId, int detraction) { DateTime hoy = DateTime.Now; string htipreg = "1"; // Tipo de registro 1 1 1 string hnroabonos = ""; // Cantidad de abonos de la planilla 6 2 000006 string hfechproc = hoy.ToString("yyyyMMdd"); //Fecha de proceso 8 8 20070712 string htipctacargo = "C"; //Tipo de la cuenta de cargo 1 16 C string hmonctacargo = ""; // Moneda de la cuenta de cargo 4 17 0001 string hnroctacargo = ""; //Número de la cuenta de cargo 20 21 1910695055056 string hmtoplanilla = ""; //Monto total de la planilla 17 41 00000000001200.00 string hrefplanilla = "PAGOSAPP"; //Referencia de la planilla 40 58 Referencia de la planilla Dividendos hrefplanilla = hrefplanilla.PadRight(40, ' '); string hflagexonera = "N"; //Flag de exoneración ITF 1 98 S string hctrolcheck = ""; //Total de control (checksum) 15 99 000001100000000 string dtipreg = "2"; //Tipo de registro 1 1 2 string dtipctabono = ""; //Tipo de la cuenta de abono 1 2 C string dnroctaabono = ""; //Número de la cuenta de abono 20 3 1910695055056 string dmodpago = "1"; //Modalidad de pago 1 23 1 string dtipdocprov = "6"; //Tipo de documento del proveedor 1 24 1 string dnrodocprov = ""; //Número de documento del proveedor 12 25 123456789012 string dcordocprov = " "; //Correlativo de documento del proveedor 3 37 1 string dnomprov = ""; //Nombre del proveedor 75 40 Flávio Millioli string drefbenefic = ""; //Referencia para el beneficiario 40 115 Referencia para el beneficiario CTS drefbenefic = drefbenefic.PadRight(40, ' '); string drefparaemp = ""; //Referencia para la empresa 20 155 Ref para la empresa drefparaemp = drefparaemp.PadRight(20, ' '); string dmonabono = ""; //Moneda del importe a abonar 4 175 1001 string dimpabono = ""; //Importe a abonar 17 179 00000000001200.00 string dflagvalidar = "S"; //Flag validar IDC 1 196 S string dbtipreg = "3"; //Tipo de registro 1 1 3 string dbtipdocpagar = "F"; //Tipo de documento a pagar 1 2 F string dbnrodocpagar = ""; //Número de documento a pagar 15 3 000000000000001 string dbimpdocpagar = ""; //Importe del documento a pagar 17 18 00000000001200.00 List <VE_Payment> auth = getPaymentsByAuthId(paymentAuthId); //context.PaymentAuth.Where(i => i.Id == Id).FirstOrDefault(); BL_Bank _blBank = new BL_Bank(); _blBank.connectionString = connectionString; BE_Bank bank = _blBank.GetBankById(bankId); //context.Bank.SingleOrDefault(b => b.Id == BankId); var bankaccount = _blBank.GetBankAccountById(bankAccountId); // context.BankAccount.SingleOrDefault(ba => ba.Id == BankAccountId); //var payments = context.Payment.Where(p => (p.PaymentAuthId == Id && p.BankId == BankId)).ToList(); int _hnroabonos = auth.Count(); hnroabonos = LeadingZeros(_hnroabonos.ToString(), 6); //Total de Registros 6, zero left if (bankaccount.currency == "USD") { hmonctacargo = "1001"; // Moneda de la cuenta de cargo 4 17 0001 } else { hmonctacargo = "0001"; // Moneda de la cuenta de cargo 4 17 0001 } hnroctacargo = bankaccount.accountNumber.PadRight(20, ' '); //Número de la cuenta de cargo 20 21 1910695055056 decimal _hmtoplanilla = 0; foreach (VE_Payment _vePayment in getPaymentsAuthBankAccountById(paymentAuthId, bankAccountId)) { _hmtoplanilla += _vePayment.amountPaymentFromBank; } decimal _tmphmtoplanilla = Math.Round(_hmtoplanilla, 2); hmtoplanilla = LeadingZeros(_tmphmtoplanilla.ToString(), 17); //hctrolcheck = "000001100000000"; //por verificar //Total de control (checksum) 15 99 000001100000000 var BankAccountParts = bankaccount.accountNumber.Split('-'); var newBankAccount = ""; foreach (var part in BankAccountParts) { newBankAccount += part; } //verificar con alvaro long hctrolcheck_tmp = Int64.Parse(newBankAccount); //string hctrolcheck_tmp = bankaccount.accountNumber; var mimeType = "text/plain"; var FileBanco = "TMP" + paymentAuthId; var date_pay = Convert.ToDateTime(auth[0].payDate.ToString()).ToString("yyyyMMdd"); FileBanco = FileBanco + "-" + date_pay + ".TXT"; var source = ""; var payments = getPaymentsAuthBankAccountById(paymentAuthId, bankAccountId); // context.Payment.Where(p => (p.PaymentAuthId == Id && p.BankAccountId == BankAccountId)).ToList(); foreach (var payment in payments) // query executed and data obtained from database { List <string> CustomerAccount = new List <string>(); var _BankMasterId = ""; var _TipoCta = ""; var _CtaCargo = ""; var _CtaCargoInter = ""; if (bankaccount.currency == "USD") { CustomerAccount = payment.customerBankAccountUsd.Split('|').ToList(); } else { CustomerAccount = payment.customerBankAccountPen.Split('|').ToList(); } var CtaCargoParts = CustomerAccount[2].Split('-'); var newCtaCargo = ""; foreach (var part in CtaCargoParts) { newCtaCargo += part; } var CtaCargoInterParts = CustomerAccount[3].Split('-'); var newCtaCargoInter = ""; foreach (var part in CtaCargoInterParts) { newCtaCargoInter += part; } try { _BankMasterId = CustomerAccount[0]; } catch { _BankMasterId = ""; } try { _TipoCta = CustomerAccount[1]; } catch { _TipoCta = ""; } try { _CtaCargo = newCtaCargo; } catch { _CtaCargo = "0"; } try { _CtaCargoInter = newCtaCargoInter; } catch { _CtaCargoInter = "0"; } dtipctabono = "B"; //Interbancario if (bank.bankMasterId == _BankMasterId) { dtipctabono = _TipoCta; } if (dtipctabono == "B") { dnroctaabono = LeadingRSpaces(_CtaCargoInter, 20); hctrolcheck_tmp = hctrolcheck_tmp + Int64.Parse(_CtaCargoInter.PadLeft(15, '0')); } else { dnroctaabono = LeadingRSpaces(_CtaCargo, 20); hctrolcheck_tmp = hctrolcheck_tmp + Int64.Parse(_CtaCargo.PadLeft(15, '0')); } dnrodocprov = payment.customerRuc.PadRight(12, ' ').Substring(0, 12); //Número de documento del proveedor 12 25 123456789012 dnomprov = RemoveAccents(payment.customerName).PadRight(75, ' ').Substring(0, 75); //Nombre del proveedor 75 40 Flávio Millioli dmonabono = hmonctacargo; //Moneda del importe a abonar 4 175 1001 (same as header) decimal _dimpabono = Math.Round(payment.amountPaymentFromBank, 2); dimpabono = LeadingZeros(_dimpabono.ToString(), 17); //Importe a Cargar //string 15, zeros left, no decimales (x100) source = source + dtipreg + dtipctabono + dnroctaabono + dmodpago + dtipdocprov + dnrodocprov + dcordocprov + dnomprov + drefbenefic + drefparaemp + dmonabono + dimpabono + dflagvalidar + "\r\n"; // Detalle - Documentos de los Beneficiarios //dbnrodocpagar = payment.NroComprobante.PadRight(15, ' '); dbnrodocpagar = GetLast(payment.documentType.PadLeft(2, ' '), 2) + GetLast(payment.nroSerie.PadLeft(4, ' '), 4) + GetLast(payment.nroComprobante.PadRight(9, '0'), 9); dbimpdocpagar = dimpabono; //Importe del documento a pagar 17 18 00000000001200.00 source = source + dbtipreg + dbtipdocpagar + dbnrodocpagar + dbimpdocpagar + "\r\n"; } hctrolcheck = hctrolcheck_tmp.ToString().PadLeft(15, '0').Substring(0, 15); var hsource = htipreg + hnroabonos + hfechproc + htipctacargo + hmonctacargo + hnroctacargo + hmtoplanilla + hrefplanilla + hflagexonera + hctrolcheck + "\r\n"; source = hsource + source; return(ToStream(source)); }
private Stream getIBK(int paymentAuthId, int bankId, int bankAccountId, int detraction) { string someString = ""; string codregistro = "02"; //Código de registro 02**(02) string codbenef = ""; //Código de beneficiario(RUC)**(20) string tipoperacion = "F"; //Tipo de operacion(Facturas)**(1) string docnumero = ""; //Nro de factura**(20) string fecvctodoc = ""; //Fecha de vencimiento del documento a pagar Fecha en formato "aaaammdd"(8)*/ string monoperacion = ""; //Tipo de moneda soles 01, dolares 10**(2) string impoperacion = ""; //Importe mayor a 0, hasta 13 enteros y 2 decimales**(15) string indbanco = "0"; //Indicador de cuenta bancaria, Interbank 0**(1) string tipoabono = ""; //Tipo abono efectivo 00, abono en cuenta ibk 09, cheque gerencia 11, interbankario 99(2) string producto = "001"; //productos cuenta corriente 001, cuenta ahorros 002, cts 007(3) string moneda = ""; //Tipo de moneda soles 01, dolares 10**(2) string oficina = ""; //Código de la oficina a usar en el pago según el producto(3) string ctanumero = ""; //Número de la cuenta a usar en el pago según el producto IB: 10 posiciones, CCI: 20 posiciones(20) string tipopersona = ""; //Persona natural P, persona jurídica o comercial C(1) string bendocidetip = ""; //Tipo de documento beneficiario DNI 01, RUC 02, Carnet de extranjería 03, cédula de identidad 04, pasaporte 05(2) string bendocidenro = ""; //Nro documento del beneficiario, si Tipo Persona = P, longitud DNI debe ser igual a 8 posiciones(15) string bennombre = ""; //Natural "P" Nombre Beneficiario ApPaterno(20)+ApMaterno(20)+Nombres(20),Juridica "C" Razon Social del Beneficiario(60) campo Alfanumérico hasta 60 caracteres(60) VE_Payment auth = getPaymentsByAuthId(paymentAuthId)[0]; BL_Bank _blBank = new BL_Bank(); _blBank.connectionString = connectionString; BE_Bank bank = _blBank.GetBankById(bankId); var bankaccount = _blBank.GetBankAccountById(bankAccountId); var mimeType = "text/plain"; var FileBanco = "TMP" + paymentAuthId; var date_pay = Convert.ToDateTime(auth.payDate.ToString()).ToString("yyyyMMdd"); FileBanco = FileBanco + "-" + date_pay + ".TXT"; var source = ""; List <VE_Payment> payments = getPaymentsAuthBankAccountById(paymentAuthId, bankAccountId); //var payments = context.Payment.Where(p => (p.PaymentAuthId == Id && p.BankAccountId == BankAccountId)).ToList(); foreach (var payment in payments) { someString = ""; codregistro = "02"; codbenef = ""; tipoperacion = "F"; docnumero = ""; monoperacion = ""; impoperacion = ""; indbanco = "0"; tipoabono = ""; producto = "001"; moneda = ""; oficina = ""; ctanumero = ""; tipopersona = ""; bendocidetip = ""; bendocidenro = ""; bennombre = ""; ctanumero = bankaccount.accountNumber + someString.PadLeft(20, ' '); ctanumero = ctanumero.Substring(0, 20); codbenef = auth.customerRuc + someString.PadRight(20, ' '); codbenef = codbenef.Substring(0, 20); docnumero = auth.documentId + someString.PadLeft(20, ' '); docnumero = docnumero.Substring(0, 20); fecvctodoc = auth.dueDate.ToString(); DateTime payDate = DateTime.Parse(fecvctodoc); // String.Format("{0:yyyyMM/dd/yyyy}", payDate); fecvctodoc = String.Format("{0:yyyyMMdd}", payDate); if (bankaccount.currency == "USD") { monoperacion = "10"; moneda = "10"; } // Moneda de operacion dolares 10, soles 01 else { monoperacion = "01"; moneda = "01"; } var _BankMasterId = ""; if (bank.bankMasterId == _BankMasterId) { tipoabono = "09"; } else { tipoabono = "99"; } decimal _tmphimportotal = Decimal.ToInt32(Math.Round(payment.amountPaymentFromBank, 2)); impoperacion = LeadingZeros(_tmphimportotal.ToString(), 15); var _oficina = string.Empty; oficina = LeadingRSpaces(_oficina, 3); if (auth.documentType == "01") { bendocidetip = "DNI"; tipopersona = "P"; } else { bendocidetip = "RUC"; tipopersona = "C"; } var _bendocidenro = paymentAuthId.ToString(); var _bennombre = paymentAuthId.ToString(); if (tipopersona == "P") { bendocidenro = LeadingRSpaces(_bendocidenro, 8); bennombre = LeadingRSpaces(_bennombre, 62); } else { bennombre = LeadingRSpaces(_bennombre, 60); } source = source + codregistro + codbenef + tipoperacion + docnumero + fecvctodoc + monoperacion + impoperacion + indbanco + tipoabono + producto + moneda + oficina + ctanumero + tipopersona + bendocidetip + bendocidenro + bennombre + "\r\n"; } return(ToStream(source)); }
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); }