public ActionResult CLRequisitionForFinishing(PRDYearMonthCrustReqItem model)
{
var msg = objBll.Save(model, Convert.ToInt32(Session["UserID"]));
var RequistionItemList = objDal.GetRequisitionItemList(model.RequisitionDateID.ToString());
return(Json(new { Msg = msg, RequistionItemList = RequistionItemList }, JsonRequestBehavior.AllowGet));
}
public ValidationMsg Save(PRDYearMonthCrustReqItem model, int userId)
{
var transactionOption = new TransactionOptions {
Timeout = new TimeSpan(0, 0, 9999)
};
var vMsg = new ValidationMsg();
using (var transactionScope = new TransactionScope(TransactionScopeOption.RequiresNew, transactionOption))
{
try
{
_dalObj = new DalWBRequisitionForCrusting();
RequisitionItemID = _dalObj.Save(model, userId);
if (RequisitionItemID > 0)
{
transactionScope.Complete();
vMsg.Type = Enums.MessageType.Update;
vMsg.Msg = "Updated successfully.";
}
else
{
vMsg.Type = Enums.MessageType.Error;
vMsg.Msg = "Failed to Update.";
}
}
catch (Exception)
{
vMsg.Type = Enums.MessageType.Error;
vMsg.Msg = "Failed to Update.";
}
}
return(vMsg);
}
public long Save(PRDYearMonthCrustReqItem model, int userId)
{
long CurrentRequisitionItemID = 0;
try
{
using (TransactionScope transaction = new TransactionScope())
{
using (_context)
{
var RequisitionDateInfo = (from r in _context.PRD_YearMonthFinishReqDate.AsEnumerable()
where r.RequisitionDateID == model.RequisitionDateID
select r).FirstOrDefault();
RequisitionDateInfo.Remark = model.ConfirmNote;
_context.SaveChanges();
#region Update_Item_Information
if (model.ItemList != null)
{
foreach (var Item in model.ItemList)
{
#region New_Item_Insertion
if (Item.RequisitionItemID == 0)
{
PRD_YearMonthFinishReqItem objItem = new PRD_YearMonthFinishReqItem();
objItem.RequisitionDateID = Item.RequisitionDateID;
objItem.ScheduleItemID = Item.ScheduleItemID;
objItem.ScheduleProductionNo = Item.ScheduleProductionNo;
//objItem.RequisitionNo = Convert.ToInt32(model.PurchaseID);
objItem.BuyerID = Item.BuyerID;
objItem.BuyerOrderID = Item.BuyerOrderID;
objItem.ArticleID = Item.ArticleID;
objItem.ArticleNo = Item.ArticleNo;
if (Item.ArticleChallanID != 0)
{
objItem.ArticleChallanID = Item.ArticleChallanID;
objItem.ArticleChallanNo = Item.ArticleChallanNo;
}
objItem.AvgSize = Item.AvgSize;
objItem.AvgSizeUnit = DalCommon.GetUnitCode(Item.AvgSizeUnitName);
objItem.SelectionRange = Item.SelectionRange;
objItem.SideDescription = Item.SideDescription;
objItem.Thickness = Item.Thickness;
objItem.ThicknessUnit = DalCommon.GetUnitCode(Item.ThicknessUnitName);
objItem.ThicknessAt = (Item.ThicknessAt == "After Shaving" ? "AFSV" : "AFFN");
objItem.ItemTypeID = DalCommon.GetItemTypeCode(Item.ItemTypeName);
objItem.LeatherStatusID = DalCommon.GetLeatherStatusCode(Item.LeatherStatusName);
objItem.LeatherTypeID = DalCommon.GetLeatherTypeCode("Crust");
objItem.Remark = Item.Remarks;
objItem.SetOn = DateTime.Now;
objItem.SetBy = 1;;
_context.PRD_YearMonthFinishReqItem.Add(objItem);
_context.SaveChanges();
CurrentRequisitionItemID = objItem.RequisitionItemID;
}
#endregion
#region Existing_Challan_Update
else if (Item.RequisitionItemID != 0)
{
var CurrentItem = (from c in _context.PRD_YearMonthFinishReqItem.AsEnumerable()
where c.RequisitionItemID == Item.RequisitionItemID
select c).FirstOrDefault();
CurrentItem.RequisitionDateID = Item.RequisitionDateID;
CurrentItem.ScheduleProductionNo = Item.ScheduleProductionNo;
//CurrentItem.RequisitionNo = Convert.ToInt32(model.PurchaseID);
CurrentItem.BuyerID = Item.BuyerID;
CurrentItem.BuyerOrderID = Item.BuyerOrderID;
CurrentItem.ArticleID = Item.ArticleID;
CurrentItem.ArticleNo = Item.ArticleNo;
if (Item.ArticleChallanID != 0)
{
CurrentItem.ArticleChallanID = Item.ArticleChallanID;
CurrentItem.ArticleChallanNo = Item.ArticleChallanNo;
}
CurrentItem.AvgSize = Item.AvgSize;
CurrentItem.AvgSizeUnit = DalCommon.GetUnitCode(Item.AvgSizeUnitName);
CurrentItem.SelectionRange = Item.SelectionRange;
CurrentItem.SideDescription = Item.SideDescription;
CurrentItem.Thickness = Item.Thickness.ToString();
CurrentItem.ThicknessUnit = DalCommon.GetUnitCode(Item.ThicknessUnitName);
CurrentItem.ThicknessAt = Item.ThicknessAt;
CurrentItem.ItemTypeID = DalCommon.GetItemTypeCode(Item.ItemTypeName);
CurrentItem.LeatherStatusID = DalCommon.GetLeatherStatusCode(Item.LeatherStatusName);
CurrentItem.LeatherTypeID = DalCommon.GetLeatherTypeCode("Crust");
CurrentItem.Remark = Item.Remarks;
_context.SaveChanges();
}
#endregion
}
}
#endregion
#region To_Find_ColorItemID_For_Items_If_Any
if (model.ColorList != null)
{
foreach (var Color in model.ColorList)
{
if (Color.RequisitionItemID != null && Color.RequisitionItemID != 0)
{
CurrentRequisitionItemID = Convert.ToInt64(Color.RequisitionItemID);
break;
}
else
{
if (model.SelectedRequisitionItemID != 0)
{
CurrentRequisitionItemID = model.SelectedRequisitionItemID;
}
break;
}
}
}
#endregion
#region Update_Color_Item_Information
if (model.ColorList != null)
{
foreach (var Color in model.ColorList)
{
#region New_Color_Item_Insertion
if (Color.ReqItemColorID == 0)
{
PRD_YearMonthFinishReqItemColor objColor = new PRD_YearMonthFinishReqItemColor();
objColor.RequisitionItemID = CurrentRequisitionItemID;
objColor.ColorID = Color.ColorID;
objColor.ArticleColorNo = Color.ArticleColorNo;
objColor.ColorPcs = (Color.ColorPCS);
objColor.ColorSide = (Color.ColorSide);
objColor.ColorArea = Color.ColorArea;
objColor.AreaUnit = DalCommon.GetUnitCode(Color.AreaUnitName);
objColor.Remarks = Color.Remarks;
objColor.SetBy = 1;;
objColor.SetOn = DateTime.Now;
_context.PRD_YearMonthFinishReqItemColor.Add(objColor);
_context.SaveChanges();
}
#endregion
#region Update_Existing_Color_Item
else if (Color.ReqItemColorID != 0)
{
var currentColorItem = (from c in _context.PRD_YearMonthFinishReqItemColor.AsEnumerable()
where c.ReqItemColorID == Color.ReqItemColorID
select c).FirstOrDefault();
currentColorItem.RequisitionItemID = CurrentRequisitionItemID;
currentColorItem.ColorID = Color.ColorID;
currentColorItem.ArticleColorNo = Color.ArticleColorNo;
currentColorItem.ColorPcs = (Color.ColorPCS);
currentColorItem.ColorSide = (Color.ColorSide);
currentColorItem.ColorArea = Color.ColorArea;
currentColorItem.AreaUnit = DalCommon.GetUnitCode(Color.AreaUnitName);
currentColorItem.Remarks = Color.Remarks;
currentColorItem.SetBy = 1;;
currentColorItem.SetOn = DateTime.Now;
_context.SaveChanges();
}
#endregion
}
}
#endregion
}
transaction.Complete();
}
return(CurrentRequisitionItemID);
}
catch (Exception e)
{
return(0);
}
}