private INV_CrustLeatherIssueItem ConvertIssueItem(InvCrustLeatherIssueItem model, long issueId, int userId)
{
var entity = model.CrustLeatherIssueItemID == 0 ? new INV_CrustLeatherIssueItem() : (from b in _context.INV_CrustLeatherIssueItem.AsEnumerable()
where b.CrustLeatherIssueItemID == model.CrustLeatherIssueItemID
select b).FirstOrDefault();
entity.CrustLeatherIssueItemID = model.CrustLeatherIssueItemID;
entity.CrustLeatherIssueID = issueId;
entity.RequisitionDateID = model.RequisitionDateID ?? null;
//entity.RequisitionNo = null;
entity.CrustQCLabel = model.CrustQCLabel ?? null;
entity.BuyerID = model.BuyerID;
entity.BuyerOrderID = model.BuyerOrderID;
entity.ArticleID = model.ArticleID;
entity.ArticleNo = model.ArticleNo;
entity.ArticleChallanID = model.ArticleChallanID;
entity.ArticleChallanNo = model.ArticleChallanNo;
entity.ItemTypeID = model.ItemTypeID;
entity.LeatherTypeID = model.LeatherTypeID;
entity.LeatherStatusID = model.LeatherStatusID;
entity.SetOn = model.CrustLeatherIssueItemID == 0
? DateTime.Now
: _unit.CrustLeatherIssueItem.GetByID(model.CrustLeatherIssueItemID).SetOn;
entity.SetBy = model.CrustLeatherIssueItemID == 0
? userId
: _unit.CrustLeatherIssueItem.GetByID(model.CrustLeatherIssueItemID).SetBy;
entity.ModifiedOn = model.CrustLeatherIssueItemID == 0 ? (DateTime?)null : DateTime.Now;
entity.ModifiedBy = model.CrustLeatherIssueItemID == 0 ? (int?)null : userId;
return(entity);
}
public List <InvCrustLeatherIssueItem> GetReqItemNColors(long reqDateId, byte?issueFrom, byte?issueTo, string qcLabel)
{
var items = _unit.FinishReqItem.Get().Where(ob => ob.RequisitionDateID == reqDateId).ToList();
var result = new List <InvCrustLeatherIssueItem>();
foreach (var item in items)
{
var rslt = new InvCrustLeatherIssueItem();
rslt.RequisitionItemID = item.RequisitionItemID;
rslt.RequisitionNo = item.RequisitionNo;
rslt.RequisitionDateID = item.RequisitionDateID;
rslt.BuyerID = item.BuyerID;
rslt.BuyerName = item.BuyerID == null ? "" : _unit.SysBuyerRepository.GetByID(item.BuyerID).BuyerName;
rslt.BuyerOrderID = item.BuyerOrderID;
rslt.BuyerOrderNo = item.BuyerOrderID == null
? ""
: _unit.SlsBuyerOrederRepository.GetByID(item.BuyerOrderID).BuyerOrderNo;
rslt.ArticleID = item.ArticleID;
rslt.ArticleNo = item.ArticleNo;
rslt.ArticleChallanID = item.ArticleChallanID;
rslt.ArticleChallanNo = item.ArticleChallanNo;
rslt.ArticleName = item.ArticleID == null
? ""
: _unit.ArticleRepository.GetByID(item.ArticleID).ArticleName;
rslt.ItemTypeID = item.ItemTypeID;
rslt.ItemTypeName = item.ItemTypeID == null
? ""
: _unit.SysItemTypeRepository.GetByID(item.ItemTypeID).ItemTypeName;
rslt.LeatherTypeID = item.LeatherTypeID;
rslt.LeatherTypeName = item.LeatherTypeID == null
? ""
: _unit.SysLeatherTypeRepository.GetByID(item.LeatherTypeID).LeatherTypeName;
rslt.LeatherStatusID = item.LeatherStatusID;
rslt.LeatherStatusName = item.LeatherStatusID == null
? ""
: _unit.SysLeatherStatusRepo.GetByID(item.LeatherStatusID).LeatherStatusName;
rslt.Colors = new List <InvCrustLeatherIssueColor>();
var rqClrs = _unit.FinishReqItemColor.Get().Where(ob => ob.RequisitionItemID == item.RequisitionItemID);
foreach (var rqClr in rqClrs)
{
var clr = new InvCrustLeatherIssueColor();
clr.ColorID = rqClr.ColorID;
clr.ColorName = rqClr.ColorID == null
? ""
: _unit.SysColorRepository.GetByID(rqClr.ColorID).ColorName;
var clsngStkPcs = _context.INV_CrustBuyerStock.FirstOrDefault(
ob => ob.StoreID == issueFrom && ob.BuyerID == item.BuyerID &&
ob.BuyerOrderID == item.BuyerOrderID && ob.ArticleID == item.ArticleID &&
ob.ItemTypeID == item.ItemTypeID && ob.LeatherTypeID == item.LeatherTypeID &&
ob.LeatherStatusID == item.LeatherStatusID && ob.ColorID == rqClr.ColorID &&
ob.CrustQCLabel == qcLabel && ob.ArticleChallanNo == item.ArticleChallanNo);
clr.GradeRange = clsngStkPcs == null ? "" : clsngStkPcs.GradeRange;
clr.IssuePcs = rqClr.ColorPcs ?? 0;
clr.IssueSide = rqClr.ColorSide ?? 0;
clr.IssueArea = rqClr.ColorArea ?? 0;
//clr.AreaUnit = rqClr.AreaUnit;
//clr.AreaUnitName = rqClr.AreaUnit == null
// ? ""
// : _unit.SysUnitRepository.GetByID(rqClr.AreaUnit).UnitName;
clr.ClosingStockPcs = clsngStkPcs == null ? 0 : clsngStkPcs.ClosingStockPcs;
var clsngStkArea = _context.INV_CrustBuyerStock.FirstOrDefault(
ob => ob.StoreID == issueFrom && ob.BuyerID == item.BuyerID &&
ob.BuyerOrderID == item.BuyerOrderID && ob.ArticleID == item.ArticleID &&
ob.ItemTypeID == item.ItemTypeID && ob.LeatherTypeID == item.LeatherTypeID &&
ob.LeatherStatusID == item.LeatherStatusID && ob.ColorID == rqClr.ColorID &&
ob.CrustQCLabel == qcLabel && ob.ArticleChallanNo == item.ArticleChallanNo);
clr.ClosingStockArea = clsngStkArea == null ? 0 : clsngStkArea.ClosingStockArea;
var clsngStkSide = _context.INV_CrustBuyerStock.FirstOrDefault(
ob => ob.StoreID == issueFrom && ob.BuyerID == item.BuyerID &&
ob.BuyerOrderID == item.BuyerOrderID && ob.ArticleID == item.ArticleID &&
ob.ItemTypeID == item.ItemTypeID && ob.LeatherTypeID == item.LeatherTypeID &&
ob.LeatherStatusID == item.LeatherStatusID && ob.ColorID == rqClr.ColorID &&
ob.CrustQCLabel == qcLabel && ob.ArticleChallanNo == item.ArticleChallanNo);
clr.ClosingStockSide = clsngStkSide == null ? 0 : clsngStkSide.ClosingStockSide;
clr.CrustQCLabel = qcLabel;
clr.ArticleColorNo = rqClr.ArticleColorNo;
rslt.Colors.Add(clr);
}
result.Add(rslt);
}
return(result);
}
public ActionResult GetIssueById(long issueId)
{
//var result = _dalInvCrustedLeatherIssueFrom.GetIssueById(issueId);
var issue = _unit.CrustLeatherIssue.GetByID(issueId);
var result = new InvCrustLeatherIssue();
result.CrustLeatherIssueID = issue.CrustLeatherIssueID;
result.CrustLeatherIssueNo = issue.CrustLeatherIssueNo;
result.CrustLeatherIssueDate = string.Format("{0:dd/MM/yyyy}", issue.CrustLeatherIssueDate);
result.IssueCategory = issue.IssueCategory;
result.IssueFor = issue.IssueFor;
result.IssueFrom = issue.IssueFrom;
result.IssueTo = issue.IssueTo;
result.RecordStatus = issue.RecordStatus;
result.CheckNote = issue.CheckNote;
result.IssueNote = issue.IssueNote;
result.Items = new List <InvCrustLeatherIssueItem>();
var items =
_unit.CrustLeatherIssueItem.Get()
.Where(ob => ob.CrustLeatherIssueID == result.CrustLeatherIssueID)
.ToList();
if (items.Count > 0)
{
foreach (var item in items)
{
var x = new InvCrustLeatherIssueItem();
x.CrustLeatherIssueID = item.CrustLeatherIssueID;
x.CrustLeatherIssueItemID = item.CrustLeatherIssueItemID;
x.RequisitionDateID = item.RequisitionDateID;
x.RequisitionNo = item.RequisitionDateID == null ? "" : _unit.PrdYearMonthFinishReqDate.GetByID(item.RequisitionDateID).RequisitionNo;
x.BuyerID = item.BuyerID;
x.BuyerName = item.BuyerID == null ? "" : _unit.SysBuyerRepository.GetByID(item.BuyerID).BuyerName;
x.BuyerOrderID = item.BuyerOrderID;
x.BuyerOrderNo = item.BuyerOrderID == null
? ""
: _unit.SlsBuyerOrederRepository.GetByID(item.BuyerOrderID).BuyerOrderNo;
x.ArticleID = item.ArticleID;
x.ArticleName = item.ArticleID == null
? ""
: _unit.ArticleRepository.GetByID(item.ArticleID).ArticleName;
x.ArticleNo = item.ArticleID == null
? ""
: _unit.ArticleRepository.GetByID(item.ArticleID).ArticleNo;
x.ArticleChallanNo = item.ArticleChallanNo;
x.ArticleChallanID = item.ArticleChallanID;
x.ItemTypeID = item.ItemTypeID;
x.ItemTypeName = item.ItemTypeID == null
? ""
: _unit.SysItemTypeRepository.GetByID(item.ItemTypeID).ItemTypeName;
x.LeatherTypeID = item.LeatherTypeID;
x.LeatherTypeName = item.LeatherTypeID == null
? ""
: _unit.SysLeatherTypeRepository.GetByID(item.LeatherTypeID).LeatherTypeName;
x.LeatherStatusID = item.LeatherStatusID;
x.LeatherStatusName = item.LeatherStatusID == null
? ""
: _unit.SysLeatherStatusRepo.GetByID(item.LeatherStatusID).LeatherStatusName;
x.CrustQCLabel = item.CrustQCLabel;
x.Colors = new List <InvCrustLeatherIssueColor>();
var colors =
_unit.CrustLeatherIssueColor.Get()
.Where(ob => ob.CrustLeatherIssueItemID == x.CrustLeatherIssueItemID)
.ToList();
if (colors.Count > 0)
{
foreach (var color in colors)
{
var y = new InvCrustLeatherIssueColor();
y.CrustLeatherIssueID = color.CrustLeatherIssueID;
y.CrustLeatherIssueItemID = color.CrustLeatherIssueItemID;
y.CrustLeatherIssueColorID = color.CrustLeatherIssueColorID;
y.ArticleColorNo = color.ArticleColorNo;
y.ColorID = color.ColorID;
y.ColorName = color.ColorID == null
? ""
: _unit.SysColorRepository.GetByID(color.ColorID).ColorName;
y.GradeRange = color.GradeRange;
//y.GradeID = color.GradeID;
//y.GradeName = color.GradeID == null ? "" : _unit.SysGrade.GetByID(color.GradeID).GradeName;
var clsngStkPcs = _context.INV_CrustBuyerStock.Where(
ob =>
ob.StoreID == issue.IssueFrom && ob.BuyerID == item.BuyerID &&
ob.BuyerOrderID == item.BuyerOrderID && ob.ArticleID == item.ArticleID &&
ob.ItemTypeID == item.ItemTypeID && ob.LeatherTypeID == item.LeatherTypeID &&
ob.LeatherStatusID == item.LeatherStatusID && ob.ColorID == color.ColorID &&
ob.CrustQCLabel == color.CrustQCLabel &&
ob.ArticleChallanNo == item.ArticleChallanNo)
.OrderByDescending(m => m.TransectionID)
.FirstOrDefault();
y.ClosingStockPcs = clsngStkPcs == null ? 0 : clsngStkPcs.ClosingStockPcs;
var clsngStkSide = _context.INV_CrustBuyerStock.Where(
ob =>
ob.StoreID == issue.IssueFrom && ob.BuyerID == item.BuyerID &&
ob.BuyerOrderID == item.BuyerOrderID && ob.ArticleID == item.ArticleID &&
ob.ItemTypeID == item.ItemTypeID && ob.LeatherTypeID == item.LeatherTypeID &&
ob.LeatherStatusID == item.LeatherStatusID && ob.ColorID == color.ColorID &&
ob.CrustQCLabel == color.CrustQCLabel &&
ob.ArticleChallanNo == item.ArticleChallanNo)
.OrderByDescending(m => m.TransectionID)
.FirstOrDefault();
y.ClosingStockSide = clsngStkSide == null ? 0 : clsngStkSide.ClosingStockSide;
var clsngStkArea = _context.INV_CrustBuyerStock.Where(
ob =>
ob.StoreID == issue.IssueFrom && ob.BuyerID == item.BuyerID &&
ob.BuyerOrderID == item.BuyerOrderID && ob.ArticleID == item.ArticleID &&
ob.ItemTypeID == item.ItemTypeID && ob.LeatherTypeID == item.LeatherTypeID &&
ob.LeatherStatusID == item.LeatherStatusID && ob.ColorID == color.ColorID &&
ob.CrustQCLabel == color.CrustQCLabel &&
ob.ArticleChallanNo == item.ArticleChallanNo)
.OrderByDescending(m => m.TransectionID)
.FirstOrDefault();
y.ClosingStockArea = clsngStkArea == null ? 0 : clsngStkArea.ClosingStockArea;
y.IssuePcs = color.IssuePcs;
y.IssueSide = color.IssueSide;
y.IssueArea = color.IssueArea;
y.SideArea = color.SideArea;
y.AreaUnit = color.AreaUnit;
y.AreaUnitName = color.AreaUnit == null
? ""
: _unit.SysUnitRepository.GetByID(color.AreaUnit).UnitName;
y.CrustQCLabel = color.CrustQCLabel;
x.Colors.Add(y);
}
}
result.Items.Add(x);
}
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
