private bool AddNew([FromBody] RadioBroadcast radioBroadcast)
{
string sql = "INSERT INTO AllRadioBroadcast (BroadcastName, CreateAt, VodID, VodName, FilePath, FileSize, StreamID, StreamName, Type, Duration, Description, Likes, Username, UserEmail, BroadcastOnDate, OneFact)" +
" VALUES (@BroadcastName, @CreateAt, @VodID, @VodName, @FilePath, @FileSize, @StreamID, @StreamName, @Type, @Duration, @Description, @Likes, @Username, @UserEmail, @BroadcastOnDate, @OneFact) ";
return(DB.ExecuteCommand(sql, (cmd) =>
{
cmd.Parameters.AddWithValueCheckNull("@BroadcastName", radioBroadcast.BroadcastName);
cmd.Parameters.AddWithValueCheckNull("@CreateAt", radioBroadcast.CreateAt);
cmd.Parameters.AddWithValueCheckNull("@VodID", radioBroadcast.VodID);
cmd.Parameters.AddWithValueCheckNull("@VodName", radioBroadcast.VodName);
cmd.Parameters.AddWithValueCheckNull("@FilePath", radioBroadcast.FilePath);
cmd.Parameters.AddWithValueCheckNull("@FileSize", radioBroadcast.FileSize);
cmd.Parameters.AddWithValueCheckNull("@StreamID", radioBroadcast.StreamID);
cmd.Parameters.AddWithValueCheckNull("@StreamName", radioBroadcast.StreamName);
cmd.Parameters.AddWithValueCheckNull("@Type", radioBroadcast.Type);
cmd.Parameters.AddWithValueCheckNull("@Duration", radioBroadcast.Duration);
cmd.Parameters.AddWithValueCheckNull("@Description", radioBroadcast.Description);
cmd.Parameters.AddWithValueCheckNull("@Likes", radioBroadcast.Likes);
cmd.Parameters.AddWithValueCheckNull("@Username", radioBroadcast.Username);
cmd.Parameters.AddWithValueCheckNull("@UserEmail", radioBroadcast.UserEmail);
cmd.Parameters.AddWithValueCheckNull("@BroadcastOnDate", radioBroadcast.BroadcastOnDate);
cmd.Parameters.AddWithValueCheckNull("@OneFact", radioBroadcast.OneFact);
}, true) == 1);
}
public RadioBroadcast GetByID(int broadcastID)
{
RadioBroadcast radioBroadcast = new RadioBroadcast();
string sql = "SELECT * FROM AllRadioBroadcast WHERE BroadcastID=@BroadcastID";
DB.PullFromDB(sql,
(cmd) => cmd.Parameters.AddWithValueCheckNull("@BroadcastID", broadcastID),
(dr) => radioBroadcast = new RadioBroadcast(dr));
return(radioBroadcast);
}
public bool Update([FromBody] RadioBroadcast radioBroadcast)
{
string sql = "UPDATE AllRadioBroadcast SET Username=@Username, UserEmail=@UserEmail, OneFact=@OneFact WHERE BroadcastID=@BroadcastID";
return(DB.ExecuteCommand(sql, (cmd) =>
{
cmd.Parameters.AddWithValueCheckNull("@Username", radioBroadcast.Username);
cmd.Parameters.AddWithValueCheckNull("@UserEmail", radioBroadcast.UserEmail);
cmd.Parameters.AddWithValueCheckNull("@OneFact", radioBroadcast.OneFact);
cmd.Parameters.AddWithValueCheckNull("@BroadcastID", radioBroadcast.BroadcastID);
}, true) == 0);
}
