public ResultAndError <Recuento> CheckProductoRecuento(string product, ResultAndError <Recuento> recount)
{
IEnumerable <HojaRecuento> oHojas = db.HojaRecuentos.Where(o => o.ProductNo == product && o.Date.Value.Month == DateTime.Now.Month);
if (oHojas.Count() > 0)
{
return(recount.AddError("El producto " + product + " ya esta en un recuento" + oHojas.First().Codigo));
}
return(recount);
}
public ResultAndError <Recuento> CheckZonaRecuento(List <string> zonas, ResultAndError <Recuento> recount)
{
foreach (string zona in zonas)
{
IEnumerable <HojaRecuento> oHojas = db.HojaRecuentos.Where(o => o.Zone == zona && o.Date.Value.Month == DateTime.Now.Month);
if (oHojas.Count() > 0)
{
return(recount.AddError("La zona " + zona + " ya esta en el recuento " + oHojas.First().Codigo));
}
}
return(recount);
}
public ResultAndError <HistoricoPedido> CloseOrder(Document order)
{
ResultAndError <HistoricoPedido> result = new ResultAndError <HistoricoPedido>();
try
{
HistoricoPedido oHistorico = GetHistoricoFromOrder(order);
return(result = Update(oHistorico, true));
}
catch (Exception e)
{
return(result.AddError(e, HttpStatusCode.InternalServerError));
}
}
public ResultAndError <CrossReference> Add(CrossReference c)
{
ResultAndError <CrossReference> result = new ResultAndError <CrossReference>();
try
{
db.CrossReferences.Add(c);
db.SaveChanges();
return(result.AddResult(c));
}
catch (Exception e)
{
return(result.AddError(e, HttpStatusCode.InternalServerError));
}
}
public ResultAndError <PedVentaCab> Add(PedVentaCab c)
{
ResultAndError <PedVentaCab> result = new ResultAndError <PedVentaCab>();
try
{
db.PedVentaCabs.Add(c);
db.SaveChanges();
return(result.AddResult(c));
}
catch (Exception e)
{
return(result.AddError(e, HttpStatusCode.InternalServerError));
}
}
public ResultAndError <ProductCategory> Add(ProductCategory c)
{
ResultAndError <ProductCategory> result = new ResultAndError <ProductCategory>();
try
{
db.ProductCategories.Add(c);
db.SaveChanges();
return(result.AddResult(c));
}
catch (Exception e)
{
return(result.AddError(e, HttpStatusCode.InternalServerError));
}
}
public ResultAndError <Dimension> Add(Dimension c)
{
ResultAndError <Dimension> result = new ResultAndError <Dimension>();
try
{
db.Dimensions.Add(c);
db.SaveChanges();
return(result.AddResult(c));
}
catch (Exception e)
{
return(result.AddError(e, HttpStatusCode.InternalServerError));
}
}
public ResultAndError <Subcenter> Add(Subcenter c)
{
ResultAndError <Subcenter> result = new ResultAndError <Subcenter>();
try
{
db.Subcenters.Add(c);
db.SaveChanges();
return(result.AddResult(c));
}
catch (Exception e)
{
return(result.AddError(e, HttpStatusCode.InternalServerError));
}
}
public ResultAndError <Provider> Add(Provider p)
{
ResultAndError <Provider> result = new ResultAndError <Provider>();
try
{
db.Providers.Add(p);
db.SaveChanges();
return(result.AddResult(p));
}
catch (Exception e)
{
return(result.AddError(e, HttpStatusCode.InternalServerError));
}
}
public ResultAndError <Document> Add(Document c)
{
ResultAndError <Document> result = new ResultAndError <Document>();
try
{
db.HeaderRequests.Add(c);
db.SaveChanges();
return(result.AddResult(c));
}
catch (Exception e)
{
return(result.AddError(e, HttpStatusCode.InternalServerError));
}
}
public ResultAndError <DiscountLineInvoice> Add(DiscountLineInvoice c)
{
ResultAndError <DiscountLineInvoice> result = new ResultAndError <DiscountLineInvoice>();
try
{
db.DiscountLineInvoices.Add(c);
db.SaveChanges();
return(result.AddResult(c));
}
catch (Exception e)
{
return(result.AddError(e, HttpStatusCode.InternalServerError));
}
}
public ResultAndError <UnitMeasureProduct> Add(UnitMeasureProduct c)
{
ResultAndError <UnitMeasureProduct> result = new ResultAndError <UnitMeasureProduct>();
try
{
db.UnitMeasureProducts.Add(c);
db.SaveChanges();
return(result.AddResult(c));
}
catch (Exception e)
{
return(result.AddError(e, HttpStatusCode.InternalServerError));
}
}
public ResultAndError <AlmacenZP> Add(AlmacenZP pr)
{
ResultAndError <AlmacenZP> result = new ResultAndError <AlmacenZP>();
try
{
db.AlmacenZPs.Add(pr);
db.SaveChanges();
return(result.AddResult(pr));
}
catch (Exception e)
{
return(result.AddError(e, HttpStatusCode.InternalServerError));
}
}
public ResultAndError <Line> Add(Line c)
{
ResultAndError <Line> result = new ResultAndError <Line>();
try
{
db.LineRequests.Add(c);
db.SaveChanges();
return(result.AddResult(c));
}
catch (Exception e)
{
return(result.AddError(e, HttpStatusCode.InternalServerError));
}
}
public ResultAndError <HistoricoPedido> Add(HistoricoPedido c)
{
ResultAndError <HistoricoPedido> result = new ResultAndError <HistoricoPedido>();
try
{
db.HistoricoPedidos.Add(c);
db.SaveChanges();
return(result.AddResult(c));
}
catch (Exception e)
{
return(result.AddError(e, HttpStatusCode.InternalServerError));
}
}
public ResultAndError <CabeceraRecuento> Add(CabeceraRecuento pr)
{
ResultAndError <CabeceraRecuento> result = new ResultAndError <CabeceraRecuento>();
try
{
db.CabeceraRecuentos.Add(pr);
db.SaveChanges();
return(result.AddResult(pr));
}
catch (Exception e)
{
return(result.AddError(e, HttpStatusCode.InternalServerError));
}
}
public ResultAndError <InvoiceProviderDiscount> Add(InvoiceProviderDiscount c)
{
ResultAndError <InvoiceProviderDiscount> result = new ResultAndError <InvoiceProviderDiscount>();
try
{
db.InvoiceProviderDiscounts.Add(c);
db.SaveChanges();
return(result.AddResult(c));
}
catch (Exception e)
{
return(result.AddError(e, HttpStatusCode.InternalServerError));
}
}
public ResultAndError <AlbaranLinea> Add(AlbaranLinea c)
{
ResultAndError <AlbaranLinea> result = new ResultAndError <AlbaranLinea>();
try
{
db.AlbaranLineas.Add(c);
db.SaveChanges();
return(result.AddResult(c));
}
catch (Exception e)
{
return(result.AddError(e, HttpStatusCode.InternalServerError));
}
}
public ResultAndError <bool> UpdateReadingDate(IEnumerable <int> cashId, DateTimeOffset readingDate)
{
ResultAndError <bool> result = new ResultAndError <bool>();
try
{
foreach (int no in cashId)
{
CashMovementCenter oCash = Get(no.ToString());
oCash.ReadingDate = readingDate;
db.SaveChanges();
}
return(result.AddResult(true));
}
catch (Exception e)
{
return(result.AddError(e, HttpStatusCode.InternalServerError));
}
}
public ResultAndError <bool> UpdateReadingDate(IEnumerable <KeyValuePair <string, int> > pedventa, DateTimeOffset readingDate)
{
ResultAndError <bool> result = new ResultAndError <bool>();
try
{
foreach (KeyValuePair <string, int> no in pedventa)
{
PedVentaLinea oPedVentaLineas = Get(no.Key, no.Value);
oPedVentaLineas.ReadingDate = readingDate;
db.SaveChanges();
}
return(result.AddResult(true));
}
catch (Exception e)
{
return(result.AddError(e, HttpStatusCode.InternalServerError));
}
}
public ResultAndError <bool> UpdateReadingDate(IEnumerable <int> centersNo, DateTimeOffset readingDate)
{
ResultAndError <bool> result = new ResultAndError <bool>();
try
{
foreach (int no in centersNo)
{
Document oSalesCenter = Get(no);
oSalesCenter.ReadingDate = readingDate;
db.SaveChanges();
}
return(result.AddResult(true));
}
catch (Exception e)
{
return(result.AddError(e, HttpStatusCode.InternalServerError));
}
}
public ResultAndError <bool> UpdateReadingDate(IEnumerable <string> centersNo, DateTimeOffset readingDate)
{
ResultAndError <bool> result = new ResultAndError <bool>();
try
{
foreach (string no in centersNo)
{
PedVentaCab oPedVentaCabs = Get(no);
oPedVentaCabs.ReadingDate = readingDate;
db.SaveChanges();
}
return(result.AddResult(true));
}
catch (Exception e)
{
return(result.AddError(e, HttpStatusCode.InternalServerError));
}
}
public ResultAndError <ProviderRate> Add(ProviderRate pr)
{
ResultAndError <ProviderRate> result = new ResultAndError <ProviderRate>();
try
{
if (pr.Id == Guid.Empty)
{
pr.Id = new Guid();
}
db.ProviderRates.Add(pr);
db.SaveChanges();
return(result.AddResult(pr));
}
catch (Exception e)
{
return(result.AddError(e, HttpStatusCode.InternalServerError));
}
}
public ResultAndError <ProductCategory> Update(ProductCategory cr, bool insertIfNoExists = false)
{
ResultAndError <ProductCategory> result = new ResultAndError <ProductCategory>();
try
{
ProductCategory old = Get(cr.Code);
if (old == null && insertIfNoExists)
{
return(Add(cr));
}
db.Entry(old).CurrentValues.SetValues(cr);
db.SaveChanges();
return(result.AddResult(cr));
}
catch (Exception e)
{
return(result.AddError(e, HttpStatusCode.InternalServerError));
}
}
public ResultAndError <AlmacenZP> Update(AlmacenZP pr, bool insertIfNoExists = false)
{
ResultAndError <AlmacenZP> result = new ResultAndError <AlmacenZP>();
try
{
AlmacenZP old = Get(pr.ProductNo, pr.LocationCode);
if (old == null && insertIfNoExists)
{
return(Add(pr));
}
db.Entry(old).CurrentValues.SetValues(pr);
db.SaveChanges();
return(result.AddResult(pr));
}
catch (Exception e)
{
return(result.AddError(e, HttpStatusCode.InternalServerError));
}
}
public ResultAndError <bool> Delete(string id)
{
ResultAndError <bool> result = new ResultAndError <bool>();
try
{
ProductCategory ProductCategory = Get(id);
if (ProductCategory == null)
{
return(result.AddError("No se encontro la categoria con el id " + id));
}
db.ProductCategories.Remove(ProductCategory);
db.SaveChanges();
return(result.AddResult(true));
}
catch (Exception e)
{
return(result.AddError(e, HttpStatusCode.InternalServerError));
}
}
public ResultAndError <bool> Delete(string id)
{
ResultAndError <bool> result = new ResultAndError <bool>();
try
{
PedVentaCab PedVentaCabs = Get(id);
if (PedVentaCabs == null)
{
return(result.AddError("No se encontro la tarifa con el id " + id));
}
db.PedVentaCabs.Remove(PedVentaCabs);
db.SaveChanges();
return(result.AddResult(true));
}
catch (Exception e)
{
return(result.AddError(e, HttpStatusCode.InternalServerError));
}
}
public ResultAndError <bool> Delete(string productNo, string locationCode)
{
ResultAndError <bool> result = new ResultAndError <bool>();
try
{
AlmacenZP oAlmacenZP = Get(productNo, locationCode);
if (oAlmacenZP == null)
{
return(result.AddError("No se encontro almacen con el id " + productNo + " " + locationCode));
}
db.AlmacenZPs.Remove(oAlmacenZP);
db.SaveChanges();
return(result.AddResult(true));
}
catch (Exception e)
{
return(result.AddError(e, HttpStatusCode.InternalServerError));
}
}
public ResultAndError <bool> Delete(string productNo, string providerNo)
{
ResultAndError <bool> result = new ResultAndError <bool>();
try
{
ProviderRate oProviderRate = Get(productNo, providerNo);
if (oProviderRate == null)
{
return(result.AddError("No se encontro la tarifa con el id " + productNo + " " + providerNo));
}
db.ProviderRates.Remove(oProviderRate);
db.SaveChanges();
return(result.AddResult(true));
}
catch (Exception e)
{
return(result.AddError(e, HttpStatusCode.InternalServerError));
}
}
public ResultAndError <ProviderRate> Update(ProviderRate pr, bool insertIfNoExists = false)
{
ResultAndError <ProviderRate> result = new ResultAndError <ProviderRate>();
try
{
ProviderRate old = Get(pr.ProductNo, pr.VendorNo);
if (old == null && insertIfNoExists)
{
return(Add(pr));
}
db.Entry(old).CurrentValues.SetValues(pr);
db.SaveChanges();
return(result.AddResult(pr));
}
catch (Exception e)
{
return(result.AddError(e, HttpStatusCode.InternalServerError));
}
}
