public static DataSet GetEbulletinList(EbulletinSearch ebull, string searchtext)
{
try
{
//var memId = new MySqlParameter("?memberId", ebull.memberProfileId);
//var groupId = new MySqlParameter("?grpId", ebull.groupId);
//var searchText = new MySqlParameter("?searchText", searchtext);
//var type = new MySqlParameter("?type", ebull.type);
//var isAdmin = new MySqlParameter("?isAdmin", ebull.isAdmin);
//var Result = _DBTouchbase.ExecuteStoreQuery<EbulletinList>("CALL USPGetEbulletinList(?memberId,?grpId,?searchText,?type,?isAdmin)", memId, groupId, searchText, type, isAdmin).ToList();
//foreach (EbulletinList ebulltn in Result)
//{
// if (ebulltn.ebulletinType == "File")
// {
// string ebulletinlink = ebulltn.ebulletinlink.ToString();
// string path = ConfigurationManager.AppSettings["imgPath"] + "/Documents/ebulletin/Group" + ebull.groupId + "/";
// ebulltn.ebulletinlink = path + ebulletinlink;
// }
//}
//return Result;
MySqlParameter[] param = new MySqlParameter[5];
param[0] = new MySqlParameter("?memberId", ebull.memberProfileId);
param[1] = new MySqlParameter("?grpId", ebull.groupId);
param[2] = new MySqlParameter("?searchText", searchtext);
param[3] = new MySqlParameter("?type", ebull.type);
param[4] = new MySqlParameter("?isAdmin", ebull.isAdmin);
DataSet Result = MySqlHelper.ExecuteDataset(GlobalVar.strAppConn, CommandType.StoredProcedure, "V2_USPGetEbulletinList", param);
return(Result);
}
catch (Exception ex)
{
throw ex;
}
}
public object GetEbulletinList(EbulletinSearch ebull)
{
dynamic TBEbulletinListResult;
List <object> EbulletinListResult = new List <object>();
DataSet Result = new DataSet();
try
{
string search = "";
if (ebull.searchText == null)
{
search = "";
}
else
{
search = ebull.searchText;
}
Result = Ebulletin.GetEbulletinList(ebull, search);
DataTable dt = Result.Tables[0];
DataTable dt1 = Result.Tables[1];
List <EbulletinList> res = new List <EbulletinList>();
if (dt.Rows.Count > 0)
{
res = GlobalFuns.DataTableToList <EbulletinList>(dt);
for (int i = 0; i < res.Count; i++)
{
if (!string.IsNullOrEmpty(res[i].ebulletinlink) && res[i].ebulletinType != "Link")
{
string ebulletinlink = res[i].ebulletinlink.ToString();
string path = ConfigurationManager.AppSettings["imgPath"] + "Documents/ebulletin/Group" + ebull.groupId + "/";
res[i].ebulletinlink = path + ebulletinlink;
}
}
}
for (int i = 0; i < res.Count; i++)
{
EbulletinListResult.Add(new { EbulletinList = res[i] });
}
if (res != null && res.Count != 0)
{
TBEbulletinListResult = new { status = "0", message = "success", smscount = dt1.Rows[0]["SMSCount"].ToString(), EbulletinListResult = EbulletinListResult };
}
else
{
TBEbulletinListResult = new { status = "0", message = "Record not found", smscount = dt1.Rows[0]["SMSCount"].ToString(), EbulletinListResult = EbulletinListResult };
}
}
catch
{
TBEbulletinListResult = new { status = "1", message = "failed", smscount = 0 };
}
return(new { TBEbulletinListResult });
}
