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 void Update(Invoice_detail model)
{
db.Entry(model).State = EntityState.Modified;
db.SaveChanges();
}
public void Create(Invoice_detail model)
{
db.Invoice_details.Add(model);
db.SaveChanges();
}
