Пример #1
0
        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;
        }