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