public string SaveDetalle(Invoice_detail _insertData, string numFact, int idAccount, int iduser, string option, string campaign, string statusStask)
{
bool status = false;
Branch branch = null;
Person person = null;
Central_Warenhouse centralw = new Central_Warenhouse();
Invoice invoice = new Invoice();
IQueryable <Invoice> invoices = Enumerable.Empty <Invoice>().AsQueryable();
IQueryable <Distributor> distributors = Enumerable.Empty <Distributor>().AsQueryable();
TaskCampaign task = null;
int idDistributor = 0;
try
{
invoices = Context.Invoices.Where(i => i.NUMBER == numFact);
if (invoices.Count() > 0)
{
invoice = invoices.First();
distributors = Context.Distributors.Where(d => d.RUC == invoice.RUC_CEDULA);
if (invoice.IDINVOICE != 0)
{
invoice.Invoice_details = new List <Invoice_detail>();
invoice.Invoice_details.Add(_insertData);
}
}
else
{
return("No puedo actualizar la información en la base de datos. Revise la Información");
}
Context.SaveChanges();
centralw.IDPRODUCTO = _insertData.IDPRODUCTO;
centralw.BALANCE = (decimal)_insertData.AMOUNT;
centralw.DESCRIPTION = _insertData.DESCRIPTION;
centralw.MOVEMENT = "1";
centralw.IDDISTRIBUTOR = distributors.Count() > 0 ? distributors.First().IDDISTRIBUTOR : 1;
Context.Central_Warenhouses.Add(centralw);
Context.SaveChanges();
Context.Query <string>($@"EXEC dbo.sp_actualiza_central_warehouse_app @idproducto = {centralw.IDPRODUCTO}, @iddistribuidor = {centralw.IDDISTRIBUTOR}");
return("");
}
catch (Exception e)
{
return("No puedo actualizar la información en la base de datos. Revise la Información");
throw;
}
finally
{
status = true;
}
}
public string SaveInvoive(Invoice _insertData, int idAccount, int iduser, string option, string campaign, string statusStask)
{
bool status = false;
Branch branch = null;
Person person = null;
Central_Warenhouse centralw = new Central_Warenhouse();
Invoice invoice = new Invoice();
IQueryable <Invoice> invoices = Enumerable.Empty <Invoice>().AsQueryable();
TaskCampaign task = null;
try
{
invoices = Context.Invoices.Where(i => i.NUMBER == _insertData.NUMBER);
if (invoices.Count() > 0)
{
invoice = invoices.First();
}
else
{
invoice = _insertData;
Context.Invoices.Add(invoice);
}
Context.SaveChanges();
return("");
}
catch (Exception e)
{
return("No puedo actualizar la información en la base de datos. Revise la Información");
throw;
}
finally
{
status = true;
}
}
public Boolean GuardarBodegaMovil(int warehouseid, int productid, int quantity, int entregadorid, int userid, string comment, int tipo)
{
try
{
int tipoIngreso = 1 * tipo;
Movil_Warenhouse movil_Warenhouse = new Movil_Warenhouse();
movil_Warenhouse.IDVENDEDOR = entregadorid;
movil_Warenhouse.BALANCE = quantity;
movil_Warenhouse.DESCRIPTION = "INGRESO DE INVENTARIO APP";
movil_Warenhouse.MOVEMENT = tipoIngreso.ToString();
movil_Warenhouse.IDPRODUCTO = productid;
movil_Warenhouse.COMMENT = comment;
Context.Movil_Warenhouses.Add(movil_Warenhouse);
Context.SaveChanges();
int tipoIngresoWarenhouse = -1 * tipo;
Central_Warenhouse central_Warenhouse = new Central_Warenhouse();
central_Warenhouse.IDDISTRIBUTOR = warehouseid;
central_Warenhouse.BALANCE = quantity;
central_Warenhouse.DESCRIPTION = "INGRESO DE INVENTARIO APP";
central_Warenhouse.MOVEMENT = tipoIngresoWarenhouse.ToString();
central_Warenhouse.IDPRODUCTO = productid;
Context.Central_Warenhouses.Add(central_Warenhouse);
Context.SaveChanges();
var _dataTable = Context.Query <List <int> >($@"EXEC dbo.sp_actuaiza_movil_warehouse_resume_APP @idvendedor ={entregadorid} ,@idproducto = { productid} ,@iddistribuidor ={warehouseid}");
return(true);
}
catch (Exception ex)
{
throw;
return(false);
}
}
public string SaveProductNutriMigrate(Invoice _insertData, int idAccount, int iduser, string option, string campaign, string statusStask)
{
bool status = false;
Branch branch = null;
Person person = null;
Central_Warenhouse centralw = new Central_Warenhouse();
Invoice invoice = new Invoice();
IQueryable <Invoice> invoices = Enumerable.Empty <Invoice>().AsQueryable();
TaskCampaign task = null;
try
{
invoices = Context.Invoices.Where(i => i.NUMBER == _insertData.NUMBER);
if (invoices.Count() > 0)
{
invoice = invoices.First();
if (invoice.IDINVOICE != 0)
{
invoice.Invoice_details = new List <Invoice_detail>();
invoice.Invoice_details.Add(_insertData.Invoice_details.First());
}
}
else
{
invoice = _insertData;
Context.Invoices.Add(invoice);
}
Context.SaveChanges();
if (Context.Central_Warenhouses.Where(c => c.IDPRODUCTO == _insertData.Invoice_details.First().IDPRODUCTO).Count() > 0)
{
centralw = Context.Central_Warenhouses.Where(c => c.IDPRODUCTO == _insertData.Invoice_details.First().IDPRODUCTO).First();
if (centralw.ID_CENTRALW != 0)
{
centralw.BALANCE = centralw.BALANCE + (decimal)_insertData.Invoice_details.First().AMOUNT;
}
}
else
{
centralw.IDPRODUCTO = _insertData.Invoice_details.First().IDPRODUCTO;
//centralw.ID = _insertData.Invoice_details.First().IDPRODUCTO;
centralw.IDDISTRIBUTOR = 1;
centralw.BALANCE = (decimal)_insertData.Invoice_details.First().AMOUNT;
centralw.DESCRIPTION = _insertData.Invoice_details.First().DESCRIPTION;
centralw.MOVEMENT = "1";
Context.Central_Warenhouses.Add(centralw);
}
Context.SaveChanges();
return("");
}
catch (Exception e)
{
return("No puedo actualizar la información en la base de datos. Revise la Información");
throw;
}
finally
{
status = true;
}
}
