public BLL.Receive GenerateReceive()
{
BLL.Receive receive = new BLL.Receive()
{
CreatedDate = DateTime.Now,
ReceiptDate = this.ReceiptDate,
DriverName = this.DriverName,
GRN = this.GRN,
PlateNo_Prime = this.PlateNo_Prime,
PlateNo_Trailer = this.PlateNo_Trailer,
TransporterID = this.TransporterID,
HubID = this.HubID,
CommodityTypeID = this.CommodityTypeID,
WayBillNo = this.WayBillNo,
ResponsibleDonorID = this.ResponsibleDonorID,
SourceDonorID = this.SourceDonorID,
CommoditySourceID = this.CommoditySourceID,
WeightBridgeTicketNumber = this.TicketNumber,
WeightBeforeUnloading = this.WeightBeforeUnloading,
WeightAfterUnloading = this.WeightAfterUnloading,
ReceivedByStoreMan = this.ReceivedByStoreMan,
VesselName = this.VesselName,
PortName = this.PortName,
PurchaseOrder = this.PurchaseOrder,
SupplierName = this.SupplierName,
ReceiptAllocationID = this.ReceiptAllocationID,
Remark = this.Remark,
};
if (this.ReceiveID.HasValue)
{
receive.ReceiveID = this.ReceiveID.Value;
}
return receive;
}
/// <summary>
/// Saves the receipt transaction.
/// </summary>
/// <param name="receiveModels">The receive models.</param>
/// <param name="user">The user.</param>
public void SaveReceiptTransaction(ReceiveViewModel receiveModels, UserProfile user)
{
// Populate more details of the reciept object
// Save it when you are done.
Receive receive = receiveModels.GenerateReceive();
receive.CreatedDate = DateTime.Now;
receive.HubID = user.DefaultHub.HubID;
receive.UserProfileID = user.UserProfileID;
var commType = _unitOfWork.CommodityTypeRepository.FindById(receiveModels.CommodityTypeID);
// var comms = GenerateReceiveDetail(commodities);
foreach (ReceiveDetailViewModel c in receiveModels.ReceiveDetails)
{
if (commType.CommodityTypeID == 2)//if it's a non food
{
c.ReceivedQuantityInMT = 0;
c.SentQuantityInMT = 0;
}
TransactionGroup tgroup = new TransactionGroup();
var receiveDetail = new ReceiveDetail()
{
CommodityID = c.CommodityID,
Description = c.Description,
SentQuantityInMT = c.SentQuantityInMT.Value,
SentQuantityInUnit = c.SentQuantityInUnit.Value,
UnitID = c.UnitID,
ReceiveID = receive.ReceiveID
};
if (c.ReceiveDetailID.HasValue)
{
receiveDetail.ReceiveDetailID = c.ReceiveDetailID.Value;
}
// receiveDetail.TransactionGroupID = tgroup.TransactionGroupID;
receiveDetail.TransactionGroup = tgroup;
receive.ReceiveDetails.Add(receiveDetail);
Transaction transaction = new Transaction();
transaction.TransactionDate = DateTime.Now;
transaction.ParentCommodityID = _unitOfWork.CommodityRepository.FindById(c.CommodityID).ParentID ?? c.CommodityID;
transaction.CommodityID = c.CommodityID;
transaction.LedgerID = Ledger.Constants.GOODS_ON_HAND_UNCOMMITED;
transaction.HubOwnerID = user.DefaultHub.HubOwnerID;
transaction.AccountID = _accountService.GetAccountIdWithCreate(Account.Constants.HUB, receive.HubID);
transaction.ShippingInstructionID = _shippingInstructionService.GetSINumberIdWithCreate(receiveModels.SINumber).ShippingInstructionID;
//TODO:After Implementing ProjectCodeService Please Return Here
//transaction.ProjectCodeID = repository.ProjectCode.GetProjectCodeIdWIthCreate(receiveModels.ProjectNumber).ProjectCodeID;
transaction.HubID = user.DefaultHub.HubID;
transaction.UnitID = c.UnitID;
if (c.ReceivedQuantityInMT != null) transaction.QuantityInMT = c.ReceivedQuantityInMT.Value;
if (c.ReceivedQuantityInUnit != null) transaction.QuantityInUnit = c.ReceivedQuantityInUnit.Value;
if (c.CommodityGradeID != null) transaction.CommodityGradeID = c.CommodityGradeID.Value;
transaction.ProgramID = receiveModels.ProgramID;
transaction.StoreID = receiveModels.StoreID;
transaction.Stack = receiveModels.StackNumber;
transaction.TransactionGroupID = tgroup.TransactionGroupID;
tgroup.Transactions.Add(transaction);
// do the second half of the transaction here.
var transaction2 = new Transaction();
transaction2.TransactionDate = DateTime.Now;
//TAKEs the PARENT FROM THE FIRST TRANSACTION
transaction2.ParentCommodityID = transaction.ParentCommodityID;
transaction2.CommodityID = c.CommodityID;
transaction2.HubOwnerID = user.DefaultHub.HubOwnerID;
//Decide from where the -ve side of the transaction comes from
//it is either from the allocated stock
// or it is from goods under care.
// this means that this receipt is done without having gone through the gift certificate process.
if (receiveModels.CommoditySourceID == BLL.CommoditySource.Constants.DONATION || receiveModels.CommoditySourceID == BLL.CommoditySource.Constants.LOCALPURCHASE)
{
transaction2.LedgerID = Ledger.Constants.GOODS_UNDER_CARE;
transaction2.AccountID = _accountService.GetAccountIdWithCreate(Account.Constants.DONOR, receive.ResponsibleDonorID.Value);
}
else if (receiveModels.CommoditySourceID == BLL.CommoditySource.Constants.REPAYMENT)
{
transaction2.LedgerID = Ledger.Constants.GOODS_RECIEVABLE;
transaction2.AccountID = _accountService.GetAccountIdWithCreate(Account.Constants.HUB, receiveModels.SourceHubID.Value);
}
else
{
transaction2.LedgerID = Ledger.Constants.LIABILITIES;
transaction2.AccountID = _accountService.GetAccountIdWithCreate(Account.Constants.HUB, receiveModels.SourceHubID.Value);
}
transaction2.ShippingInstructionID = _shippingInstructionService.GetSINumberIdWithCreate(receiveModels.SINumber).ShippingInstructionID;
//TODO:After Implementing ProjectCodeService Please return here
//transaction2.ProjectCodeID = repository.ProjectCode.GetProjectCodeIdWIthCreate(receiveModels.ProjectNumber).ProjectCodeID;
transaction2.HubID = user.DefaultHub.HubID;
transaction2.UnitID = c.UnitID;
// this is the credit part, so make it Negative
if (c.ReceivedQuantityInMT != null) transaction2.QuantityInMT = -c.ReceivedQuantityInMT.Value;
if (c.ReceivedQuantityInUnit != null) transaction2.QuantityInUnit = -c.ReceivedQuantityInUnit.Value;
if (c.CommodityGradeID != null) transaction2.CommodityGradeID = c.CommodityGradeID.Value;
transaction2.ProgramID = receiveModels.ProgramID;
transaction2.StoreID = receiveModels.StoreID;
transaction2.Stack = receiveModels.StackNumber;
transaction2.TransactionGroupID = tgroup.TransactionGroupID;
// hack to get past same key object in context error
//repository.Transaction = new TransactionRepository();
tgroup.Transactions.Add(transaction2);
}
// Try to save this transaction
// db.Database.Connection.Open();
// DbTransaction dbTransaction = db.Database.Connection.BeginTransaction();
try
{
//repository.Receive.Add(receive);
_unitOfWork.ReceiveRepository.Add(receive);
_unitOfWork.Save();
}
catch (Exception exp)
{
// dbTransaction.Rollback();
//TODO: Save the exception somewhere
throw new Exception("The Receipt Transaction Cannot be saved. <br />Detail Message :" + exp.StackTrace);
}
}
