public PRDChemProdReq GetRequisitionDetailsAfterSearch(int _RequisitionID)
{
var model = new PRDChemProdReq();
var RequisitionInfo = (from r in _context.PRD_ChemProdReq.AsEnumerable()
where r.RequisitionID == _RequisitionID
join re in _context.PRD_Recipe on(r == null?null:r.RecipeID) equals re.RecipeID into Recepies
from re in Recepies.DefaultIfEmpty()
join c in _context.Sys_Color on(re == null? null: re.ArticleColor) equals c.ColorID into Colors
from c in Colors.DefaultIfEmpty()
join u in _context.Sys_Unit on(re == null ? 0 : re.BaseUnit) equals u.UnitID into Units
from u in Units.DefaultIfEmpty()
select new PRDChemProdReq
{
RequisitionID = r.RequisitionID,
RequisitionNo = r.RequisitionNo,
RequisitionCategory = r.RequisitionCategory,
RequisitionType = r.RequisitionType,
ReqRaisedOn = (Convert.ToDateTime(r.ReqRaisedOn)).ToString("dd'/'MM'/'yyyy"),
RequiredByTime = (r.RequiredByTime == 0? null: r.RequiredByTime),
ReqRaisedBy = (r.ReqRaisedBy),
RequisitionFrom = r.RequisitionFrom,
RequisitionTo = r.RequisitionTo,
RecipeFor = (r.RecipeFor),
RecipeID = (r.RecipeID),
ArticleNo = r.ArticleNo,
ArticleName = (re == null? null: re.ArticleName),
ArticleChallanNo = (re == null ? null : re.ArticleChallanNo),
ArticleColor = (re == null ? null : re.ArticleColor),
ArticleColorName = (c == null ? null : c.ColorName),
BaseQuantity = (re == null ? null : (re.BaseQuantity).ToString()),
//BaseUnit = (re == null ? null : re.BaseUnit),
BaseUnitName = (u == null ? null : u.UnitName),
LeatherSize = r.LeatherSize,
SizeUnit = (r.SizeUnit),
Selection = r.Selection,
Thickness = r.Thickness,
ThicknessUnit = (r.ThicknessUnit),
ProductionQty = (r.ProductionQty == 0 ? null : r.ProductionQty),
ProductionQuantityUnit = (u == null ? null : u.UnitName),
RecordStatus = r.RecordStatus
}).FirstOrDefault();
model.RequisitionInfo = RequisitionInfo;
model.RequisitionItemList = GetRequisitionItemList(_RequisitionID, RequisitionInfo.RequisitionTo);
return(model);
}
public ValidationMsg Save(PRDChemProdReq model, int userId, string pageUrl)
{
var transactionOption = new TransactionOptions {
Timeout = new TimeSpan(0, 0, 99999)
};
var vMsg = new ValidationMsg();
using (var transactionScope = new TransactionScope(TransactionScopeOption.RequiresNew, transactionOption))
{
try
{
_dalProductionRequisition = new DalProductionRequisition();
RequisitionID = _dalProductionRequisition.Save(model, userId, pageUrl);
//GetpurchaseID(purchaseID);
if (RequisitionID > 0)
{
transactionScope.Complete();
vMsg.Type = Enums.MessageType.Success;
vMsg.Msg = "Saved successfully.";
//vMsg.ReturnId = _dalChemicalForeignPurchaseOrder.GetOrderNo(OrderID);
}
else
{
vMsg.Type = Enums.MessageType.Error;
vMsg.Msg = "Failed to save.";
}
}
catch (Exception e)
{
vMsg.Type = Enums.MessageType.Error;
vMsg.Msg = "Failed to save.";
}
}
return(vMsg);
}
public ActionResult ProductionRequisition(PRDChemProdReq model)
{
if (model.RequisitionID == 0)
{
//Convert.ToInt32(Session["UserID"])
var msg = objBLL.Save(model, 1, "ProductionRequisition/ProductionRequisition");
var RequisitionID = objBLL.GetRequisitionID();
var RequisitionNo = objDal.GetRequisitionNo(RequisitionID);
var RequisitionTo = objDal.GetRequisitionToInfo(RequisitionID);
var RequisitionItemList = objDal.GetRequisitionItemList(RequisitionID, RequisitionTo);
return(Json(new { Msg = msg, RequisitionID = RequisitionID, RequisitionNo = RequisitionNo, RequisitionItemList = RequisitionItemList }, JsonRequestBehavior.AllowGet));
}
else
{
var msg = objBLL.Update(model, 1);
var RequisitionTo = objDal.GetRequisitionToInfo(model.RequisitionID);
var RequisitionItemList = objDal.GetRequisitionItemList(model.RequisitionID, RequisitionTo);
return(Json(new { Msg = msg, RequisitionItemList = RequisitionItemList }, JsonRequestBehavior.AllowGet));
}
}
public ValidationMsg Update(PRDChemProdReq 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
{
_dalProductionRequisition = new DalProductionRequisition();
var UpdateStatus = _dalProductionRequisition.Update(model, userId);
if (UpdateStatus > 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 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);
}
}
// After Requisition LOV
public PRDChemProdReq GetRequisitionDetailsFromFixedStore(int _RequisitionID, byte _RequisitionAt)
{
var FinalStock = DalChemicalStock.ItemWiseStockInSpecificChemicalStore(_RequisitionAt);
var model = new PRDChemProdReq();
var RequisitionInfo = (from r in _context.PRD_ChemProdReq.AsEnumerable()
where r.RequisitionID == _RequisitionID
from u in _context.Users.Where(x => x.UserID == r.ReqRaisedBy).DefaultIfEmpty()
select new PRDChemProdReq
{
RequisitionID = r.RequisitionID,
RequisitionNo = r.RequisitionNo,
JobOrderID = Convert.ToInt16(r.JobOrderID),
JobOrderNo = r.JobOrderNo,
ReqRaisedOn = (Convert.ToDateTime(r.ReqRaisedOn)).ToString("dd'/'MM'/'yyyy"),
ReqRaisedBy = Convert.ToInt16(r.ReqRaisedBy),
ReqRaisedByName = (u == null ? null : (u.FirstName + " " + u.MiddleName + " " + u.LastName)),
RequiredByTime = Convert.ToByte(r.RequiredByTime),
RequisitionCategory = DalCommon.ReturnRequisitionCategory(r.RequisitionCategory),
RequisitionType = DalCommon.ReturnOrderType(r.RequisitionType),
IssueTo = r.RequisitionFrom,
IssueFrom = _RequisitionAt
}).FirstOrDefault();
model.RequisitionInfo = RequisitionInfo;
var RequisitionItemList = (from i in _context.PRD_ChemProdReqItem.AsEnumerable()
where i.RequisitionID == _RequisitionID
from it in _context.Sys_ChemicalItem.Where(x => x.ItemID == i.ItemID).DefaultIfEmpty()
join s in FinalStock on i.ItemID equals s.ItemID into badhon
from item in badhon.DefaultIfEmpty()
join su in _context.Sys_Unit on(item == null? 0: item.UnitID) equals su.UnitID into StockUnits
from su in StockUnits.DefaultIfEmpty()
join sup in _context.Sys_Supplier on(item == null ? 0 : item.SupplierID) equals sup.SupplierID into badhon2
from finalitem in badhon2.DefaultIfEmpty()
from siu in _context.Sys_Unit.Where(x => x.UnitID == i.SizeUnit).DefaultIfEmpty()
from ru in _context.Sys_Unit.Where(x => x.UnitID == i.RequisitionUnit).DefaultIfEmpty()
from ps in _context.Sys_Size.Where(x => x.SizeID == i.PackSize).DefaultIfEmpty()
select new PRDChemProdReqItem
{
ItemID = i.ItemID,
ItemName = (it == null ? null : it.ItemName),
StockQty = (item == null ? 0 : item.ClosingQty),
StockUnitName = (su == null ? null : su.UnitName),
SupplierID = (finalitem == null ? 0 : finalitem.SupplierID),
SupplierName = (finalitem == null ? null : finalitem.SupplierName),
PackSizeName = (ps == null ? null : ps.SizeName),
SizeUnitName = (siu == null ? null : siu.UnitName),
PackQty = Convert.ToInt16(i.PackQty),
RequsitionQty = i.RequsitionQty,
RequisitionUnitName = (ru == null ? null : ru.UnitName),
IssuePackSizeName = "Press F9",
IssueUnitName = "",
//IssuePackSize = Convert.ToByte(i.PackSize),
//IssuePackSizeName = (ps == null ? null : ps.SizeName),
//IssueSizeUnit = Convert.ToByte(i.SizeUnit),
//IssueSizeUnitName = (siu == null ? null : siu.UnitName),
//IssuePackQty = Convert.ToInt16(i.PackQty),
//IssueQty = i.RequsitionQty,
//IssueUnit = i.RequisitionUnit,
//IssueUnitName = (ru == null ? null : ru.UnitName),
ItemSource = "Via Requisition"
}).ToList();
model.RequisitionItemList = RequisitionItemList;
return(model);
}