private MakeDelivery MakeBrandDeliveryRecord(long storeId, Delivery delivery, string userId)
{
var soldOut = false;
var stockReduced = false;
double balance = 0;
var makeDelivery = new MakeDelivery();
var storeStock = _stockService.GetStockForAParticularStoreForDelivery(storeId, delivery.ProductId, delivery.BatchId);
if (storeStock != null)
{
if (storeStock.Balance == delivery.Quantity)
{
soldOut = true;
if (storeStock.Balance != 0 || storeStock.Balance != null)
{
balance = Convert.ToDouble(storeStock.Balance) - Convert.ToDouble(delivery.Quantity);
}
else
{
balance = storeStock.Quantity - Convert.ToDouble(delivery.Quantity);
}
UpdateStoreStockDetailsOnDelivery(storeId, delivery.ProductId, userId, soldOut, storeStock.StockId);
var storeStockObject = new StoreStock()
{
StoreId = storeStock.StoreId,
ProductId = storeStock.ProductId,
BranchId = storeStock.BranchId,
StockId = storeStock.StockId,
Quantity = storeStock.Quantity,
SectorId = storeStock.SectorId,
StockBalance = storeStock.StockBalance,
StartStock = storeStock.StartStock,
StoreStockId = storeStock.StoreStockId,
Balance = balance,
SoldAmount = delivery.Quantity,
CreatedOn = storeStock.CreatedOn,
SoldOut = soldOut,
};
_stockService.SaveStoreStock(storeStockObject, false);
stockReduced = true;
makeDelivery = new MakeDelivery()
{
StockId = storeStock.StockId,
StockReduced = stockReduced,
OrderQuantityBalance = balance,
};
return(makeDelivery);
}
else if (storeStock.Balance > delivery.Quantity)
{
if (storeStock.Balance != 0 || storeStock.Balance != null)
{
balance = Convert.ToDouble(storeStock.Balance) - Convert.ToDouble(delivery.Quantity);
}
else
{
balance = storeStock.Quantity - Convert.ToDouble(delivery.Quantity);
}
var storeStockObject = new StoreStock()
{
StoreId = storeStock.StoreId,
ProductId = storeStock.ProductId,
BranchId = storeStock.BranchId,
StockId = storeStock.StockId,
Quantity = storeStock.Quantity,
SectorId = storeStock.SectorId,
StoreStockId = storeStock.StoreStockId,
StockBalance = storeStock.StockBalance,
StartStock = storeStock.StartStock,
Balance = balance,
SoldAmount = delivery.Quantity,
CreatedOn = storeStock.CreatedOn,
SoldOut = storeStock.SoldOut,
};
_stockService.SaveStoreStock(storeStockObject, false);
stockReduced = true;
makeDelivery = new MakeDelivery()
{
StockId = storeStock.StockId,
StockReduced = stockReduced,
OrderQuantityBalance = 0,
};
return(makeDelivery);
}
else
{
double stockBalance = 0, deliverQuantity = 0, newOrderQuantity = 0;
if (storeStock.Balance != 0 || storeStock.Balance != null)
{
balance = Convert.ToDouble(storeStock.Balance) - Convert.ToDouble(delivery.Quantity);
}
else
{
balance = storeStock.Quantity - Convert.ToDouble(delivery.Quantity);
}
if (stockBalance < 0)
{
balance = 0;
deliverQuantity = storeStock.Quantity;
newOrderQuantity = Convert.ToDouble(delivery.Quantity) - storeStock.Quantity;
}
soldOut = true;
UpdateStoreStockDetailsOnDelivery(storeId, delivery.ProductId, userId, soldOut, storeStock.StockId);
var storeStockObject = new StoreStock()
{
StoreId = storeStock.StoreId,
ProductId = storeStock.ProductId,
BranchId = storeStock.BranchId,
StockId = storeStock.StockId,
Quantity = storeStock.Quantity,
SectorId = storeStock.SectorId,
StoreStockId = storeStock.StoreStockId,
StockBalance = storeStock.StockBalance,
StartStock = storeStock.StartStock,
Balance = balance,
SoldAmount = deliverQuantity,
CreatedOn = storeStock.CreatedOn,
SoldOut = soldOut,
};
_stockService.SaveStoreStock(storeStockObject, false);
stockReduced = true;
makeDelivery = new MakeDelivery()
{
StockId = storeStock.StockId,
StockReduced = stockReduced,
OrderQuantityBalance = stockBalance,
};
return(makeDelivery);
}
}
else
{
// we dont have stock in store
stockReduced = false;
}
return(makeDelivery);
}
public long SaveDelivery(Delivery delivery, string userId)
{
long deliveryId = 0;
MakeDelivery makeDelivery = new MakeDelivery();
if (delivery.OrderId != 0)
{
//var order = _orderService.GetOrder(delivery.OrderId);
if (delivery.ProductId == 2)
{
var deliveryDTO = new DTO.DeliveryDTO()
{
StoreId = delivery.StoreId,
CustomerId = delivery.CustomerId,
DeliveryCost = delivery.DeliveryCost,
OrderId = delivery.OrderId,
VehicleNumber = delivery.VehicleNumber,
BranchId = delivery.BranchId,
SectorId = delivery.SectorId,
PaymentModeId = delivery.PaymentModeId,
BatchId = delivery.BatchId,
Price = delivery.Price,
Quantity = delivery.Quantity,
ProductId = delivery.ProductId,
Amount = delivery.Amount,
Location = delivery.Location,
TransactionSubTypeId = delivery.TransactionSubTypeId,
MediaId = delivery.MediaId,
DeliveryId = delivery.DeliveryId,
DriverName = delivery.DriverName,
DriverNIN = delivery.DriverNIN,
Deleted = delivery.Deleted,
CreatedBy = delivery.CreatedBy,
CreatedOn = delivery.CreatedOn,
};
makeDelivery = MakeBrandDeliveryRecord(delivery.StoreId, delivery, userId);
if (makeDelivery.StockReduced && (makeDelivery.OrderQuantityBalance == 0 || makeDelivery.OrderQuantityBalance > 0))
{
deliveryId = this._dataService.SaveDelivery(deliveryDTO, userId);
//StringBuilder sb = new StringBuilder();
//string strNewPath = System.Web.HttpContext.Current.Server.MapPath(ConfigurationManager.AppSettings["MbaleReceipt"]);
//using (StreamReader sr = new StreamReader(strNewPath))
//{
// while (!sr.EndOfStream)
// {
// sb.Append(sr.ReadLine());
// }
//}
//string body = sb.ToString().Replace("#CUSTOMERNAME#", deliveryDTO.CustomerId);
//body = body.Replace("#AMOUNT#", deliveryDTO.Amount);
//try
//{
//}
//catch (Exception ex)
//{
// logger.Debug("receipt Not generated: " + ex.Message);
//}
var deliveryStockDTO = new DeliveryStockDTO()
{
StockId = makeDelivery.StockId,
DeliveryId = deliveryId,
};
_dataService.SaveDeliveryStock(deliveryStockDTO);
_orderService.UpdateOrderWithCompletedStatus(delivery.OrderId, orderStatusIdComplete, userId);
}
else if (makeDelivery.StockReduced && makeDelivery.OrderQuantityBalance < 0)
{
deliveryId = this._dataService.SaveDelivery(deliveryDTO, userId);
if (makeDelivery.OrderQuantityBalance != 0)
{
var deliveryStockDTO = new DeliveryStockDTO()
{
StockId = makeDelivery.StockId,
DeliveryId = deliveryId,
};
_dataService.SaveDeliveryStock(deliveryStockDTO);
_orderService.UpdateOrderWithInProgressStatus(delivery.OrderId, orderStatusIdInProgress, userId);
}
}
}
else
{
//if order.ProductId == 1
var deliveryDTO = new DTO.DeliveryDTO()
{
StoreId = delivery.StoreId,
CustomerId = delivery.CustomerId,
DeliveryCost = delivery.DeliveryCost,
OrderId = delivery.OrderId,
VehicleNumber = delivery.VehicleNumber,
BranchId = delivery.BranchId,
SectorId = delivery.SectorId,
PaymentModeId = delivery.PaymentModeId,
BatchId = delivery.BatchId,
Price = delivery.Price,
ProductId = delivery.ProductId,
Amount = delivery.Amount,
Quantity = delivery.Quantity,
Location = delivery.Location,
TransactionSubTypeId = delivery.TransactionSubTypeId,
MediaId = delivery.MediaId,
DeliveryId = delivery.DeliveryId,
DriverName = delivery.DriverName,
DriverNIN = delivery.DriverNIN,
Deleted = delivery.Deleted,
CreatedBy = delivery.CreatedBy,
CreatedOn = delivery.CreatedOn,
};
makeDelivery = MakeFlourDeliveryRecord(delivery.StoreId, delivery, userId);
if (makeDelivery.StockReduced && makeDelivery.OrderQuantityBalance == 0)
{
deliveryId = this._dataService.SaveDelivery(deliveryDTO, userId);
var deliveryStockDTO = new DeliveryStockDTO()
{
StockId = makeDelivery.StockId,
DeliveryId = deliveryId,
};
_dataService.SaveDeliveryStock(deliveryStockDTO);
_orderService.UpdateOrderWithCompletedStatus(delivery.OrderId, orderStatusIdComplete, userId);
List <DeliveryGradeSize> deliveryGradeSizeList = new List <DeliveryGradeSize>();
foreach (var grade in delivery.Grades)
{
long sizeId = 0;
double amount = 0, price = 0, quantity = 0;
foreach (var denomination in grade.Denominations)
{
sizeId = denomination.DenominationId;
price = denomination.Price;
quantity = denomination.Quantity;
amount = (denomination.Quantity * denomination.Price);
var deliveryGradeSize = new DeliveryGradeSize()
{
DeliveryId = deliveryId,
GradeId = grade.GradeId,
SizeId = sizeId,
Quantity = quantity,
Price = price,
Amount = amount,
TimeStamp = DateTime.Now,
};
deliveryGradeSizeList.Add(deliveryGradeSize);
}
}
this._dataService.PurgeDeliveryGradeSize(deliveryId);
this.SaveDeliveryGradeSizeList(deliveryGradeSizeList);
}
else
{
deliveryId = this._dataService.SaveDelivery(deliveryDTO, userId);
if (makeDelivery.OrderQuantityBalance != 0)
{
var deliveryStockDTO = new DeliveryStockDTO()
{
StockId = makeDelivery.StockId,
DeliveryId = deliveryId,
};
_dataService.SaveDeliveryStock(deliveryStockDTO);
_orderService.UpdateOrderWithInProgressStatus(delivery.OrderId, orderStatusIdInProgress, userId);
List <DeliveryGradeSize> deliveryGradeSizeList = new List <DeliveryGradeSize>();
foreach (var grade in delivery.Grades)
{
long sizeId = 0;
double amount = 0, price = 0, quantity = 0;
foreach (var denomination in grade.Denominations)
{
sizeId = denomination.DenominationId;
price = denomination.Price;
quantity = denomination.Quantity;
amount = (denomination.Quantity * denomination.Price);
var deliveryGradeSize = new DeliveryGradeSize()
{
DeliveryId = deliveryId,
GradeId = grade.GradeId,
SizeId = sizeId,
Quantity = quantity,
Price = price,
Amount = amount,
TimeStamp = DateTime.Now,
};
deliveryGradeSizeList.Add(deliveryGradeSize);
}
}
this._dataService.PurgeDeliveryGradeSize(deliveryId);
this.SaveDeliveryGradeSizeList(deliveryGradeSizeList);
}
}
long transactionSubTypeId = 0;
var notes = string.Empty;
if (delivery.ProductId == 1)
{
transactionSubTypeId = flourTransactionSubTypeId;
notes = "Maize Flour Sale";
}
else if (delivery.ProductId == 2)
{
transactionSubTypeId = branTransactionSubTypeId;
notes = "Bran Sale";
}
var paymentMode = _accountTransactionActivityService.GetPaymentMode(delivery.PaymentModeId);
var paymentModeName = paymentMode.Name;
if (paymentModeName == "Credit")
{
var accountActivity = new AccountTransactionActivity()
{
AspNetUserId = delivery.CustomerId,
Amount = delivery.Amount,
Notes = notes,
Action = "-",
BranchId = delivery.BranchId,
TransactionSubTypeId = transactionSubTypeId,
SectorId = delivery.SectorId,
Deleted = delivery.Deleted,
CreatedBy = userId,
PaymentMode = paymentModeName,
};
var accountActivityId = this._accountTransactionActivityService.SaveAccountTransactionActivity(accountActivity, userId);
}
if (delivery.Amount == 0)
{
return(deliveryId);
}
else
{
long transactionTypeId = 0;
var transactionSubtype = _transactionSubTypeService.GetTransactionSubType(delivery.TransactionSubTypeId);
if (transactionSubtype != null)
{
transactionTypeId = transactionSubtype.TransactionTypeId;
}
var transaction = new TransactionDTO()
{
BranchId = delivery.BranchId,
SectorId = delivery.SectorId,
Amount = delivery.DeliveryCost,
TransactionSubTypeId = delivery.TransactionSubTypeId,
TransactionTypeId = transactionTypeId,
CreatedOn = DateTime.Now,
TimeStamp = DateTime.Now,
CreatedBy = userId,
Deleted = false,
};
var transactionId = _transactionDataService.SaveTransaction(transaction, userId);
return(deliveryId);
}
}
}
return(deliveryId);
}
private MakeDelivery MakeFlourDeliveryRecord(long storeId, Delivery delivery, string userId)
{
var soldOut = false;
var stockReduced = false;
double balance = 0, totalBalance = 0;
List <long> orderGradeIds = new List <long>();
List <long> stockGradeIds = new List <long>();
List <StoreGradeSize> storeGradeSizes = new List <StoreGradeSize>();
List <OrderGradeSize> orderGradeSizes = new List <OrderGradeSize>();
var makeDelivery = new MakeDelivery();
var storeStock = _stockService.GetStockForAParticularStoreForDelivery(storeId, delivery.ProductId, delivery.BatchId);
var order = _orderService.GetOrder(delivery.OrderId);
if (storeStock != null)
{
if (delivery.Grades != null)
{
foreach (var grade in delivery.Grades)
{
orderGradeIds.Add(grade.GradeId);
}
foreach (var stockGrade in storeStock.Stock.Grades)
{
stockGradeIds.Add(stockGrade.GradeId);
}
foreach (var orderGradeId in orderGradeIds)
{
if (CheckIfStockHasOrderGrade(orderGradeId, stockGradeIds))
{
storeGradeSizes = _stockService.GetStoreGradeSizeForParticularGradeAtAStore(orderGradeId, storeStock.StoreId).ToList();
orderGradeSizes = GetOrderGradeSizes(order, orderGradeId);
if (orderGradeSizes.Any())
{
foreach (var orderGradeSize in orderGradeSizes)
{
if (storeGradeSizes.Any())
{
foreach (var storeGradeSize in storeGradeSizes)
{
if (orderGradeSize.SizeId == storeGradeSize.SizeId)
{
balance = storeGradeSize.Quantity - orderGradeSize.Quantity;
if (balance < 0)
{
//store doesn't have enough stock to cover this denomination
}
else
{
var storeGradeSizeDTO = new StoreGradeSizeDTO()
{
GradeId = storeGradeSize.GradeId,
StoreId = storeGradeSize.StoreId,
SizeId = storeGradeSize.SizeId,
Quantity = orderGradeSize.Quantity,
};
_stockDataService.SaveStoreGradeSize(storeGradeSizeDTO, false);
}
}
}
}
else
{
//store doesn't have that Grade
}
}
}
stockReduced = true;
makeDelivery = new MakeDelivery()
{
StockId = storeStock.StockId,
StockReduced = stockReduced,
OrderQuantityBalance = totalBalance,
};
}
}
return(makeDelivery);
}
else
{
return(makeDelivery);
}
}
else
{
return(makeDelivery);
}
return(makeDelivery);
}
