/// <summary> /// Inserts a category into the database /// </summary> /// <param name="entity"></param> /// <returns></returns> public override bool InsertCategory(ref CategoryInfo entity) { DbCommand cmd = SqlHelpers.CreateCommand(DataHelpers.ConnectionString); cmd.CommandText = "dbo.mon_elrn_INSERT_CATEGORY"; cmd.AddInputParam("@Name", DbType.AnsiString, entity.CategoryName); cmd.AddInputParam("@Visible", DbType.Boolean, entity.Visible); cmd.AddInputParam("@ApplicationName", DbType.String, System.Web.Security.Membership.Provider.ApplicationName); int result; result = Convert.ToInt32(cmd.ExecuteSelectTable().Rows[0].ItemArray[0].ToString()); if (result > 0) return true; else return false; }
public static bool UpdateCategory(CategoryInfo entity) { return Instance.UpdateCategory(entity); }
/// <summary> /// Updates a category into the database /// </summary> /// <param name="entity"></param> /// <returns></returns> public override bool UpdateCategory(CategoryInfo entity) { DbCommand cmd = SqlHelpers.CreateCommand(DataHelpers.ConnectionString); cmd.CommandText = "dbo.mon_elrn_UPDATE_CATEGORY"; cmd.AddInputParam("@Id", DbType.Int32, entity.Id); cmd.AddInputParam("@Name", DbType.AnsiString, entity.CategoryName); cmd.AddInputParam("@Visible", DbType.Boolean, entity.Visible); return Convert.ToBoolean(SqlHelpers.ExecuteNonQuery(cmd)); }
//Category related functions public static bool InsertCategory(ref CategoryInfo entity) { return Instance.InsertCategory(ref entity); }