public BE_Json GetInvoiceDetailByInvoiceId(string invoiceId)
{
BE_Json objJson = null;
var objListaAux = string.Empty;
try
{
BL_Invoice _blInvoice = new BL_Invoice();
_blInvoice.connectionString = AppConfig.DbConnection;
objListaAux = JsonConvert.SerializeObject(_blInvoice.GetInvoiceDetailByInvoiceId(int.Parse(invoiceId)));
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 GetOrderInvoiceByCompany(string companyCode, string searchField)
{
BE_Json objJson = null;
var objListaAux = string.Empty;
try
{
BL_Invoice _blInvoice = new BL_Invoice();
_blInvoice.connectionString = AppConfig.DbConnection;
objListaAux = JsonConvert.SerializeObject(_blInvoice.GetOrderInvoiceByCompany(companyCode));
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 MakePaymentsDetailsPartials(MakePaymentsDetailsPartialsViewModel ViewModel)
{
BE_Json objJson = null;
var objListaAux = string.Empty;
try
{
BL_Invoice _blInvoice = new BL_Invoice();
_blInvoice.connectionString = AppConfig.DbConnection;
objListaAux = JsonConvert.SerializeObject(_blInvoice.MakePaymentsDetailsPartials(ViewModel.lstInvoices, ViewModel.payment));
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 UpdateDocumentTypeGeneral([FromBody] BE_DocumentType _DocumentType)
{
BE_Json objJson = null;
var objListaAux = string.Empty;
try
{
BL_Invoice _blInvoice = new BL_Invoice();
_blInvoice.connectionString = AppConfig.DbConnection;
objListaAux = JsonConvert.SerializeObject(_blInvoice.UpdateDocumentTypeGeneral(_DocumentType));
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 GetUnpaidCompanyInvoices(string companyCode)
{
//logger.Debug("hello world");
//BL_Invoice BL_Invoice = new BL_Invoice();
//_blInvoice.connectionString = AppConfig.DbConnection;
//return _blInvoice.GetUnpaidCompanyInvoices(companyCode);
BE_Json objJson = null;
var objListaAux = string.Empty;
try
{
BL_Invoice _blInvoice = new BL_Invoice();
_blInvoice.connectionString = AppConfig.DbConnection;
objListaAux = JsonConvert.SerializeObject(_blInvoice.GetUnpaidCompanyInvoices(companyCode));
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 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 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 BE_Product CreateProduct(BE_Product bE_Product)
{
bool bOk = true;
_database = new MySQLDatabase(connectionString);
BL_Invoice bL_Invoice = new BL_Invoice();
bL_Invoice.connectionString = connectionString;
int filas = GetProductByCode(bE_Product.code).Count;
if (filas > 0)
{
return(null);
}
if (filas != 0)
{
bOk = false;
}
if (bOk)
{
BE_InvoiceItem BE_InvoiceItem = bL_Invoice.AddInvoiceItem(new BE_InvoiceItem()
{
companyCode = bE_Product.CompanyCode
,
igvAffected = true
,
IsEnabled = true
,
invoiceItemType = "P"
,
name = bE_Product.code + "-" + bE_Product.name
});
bE_Product.invoiceItemId = BE_InvoiceItem.invoiceItemId;
}
var newProduct = new DA_Product(_database).CreateProduct(bE_Product);
if (bOk && newProduct.detail != null)
{
foreach (var detail in newProduct.detail)
{
detail.productId = newProduct.productId;
CreateProductDetail(detail);
}
}
return(newProduct);
}
public BE_Json GetInvoiceByCompanyCodeAndType(string companyCode, string invoiceType, string invoiceStatusId)
{
BE_Json objJson = null;
var objListaAux = string.Empty;
try
{
BL_Invoice _blInvoice = new BL_Invoice();
_blInvoice.connectionString = AppConfig.DbConnection;
List <VE_Invoice> result = null;
if (invoiceType.ToUpper() == "O")
{
result = _blInvoice.GetInvoiceGeneral(new BEInvoiceFilter()
{
CompanyCodeTarget = companyCode, invoiceType = invoiceType, invoiceStatusId = 0
});
}
else
{
result = _blInvoice.GetInvoiceByCompanyCodeAndType(companyCode, invoiceType, int.Parse(invoiceStatusId));
}
objListaAux = JsonConvert.SerializeObject(result);
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);
}
