public bool DeleteAdjustment(Adjustment adjustment) { if (adjustment == null) return false; _unitOfWork.AdjustmentRepository.Delete(adjustment); _unitOfWork.Save(); return true; }
public void SaveAdjustment(StockAdjustmentViewModel viewModel, UserProfile user,int stockType) { Commodity commodity = _unitOfWork.CommodityRepository.FindById((int)viewModel.CommodityID); int ledgerPlus, LedgerMinus; if (stockType == 0) { LedgerMinus = Cats.Models.Ledger.Constants.GOODS_ON_HAND; ledgerPlus = Cats.Models.Ledger.Constants.LOSS_IN_TRANSIT; } else { LedgerMinus = Cats.Models.Ledger.Constants.COMMITED_TO_FDP; ledgerPlus = Cats.Models.Ledger.Constants.PLEDGED_TO_FDP; } Adjustment lossAndAdjustment = new Adjustment(); TransactionGroup transactionGroup = new TransactionGroup(); Transaction transactionOne = new Transaction(); var transactionGroupId = Guid.NewGuid(); transactionOne.TransactionID = Guid.NewGuid(); transactionOne.TransactionGroupID = transactionGroupId; transactionOne.LedgerID = LedgerMinus;// 2; transactionOne.HubOwnerID = user.DefaultHubObj.HubOwner.HubOwnerID; //transactionOne.AccountID = _accountService.GetAccountIdWithCreate(Account.Constants.HUB, user.DefaultHub.Value); // transactionOne.HubID = user.DefaultHub.Value; transactionOne.StoreID = viewModel.StoreID; // transactionOne.ProjectCodeID = viewModel.ProjectCodeID; transactionOne.ShippingInstructionID = viewModel.ShippingInstructionID; transactionOne.ParentCommodityID = (commodity.ParentID == null) ? commodity.CommodityID : commodity.ParentID.Value; transactionOne.CommodityID = viewModel.CommodityID; transactionOne.ProgramID = viewModel.ProgramID; transactionOne.CommodityGradeID = null; // How did I get this value ? transactionOne.QuantityInMT = 0-viewModel.QuantityInMT; transactionOne.QuantityInUnit =0- viewModel.QuantityInUnit; transactionOne.UnitID =1; transactionOne.TransactionDate = DateTime.Now; Transaction transactionTwo = new Transaction(); transactionTwo.TransactionID = Guid.NewGuid(); transactionTwo.TransactionGroupID = transactionGroupId; transactionTwo.LedgerID = ledgerPlus;// 14; transactionTwo.HubOwnerID = user.DefaultHubObj.HubOwnerID; //transactionTwo.AccountID = _accountService.GetAccountIdWithCreate(Account.Constants.HUB, user.DefaultHub.Value); // transactionTwo.HubID = user.DefaultHub.Value; transactionTwo.StoreID = viewModel.StoreID; // transactionTwo.ProjectCodeID = viewModel.ProjectCodeID; transactionTwo.ShippingInstructionID = viewModel.ShippingInstructionID; transactionTwo.ParentCommodityID = (commodity.ParentID == null) ? commodity.CommodityID : commodity.ParentID.Value; transactionTwo.CommodityID = viewModel.CommodityID; transactionTwo.ProgramID = viewModel.ProgramID; transactionTwo.CommodityGradeID = null; // How did I get this value ? transactionTwo.QuantityInMT = viewModel.QuantityInMT; transactionTwo.QuantityInUnit = viewModel.QuantityInUnit; transactionTwo.UnitID =1; transactionTwo.TransactionDate = DateTime.Now; transactionGroup.TransactionGroupID = transactionGroupId; transactionGroup.Transactions.Add(transactionOne); transactionGroup.Transactions.Add(transactionTwo); lossAndAdjustment.PartitionId = 0; lossAndAdjustment.AdjustmentID = Guid.NewGuid(); lossAndAdjustment.TransactionGroupID = transactionGroupId; lossAndAdjustment.TransactionGroup = transactionGroup; lossAndAdjustment.HubID = user.DefaultHub.Value; lossAndAdjustment.AdjustmentReasonID = 7; lossAndAdjustment.AdjustmentDirection = "S"; lossAndAdjustment.AdjustmentDate = DateTime.Now.Date; lossAndAdjustment.ApprovedBy = ""; lossAndAdjustment.Remarks = "Stock take adjustement"; lossAndAdjustment.UserProfileID = user.UserProfileID; lossAndAdjustment.ReferenceNumber = ""; lossAndAdjustment.StoreManName = ""; // Try to save this transaction try { _unitOfWork.AdjustmentRepository.Add(lossAndAdjustment); _unitOfWork.Save(); } catch (Exception exp) { // dbTransaction.Rollback(); //TODO: Save the detail of this exception somewhere throw new Exception("The Internal Movement Transaction Cannot be saved. <br />Detail Message :" + exp.Message); } }
public bool EditAdjustment(Adjustment adjustment) { _unitOfWork.AdjustmentRepository.Edit(adjustment); _unitOfWork.Save(); return true; }
/// <summary> /// </summary> /// <param name="viewModel"></param> /// <param name="user"></param> /// <exception cref="System.Exception"></exception> public void SaveLossTrasnsaction(LossesAndAdjustmentsViewModel viewModel, UserProfile user) { Commodity commodity = _unitOfWork.CommodityRepository.FindById(viewModel.CommodityId); Adjustment lossAndAdjustment = new Adjustment(); TransactionGroup transactionGroup = new TransactionGroup(); Transaction transactionOne = new Transaction(); var transactionGroupId = Guid.NewGuid(); transactionOne.TransactionID = Guid.NewGuid(); transactionOne.TransactionGroupID = transactionGroupId; transactionOne.LedgerID = Cats.Models.Ledger.Constants.GOODS_ON_HAND;// 2; transactionOne.HubOwnerID = user.DefaultHubObj.HubOwner.HubOwnerID; transactionOne.AccountID = _accountService.GetAccountIdWithCreate(Account.Constants.HUB, user.DefaultHub.Value); // transactionOne.HubID = user.DefaultHub.Value; transactionOne.StoreID = viewModel.StoreId; // transactionOne.ProjectCodeID = viewModel.ProjectCodeId; transactionOne.ShippingInstructionID = viewModel.ShippingInstructionId; transactionOne.ParentCommodityID = (commodity.ParentID == null) ? commodity.CommodityID : commodity.ParentID.Value; transactionOne.CommodityID = viewModel.CommodityId; transactionOne.ProgramID = viewModel.ProgramId; transactionOne.CommodityGradeID = null; // How did I get this value ? transactionOne.QuantityInMT = 0 - viewModel.QuantityInMt; transactionOne.QuantityInUnit = 0 - viewModel.QuantityInUint; transactionOne.UnitID = viewModel.UnitId; transactionOne.TransactionDate = DateTime.Now; Transaction transactionTwo = new Transaction(); transactionTwo.TransactionID = Guid.NewGuid(); transactionTwo.TransactionGroupID = transactionGroupId; transactionTwo.LedgerID = Cats.Models.Ledger.Constants.LOSS_IN_TRANSIT;// 14; transactionTwo.HubOwnerID = user.DefaultHubObj.HubOwnerID; transactionTwo.AccountID = _accountService.GetAccountIdWithCreate(Account.Constants.HUB, user.DefaultHub.Value); // transactionTwo.HubID = user.DefaultHub.Value; transactionTwo.StoreID = viewModel.StoreId; // transactionTwo.ProjectCodeID = viewModel.ProjectCodeId; transactionTwo.ShippingInstructionID = viewModel.ShippingInstructionId; transactionTwo.ParentCommodityID = (commodity.ParentID == null) ? commodity.CommodityID : commodity.ParentID.Value; transactionTwo.CommodityID = viewModel.CommodityId; transactionTwo.ProgramID = viewModel.ProgramId; transactionTwo.CommodityGradeID = null; // How did I get this value ? transactionTwo.QuantityInMT = viewModel.QuantityInMt; transactionTwo.QuantityInUnit = viewModel.QuantityInUint; transactionTwo.UnitID = viewModel.UnitId; transactionTwo.TransactionDate = DateTime.Now; transactionGroup.TransactionGroupID = transactionGroupId; transactionGroup.Transactions.Add(transactionOne); transactionGroup.Transactions.Add(transactionTwo); lossAndAdjustment.PartitionId = 0; lossAndAdjustment.AdjustmentID = Guid.NewGuid(); lossAndAdjustment.TransactionGroupID = transactionGroupId; lossAndAdjustment.TransactionGroup = transactionGroup; lossAndAdjustment.HubID = user.DefaultHub.Value; lossAndAdjustment.AdjustmentReasonID = viewModel.ReasonId; lossAndAdjustment.AdjustmentDirection = "L"; lossAndAdjustment.AdjustmentDate = viewModel.SelectedDate; lossAndAdjustment.ApprovedBy = viewModel.ApprovedBy; lossAndAdjustment.Remarks = viewModel.Description; lossAndAdjustment.UserProfileID = user.UserProfileID; lossAndAdjustment.ReferenceNumber = viewModel.MemoNumber; lossAndAdjustment.StoreManName = viewModel.StoreMan; // Try to save this transaction try { _unitOfWork.AdjustmentRepository.Add(lossAndAdjustment); _unitOfWork.Save(); } catch (Exception exp) { // dbTransaction.Rollback(); //TODO: Save the detail of this exception somewhere throw new Exception("The Internal Movement Transaction Cannot be saved. <br />Detail Message :" + exp.Message); } }