public static SubGrpDirectoryResult GetClubsMemberList(GroupInfo input) { try { SubGrpDirectoryResult list = new SubGrpDirectoryResult(); MySqlParameter[] parameterList = new MySqlParameter[2]; parameterList[0] = new MySqlParameter("?groupID", input.grpID); parameterList[1] = new MySqlParameter("?SearchText", input.SearchText); DataSet result = MySqlHelper.ExecuteDataset(GlobalVar.strAppConn, CommandType.StoredProcedure, "V7_USPGetClubMemberList", parameterList); DataTable dtMemberList = result.Tables[0]; DataTable dtDesignation = result.Tables[1]; List <MemberList> memberList = new List <MemberList>(); List <DesignationList> classification = new List <DesignationList>(); if (dtMemberList.Rows.Count > 0) { memberList = GlobalFuns.DataTableToList <MemberList>(dtMemberList); foreach (MemberList mem in memberList) { if (!string.IsNullOrEmpty(mem.pic)) { string ImageName = mem.pic.ToString(); string path = ConfigurationManager.AppSettings["imgPath"] + "Documents/directory/"; mem.pic = path + ImageName; } } } if (dtDesignation.Rows.Count > 0) { classification = GlobalFuns.DataTableToList <DesignationList>(dtDesignation); } list.memberList = memberList; list.classification = classification; return(list); } catch (Exception ex) { throw ex; } }
public object GetClubMembers(GroupInfo input) { dynamic TBMemberList; try { SubGrpDirectoryResult Result = FindClub.GetClubsMemberList(input); if (Result != null) { TBMemberList = new { status = "0", message = "success", Result }; } else { TBMemberList = new { status = "0", message = "Record not found" }; } } catch { TBMemberList = new { status = "1", message = "failed" }; } return(new { TBMemberList }); }
/// <summary> /// Get SubGrp Directory /// </summary> /// <param name="sub"></param> /// <returns></returns> public static SubGrpDirectoryResult GetSubGroupDirectory(SubGrpDirectoryInput sub) { string subGrpIDs = ""; SubGrpDirectoryResult directory = new SubGrpDirectoryResult(); try { // Check if member is group Admin MySqlParameter[] param = new MySqlParameter[3]; param[0] = new MySqlParameter("?grpId", sub.groupId); param[1] = new MySqlParameter("?profileID", sub.profileId); param[2] = new MySqlParameter("?IsAdmin", "0"); param[2].Direction = ParameterDirection.InputOutput; DataSet dsSubgrpIDs = MySqlHelper.ExecuteDataset(GlobalVar.strAppConn, CommandType.StoredProcedure, "V4_SubGroupIsAdmin", param); if (dsSubgrpIDs != null) { for (int i = 0; i < dsSubgrpIDs.Tables[0].Rows.Count; i++) { subGrpIDs += dsSubgrpIDs.Tables[0].Rows[i]["subGrpID"].ToString(); subGrpIDs += ","; } subGrpIDs = subGrpIDs.TrimEnd(','); // Member Is subGroup Admin return subgrp List if (Convert.ToInt32(param[2].Value.ToString()) > 0 && subGrpIDs != "") { if (sub.parentID == "0") { MySqlParameter[] param1 = new MySqlParameter[4]; param1[0] = new MySqlParameter("?grpId", sub.groupId); param1[1] = new MySqlParameter("?profileID", sub.profileId); param1[2] = new MySqlParameter("?subGrpIds", subGrpIDs); param1[3] = new MySqlParameter("?parentID", sub.parentID); var subgrpList = _DbTouchbase.ExecuteStoreQuery <SubGrpListResult>("V4_USPGetSubGrpList(?grpId,?profileID,?subGrpIds,?parentID)", param1).ToList(); directory.subGrpList = subgrpList; } else { MySqlParameter[] param2 = new MySqlParameter[3]; param2[0] = new MySqlParameter("?grpId", sub.groupId); param2[1] = new MySqlParameter("?profileID", sub.profileId); param2[2] = new MySqlParameter("?parentID", sub.parentID); DataSet dsSubgrpList = MySqlHelper.ExecuteDataset(GlobalVar.strAppConn, CommandType.StoredProcedure, "V4_USPGetSubGrpDetails", param2); if (dsSubgrpList != null) { if (dsSubgrpList.Tables[0].Rows.Count > 0) { List <SubGrpListResult> subgrpList = GlobalFuns.DataTableToList <SubGrpListResult>(dsSubgrpList.Tables[0]); directory.subGrpList = subgrpList; } if (dsSubgrpList.Tables[1].Rows.Count > 0) { List <MemberList> memList = GlobalFuns.DataTableToList <MemberList>(dsSubgrpList.Tables[1]); foreach (MemberList mem in memList) { if (!string.IsNullOrEmpty(mem.pic)) { string ImageName = mem.pic.ToString(); string path = ConfigurationManager.AppSettings["imgPath"] + "Documents/directory/"; mem.pic = path + ImageName; } } directory.memberList = memList; } } } } //IF Member Is Not an Admin Then return Member Directory else if (param[2].Value.ToString() == "0" && subGrpIDs != "") { MySqlParameter[] param3 = new MySqlParameter[3]; param3[0] = new MySqlParameter("?grpId", sub.groupId); param3[1] = new MySqlParameter("?profileID", sub.profileId); param3[2] = new MySqlParameter("?subGrpIds", subGrpIDs); var memberList = _DbTouchbase.ExecuteStoreQuery <MemberList>("CALL V4_USPGetSubGrpMemberList(?grpId,?profileID,?subGrpIds)", param3).ToList(); foreach (MemberList mem in memberList) { if (!string.IsNullOrEmpty(mem.pic)) { string ImageName = mem.pic.ToString(); string path = ConfigurationManager.AppSettings["imgPath"] + "Documents/directory/"; mem.pic = path + ImageName; } } directory.memberList = memberList; } } } catch { throw; } if (directory.memberList == null) { directory.memberList = new List <MemberList>(); } if (directory.subGrpList == null) { directory.subGrpList = new List <SubGrpListResult>(); } return(directory); }