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); }