public static void UpdateCategory(DevCategory category)
{
using (var db = DbHelper.Create())
{
db.UpdateEntity(category);
}
}
public static void InsertCategory(DevCategory category)
{
using (var db = DbHelper.Create())
{
db.InsertEntity(category);
}
}
public static void UpdateCategoryName(DevCategory category)
{
string sql = @"UPDATE [dbo].[DevCategory] SET CategoryName=@CategoryName, MainTable=@MainTable WHERE CategoryId=@CategoryId";
using (var db = DbHelper.Create())
{
db.Execute(sql, category);
}
}
public static void DeleteCategory(DevCategory category)
{
string sql = @"UPDATE[dbo].[DevCategory] SET Deleted = 1 WHERE CategoryId = @CategoryId";
using (var db = DbHelper.Create())
{
db.Execute(sql, category);
}
}
public string UpdateCategoryName(DevCategory category)
{
DevCategoryBusiness.UpdateCategoryName(category);
return "";
}
public JsonResult InsertCategory(DevCategory category)
{
DevCategoryBusiness.InsertCategory(category);
return Json(category);
}
public string DeleteCategory(DevCategory category)
{
category.Deleted = true;
DevCategoryBusiness.DeleteCategory(category);
return "";
}