public int AddQuery(KnowledgeQueryModel queryModel)
{
int queryId = 0;
try
{
queryId = (from ind in DatabaseConnection.KnowledgeQueries
where ind.Query == queryModel.Query && ind.IndustryId == queryModel.IndustryId
&& ind.IndustryCatId == queryModel.IndustryCatId && ind.IndustrySubCatId == queryModel.IndustrySubCatId
select ind.Id).FirstOrDefault();
if (queryId == 0)
{
DatabaseConnection.KnowledgeQueries.Add(new KnowledgeQuery()
{
IndustryId = queryModel.IndustryId,
IndustryCatId = queryModel.IndustryCatId,
IndustrySubCatId = queryModel.IndustrySubCatId,
Query = queryModel.Query
});
DatabaseConnection.SaveChanges();
queryId = (from ind in DatabaseConnection.KnowledgeQueries
where ind.Query == queryModel.Query && ind.IndustryId == queryModel.IndustryId
&& ind.IndustryCatId == queryModel.IndustryCatId && ind.IndustrySubCatId == queryModel.IndustrySubCatId
select ind.Id).FirstOrDefault();
}
else
{
queryId = 0;
}
}
catch (Exception ex)
{
queryId = -1;
new KnowledgeException(ex.Message);
}
return queryId;
}