public int AddIndustryCategory(IndustryCategoryModel categoryModel) { int CategoryId = 0; try { CategoryId = (from cat in DatabaseConnection.IndustryCategories where cat.CategoryName.ToLower() == categoryModel.CategoryName.ToLower() select cat.Id).FirstOrDefault(); if (CategoryId == 0) { DatabaseConnection.IndustryCategories.Add(new WorldRef.IndustryCategory() { IndustryId = categoryModel.IndustryId, CategoryName = categoryModel.CategoryName, createdon = DateTime.Now }); DatabaseConnection.SaveChanges(); CategoryId = (from cat in DatabaseConnection.IndustryCategories where cat.CategoryName.ToLower() == categoryModel.CategoryName.ToLower() select cat.Id).FirstOrDefault(); } } catch (Exception ex) { CategoryId = 0; } return CategoryId; }
public int AddIndustryCategory(IndustryCategoryModel categoryModel) { int CategoryId = 0; try { CategoryId = (from cat in DatabaseConnection.IndustryCategories where cat.CategoryName.ToLower() == categoryModel.CategoryName.ToLower() select cat.Id).FirstOrDefault(); if (CategoryId == 0) { DatabaseConnection.IndustryCategories.Add(new WorldRef.IndustryCategory() { IndustryId = categoryModel.IndustryId, CategoryName = categoryModel.CategoryName, createdon = DateTime.Now }); DatabaseConnection.SaveChanges(); CategoryId = (from cat in DatabaseConnection.IndustryCategories where cat.CategoryName.ToLower() == categoryModel.CategoryName.ToLower() select cat.Id).FirstOrDefault(); } } catch (Exception ex) { CategoryId = 0; } return(CategoryId); }