public int Update(PRDChemProdReq model, int userId)
{
try
{
using (TransactionScope transaction = new TransactionScope())
{
using (_context)
{
#region PI_Informaiton_Update
var CurrentRequisition = (from p in _context.PRD_ChemProdReq.AsEnumerable()
where p.RequisitionID == model.RequisitionID
select p).FirstOrDefault();
CurrentRequisition.RequisitionCategory = model.RequisitionCategory;
CurrentRequisition.RequisitionType = model.RequisitionType;
CurrentRequisition.RequisitionFrom = model.RequisitionFrom;
CurrentRequisition.RequisitionTo = model.RequisitionTo;
CurrentRequisition.RequiredByTime = model.RequiredByTime;
CurrentRequisition.ReqRaisedBy = 1;
CurrentRequisition.ReqRaisedOn = DalCommon.SetDate((model.ReqRaisedOn).ToString());
if (model.RecipeFor == 0)
{
CurrentRequisition.RecipeFor = null;
}
else
{
CurrentRequisition.RecipeFor = model.RecipeFor;
}
if (model.RecipeID == 0)
{
CurrentRequisition.RecipeID = null;
}
else
{
CurrentRequisition.RecipeID = model.RecipeID;
}
//CurrentRequisition.RecipeFor = model.RecipeFor;
//CurrentRequisition.RecipeID = model.RecipeID;
CurrentRequisition.ArticleNo = model.ArticleNo;
CurrentRequisition.Thickness = model.Thickness;
if (model.ThicknessUnit != null)
{
CurrentRequisition.ThicknessUnit = model.ThicknessUnit;
}
CurrentRequisition.LeatherSize = model.LeatherSize;
if (model.SizeUnit != null)
{
CurrentRequisition.SizeUnit = model.SizeUnit;
}
CurrentRequisition.Selection = model.Selection;
CurrentRequisition.ProductionQty = model.ProductionQty;
CurrentRequisition.ModifiedBy = userId;
CurrentRequisition.ModifiedOn = DateTime.Now;
_context.SaveChanges();
#endregion
#region Update Requisition ItemList
if (model.RequisitionItemList != null)
{
foreach (var item in model.RequisitionItemList)
{
var checkRequisitionItem = (from i in _context.PRD_ChemProdReqItem.AsEnumerable()
where i.RequisitionItemID == item.RequisitionItemID
select i).Any();
#region New_Requisition_Insertion
if (!checkRequisitionItem)
{
PRD_ChemProdReqItem objItem = new PRD_ChemProdReqItem();
objItem.RequisitionID = model.RequisitionID;
objItem.ItemID = Convert.ToInt32(item.ItemID);
if (item.SupplierID == 0)
{
objItem.SupplierID = null;
}
else
{
objItem.SupplierID = item.SupplierID;
}
objItem.RequiredQty = item.RequiredQty;
if (item.RequiredUnitName == null)
{
objItem.RequiredUnit = null;
}
else
{
objItem.RequiredUnit = DalCommon.GetUnitCode(item.RequiredUnitName);
}
objItem.RequsitionQty = Convert.ToDecimal(item.RequsitionQty);
objItem.RequisitionUnit = DalCommon.GetUnitCode(item.RequisitionUnitName);
if (item.PackSizeName == null)
{
objItem.PackSize = null;
}
else
{
objItem.PackSize = DalCommon.GetSizeCode(item.PackSizeName);
}
//objItem.PackSize = DalCommon.GetSizeCode(item.PackSizeName);
if (item.SizeUnitName == null)
{
objItem.SizeUnit = null;
}
else
{
objItem.SizeUnit = DalCommon.GetUnitCode(item.SizeUnitName);
}
objItem.PackQty = item.PackQty;
objItem.ApproveQty = item.ApproveQty;
objItem.ApproveUnit = DalCommon.GetUnitCode(item.ApproveUnitName);
//objItem.ManufacturerID = item.ManufacturerID;
objItem.ItemSource = DalCommon.ReturnItemSource(item.ItemSource);
objItem.SetOn = DateTime.Now;
objItem.SetBy = userId;
_context.PRD_ChemProdReqItem.Add(objItem);
_context.SaveChanges();
}
#endregion
#region Existing_Requisition_Update
else
{
var FoundRequisition = (from i in _context.PRD_ChemProdReqItem.AsEnumerable()
where i.RequisitionItemID == item.RequisitionItemID
select i).FirstOrDefault();
FoundRequisition.RequisitionID = model.RequisitionID;
FoundRequisition.ItemID = Convert.ToInt32(item.ItemID);
if (item.SupplierID == 0)
{
FoundRequisition.SupplierID = null;
}
else
{
FoundRequisition.SupplierID = item.SupplierID;
}
FoundRequisition.RequiredQty = item.RequiredQty;
if (item.RequiredUnitName == null)
{
FoundRequisition.RequiredUnit = null;
}
else
{
FoundRequisition.RequiredUnit = DalCommon.GetUnitCode(item.RequiredUnitName);
}
FoundRequisition.RequsitionQty = Convert.ToDecimal(item.RequsitionQty);
FoundRequisition.RequisitionUnit = DalCommon.GetUnitCode(item.RequisitionUnitName);
if (item.PackSizeName == null)
{
FoundRequisition.PackSize = null;
}
else
{
FoundRequisition.PackSize = DalCommon.GetSizeCode(item.PackSizeName);
}
//objItem.PackSize = DalCommon.GetSizeCode(item.PackSizeName);
if (item.SizeUnitName == null)
{
FoundRequisition.SizeUnit = null;
}
else
{
FoundRequisition.SizeUnit = DalCommon.GetUnitCode(item.SizeUnitName);
}
FoundRequisition.PackQty = item.PackQty;
FoundRequisition.ApproveQty = item.ApproveQty;
FoundRequisition.ApproveUnit = DalCommon.GetUnitCode(item.ApproveUnitName);
FoundRequisition.ItemSource = DalCommon.ReturnItemSource(item.ItemSource);
FoundRequisition.ModifiedOn = DateTime.Now;
FoundRequisition.ModifiedBy = userId;
_context.SaveChanges();
}
#endregion
}
}
#endregion
}
transaction.Complete();
}
return(1);
}
catch (Exception e)
{
return(0);
}
}
public int Save(PRDChemProdReq model, int userId, string pageUrl)
{
int CurrentRequisitionID = 0;
try
{
using (TransactionScope transaction = new TransactionScope())
{
using (_context)
{
var GetRequisitionNo = DalCommon.GetPreDefineNextCodeByUrl(pageUrl);
if (GetRequisitionNo != null)
{
#region New_Requisition_Insert
PRD_ChemProdReq objRequisition = new PRD_ChemProdReq();
objRequisition.RequisitionNo = GetRequisitionNo;
objRequisition.RequisitionCategory = model.RequisitionCategory;
objRequisition.RequisitionType = model.RequisitionType;
objRequisition.RequisitionFrom = model.RequisitionFrom;
objRequisition.RequisitionTo = model.RequisitionTo;
objRequisition.RequiredByTime = model.RequiredByTime;
objRequisition.ReqRaisedBy = userId;
objRequisition.ReqRaisedOn = DalCommon.SetDate((model.ReqRaisedOn).ToString());
if (model.RecipeFor == 0)
{
objRequisition.RecipeFor = null;
}
else
{
objRequisition.RecipeFor = model.RecipeFor;
}
if (model.RecipeID == 0)
{
objRequisition.RecipeID = null;
}
else
{
objRequisition.RecipeID = model.RecipeID;
}
objRequisition.ArticleNo = model.ArticleNo;
objRequisition.Thickness = model.Thickness;
if (model.ThicknessUnit != null)
{
objRequisition.ThicknessUnit = model.ThicknessUnit;
}
objRequisition.LeatherSize = model.LeatherSize;
if (model.SizeUnit != null)
{
objRequisition.SizeUnit = model.SizeUnit;
}
objRequisition.Selection = model.Selection;
objRequisition.ProductionQty = model.ProductionQty;
objRequisition.RequisitionState = "RNG";
objRequisition.RequisitionStatus = "PND";
objRequisition.RecordStatus = "NCF";
objRequisition.SetBy = userId;
objRequisition.SetOn = DateTime.Now;
//if (model.BuyerAddressID == 0)
// objPI.BeneficiaryAddressID = null;
//else
// objPI.BeneficiaryAddressID = model.BuyerAddressID;
_context.PRD_ChemProdReq.Add(objRequisition);
_context.SaveChanges();
CurrentRequisitionID = objRequisition.RequisitionID;
#endregion
#region Item Insert
if (model.RequisitionItemList != null)
{
foreach (var item in model.RequisitionItemList)
{
PRD_ChemProdReqItem objItem = new PRD_ChemProdReqItem();
objItem.RequisitionID = CurrentRequisitionID;
objItem.ItemID = Convert.ToInt32(item.ItemID);
if (item.SupplierID == 0)
{
objItem.SupplierID = null;
}
else
{
objItem.SupplierID = item.SupplierID;
}
//objItem.SupplierID = item.SupplierID;
objItem.RequiredQty = item.RequiredQty;
if (item.RequiredUnitName == null)
{
objItem.RequiredUnit = null;
}
else
{
objItem.RequiredUnit = DalCommon.GetUnitCode(item.RequiredUnitName);
}
objItem.RequsitionQty = Convert.ToDecimal(item.RequsitionQty);
objItem.RequisitionUnit = DalCommon.GetUnitCode(item.RequisitionUnitName);
if (item.PackSizeName == null)
{
objItem.PackSize = null;
}
else
{
objItem.PackSize = DalCommon.GetSizeCode(item.PackSizeName);
}
//objItem.PackSize = DalCommon.GetSizeCode(item.PackSizeName);
if (item.SizeUnitName == null)
{
objItem.SizeUnit = null;
}
else
{
objItem.SizeUnit = DalCommon.GetUnitCode(item.SizeUnitName);
}
//objItem.SizeUnit = DalCommon.GetUnitCode(item.SizeUnitName);
objItem.PackQty = item.PackQty;
objItem.ApproveQty = item.ApproveQty;
objItem.ApproveUnit = DalCommon.GetUnitCode(item.ApproveUnitName);
//objItem.ManufacturerID = item.ManufacturerID;
objItem.ItemSource = DalCommon.ReturnItemSource(item.ItemSource);
objItem.SetOn = DateTime.Now;
objItem.SetBy = userId;
_context.PRD_ChemProdReqItem.Add(objItem);
_context.SaveChanges();
}
}
#endregion
}
}
transaction.Complete();
}
return(CurrentRequisitionID);
}
catch (Exception e)
{
return(0);
}
}
