public vmItemGroup GetItemGroupByID(int id)
{
vmItemGroup _objvmItemGroups = null;
List <CmnItemGroup> objAllItemGroups = null;
List <CmnItemGroup> objItemGroup = null;
List <CmnItemType> _objCmnItemTypes = null;
try
{
objItemGroup = GenericFactory_EF_ItemGroup.FindBy(m => m.ItemGroupID == id).ToList();
_objCmnItemTypes = GenericFactory_EF_ItemType.GetAll().Where(x => x.IsDeleted == false).ToList();
objAllItemGroups = GenericFactory_EF_ItemGroup.GetAll().Where(x => x.IsDeleted == false).ToList();
_objvmItemGroups = (from ig in objItemGroup
join it in _objCmnItemTypes on ig.ItemTypeID equals it.ItemTypeID
where ig.ItemGroupID == id
select new vmItemGroup
{
ItemGroupID = ig.ItemGroupID,
ItemGroupName = ig.ItemGroupName,
Type = it.ItemTypeName,
TypeId = ig.ItemTypeID,
IsActive = ig.IsActive == true ? "Yes" : "NO",
ParentId = ig.ParentID,
Parent = ig.ParentID == null ? null : (from re in objAllItemGroups
where re.ItemGroupID == ig.ParentID
select re.ItemGroupName).FirstOrDefault()
}).FirstOrDefault();
}
catch (Exception e)
{
e.ToString();
}
return(_objvmItemGroups);
}
public vmItemGroup GetItemGroupByID(int?GID, int?CompanyID)
{
GenericFactoryFor_VmItemGroup = new vmItemGroup_GF();
vmItemGroup _objvmItemGroup = 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", 0);
ht.Add("ItemGroupID", GID);
spQuery = "[SPGetItemGroupDetail]";
_objvmItemGroup = GenericFactoryFor_VmItemGroup.ExecuteQuery(spQuery, ht).FirstOrDefault();
}
}
catch (Exception e)
{
e.ToString();
}
return(_objvmItemGroup);
}
public vmItemGroup GetItemGroupById(int?GID, int?CompanyID)
{
vmItemGroup objItemGroup = null;
try
{
objItemGroup = objItemGroupMgtFF.GetItemGroupByID(GID, CompanyID);
}
catch (Exception e)
{
e.ToString();
}
return(objItemGroup);
}
