/// <summary> /// @author : TrungMT /// @CreateDate:04/07/2008 /// @Description: Update 1 DownloadLog with DownloadLog_id /// </summary> /// <param name="pDownloadLog">DownloadLog</param> public int UpdateDownloadedAll(DownloadLog pDownloadLog) { IDbDataParameter[] parameters = { MakeParameter("@WORKSTATION_ID", DbType.Int32, 8), MakeParameter("@SCHEDULE_DATE", DbType.Date, 10), MakeParameter("@DOWNLOADED_ALL", DbType.Int16, 32), }; parameters[0].Value = pDownloadLog.WorkstationID; parameters[1].Value = pDownloadLog.ScheduleDate; parameters[2].Value = pDownloadLog.DownloadedAll; int rowAffected = 0; RunProcedure("sp_ADV_DownloadLog_UPDATE_DOWNLOADED", parameters, out rowAffected); return rowAffected; }
/// <summary> /// @author : TrungMT /// @CreateDate:04/07/2008 /// @Description: Update 1 DownloadLog with DownloadLog_id /// </summary> /// <param name="pDownloadLog">DownloadLog</param> public int UpdateCreatedPlaylist(DownloadLog pDownloadLog) { IDbDataParameter[] parameters = { MakeParameter("@WORKSTATION_ID", DbType.Int32, 8), MakeParameter("@SCHEDULE_DATE", DbType.Date, 10), MakeParameter("@CREATED_PLAYLIST", DbType.Int16, 32), }; parameters[0].Value = pDownloadLog.WorkstationID; parameters[1].Value = pDownloadLog.ScheduleDate; parameters[2].Value = pDownloadLog.CreatedPlaylist; int rowAffected = 0; RunProcedure("sp_ADV_DownloadLog_UPDATE_CREATED_PLS", parameters, out rowAffected); return rowAffected; }
/// <summary> /// @author : TrungMT /// @CreateDate:04/07/2008 /// @Description: update downloaded status /// </summary> public int UpdateDownloadedAll(DownloadLog pDownloadLog) { PrDownloadLog DownloadLog = new PrDownloadLog(Connection); int intRowAffected = 0; try { Open(); intRowAffected = DownloadLog.UpdateDownloadedAll(pDownloadLog); Commit(); } catch (Exception exp) { Rollback(); throw exp; } finally { Close(); } return intRowAffected; }