public object GetAnnouncementList(AnnouncementSearch ann)
{
dynamic TBAnnounceListResult;
List <object> AnnounListResult = new List <object>();
DataSet Result = new DataSet();
try
{
string search = "";
if (ann.searchText == null)
{
search = "";
}
else
{
search = ann.searchText;
}
Result = Announcement.GetAnnouncementList(ann, search);
DataTable dt = Result.Tables[0];
DataTable dt1 = Result.Tables[1];
List <AnnounceList> res = new List <AnnounceList>();
if (dt.Rows.Count > 0)
{
res = GlobalFuns.DataTableToList <AnnounceList>(dt);
if (!string.IsNullOrEmpty(res[0].announImg))
{
string announ_Image = res[0].announImg.ToString();
string path = ConfigurationManager.AppSettings["imgPath"] + "Documents/announcement/Group" + ann.groupId + "/thumb/";
res[0].announImg = path + announ_Image;
}
}
for (int i = 0; i < res.Count; i++)
{
AnnounListResult.Add(new { AnnounceList = res[i] });
}
if (res != null && res.Count != 0)
{
TBAnnounceListResult = new { status = "0", message = "success", smscount = dt1.Rows[0]["SMSCount"].ToString(), AnnounListResult = AnnounListResult };
}
else
{
TBAnnounceListResult = new { status = "1", message = "Record not found", smscount = dt1.Rows[0]["SMSCount"].ToString(), AnnounListResult = AnnounListResult };
}
}
catch
{
TBAnnounceListResult = new { status = "1", message = "failed", smscount = 0 };
}
return(new { TBAnnounceListResult });
}
public static DataSet GetAnnouncementList(AnnouncementSearch ann, string search)
{
try
{
//var memId = new MySqlParameter("?memberId", ann.memberProfileId);
//var groupId = new MySqlParameter("?grpId", ann.groupId);
//var searchText = new MySqlParameter("?searchText", search);
//var type = new MySqlParameter("?type", ann.type);
//var isAdmin = new MySqlParameter("?isAdmin", ann.isAdmin);
//var Result = _DBTouchbase.ExecuteStoreQuery<AnnounceList>("CALL USPGetAnnouncementList(?memberId,?grpId,?searchText,?type,?isAdmin)", memId, groupId, searchText, type, isAdmin).ToList();
//foreach (AnnounceList announ in Result)
//{
// if (!string.IsNullOrEmpty(announ.announImg))
// {
// string announ_Image = announ.announImg.ToString();
// string path = ConfigurationManager.AppSettings["imgPath"] + "/Documents/announcement/Group" + ann.groupId + "/thumb/";
// announ.announImg = path + announ_Image;
// }
//}
MySqlParameter[] param = new MySqlParameter[6];
param[0] = new MySqlParameter("?memberId", ann.memberProfileId);
param[1] = new MySqlParameter("?grpId", ann.groupId);
param[2] = new MySqlParameter("?moduleId", ann.moduleId);// Added by Nandu on 07/11/2016 Task--> Module replica
param[3] = new MySqlParameter("?searchText", search);
param[4] = new MySqlParameter("?type", ann.type);
param[5] = new MySqlParameter("?isAdmin", ann.isAdmin);
DataSet Result = MySqlHelper.ExecuteDataset(GlobalVar.strAppConn, CommandType.StoredProcedure, "V5_USPGetAnnouncementList", param);
return(Result);
}
catch (Exception ex)
{
throw ex;
}
}
public SearchResults Search(string searchQuery, int classId)
{
using (VCDataModelContainer data = new VCDataModelContainer())
{
searchQuery = searchQuery.ToLower();
SearchResults results = new SearchResults();
Course course = data.Courses.Find(classId);
if (course == null)
{
return(null);
}
List <QuizSearchResult> quizResults = new List <QuizSearchResult>();
foreach (Quiz quiz in course.Quizzes)
{
QuizSearchResult quizSearchResult = new QuizSearchResult();
quizSearchResult.QuizTitle = quiz.Title;
quizSearchResult.QuizId = quiz.Id;
List <QuizQuestion> questions = (from x in quiz.Questions
where x.Question.ToLower().Contains(searchQuery) || x.OptionA.ToLower().Contains(searchQuery) || x.OptionB.ToLower().Contains(searchQuery) || x.OptionC.ToLower().Contains(searchQuery) || x.OptionD.ToLower().Contains(searchQuery)
select x).ToList();
List <QuizQuestionSearch> questionSearch = new List <QuizQuestionSearch>();
foreach (QuizQuestion ques in questions)
{
QuizQuestionSearch q = new QuizQuestionSearch();
q.Question = ques.Question;
q.OptionA = ques.OptionA;
q.OptionB = ques.OptionB;
q.OptionC = ques.OptionC;
q.OptionD = ques.OptionD;
questionSearch.Add(q);
}
quizSearchResult.QuizQuestions = questionSearch;
if (questionSearch.Count != 0)
{
quizResults.Add(quizSearchResult);
}
}
results.QuizResults = quizResults;
List <AssignmentSearchResult> assignmentResults = new List <AssignmentSearchResult>();
foreach (Assignment assignment in course.Assignments)
{
AssignmentSearchResult assignmentResult = new AssignmentSearchResult();
assignmentResult.AssignmentId = assignment.Id;
assignmentResult.AssignmentTitle = assignment.Title;
List <AssignmentQuestion> questions = (from x in assignment.Questions
where x.Question.ToLower().Contains(searchQuery)
select x).ToList();
List <AssignmentQuestionSearch> assignmentSearch = new List <AssignmentQuestionSearch>();
foreach (AssignmentQuestion q in questions)
{
AssignmentQuestionSearch q1 = new AssignmentQuestionSearch();
q1.Question = q.Question;
assignmentSearch.Add(q1);
}
assignmentResult.AssignmentQuestions = assignmentSearch;
if (assignmentSearch.Count != 0)
{
assignmentResults.Add(assignmentResult);
}
}
results.AssignmentResuts = assignmentResults;
List <Announcement> announcements = (from x in course.Announcements
where x.Title.ToLower().Contains(searchQuery) || x.Body.ToLower().Contains(searchQuery)
select x).ToList();
List <AnnouncementSearch> announcementSearch = new List <AnnouncementSearch>();
foreach (Announcement ann in announcements)
{
AnnouncementSearch a = new AnnouncementSearch();
a.Body = ann.Body;
a.Id = ann.Id;
a.Title = ann.Title;
announcementSearch.Add(a);
}
results.Announcements = announcementSearch;
List <Discussion> discussions = (from x in course.Discussions
where x.Body.ToLower().Contains(searchQuery) || x.Title.ToLower().Contains(searchQuery)
select x).ToList();
List <DiscussionSearch> discussionSearch = new List <DiscussionSearch>();
foreach (Discussion dis in discussions)
{
DiscussionSearch d = new DiscussionSearch();
d.Body = dis.Body;
d.Id = dis.Id;
d.Title = dis.Title;
discussionSearch.Add(d);
}
results.Discussions = discussionSearch;
return(results);
}
}
