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