/// <summary> /// Inserts an audio into the database /// </summary> /// <param name="entity"></param> /// <returns></returns> public static bool InsertAudio(ref AudioInfo entity) { DbCommand cmd = SqlHelpers.CreateCommand(DataHelpers.ConnectionString); cmd.CommandText = "dbo.mon_elrn_INSERT_AUDIO"; cmd.AddInputParam("@ClassId", DbType.Int32, entity.ClassId); cmd.AddInputParam("@Title", DbType.AnsiString, entity.Title); cmd.AddInputParam("@Description", DbType.AnsiString, entity.Description); cmd.AddInputParam("@FilePath", DbType.AnsiString, entity.FilePath); cmd.AddInputParam("@Speakers", DbType.AnsiString, entity.Speakers); cmd.AddInputParam("@Visible", DbType.Boolean, entity.Visible); cmd.AddInputParam("@CreatedTimestamp", DbType.DateTime, entity.CreatedTimestamp); cmd.AddInputParam("@UpdatedTimestamp", DbType.DateTime, entity.UpdatedTimestamp); int result; result = Convert.ToInt32(SqlHelpers.ExecuteNonQuery(cmd)); if (result > 0) return true; else return false; }
/// <summary> /// Updates an audio into the database /// </summary> /// <param name="entity"></param> /// <returns></returns> public static bool UpdateAudio(AudioInfo entity) { DbCommand cmd = SqlHelpers.CreateCommand(DataHelpers.ConnectionString); cmd.CommandText = "dbo.mon_elrn_UPDATE_AUDIO"; cmd.AddInputParam("@Id", DbType.Int32, entity.Id); cmd.AddInputParam("@ClassId", DbType.Int32, entity.ClassId); cmd.AddInputParam("@Title", DbType.AnsiString, entity.Title); cmd.AddInputParam("@Description", DbType.AnsiString, entity.Description); cmd.AddInputParam("@Speakers", DbType.AnsiString, entity.Speakers); cmd.AddInputParam("@Visible", DbType.Boolean, entity.Visible); cmd.AddInputParam("@CreatedTimestamp", DbType.DateTime, entity.CreatedTimestamp); cmd.AddInputParam("@UpdatedTimestamp", DbType.DateTime, DateTime.UtcNow); return Convert.ToBoolean(SqlHelpers.ExecuteNonQuery(cmd)); }
public static AudioInfo ToAudioInfo(this DataRow dr) { AudioInfo a = new AudioInfo(); a.Id = dr.GetInt("ID"); a.Id = dr.GetInt("ID"); a.ClassId = dr.GetInt("ClassId"); a.Title = dr.GetString("Title"); a.Description = dr.GetString("Description"); a.FilePath = dr.GetString("FilePath"); if (!dr.IsNull("Speakers")) a.Speakers = dr.GetString("Speakers"); a.Visible = dr.GetBoolean("Visible", true); a.CreatedTimestamp = dr.GetDate("CreatedTimestamp"); a.UpdatedTimestamp = dr.GetDate("UpdatedTimestamp"); return a; }