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;
}
}
}
