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