public InvLeatherIssueItem SetToBussinessObject(Inv_LeatherIssueItem Entity)
{
InvLeatherIssueItem Model = new InvLeatherIssueItem();
Model.ItemIssueID = Entity.ItemIssueID;
Model.SupplierID = Entity.SupplierID;
Model.SupplierName = _context.Sys_Supplier.Where(m => m.SupplierID == Entity.SupplierID).FirstOrDefault().SupplierName;
Model.ChallanID = Entity.ChallanID;
Model.ChallanNo = Entity.ChallanID == null ? "" : _context.Prq_PurchaseChallan.Where(m => m.ChallanID == Entity.ChallanID).FirstOrDefault().ChallanNo;
Model.PurchaseID = Entity.PurchaseID;
Model.PurchaseNo = _context.Prq_Purchase.Where(m => m.PurchaseID == Entity.PurchaseID).FirstOrDefault().PurchaseNo;
Model.ItemType = Entity.ItemType;
Model.ItemTypeName = _context.Sys_ItemType.Where(m => m.ItemTypeID == Entity.ItemType).FirstOrDefault().ItemTypeName;
Model.LeatherType = Entity.LeatherType;
Model.LeatherTypeName = _context.Sys_LeatherType.Where(m => m.LeatherTypeID == Entity.LeatherType).FirstOrDefault().LeatherTypeName;
Model.LeatherStatus = Entity.LeatherStatus;
Model.LeatherStatusName = _context.Sys_LeatherStatus.Where(m => m.LeatherStatusID == Entity.LeatherStatus).FirstOrDefault().LeatherStatusName;
Model.IssueQty = Entity.IssueQty;
Model.IssueSide = Entity.IssueSide;
Model.ReceiveQty = Entity.IssueQty;
Model.ReceiveSide = Entity.IssueSide;
Model.UnitID = Entity.UnitID;
Model.UnitName = _context.Sys_Unit.Where(m => m.UnitID == Entity.UnitID).FirstOrDefault().UnitName;
Model.Remarks = Entity.Remarks;
return(Model);
}
public InvLeatherIssueItem SetToBussinessObject(Inv_LeatherIssueItem Entity, byte storeid)
{
InvLeatherIssueItem Model = new InvLeatherIssueItem();
Model.ItemIssueID = Entity.ItemIssueID;
Model.SupplierID = Entity.SupplierID;
Model.SupplierName = Entity.SupplierID == null ? "" : _context.Sys_Supplier.Where(m => m.SupplierID == Entity.SupplierID).SingleOrDefault().SupplierName;
Model.ChallanID = Entity.ChallanID;
Model.ChallanNo = Entity.ChallanID == null ? "" : _context.Prq_PurchaseChallan.Where(m => m.ChallanID == Entity.ChallanID).FirstOrDefault().ChallanNo;
Model.PurchaseID = Entity.PurchaseID;
Model.PurchaseNo = Entity.PurchaseID == null ? "" : _context.Prq_Purchase.Where(m => m.PurchaseID == Entity.PurchaseID).FirstOrDefault().PurchaseNo;
Model.ItemType = Entity.ItemType;
Model.ItemTypeName = Entity.ItemType == null ? "" : _context.Sys_ItemType.Where(m => m.ItemTypeID == Entity.ItemType).FirstOrDefault().ItemTypeName;
Model.LeatherType = Entity.LeatherType;
Model.LeatherTypeName = Entity.LeatherType == null ? "" : _context.Sys_LeatherType.Where(m => m.LeatherTypeID == Entity.LeatherType).FirstOrDefault().LeatherTypeName;
Model.LeatherStatus = Entity.LeatherStatus;
Model.LeatherStatusName = Entity.LeatherStatus == null ? "" : _context.Sys_LeatherStatus.Where(m => m.LeatherStatusID == Entity.LeatherStatus).FirstOrDefault().LeatherStatusName;
Model.IssueQty = Entity.IssueQty;
if (_context.Inv_StockSupplier.Where(m => m.SupplierID == Entity.SupplierID && m.StoreID == storeid && m.ItemTypeID == Entity.ItemType && m.LeatherType == Entity.LeatherType && m.LeatherStatusID == Entity.LeatherStatus && m.PurchaseID == Entity.PurchaseID).OrderByDescending(m => m.TransectionID).FirstOrDefault() != null)
{
Model.StockQty = _context.Inv_StockSupplier.Where(m => m.SupplierID == Entity.SupplierID && m.StoreID == storeid && m.ItemTypeID == Entity.ItemType && m.LeatherType == Entity.LeatherType && m.LeatherStatusID == Entity.LeatherStatus && m.PurchaseID == Entity.PurchaseID).OrderByDescending(m => m.TransectionID).FirstOrDefault().ClosingQty;
}
Model.UnitID = Entity.UnitID;
Model.UnitName = _context.Sys_Unit.Where(m => m.UnitID == Entity.UnitID).FirstOrDefault().UnitName;
Model.IssueSide = Entity.IssueSide;
Model.Remarks = Entity.Remarks;
return(Model);
}
public Inv_StockItem SetToModelObjectStockItemReceive(InvLeatherIssueItem model)
{
Inv_StockItem Entity = new Inv_StockItem();
Entity.StoreID = Convert.ToByte(model.StoreIdIssueTo);
Entity.ItemTypeID = model.ItemType;
Entity.LeatherType = model.LeatherType;
Entity.LeatherStatus = model.LeatherStatus;
Entity.UnitID = model.UnitID;
Entity.OpeningQty = 0;
Entity.ReceiveQty = model.IssueQty;
Entity.IssueQty = 0;
Entity.ClosingQty = model.IssueQty;
return(Entity);
}
public Inv_StockDaily SetToModelObjectDailyStockReceive(InvLeatherIssueItem model)
{
Inv_StockDaily Entity = new Inv_StockDaily();
Entity.StockDate = System.DateTime.Now.Date;
Entity.StoreID = Convert.ToByte(model.StoreIdIssueTo);
Entity.ItemTypeID = model.ItemType;
Entity.LeatherType = model.LeatherType;
Entity.LeatherStatus = model.LeatherStatus;
Entity.UnitID = model.UnitID;
Entity.OpeningQty = 0;
Entity.DailyReceiveQty = model.IssueQty;
Entity.DailyIssueQty = 0;
Entity.ClosingQty = model.IssueQty;
return(Entity);
}
public Inv_StockSupplier SetToModelObjectStockSupplierReceive(InvLeatherIssueItem model)
{
Inv_StockSupplier Entity = new Inv_StockSupplier();
Entity.SupplierID = model.SupplierID;
Entity.StoreID = Convert.ToByte(model.StoreIdIssueTo);
Entity.RefChallanID = model.ChallanID;
Entity.ItemTypeID = model.ItemType;
Entity.LeatherType = model.LeatherType;
Entity.LeatherStatusID = model.LeatherStatus;
Entity.UnitID = model.UnitID;
Entity.OpeningQty = 0;
Entity.ReceiveQty = model.IssueQty;
Entity.IssueQty = 0;
Entity.ClosingQty = model.IssueQty;
Entity.UpdateReason = "issue";
return(Entity);
}
public Inv_LeatherIssueItem SetToModelObject(InvLeatherIssueItem model)
{
Inv_LeatherIssueItem Entity = new Inv_LeatherIssueItem();
Entity.ItemIssueID = model.ItemIssueID;
Entity.IssueID = model.IssueID;// Convert.ToInt16(_context.Inv_LeatherIssue.DefaultIfEmpty().Max(m => m.IssueID == null ? 0 : m.IssueID));
Entity.SupplierID = model.SupplierID;
Entity.ChallanID = model.ChallanID;
Entity.PurchaseID = model.PurchaseID;//_context.Prq_PurchaseChallan.Where(m => m.ChallanID == model.ChallanID).FirstOrDefault().PurchaseID;
Entity.ItemType = model.ItemType;
Entity.LeatherType = model.LeatherType;
Entity.LeatherStatus = model.LeatherStatus;
Entity.IssueQty = model.IssueQty;
Entity.UnitID = model.UnitID;
Entity.IssueSide = model.IssueSide;
Entity.Remarks = model.Remarks;
Entity.RecordStatus = "NCF";//model.RecordStatus;
Entity.SetOn = DateTime.Now;
Entity.SetBy = model.SetBy;
Entity.IPAddress = string.Empty;
return(Entity);
}