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