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