public ActionResult GetAllGridList(string CrustLeatherIssueID, string StoreId, string QCTransactionOf)
{
InvCrustLeatherIssue model = new InvCrustLeatherIssue();
if (string.IsNullOrEmpty(CrustLeatherIssueID))
{
return(Json(model, JsonRequestBehavior.AllowGet));
}
model.IssueItemList = Dalobject.GetQCColorList(CrustLeatherIssueID);
if (model.IssueItemList.Count > 0)
{
model.IssueColorList = Dalobject.GetQCSelectionList(model.IssueItemList[0].CrustLeatherIssueItemID.ToString(), StoreId, QCTransactionOf);
}
return(Json(model, JsonRequestBehavior.AllowGet));
}
public ActionResult IssueAfterFinishQC(InvCrustLeatherIssue model)
{
_vmMsg = model.CrustLeatherIssueID == 0 ? Dalobject.Save(model, Convert.ToInt32(Session["UserID"]), "IssueAfterFinishQC/IssueAfterFinishQC") : Dalobject.Update(model, Convert.ToInt32(Session["UserID"]));
//_vmMsg = model.CrustLeatherIssueID == 0 ? Dalobject.Save(model, Convert.ToInt32(Session["UserID"]), "CrustLeatherQC/CrustLeatherQC") : Dalobject.Update(model, Convert.ToInt32(Session["UserID"]));
return(Json(new { CrustLeatherIssueID = Dalobject.GetQCID(), CrustLeatherQCNo = Dalobject.GetQCNo(), msg = _vmMsg }));
}
public ActionResult ConfirmedAfterCrustQC(InvCrustLeatherIssue model)
{
_vmMsg = Dalobject.ConfirmedAfterCrustQC(model, Convert.ToInt32(Session["UserID"]));
return(Json(new { msg = _vmMsg }));
}
public ValidationMsg Save(InvCrustLeatherIssue model, int userId, string url)
{
try
{
using (var tx = new TransactionScope())
{
using (_context)
{
var issue = ConvertIssue(model, userId, url);
if (model.CrustLeatherIssueID == 0)
{
_context.INV_CrustLeatherIssue.Add(issue);
_context.SaveChanges();
_mode = 1;
}
else
{
_context.SaveChanges();
_mode = 2;
}
if (model.Items != null)
{
foreach (var item in model.Items)
{
var issueItem = ConvertIssueItem(item, issue.CrustLeatherIssueID, userId);
if (item.CrustLeatherIssueItemID == 0)
{
_context.INV_CrustLeatherIssueItem.Add(issueItem);
_context.SaveChanges();
}
else
{
_context.SaveChanges();
}
if (item.Colors != null)
{
foreach (var color in item.Colors)
{
var itemColor = ConvertIssueItemColor(color, issueItem.CrustLeatherIssueItemID,
issue.CrustLeatherIssueID, userId);
if (color.CrustLeatherIssueColorID == 0)
{
_context.INV_CrustLeatherIssueColor.Add(itemColor);
//_context.SaveChanges();
}
else
{
//_context.SaveChanges();
}
}
}
}
_context.SaveChanges();
}
tx.Complete();
if (_mode == 1)
{
_vmMsg.ReturnId = issue.CrustLeatherIssueID;
_vmMsg.ReturnCode = issue.CrustLeatherIssueNo;
_vmMsg.Type = Enums.MessageType.Success;
_vmMsg.Msg = "Saved successfully.";
}
if (_mode == 2)
{
_vmMsg.ReturnId = issue.CrustLeatherIssueID;
_vmMsg.Type = Enums.MessageType.Update;
_vmMsg.Msg = "Updated successfully.";
}
}
}
}
catch
{
_vmMsg.Type = Enums.MessageType.Error;
_vmMsg.Msg = "Failed to save.";
}
return(_vmMsg);
}
private INV_CrustLeatherIssue ConvertIssue(InvCrustLeatherIssue model, int userId, string url)
{
var entity = model.CrustLeatherIssueID == 0 ? new INV_CrustLeatherIssue() : (from b in _context.INV_CrustLeatherIssue.AsEnumerable()
where b.CrustLeatherIssueID == model.CrustLeatherIssueID
select b).FirstOrDefault();
entity.CrustLeatherIssueID = model.CrustLeatherIssueID;
entity.CrustLeatherIssueNo = model.CrustLeatherIssueNo ?? DalCommon.GetPreDefineNextCodeByUrl(url);
entity.CrustLeatherIssueDate = model.CrustLeatherIssueDate == null ? DateTime.Now : DalCommon.SetDate(model.CrustLeatherIssueDate);
entity.IssueCategory = model.IssueCategory;
entity.IssueFor = model.IssueFor;
entity.IssueFrom = model.IssueFrom;
entity.IssueTo = model.IssueTo;
entity.RecordStatus = model.RecordStatus ?? "NCF";
entity.SetOn = model.CrustLeatherIssueID == 0
? DateTime.Now
: _unit.CrustLeatherIssue.GetByID(model.CrustLeatherIssueID).SetOn;
entity.SetBy = model.CrustLeatherIssueID == 0
? userId
: _unit.CrustLeatherIssue.GetByID(model.CrustLeatherIssueID).SetBy;
entity.ModifiedOn = model.CrustLeatherIssueID == 0 ? (DateTime?)null : DateTime.Now;
entity.ModifiedBy = model.CrustLeatherIssueID == 0 ? (int?)null : userId;
#region New Code
//var put = entity.INV_CrustLeatherReceiveItem;
//if (model.Items.Count > 0)
//{
// foreach (var item in model.Items)
// {
// put.CrustLeatherIssueItemID = item.CrustLeatherIssueItemID;
// put.CrustLeatherIssueID = entity.CrustLeatherIssueID;
// put.RequisitionDateID = item.RequisitionDateID ?? null;
// //entity.RequisitionNo = null;
// put.CrustQCLabel = item.CrustQCLabel ?? null;
// put.BuyerID = item.BuyerID;
// put.BuyerOrderID = item.BuyerOrderID;
// put.ArticleID = item.ArticleID;
// put.ArticleNo = item.ArticleNo;
// put.ArticleChallanID = item.ArticleChallanID;
// put.ArticleChallanNo = item.ArticleChallanNo;
// put.ItemTypeID = item.ItemTypeID;
// put.LeatherTypeID = item.LeatherTypeID;
// put.LeatherStatusID = item.LeatherStatusID;
// put.SetOn = item.CrustLeatherIssueItemID == 0
// ? DateTime.Now
// : _unit.CrustLeatherIssueItem.GetByID(item.CrustLeatherIssueItemID).SetOn;
// entity.SetBy = item.CrustLeatherIssueItemID == 0
// ? userId
// : _unit.CrustLeatherIssueItem.GetByID(item.CrustLeatherIssueItemID).SetBy;
// entity.ModifiedOn = item.CrustLeatherIssueItemID == 0 ? (DateTime?)null : DateTime.Now;
// entity.ModifiedBy = item.CrustLeatherIssueItemID == 0 ? (int?)null : userId;
// var col = new INV_CrustLeatherIssueColor();
// if (item.Colors.Count > 0)
// {
// foreach (var color in item.Colors)
// {
// entity.CrustLeatherIssueColorID = model.CrustLeatherIssueColorID;
// entity.CrustLeatherIssueItemID = itemId;
// entity.CrustLeatherIssueID = issueId;
// entity.ArticleColorNo = entity.ArticleColorNo;
// entity.ColorID = model.ColorID;
// entity.GradeID = model.GradeID;
// entity.GradeRange = model.GradeRange;
// entity.CrustQCLabel = model.CrustQCLabel;
// entity.IssuePcs = model.IssuePcs ?? 0;
// entity.IssueSide = model.IssueSide ?? 0;
// entity.IssueArea = model.IssueArea ?? 0;
// entity.SideArea = model.SideArea;
// entity.AreaUnit = model.AreaUnit;
// entity.SetOn = model.CrustLeatherIssueColorID == 0
// ? DateTime.Now
// : _unit.CrustLeatherIssueColor.GetByID(model.CrustLeatherIssueColorID).SetOn;
// entity.SetBy = model.CrustLeatherIssueColorID == 0
// ? userId
// : _unit.CrustLeatherIssueColor.GetByID(model.CrustLeatherIssueColorID).SetBy;
// entity.ModifiedBy = model.CrustLeatherIssueColorID == 0 ? (int?)null : userId;
// entity.ModifiedOn = model.CrustLeatherIssueColorID == 0 ? (DateTime?)null : DateTime.Now;
// return entity;
// }
// }
// }
//}
#endregion
return(entity);
}
public ActionResult Save(InvCrustLeatherIssue model)
{
_userId = Convert.ToInt32(Session["UserID"]);
_validationMsg = _dalInvCrustedLeatherIssueFrom.Save(model, _userId, "CrustedLeatherIssueFromStore/CrustedLeatherIssueFromStore");
return(Json(_validationMsg, JsonRequestBehavior.AllowGet));
}
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));
}
