public static Category createCategory(String CategoryId, String CategoryName, String CategoryDescription) { Category obj = new Category(); obj.CategoryId = CategoryId; obj.CategoryName = CategoryName; obj.CategoryDescription = CategoryDescription; return obj; }
public static CategoryDto createCategoryDTO(Category obj) { CategoryDto cat = new CategoryDto(); cat.CategoryId = obj.CategoryId; cat.CategoryName = obj.CategoryName; cat.CategoryDescription = obj.CategoryDescription; return cat; }
public Category selectCategoryById(Category obj) { NewJobBankContext db = new NewJobBankContext(); try { return db.Categories.SqlQuery("dbo.SelectCategoryById @CategoryId='" + obj.CategoryId.ToString() + "'").Single(); } catch (Exception ex) { return null; } }
public Boolean insertCategory(Category obj) { using (NewJobBankContext db = new NewJobBankContext()) { try { db.Categories.Add(obj); db.SaveChanges(); return true; } catch (Exception ex) { return false; } } }
public Boolean deleteCategory(Category obj) { using (NewJobBankContext db = new NewJobBankContext()) { try { Category category = db.Categories.SqlQuery("dbo.SelectCategoryById @CategoryId='" + obj.CategoryId.ToString() + "'").Single(); if (category != null) { db.Categories.Remove(category); #region Database Submission try { db.SaveChanges(); return true; } catch (Exception ex) { return false; } #endregion } else { return false; } } catch (Exception ex) { return false; } } }
public Boolean updateCategory(Category obj) { using (NewJobBankContext db = new NewJobBankContext()) { try { Category category = db.Categories.SqlQuery("dbo.SelectCategoryById @CategoryId='" + obj.CategoryId.ToString() + "'").Single(); if (category != null) { category.CategoryName = obj.CategoryName; category.CategoryDescription = obj.CategoryDescription; #region Database Submission with Rollback try { db.SaveChanges(); return true; } catch (Exception ex) { return false; } #endregion } else { return false; } } catch (Exception ex) { return false; } } }