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