/// CompanyID Provided but Static
public vmFinishGood GetRawMaterial(int id, int typeId, int companyId)
{
GenericFactoryFor_FabricDevelopment = new FabricDevelopment_EF();
vmFinishGood _objFinishGood = null;
string spQuery = string.Empty;
try
{
using (_ctxCmn = new ERP_Entities())
{
Hashtable ht = new Hashtable();
ht.Add("CompanyID", companyId);
ht.Add("LoggedUser", 0);
ht.Add("PageNo", 0);
ht.Add("RowCountPerPage", 0);
ht.Add("IsPaging", 0);
ht.Add("ItemTypeID", typeId);
ht.Add("ItemGroupID", 0);
ht.Add("ItemID", id);
spQuery = "[SPGetItemDetail]";
_objFinishGood = GenericFactoryFor_FabricDevelopment.ExecuteQuery(spQuery, ht).FirstOrDefault();
}
}
catch (Exception e)
{
e.ToString();
}
return(_objFinishGood);
}
/// No CompanyID Provided
public vmFinishGood GetFinishGoodById(int id)
{
GenericFactory_EF_CmnItemMaster = new CmnItemMaster_EF();
try
{
List <CmnItemMaster> _ItemMasterobj = GenericFactory_EF_CmnItemMaster.GetAll().Where(x => x.IsDeleted == false && x.ItemTypeID == 1 && x.ItemID == id).ToList();
vmFinishGood _vmItemMaster = (from olt in _ItemMasterobj
select new vmFinishGood
{
ItemID = olt.ItemID,
PDLRef = olt.ArticleNo,
FiniWtID = olt.FinishingWeightID,
FiniWt = olt.CmnItemFinishingWeight.FinishingWeigth,
WarpYarnCount = olt.RndYarnCR == null ? "" : olt.RndYarnCR.YarnCount,
// WarpYarnCountId = olt.WarpYarnID,
WarpRatio = olt.RndYarnCR == null ? "" : olt.RndYarnCR.YarnRatio,
WarpSLlot = "",
WeftYCount = olt.RndYarnCR1 == null ? "" : olt.RndYarnCR1.YarnCount,
WeftRatio = olt.RndYarnCR1 == null ? "" : olt.RndYarnCR1.YarnRatio,
WeftSLlot = "",
//WeftSuppliter = olt.CmnUser2 == null ? "" : olt.CmnUser2.UserFullName,
WeftSupplierId = olt.WeftSupplierID,
GerigeEPIxPPI = olt.EPI + "x" + olt.PPI,
GPPI = olt.GPPI,
Color = olt.CmnItemColor == null ? "" : olt.CmnItemColor.ColorName,
ColorID = olt.ItemColorID,
Weave = olt.Weave,
SetNo = olt.SetNo,
FlangeNo = olt.FlangeNo,
TotalEnds = olt.TotalEnds,
// Lengthyds = olt.Length,
//Buyer = olt.CmnUser == null ? "" : olt.CmnUser.UserFullName,
//Buyerref = olt.CmnUser1 == null ? "" : olt.CmnUser1.UserFullName,
BuyerrefId = olt.BuyerRefID,
Need = olt.Note,
Remark = olt.Description,
ItemGroup = olt.CmnItemGroup == null ? "" : olt.CmnItemGroup.ItemGroupName,
ItemGroupID = olt.ItemGroupID,
//FinishProcess = olt.PrdFinishingType == null ? "" : olt.PrdFinishingType.FInishTypeName,
//FinishProcessId = olt.FinishingTypeID,
CuttableWidth = olt.CuttableWidth,
HSCODE = olt.HSCODE,
//WeftYCountId = olt.WeftYarnID,
WeightPerUnit = olt.WeightPerUnit,
ItemName = olt.ItemName,
BuyerID = olt.BuyerID,
GEPI = olt.GEPI
}).FirstOrDefault();
return(_vmItemMaster);
}
catch (Exception)
{
throw;
}
}
public vmFinishGood GetRawMaterial(int id, int typeId, int companyID)
{
vmFinishGood _objFinishGood = null;
try
{
_objFinishGood = objCmnRawMaterial.GetRawMaterial(id, typeId, companyID);
}
catch (Exception e)
{
e.ToString();
}
return(_objFinishGood);
}
public vmFinishGood GetFabricDevelopmentDetailByID(int id)
{
vmFinishGood _objvmFinishGood = null;
try
{
_objvmFinishGood = _objFinishGood.GetFabricDevelopmentDetailsByID(id);
}
catch (Exception e)
{
e.ToString();
}
return(_objvmFinishGood);
}
public vmFinishGood GetFinishGoodById(int id)
{
vmFinishGood _objvmFinishGood = null;
try
{
_objvmFinishGood = _objFinishGood.GetFinishGoodsById(id); //_objFinishGood.GetFinishGoodById(id);
}
catch (Exception e)
{
e.ToString();
}
return(_objvmFinishGood);
}
