public int SaveAdjustItemRequest(InvLeatherStockAdjustModel model, int userID)
{
var leatherTypeID = DalCommon.GetLeatherTypeCode("Raw Hide");
var leatherStatusID = DalCommon.GetLeatherStatusCode("Raw Hide");
using (TransactionScope transaction = new TransactionScope())
{
#region Insert
Inv_LeatherStockAdjustRequest objAdjustmentRequest = new Inv_LeatherStockAdjustRequest();
objAdjustmentRequest.PurchaseYear = model.PurchaseYear;
objAdjustmentRequest.RequestDate = DalCommon.SetDate(model.RequestDate);
objAdjustmentRequest.LeatherType = model.LeatherType;
objAdjustmentRequest.StoreID = model.StoreID;
objAdjustmentRequest.RecordStatus = "NCF";
objAdjustmentRequest.SetBy = userID;
objAdjustmentRequest.SetOn = DateTime.Now;
_context.Inv_LeatherStockAdjustRequest.Add(objAdjustmentRequest);
_context.SaveChanges();
var currentRequestID = objAdjustmentRequest.RequestID;
foreach (var item in model.StockAdjustItemList)
{
Inv_LeatherStockAdjustItem objAdjustmentItems = new Inv_LeatherStockAdjustItem();
objAdjustmentItems.RequestID = currentRequestID;
objAdjustmentItems.SupplierID = item.SupplierID;
objAdjustmentItems.PurchaseID = item.ChallanID;
objAdjustmentItems.ItemTypeID = item.ItemTypeID;
objAdjustmentItems.LeatherType = model.LeatherType;
objAdjustmentItems.LeatherStatus = leatherStatusID;
objAdjustmentItems.ItemQty = item.ItemQty;
objAdjustmentItems.Unit = item.Unit;
objAdjustmentItems.Remarks = item.Remarks;
objAdjustmentItems.AdjustmentCause = item.AdjustmentCause;
_context.Inv_LeatherStockAdjustItem.Add(objAdjustmentItems);
_context.SaveChanges();
}
transaction.Complete();
return(currentRequestID);
#endregion
}
}
public int UpdateAdjustItemRequest(InvLeatherStockAdjustModel model, int userID)
{
var leatherTypeID = DalCommon.GetLeatherTypeCode("Raw Hide");
var leatherStatusID = DalCommon.GetLeatherStatusCode("Raw Hide");
//var requestdate = (model.RequestDate).ToString("dd'/'MM'/'yyyy");
using (TransactionScope transaction = new TransactionScope())
{
var currentRequestID = Convert.ToInt32(model.RequestID);
var currentRequest = (from r in _context.Inv_LeatherStockAdjustRequest.AsEnumerable()
where r.RequestID == Convert.ToInt32(model.RequestID)
select r).FirstOrDefault();
currentRequest.RequestDate = DalCommon.SetDate(model.RequestDate);
currentRequest.PurchaseYear = model.PurchaseYear;
currentRequest.LeatherType = model.LeatherType;
currentRequest.StoreID = model.StoreID;
currentRequest.SetBy = userID;
currentRequest.SetOn = DateTime.Now;
_context.SaveChanges();
if (model.StockAdjustItemList != null)
{
foreach (var item in model.StockAdjustItemList)
{
if (item.AdjustID == 0)
{
Inv_LeatherStockAdjustItem objAdjustmentItems = new Inv_LeatherStockAdjustItem();
objAdjustmentItems.RequestID = Convert.ToInt32(model.RequestID);
objAdjustmentItems.SupplierID = item.SupplierID;
objAdjustmentItems.PurchaseID = item.ChallanID;
objAdjustmentItems.ItemTypeID = item.ItemTypeID;
objAdjustmentItems.LeatherType = model.LeatherType;
objAdjustmentItems.LeatherStatus = leatherStatusID;
objAdjustmentItems.ItemQty = item.ItemQty;
objAdjustmentItems.Unit = item.Unit;
objAdjustmentItems.Remarks = item.Remarks;
objAdjustmentItems.AdjustmentCause = item.AdjustmentCause;
_context.Inv_LeatherStockAdjustItem.Add(objAdjustmentItems);
_context.SaveChanges();
}
else
{
var CurrentItem = (from i in _context.Inv_LeatherStockAdjustItem.AsEnumerable()
where i.AdjustID == item.AdjustID
select i).FirstOrDefault();
CurrentItem.SupplierID = item.SupplierID;
CurrentItem.PurchaseID = item.ChallanID;
CurrentItem.ItemTypeID = item.ItemTypeID;
CurrentItem.LeatherType = model.LeatherType;
CurrentItem.LeatherStatus = leatherStatusID;
CurrentItem.ItemQty = item.ItemQty;
CurrentItem.Unit = item.Unit;
CurrentItem.Remarks = item.Remarks;
CurrentItem.AdjustmentCause = item.AdjustmentCause;
_context.SaveChanges();
}
}
}
transaction.Complete();
return(currentRequestID);
}
}
