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