public BE_Json DeleteCompany(BE_Company _BeCompany) { //BL_Company _blCompany = new BL_Company(); //_blCompany.connectionString = AppConfig.DbConnection; //return _blCompany.DeleteCompany(_BeCompany); BE_Json objJson = null; var objListaAux = string.Empty; try { BL_Company _blCompany = new BL_Company(); _blCompany.connectionString = AppConfig.DbConnection; objListaAux = JsonConvert.SerializeObject(_blCompany.DeleteCompany(_BeCompany)); 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_Company CreateCompany(BE_Company _BeCompany) { int filasAfectadas = 0; string strError_Mensaje = string.Empty; bool boResultado = false; Dictionary <string, object> parameters = new Dictionary <string, object>(); parameters.Add("_companyCode", _BeCompany.companyCode); parameters.Add("_companyLimit", _BeCompany.companyLimit); parameters.Add("_companyName", _BeCompany.companyName); parameters.Add("_companyRUC", _BeCompany.companyRUC); parameters.Add("_userAudit", _BeCompany.userAudit); parameters.Add("_companyType", _BeCompany.companyType); parameters.Add("_districtId", _BeCompany.districtId); parameters.Add("_quantityAuth", _BeCompany.quantityAuth); filasAfectadas = _database.ExecuteSP("spi_insertCompany", parameters); boResultado = (filasAfectadas > 0); if (boResultado) { return(_BeCompany); } return(null); }
public List <BE_Company> GetCompanyGeneral(BECompanyFilter _bECompanyFilter) { BE_Company _BeCompany = null; List <BE_Company> _lstCompany = new List <BE_Company>(); Dictionary <string, object> parameters = new Dictionary <string, object>(); parameters.Add("_companyCode", _bECompanyFilter.companyCode);//Eliminar en la proxima version parameters.Add("_companyTypeList", _bECompanyFilter.CompanyTypeList); parameters.Add("_searchFilter", (string.IsNullOrEmpty(_bECompanyFilter.SearchFilter))?"": _bECompanyFilter.SearchFilter); parameters.Add("_companyRuc", _bECompanyFilter.companyRUC); parameters.Add("_userName", _bECompanyFilter.userName); var rows = _database.QuerySP("sps_getCompanyGeneral", parameters); foreach (var row in rows) { _BeCompany = new BE_Company(); _BeCompany.companyCode = row["CompanyCode"]; _BeCompany.companyLimit = string.IsNullOrEmpty(row["CompanyLimit"]) ? 0 : decimal.Parse(row["CompanyLimit"]); _BeCompany.companyName = row["CompanyName"]; _BeCompany.companyRUC = row["CompanyRUC"]; _BeCompany.companySys = row["CompanySys"]; _BeCompany.isEnabled = string.IsNullOrEmpty(row["IsEnabled"]) ? false : row["IsEnabled"].Equals("1") ? true : false; _BeCompany.companyType = row["companyType"]; _BeCompany.districtId = row["districtId"]; _BeCompany.quantityAuth = row["quantityAuth"]; _lstCompany.Add(_BeCompany); } return(_lstCompany); }
public List <BE_Company> GetCompanyByTypeId(int companyTypeId) { BE_Company _BeCompany = null; List <BE_Company> _lstCompany = new List <BE_Company>(); Dictionary <string, object> parameters = new Dictionary <string, object>(); parameters.Add("_companyTypeId", companyTypeId); var rows = _database.QuerySP("sps_getCompanyByTypeId", parameters); foreach (var row in rows) { _BeCompany = new BE_Company(); _BeCompany.companyCode = row["CompanyCode"]; _BeCompany.companyLimit = string.IsNullOrEmpty(row["CompanyLimit"]) ? 0 : decimal.Parse(row["CompanyLimit"]); _BeCompany.companyName = row["CompanyName"]; _BeCompany.companyRUC = row["CompanyRUC"]; _BeCompany.companySys = row["CompanySys"]; _BeCompany.isEnabled = string.IsNullOrEmpty(row["IsEnabled"]) ? false : row["IsEnabled"].Equals("1") ? true : false; _BeCompany.companyType = row["companyType"]; _BeCompany.districtId = row["districtId"]; _BeCompany.quantityAuth = row["quantityAuth"]; _lstCompany.Add(_BeCompany); } return(_lstCompany); }
public BE_Company DeleteCompany(BE_Company _BeCompany) { int filasAfectadas = 0; string strError_Mensaje = string.Empty; bool boResultado = false; Dictionary <string, object> parameters = new Dictionary <string, object>(); parameters.Add("_companyCode", _BeCompany.companyCode); parameters.Add("_userAudit", _BeCompany.userAudit); filasAfectadas = _database.ExecuteSP("spd_deleteCompany", parameters); boResultado = (filasAfectadas > 0); if (boResultado) { return(_BeCompany); } return(null); }
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 BE_Company DeleteCompany(BE_Company _BeCompany) { _database = new MySQLDatabase(connectionString); return(new DA_Company(_database).DeleteCompany(_BeCompany)); }
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); }