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