/// <summary> /// Add knowledge Query to database /// </summary> /// <param name="queryModel"></param> /// <returns></returns> public string AddKnowledgeQuery(KnowledgeQueryModel queryModel) { string returnString = string.Empty; try { int ind = int.Parse(queryModel.Industry); int cat = int.Parse(queryModel.IndustryCategoryId); int subCat = int.Parse(queryModel.IndustrySubCatId); var question = (from q in context.KnowledgeQueries where q.Query.ToLower() == queryModel.Query.ToLower() && q.IndustryId == ind && q.IndustryCatId == cat && q.IndustrySubCatId == subCat select q).FirstOrDefault(); if (question != null) { return returnString = "Question Already Asked."; } context.KnowledgeQueries.Add(new KnowledgeQuery() { IndustryId = ind, IndustryCatId = Convert.ToInt32(queryModel.IndustryCategoryId), IndustrySubCatId = Convert.ToInt32(queryModel.IndustrySubCatId), Query = queryModel.Query, CreatedOn = DateTime.Now }); context.SaveChanges(); } catch (Exception ex) { returnString = "Fail"; } return returnString; }
public string AddQueryAnswerByUser(KnowledgeQueryModel queryModel) { string returnString = string.Empty; try { context.KnowledgeQueryAnswers.Add(new KnowledgeQueryAnswer() { QueryID = queryModel.QueryId, UserId = queryModel.UserId, QueryAnswer = queryModel.QueryAnswer, createdOn = DateTime.Now, Relevant = queryModel.Relevant }); context.SaveChanges(); } catch (Exception ex) { returnString = "Fail"; } return returnString; }