public List <AccumulatedWeight> GetAccumulatedWeights() { using (var db = new WeighrContext()) { return(db.AccumulatedWeights.ToList()); } }
public List <ScaleSetting> GetScaleSettings() { using (var db = new WeighrContext()) { return(db.ScaleSettings.ToList()); } }
public AccumulatedWeight GetAccumulatedWeight() { using (var db = new WeighrContext()) { return(db.AccumulatedWeights.Take(1).FirstOrDefault()); } }
public List <TransactionLog> GetTransactionLogs() { using (var db = new WeighrContext()) { return(db.TransactionLogs.ToList()); } }
public List <OrderDetail> GetOrderDetails() { using (var db = new WeighrContext()) { return(db.OrderDetails.ToList()); } }
public List <ShiftTarget> GetShiftTargets() { using (var db = new WeighrContext()) { return(db.ShiftTargets.ToList()); } }
public List <Product> GetProducts() { using (var db = new WeighrContext()) { return(db.Products.ToList()); } }
public DeviceInfo GetDeviceInfo() { using (var db = new WeighrContext()) { return(db.DeviceInfos.FirstOrDefault()); } }
public Batch SetCurrentBatch(string batchCode) { using (var db = new WeighrContext()) { var previousCurrent = db.Batches .Where(p => p.isCurrent == true).FirstOrDefault(); if (previousCurrent != null) { previousCurrent.EndTime = DateTime.Now.ToUniversalTime(); previousCurrent.isCurrent = false; db.Batches.Update(previousCurrent); } var current = db.Batches .Where(p => p.BatchCode == batchCode).FirstOrDefault(); current.isCurrent = true; db.Batches.Update(current); db.SaveChanges(); return(current); } }
public List <Batch> GetBatches() { using (var db = new WeighrContext()) { return(db.Batches.ToList()); } }
public void UpdateDeviceInfo(DeviceInfo DeviceInfo) { using (var db = new WeighrContext()) { db.DeviceInfos.Update(DeviceInfo); db.SaveChanges(); } }
public void AddDeviceInfo(DeviceInfo DeviceInfo) { using (var db = new WeighrContext()) { db.DeviceInfos.Add(DeviceInfo); db.SaveChanges(); } }
public OrderDetail GetOrderDetail(int orderDetailId) { using (var db = new WeighrContext()) { return(db.OrderDetails .Where(p => p.OrderDetailId == orderDetailId).FirstOrDefault()); } }
public void UpdateShiftTarget(ShiftTarget shiftTarget) { using (var db = new WeighrContext()) { db.ShiftTargets.Update(shiftTarget); db.SaveChanges(); } }
public void UpdateScaleSetting(ScaleSetting scaleSetting) { using (var db = new WeighrContext()) { db.ScaleSettings.Update(scaleSetting); db.SaveChanges(); } }
public void UpdateAccumulatedWeight(AccumulatedWeight accumulatedWeight) { using (var db = new WeighrContext()) { db.AccumulatedWeights.Update(accumulatedWeight); db.SaveChanges(); } }
public Batch GetCurrentBatch() { using (var db = new WeighrContext()) { return(db.Batches .Where(p => p.isCurrent == true).FirstOrDefault()); } }
public Batch GetBatch(int batchId) { using (var db = new WeighrContext()) { return(db.Batches .Where(p => p.BatchId == batchId).FirstOrDefault()); } }
public void UpdateBatch(Batch Batch) { using (var db = new WeighrContext()) { db.Batches.Update(Batch); db.SaveChanges(); } }
public void AddBatch(Batch Batch) { using (var db = new WeighrContext()) { db.Batches.Add(Batch); db.SaveChanges(); } }
public void AddScaleSetting(ScaleSetting scaleSetting) { using (var db = new WeighrContext()) { db.ScaleSettings.Add(scaleSetting); db.SaveChanges(); } }
public void AddProduct(Product product) { using (var db = new WeighrContext()) { db.Products.Add(product); db.SaveChanges(); } }
public Product GetProduct(string productCode) { using (var db = new WeighrContext()) { return(db.Products .Where(p => p.ProductCode == productCode).FirstOrDefault()); } }
public ShiftTarget GetShiftTarget(int shiftTargetId) { using (var db = new WeighrContext()) { return(db.ShiftTargets .Where(p => p.ShiftTargetId == shiftTargetId).FirstOrDefault()); } }
public void UpdateProduct(Product product) { using (var db = new WeighrContext()) { db.Products.Update(product); db.SaveChanges(); } }
public void AddOrder(Order order) { using (var db = new WeighrContext()) { db.Orders.Add(order); db.SaveChanges(); } }
public Product GetProductById(int id) { using (var db = new WeighrContext()) { return(db.Products .Where(p => p.ProductId == id).FirstOrDefault()); } }
public void UpdateOrder(Order order) { using (var db = new WeighrContext()) { db.Orders.Update(order); db.SaveChanges(); } }
public Product GetCurrentProduct() { using (var db = new WeighrContext()) { return(db.Products .Where(p => p.isCurrent == true).FirstOrDefault()); } }
public void UpdateOrderDetail(OrderDetail orderDetail) { using (var db = new WeighrContext()) { db.OrderDetails.Update(orderDetail); db.SaveChanges(); } }