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