public int InsertLogs(int itemId, int quantiy)
{
TransactionLogRepository transactionLogRepo = new TransactionLogRepository();
TransactionLog transactionLog = new TransactionLog
{
ItemId = itemId,
Quantity = -quantiy,
TransactionMethodId = (int)ETransactionMethod.StockTransfer_Unit,
CompanyId = Sessions.CompanyId.Value
};
return(transactionLogRepo.Add(transactionLog));
}
public int InsertLogs(int itemId, int quantiy, DateTime req_Date)
{
TransactionLogRepository transactionLogRepo = new TransactionLogRepository();
TransactionLog transactionLog = new TransactionLog
{
ItemId = itemId,
Quantity = -quantiy,
Date = req_Date,
TransactionMethodId = (int)ETransactionMethod.Requisition,
CompanyId = Sessions.CompanyId.Value,
ItemTypeId = itemRepo.GetItemType(itemId)
};
return(transactionLogRepo.Add(transactionLog));
}
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 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 void Save(Requisition req)
{
bool reqExists = context.Requisitions.Any(p => p.No == req.No);
req.No = GenerateReqNo(req.Date);
int id;
if (!reqExists)
{
context.Requisitions.Add(req);
context.SaveChanges();
id = req.Id;
foreach (RequisitionItem reqItem in req.RequisitionItems)
{
reqItem.RequisitionId = id;
if (reqItem.Quantity != 0)
{
reqItem.TransactionLogId = InsertLogs(reqItem.ItemId, reqItem.Quantity, req.Date);
InsertStockCard(id, reqItem.ItemId, reqItem.GetItemUnitCost, reqItem.Quantity, reqItem.TransactionLogId);
}
}
}
else
{
Requisition dbEntry = context.Requisitions.FirstOrDefault(p => p.No == req.No);
if (dbEntry != null)
{
dbEntry.JobOrderDate = req.Date;
dbEntry.JobOrderNo = req.JobOrderNo;
dbEntry.UnitPlateNo = req.UnitPlateNo;
dbEntry.JobOrderDate = req.JobOrderDate;
dbEntry.OdometerReading = req.OdometerReading;
dbEntry.DriverName = req.DriverName;
dbEntry.ReportedBy = req.ReportedBy;
dbEntry.CheckedBy = req.CheckedBy;
dbEntry.ApprovedBy = req.ApprovedBy;
dbEntry.CompanyId = req.CompanyId;
}
context.SaveChanges();
id = dbEntry.Id;
//Delete previous items
foreach (RequisitionItem reqItem in dbEntry.RequisitionItems.ToList())
{
//Delete previous logs
TransactionLogRepository transLogRepo = new TransactionLogRepository();
transLogRepo.Remove(reqItem.TransactionLogId.Value);
reqItemRepo.Remove(reqItem.Id);
}
foreach (RequisitionItem reqItem in req.RequisitionItems)
{
reqItem.RequisitionId = id;
if (reqItem.Quantity != 0)
{
reqItem.TransactionLogId = InsertLogs(reqItem.ItemId, reqItem.Quantity, req.Date);
}
context.RequisitionItems.Add(reqItem);
}
}
int vehicleId = vehicleRepo.GetIdByPlateNo(req.UnitPlateNo);
int?translogId = req.RequisitionItems.Last().TransactionLogId;
SaveVehicle(vehicleId, translogId);
context.SaveChanges();
}
