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