public ActionResult Issue(InvFinishLeatherIssue model)
{
_userId = Convert.ToInt32(Session["UserID"]);
_validationMsg = _dalInvFinishedLeatherIssueFromStore.Confirm(model, _userId);
return(Json(_validationMsg, JsonRequestBehavior.AllowGet));
}
public ActionResult GetIssueById(long issueId)
{
var issue = _unit.FinishLeatherIssue.GetByID(issueId);
//var x = new InvFinishLeatherIssue();
var result = new InvFinishLeatherIssue();
result.FinishLeatherIssueID = issue.FinishLeatherIssueID;
result.FinishLeatherIssueNo = issue.FinishLeatherIssueNo;
result.FinishLeatherIssueDate = string.Format("{0:dd/MM/yyyy}", issue.FinishLeatherIssueDate);
result.IssueCategory = issue.IssueCategory;
result.IssueFor = issue.IssueFor;
result.IssueFrom = issue.IssueFrom;
result.IssueTo = issue.IssueTo;
result.CheckNote = issue.CheckNote;
result.IssueNote = issue.IssueNote;
result.RecordStatus = issue.RecordStatus;
result.Items = new List <InvFinishedLeatherIssueItem>();
var items =
_unit.FinishLeatherIssueItem.Get()
.Where(ob => ob.FinishLeatherIssueID == issue.FinishLeatherIssueID)
.ToList();
if (items.Count > 0)
{
foreach (var item in items)
{
var y = new InvFinishedLeatherIssueItem();
y.FinishLeatherIssueItemID = item.FinishLeatherIssueItemID;
y.FinishLeatherIssueID = item.FinishLeatherIssueID;
y.RequisitionDateID = item.RequisitionDateID;
y.BuyerID = item.BuyerID;
y.BuyerName = item.BuyerID == null
? ""
: _unit.SysBuyerRepository.GetByID(item.BuyerID).BuyerName;
y.BuyerOrderID = item.BuyerOrderID;
y.BuyerOrderNo = item.BuyerOrderID == null
? ""
: _unit.SlsBuyerOrederRepository.GetByID(item.BuyerOrderID).BuyerOrderNo;
y.ArticleID = item.ArticleID;
y.ArticleNo = item.ArticleNo;
y.ArticleChallanNo = item.ArticleChallanNo;
y.ArticleName = item.ArticleID == null
? ""
: _unit.ArticleRepository.GetByID(item.ArticleID).ArticleName;
y.ItemTypeID = item.ItemTypeID;
y.ItemTypeName = item.ItemTypeID == null
? ""
: _unit.SysItemTypeRepository.GetByID(item.ItemTypeID).ItemTypeName;
y.LeatherTypeID = item.LeatherTypeID;
y.LeatherTypeName = item.LeatherTypeID == null
? ""
: _unit.SysLeatherTypeRepository.GetByID(item.LeatherTypeID).LeatherTypeName;
y.LeatherStatusID = item.LeatherStatusID;
y.LeatherStatusName = item.LeatherStatusID == null
? ""
: _unit.SysLeatherStatusRepo.GetByID(item.LeatherStatusID).LeatherStatusName;
y.Colors = new List <InvFinishedLeatherIssueColor>();
var colors =
_unit.FinishLeatherIssueColor.Get()
.Where(ob => ob.FinishLeatherIssueItemID == item.FinishLeatherIssueItemID)
.ToList();
if (colors.Count > 0)
{
foreach (var color in colors)
{
var z = new InvFinishedLeatherIssueColor();
z.FinishLeatherIssueColorID = color.FinishLeatherIssueColorID;
z.FinishLeatherIssueItemID = color.FinishLeatherIssueItemID;
z.FinishLeatherIssueID = color.FinishLeatherIssueID;
z.ColorID = color.ColorID;
z.ColorName = color.ColorID == null
? ""
: _unit.SysColorRepository.GetByID(color.ColorID).ColorName;
//z.GradeID = color.GradeID;
//z.GradeName = color.GradeID == null ? "" : _unit.SysGrade.GetByID(color.GradeID).GradeName;
var stock =
_unit.FinishBuyerStock.Get()
.Where(
ob =>
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.GradeID == color.GradeID && ob.ClosingStockPcs > 0).OrderByDescending(ob => ob.TransectionID)
.FirstOrDefault();
z.ClosingStockPcs = stock == null ? 0 : stock.ClosingStockPcs;
z.ClosingStockSide = stock == null ? 0 : stock.ClosingStockSide;
z.ClosingStockArea = stock == null ? 0 : stock.ClosingStockArea;
z.IssuePcs = color.IssuePcs;
z.IssueSide = color.IssueSide;
z.IssueArea = color.IssueArea;
z.SideArea = color.SideArea;
z.AreaUnit = color.AreaUnit;
z.UnitName = color.AreaUnit == null
? ""
: _unit.SysUnitRepository.GetByID(color.AreaUnit).UnitName;
z.FinishQCLabel = color.FinishQCLabel;
y.Colors.Add(z);
}
}
result.Items.Add(y);
}
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
