public void Delete(string no)
{
StockTransfer stockTransfer = context.StockTransfers.FirstOrDefault(p => p.No == no);
context.StockTransfers.Remove(stockTransfer);
context.SaveChanges();
}
public void Save(StockTransfer st)
{
bool exists = context.StockTransfers.Any(p => p.No == st.No);
int id;
if (!exists)
{
context.StockTransfers.Add(st);
context.SaveChanges();
id = st.Id;
foreach (StockTransferItem stItem in st.StockTransferItems)
{
stItem.StockTransferId = id;
if (stItem.Quantity != 0)
{
stItem.TransactionLogId = null; //InsertLogs(stItem.ItemId, stItem.Quantity);
}
}
}
else
{
StockTransfer dbEntry = context.StockTransfers.FirstOrDefault(p => p.No == st.No);
if (dbEntry != null)
{
dbEntry.JobOrderDate = st.Date;
dbEntry.JobOrderNo = st.JobOrderNo;
dbEntry.UnitPlateNo = st.UnitPlateNo;
dbEntry.JobOrderDate = st.JobOrderDate;
dbEntry.OdometerReading = st.OdometerReading;
dbEntry.DriverName = st.DriverName;
dbEntry.ReportedBy = st.ReportedBy;
dbEntry.CheckedBy = st.CheckedBy;
dbEntry.ApprovedBy = st.ApprovedBy;
dbEntry.CompanyId = st.CompanyId;
}
context.SaveChanges();
id = dbEntry.Id;
//Delete previous items
foreach (StockTransferItem stItem in dbEntry.StockTransferItems.ToList())
{
//Delete previous logs
TransactionLogRepository transLogRepo = new TransactionLogRepository();
transLogRepo.Remove(stItem.TransactionLogId.Value);
stItemRepo.Remove(stItem.Id);
}
foreach (StockTransferItem stItem in st.StockTransferItems)
{
stItem.StockTransferId = id;
if (stItem.Quantity != 0)
{
stItem.TransactionLogId = null; //InsertLogs(stItem.ItemId, stItem.Quantity);
}
context.StockTransferItems.Add(stItem);
}
}
context.SaveChanges();
}
public StockTransfer GetByNo(string no)
{
StockTransfer stockTransfer = context.StockTransfers.FirstOrDefault(p => p.No == no);
return(stockTransfer);
}
public StockTransfer GetById(int id)
{
StockTransfer stockTransfer = context.StockTransfers.FirstOrDefault(p => p.Id == id);
return(stockTransfer);
}
