public List <VE_Invoice> GetBankAdjusmentHistory(int bankAccountId) { VE_Invoice _VeInvoice = null; List <VE_Invoice> _lstInvoice = new List <VE_Invoice>(); Dictionary <string, object> parameters = new Dictionary <string, object>(); parameters.Add("_bankAccountId", bankAccountId); var rows = _database.QuerySP("sp_getBankAdjusmentHistory", parameters); foreach (var row in rows) { _VeInvoice = new VE_Invoice(); _VeInvoice.invoiceId = row["Id"]; _VeInvoice.amountBalance = string.IsNullOrEmpty(row["AmountBalance"]) ? 0 : decimal.Parse(row["AmountBalance"]); _VeInvoice.amountDetraction = string.IsNullOrEmpty(row["AmountDetraction"]) ? 0 : decimal.Parse(row["AmountDetraction"]); _VeInvoice.amountPayment = string.IsNullOrEmpty(row["AmountPayment"]) ? 0 : decimal.Parse(row["AmountPayment"]); _VeInvoice.amountPaymentDetraction = string.IsNullOrEmpty(row["AmountPaymentDetraction"]) ? 0 : decimal.Parse(row["AmountPaymentDetraction"]); _VeInvoice.amountPaymentFromBank = string.IsNullOrEmpty(row["AmountPaymentFromBank"]) ? 0 : decimal.Parse(row["AmountPaymentFromBank"]); _VeInvoice.amountPaymentPen = string.IsNullOrEmpty(row["AmountPaymentPen"]) ? 0 : decimal.Parse(row["AmountPaymentPen"]); _VeInvoice.amountTotal = string.IsNullOrEmpty(row["AmountTotal"]) ? 0 : decimal.Parse(row["AmountTotal"]); _VeInvoice.bankAccountId = string.IsNullOrEmpty(row["BankAccountId"]) ? 0 : int.Parse(row["BankAccountId"]); _VeInvoice.bankAccountNumber = row["BankAccountNumber"]; _VeInvoice.bankId = string.IsNullOrEmpty(row["BankId"]) ? 0 : int.Parse(row["BankId"]); _VeInvoice.budgetFile = row["BudgetFile"]; _VeInvoice.companyCode = row["CompanyCode"]; _VeInvoice.currency = row["Currency"]; _VeInvoice.currencyPayment = row["CurrencyPayment"]; _VeInvoice.customerBankAccountPen = row["CustomerBankAccountPen"]; _VeInvoice.customerBankAccountUsd = row["CustomerBankAccountUsd"]; _VeInvoice.customerName = row["CustomerName"]; _VeInvoice.customerRuc = row["CustomerRuc"]; _VeInvoice.documentDate = string.IsNullOrEmpty(row["DocumentDate"]) ? DateTime.Now : DateTime.Parse(row["DocumentDate"]); _VeInvoice.documentId = row["DocumentId"]; _VeInvoice.dueDate = string.IsNullOrEmpty(row["DueDate"]) ? DateTime.Now : DateTime.Parse(row["DueDate"]); _VeInvoice.exchangeRate = row["ExchangeRate"]; _VeInvoice.invoiceFile = row["InvoiceFile"]; _VeInvoice.ocrFile = row["OCRFile"]; _VeInvoice.customerEmail = row["CustomerEmail"]; _VeInvoice.documentType = row["DocumentType"]; _VeInvoice.customerBankAccountDetraction = row["CustomerBankAccountDetraction"]; _VeInvoice.nroComprobante = row["NroComprobante"]; _VeInvoice.nroSerie = row["NroSerie"]; _VeInvoice.tipoServicio = row["TipoServicio"]; _VeInvoice.customerDocType = row["CustomerDocType"]; _VeInvoice.accounting = row["Accounting"]; _VeInvoice.amountDetraccionUS = string.IsNullOrEmpty(row["AmountDetractionUS"]) ? 0 : decimal.Parse(row["AmountDetractionUS"]); _VeInvoice.status = row["Status"]; _VeInvoice.invoiceStatusId = string.IsNullOrEmpty(row["InvoiceStatusId"]) ? 0 : int.Parse(row["InvoiceStatusId"]); _VeInvoice.invoiceType = row["InvoiceType"]; _VeInvoice.reference = row["reference"]; _VeInvoice.comments = row["comments"]; _lstInvoice.Add(_VeInvoice); } return(_lstInvoice); }
public BE_Json GetInvoiceExpByCompany(string companyCode, string searchField) { //BL_Invoice _blInvoice = new BL_Invoice(); //_blInvoice.connectionString = AppConfig.DbConnection; //return _blInvoice.GetInvoiceById(_invoiceId); BE_Json objJson = null; var objListaAux = string.Empty; try { BL_Invoice _blInvoice = new BL_Invoice(); _blInvoice.connectionString = AppConfig.DbConnection; List <VE_Invoice> a = new List <VE_Invoice>(); VE_Invoice b = new VE_Invoice(); a.Add(b); objListaAux = JsonConvert.SerializeObject(a); objJson = new BE_Json(); objJson.data = objListaAux; objJson.status = CManager.RESULTADO_WCF.OK; } catch (Exception ex) { objJson = new BE_Json(); objJson.data = "Hubo en error en servidor:" + ex.Message + ";" + ex.StackTrace + ";" + ex.ToString(); objJson.status = CManager.RESULTADO_WCF.ERROR; objJson.status = CManager.RESULTADO_WCF.ERROR; } finally { objListaAux = null; } return(objJson); }
public BE_Json DeleteInvoice(VE_Invoice _VeInvoice) { //BL_Invoice _blInvoice = new BL_Invoice(); //_blInvoice.connectionString = AppConfig.DbConnection; //return _blInvoice.DeleteInvoice(_VeInvoice); BE_Json objJson = null; var objListaAux = string.Empty; try { BL_Invoice _blInvoice = new BL_Invoice(); _blInvoice.connectionString = AppConfig.DbConnection; objListaAux = JsonConvert.SerializeObject(_blInvoice.DeleteInvoice(_VeInvoice)); objJson = new BE_Json(); objJson.data = objListaAux; objJson.status = CManager.RESULTADO_WCF.OK; } catch (Exception ex) { objJson = new BE_Json(); objJson.data = "Hubo en error en servidor:" + ex.Message + ";" + ex.StackTrace + ";" + ex.ToString(); objJson.status = CManager.RESULTADO_WCF.ERROR; objJson.status = CManager.RESULTADO_WCF.ERROR; } finally { objListaAux = null; } return(objJson); }
public BE_Json BankAdjustment([FromBody] VE_Invoice vE_Invoice) { BE_Json objJson = null; var objListaAux = string.Empty; try { BL_Bank _blBank = new BL_Bank(); _blBank.connectionString = AppConfig.DbConnection; objListaAux = JsonConvert.SerializeObject(_blBank.BankAdjustment(vE_Invoice)); objJson = new BE_Json(); objJson.data = objListaAux; objJson.status = CManager.RESULTADO_WCF.OK; } catch (Exception ex) { objJson = new BE_Json(); objJson.data = "Hubo en error en servidor:" + ex.Message + ";" + ex.StackTrace + ";" + ex.ToString(); objJson.status = CManager.RESULTADO_WCF.ERROR; objJson.status = CManager.RESULTADO_WCF.ERROR; } finally { objListaAux = null; } return(objJson); }
public bool CreateSchedule(BE_Schedule bE_Schedule) { _database = new MySQLDatabase(connectionString); bool bOk = true; BL_Invoice blInvoice = new BL_Invoice(); blInvoice.connectionString = connectionString; //blInvoice._database = _database; VE_Invoice invoice = blInvoice.CreateInvoiceGeneral(bE_Schedule.Invoice); bOk = (invoice != null); if (exist(bE_Schedule)) { bOk = bOk && new DA_Schedule(_database).UpdateSchedule(bE_Schedule); } else { bOk = bOk && new DA_Schedule(_database).CreateSchedule(bE_Schedule); } return(bOk); }
public VE_BankAccount BankAdjustment(VE_Invoice vE_Invoice) { vE_Invoice.invoiceDetail = new List <VE_InvoiceDetail>(); if (vE_Invoice.amountTotal < 0) { vE_Invoice.amountTotal = vE_Invoice.amountTotal * -1; vE_Invoice.invoiceType = "O"; } else { vE_Invoice.invoiceType = "S"; } BL_Invoice bL_Invoice = new BL_Invoice(); bL_Invoice.connectionString = connectionString; var invoice = bL_Invoice.CreateInvoice(vE_Invoice); _database = new MySQLDatabase(connectionString); return(new DA_Bank(_database).updateBalanceBankAccountByInvoice(int.Parse(invoice.invoiceId), invoice.bankAccountId)); }
public BE_Json UpdateInvoiceGeneral([FromBody] VE_Invoice _VeInvoice) { BE_Json objJson = null; var objListaAux = string.Empty; if (_VeInvoice == null) { return(objJson); } try { BL_Invoice _blInvoice = new BL_Invoice(); _blInvoice.connectionString = AppConfig.DbConnection; objListaAux = JsonConvert.SerializeObject(_blInvoice.updateInvoiceGeneral(_VeInvoice)); objJson = new BE_Json(); objJson.data = objListaAux; objJson.status = CManager.RESULTADO_WCF.OK; } catch (ApplicationException ex) { objJson = new BE_Json(); objJson.data = ex.Message; objJson.status = CManager.RESULTADO_WCF.ERROR; } catch (Exception ex) { objJson = new BE_Json(); objJson.data = "Hubo en error en servidor:" + ex.Message + ";" + ex.StackTrace + ";" + ex.ToString(); objJson.status = CManager.RESULTADO_WCF.ERROR; objJson.status = CManager.RESULTADO_WCF.ERROR; } finally { objListaAux = null; } return(objJson); }
/* * public VE_Invoice updateInvoiceGeneral(VE_Invoice _vE_Invoice) * { * _database = new MySQLDatabase(connectionString); * return new DA_Invoice(_database).updateInvoiceGeneral(_vE_Invoice); * }*/ public VE_Invoice updateInvoiceGeneral(VE_Invoice _VeInvoice) { _database = new MySQLDatabase(connectionString); BL_Option bL_Option = new BL_Option(this.connectionString); //bL_Option.connectionString = connectionString; var ok = bL_Option.ValidateOption(9, _VeInvoice.userName); if (ok == 0) { throw new ApplicationException("Ud. no cuenta con los permisos necesarios"); } if (_VeInvoice.documentId != null) { var numbers = _VeInvoice.documentId.Split('-'); if (numbers.Count() < 2) { throw new ApplicationException("Ingrese una factura válida"); } _VeInvoice.nroSerie = numbers[0]; _VeInvoice.nroComprobante = numbers[1]; } new DA_Invoice(_database).updateInvoiceGeneral(_VeInvoice); var invoice = new DA_Invoice(_database).getInvoiceGeneral(new BEInvoiceFilter { invoiceIdList = _VeInvoice.invoiceId }); if (_VeInvoice.invoiceStatusId != invoice[0].invoiceStatusId) { BL_WorkFlow _blWorkFlow = new BL_WorkFlow(); _blWorkFlow.connectionString = connectionString; var mensaje = ""; bool bOk = false; if (_VeInvoice.invoiceStatusId == 2) { bOk = _blWorkFlow.NextWorkFlowStep(ref mensaje, 9, int.Parse(_VeInvoice.invoiceId), _VeInvoice.userName, false); } else { bOk = _blWorkFlow.NextWorkFlowStep(ref mensaje, 1, int.Parse(_VeInvoice.invoiceId), _VeInvoice.userName, false); } if (!bOk) { throw new ApplicationException(mensaje); } } new DA_Invoice(_database).DeleteInvoiceDetailByInvoiceId(_VeInvoice.invoiceId); if (_VeInvoice.invoiceDetail != null) { foreach (VE_InvoiceDetail _veInvoiceDetail in _VeInvoice.invoiceDetail) { _veInvoiceDetail.invoiceId = int.Parse(_VeInvoice.invoiceId); new DA_Invoice(_database).createInvoiceDetail(_veInvoiceDetail); } } return(_VeInvoice); }
public VE_Invoice DeleteInvoice(VE_Invoice _VeInvoice) { _database = new MySQLDatabase(connectionString); return(new DA_Invoice(_database).deleteInvoice(_VeInvoice)); }
public VE_Invoice UpdateInvoiceStatus(VE_Invoice _VeInvoice) { _database = new MySQLDatabase(connectionString); return(new DA_Invoice(_database).updateInvoiceStatus(_VeInvoice)); }
public VE_Invoice CreateInvoice(VE_Invoice _VeInvoice) { string invoiceId; _database = new MySQLDatabase(connectionString); var companysSystem = (new BL_Company() { connectionString = connectionString }).GetCompanyGeneral(new BECompanyFilter() { companyCode = _VeInvoice.companyCode }); BE_Company _companySystem = null; if (companysSystem.Count > 0) { _companySystem = companysSystem[0]; } else { throw new Exception("codigo Invalido"); } if (_VeInvoice.invoiceType.Equals("O") && _companySystem.companyType.Equals("3"))// del sistema { var companysEmisor = (new BL_Company() { connectionString = connectionString }).GetCompanyGeneral(new BECompanyFilter() { companyRUC = _VeInvoice.customerRuc }); BE_Company _companyEmisor = null; if (companysEmisor.Count > 0) { _companyEmisor = companysEmisor[0]; } else { throw new Exception("codigo Invalido"); } _VeInvoice.companyCode = _companyEmisor.companyCode; _VeInvoice.customerRuc = _companySystem.companyRUC; _VeInvoice.customerName = _companySystem.companyName; } if (_VeInvoice.documentId != null) { var numbers = _VeInvoice.documentId.Split('-'); if (numbers.Count() < 2) { throw new Exception("Ingrese una factura válida"); } _VeInvoice.nroSerie = numbers[0]; _VeInvoice.nroComprobante = numbers[1]; } invoiceId = new DA_Invoice(_database).createInvoice(_VeInvoice).invoiceId; foreach (VE_InvoiceDetail _veInvoiceDetail in _VeInvoice.invoiceDetail) { _veInvoiceDetail.invoiceId = int.Parse(invoiceId); new DA_Invoice(_database).createInvoiceDetail(_veInvoiceDetail); } return(_VeInvoice); }
public VE_Invoice CreateInvoiceGeneral(VE_Invoice _VeInvoice) { string invoiceId; _database = new MySQLDatabase(connectionString); var companysSystem = (new BL_Company() { connectionString = connectionString }).GetCompanyGeneral(new BECompanyFilter() { companyCode = _VeInvoice.companyCode }); BE_Company _companySystem = null; if (companysSystem.Count > 0) { _companySystem = companysSystem[0]; } else { throw new Exception("codigo Invalido"); } if ((_VeInvoice.invoiceType.Equals(BE_Invoice.ORDER) || _VeInvoice.invoiceType.Equals(BE_Invoice.PURCHASEORDER)) && _companySystem.companyType.Equals("3")) // del sistema { var companysEmisor = (new BL_Company() { connectionString = connectionString }).GetCompanyGeneral(new BECompanyFilter() { companyRUC = _VeInvoice.customerRuc }); BE_Company _companyEmisor = null; if (companysEmisor.Count > 0) { _companyEmisor = companysEmisor[0]; } else { throw new Exception("codigo Invalido"); } _VeInvoice.companyCode = _companyEmisor.companyCode; _VeInvoice.customerRuc = _companySystem.companyRUC; _VeInvoice.customerName = _companySystem.companyName; } invoiceId = new DA_Invoice(_database).createInvoice(_VeInvoice).invoiceId; foreach (VE_InvoiceDetail _veInvoiceDetail in _VeInvoice.invoiceDetail) { _veInvoiceDetail.invoiceId = int.Parse(invoiceId); new DA_Invoice(_database).createInvoiceDetail(_veInvoiceDetail); } return(_VeInvoice); }