public void Delete(string no) { VehicleStockTransfer vehicleStockTransfer = context.VehicleStockTransfers.FirstOrDefault(p => p.No == no); context.VehicleStockTransfers.Remove(vehicleStockTransfer); context.SaveChanges(); }
public void Approved(VehicleStockTransfer po) { VehicleStockTransfer dbEntry = context.VehicleStockTransfers.FirstOrDefault(p => p.No == po.No); if (dbEntry != null) { dbEntry.Approved = po.Approved; } context.SaveChanges(); }
public void Save(VehicleStockTransfer vst) { bool exists = context.VehicleStockTransfers.Count(p => p.No == vst.No) > 0; vst.No = GenerateVehicleStockTransferNo(vst.Date); int id; if (!exists) { context.VehicleStockTransfers.Add(vst); context.SaveChanges(); id = vst.Id; foreach (VehicleStockTransferItem vsItem in vst.VehicleStockTransferItems) { vsItem.VehicleStockTransferId = id; if (vsItem.Quantity != 0) { vsItem.TransactionLogId = InsertLogs(vsItem.ItemId, vsItem.Quantity); } } } else { VehicleStockTransfer dbEntry = context.VehicleStockTransfers.FirstOrDefault(p => p.No == vst.No); if (dbEntry != null) { dbEntry.No = vst.No; dbEntry.Date = vst.Date; dbEntry.RequestedBy = vst.RequestedBy; dbEntry.CheckedBy = Common.GetCurrentUser.Id; dbEntry.ApprovedBy = Common.GetCurrentUser.GeneralManagerId; } id = dbEntry.Id; //Delete previous items foreach (VehicleStockTransferItem vsItem in dbEntry.VehicleStockTransferItems.ToList()) { //Delete previous logs TransactionLogRepository transLogRepo = new TransactionLogRepository(); transLogRepo.Remove(vsItem.TransactionLogId.Value); vsItemRepo.Remove(vsItem.Id); } foreach (VehicleStockTransferItem vstIitem in dbEntry.VehicleStockTransferItems.ToList()) { context.VehicleStockTransferItems.Remove(vstIitem); } foreach (VehicleStockTransferItem vstIitem in vst.VehicleStockTransferItems.ToList()) { vstIitem.VehicleStockTransferId = id; context.VehicleStockTransferItems.Add(vstIitem); } } context.SaveChanges(); }
public VehicleStockTransfer GetByNo(string no) { VehicleStockTransfer vehicleStockTransfer = context.VehicleStockTransfers.FirstOrDefault(p => p.No == no); return(vehicleStockTransfer); }
public VehicleStockTransfer GetById(int id) { VehicleStockTransfer vehicleStockTransfer = context.VehicleStockTransfers.FirstOrDefault(p => p.Id == id); return(vehicleStockTransfer); }