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