public int SubAddIndustryCategory(IndustrySubCatModel subcategoryModel)
{
int SubCategoryId = 0;
try
{
SubCategoryId = (from sub in DatabaseConnection.IndustrySubCategories
where sub.SubCategoryName.ToLower() == subcategoryModel.SubCategoryName.ToLower()
select sub.Id).FirstOrDefault();
if (SubCategoryId == 0)
{
DatabaseConnection.IndustrySubCategories.Add(new WorldRef.IndustrySubCategory()
{
IndustryId = subcategoryModel.IndustryId,
IndusCategoryId = subcategoryModel.CategoryId,
SubCategoryName = subcategoryModel.SubCategoryName,
createdon = DateTime.Now
});
DatabaseConnection.SaveChanges();
SubCategoryId = (from sub in DatabaseConnection.IndustrySubCategories
where sub.SubCategoryName.ToLower() == subcategoryModel.SubCategoryName.ToLower()
select sub.Id).FirstOrDefault();
}
}
catch (Exception ex)
{
SubCategoryId = 0;
new KnowledgeException(ex.Message);
}
return(SubCategoryId);
}
public int SubAddIndustryCategory(IndustrySubCatModel subcategoryModel)
{
int SubCategoryId = 0;
try
{
SubCategoryId = (from sub in DatabaseConnection.IndustrySubCategories
where sub.SubCategoryName.ToLower() == subcategoryModel.SubCategoryName.ToLower()
select sub.Id).FirstOrDefault();
if (SubCategoryId == 0)
{
DatabaseConnection.IndustrySubCategories.Add(new WorldRef.IndustrySubCategory()
{
IndustryId = subcategoryModel.IndustryId,
IndusCategoryId = subcategoryModel.CategoryId,
SubCategoryName = subcategoryModel.SubCategoryName,
createdon = DateTime.Now
});
DatabaseConnection.SaveChanges();
SubCategoryId = (from sub in DatabaseConnection.IndustrySubCategories
where sub.SubCategoryName.ToLower() == subcategoryModel.SubCategoryName.ToLower()
select sub.Id).FirstOrDefault();
}
}
catch (Exception ex)
{
SubCategoryId = 0;
new KnowledgeException(ex.Message);
}
return SubCategoryId;
}
