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