private void FillObject(_4screen.CSB.DataAccess.Business.ConvertQueue item, SqlDataReader sqlReader)
{
item.ID = sqlReader["COQ_ID"].ToString().ToGuid();
item.Status = (MediaConvertedState)Convert.ToInt32(sqlReader["COQ_Status"]);
item.InsertedDate = Convert.ToDateTime(sqlReader["COQ_InsertedDate"]);
if (sqlReader["COQ_LookID"] != DBNull.Value && !string.IsNullOrEmpty(sqlReader["COQ_LookID"].ToString()))
item.LookID = sqlReader["COQ_LookID"].ToString().ToGuid();
item.ObjectID = sqlReader["OBJ_ID"].ToString().ToGuid();
item.ObjectType = Convert.ToInt32(sqlReader["OBJ_Type"]);
if (sqlReader["COQ_LastTimeStamp"] != DBNull.Value)
item.LastTimeStamp = Convert.ToDateTime(sqlReader["COQ_LastTimeStamp"]);
item.TryingCount = Convert.ToInt32(sqlReader["COQ_TryingCount"]);
item.ServerName = sqlReader["COQ_ServerName"].ToString();
item.UserEmail = sqlReader["COQ_UserEmail"].ToString();
if (sqlReader["COQ_VideoPreviewPictureTimepointSec"] != DBNull.Value)
item.VideoPreviewPictureTimepointSec = Convert.ToDouble(sqlReader["COQ_VideoPreviewPictureTimepointSec"]);
item.EstimatedWorkTimeSec = Convert.ToInt32(sqlReader["COQ_EstimatedWorkTimeSec"]);
item.ConvertMessage = sqlReader["COQ_ConvertMessage"].ToString();
if (sqlReader["COQ_StatisticFileExtension"] != DBNull.Value)
item.StatisticFileExtension = sqlReader["COQ_StatisticFileExtension"].ToString();
if (sqlReader["COQ_StatisticFileSizeByte"] != DBNull.Value)
item.StatisticFileSizeByte = Convert.ToInt32(sqlReader["COQ_StatisticFileSizeByte"]);
if (sqlReader["COQ_StatisticWorkTimeSec"] != DBNull.Value)
item.StatisticWorkTimeSec = Convert.ToInt32(sqlReader["COQ_StatisticWorkTimeSec"]);
}
internal void Update(_4screen.CSB.DataAccess.Business.ConvertQueue item)
{
SqlConnection Conn = new SqlConnection(strConn);
try
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = Conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "hisp_ConvertQueue_Update";
cmd.Parameters.Add(SqlHelper.AddParameter("@COQ_ID", SqlDbType.UniqueIdentifier, item.ID.Value));
cmd.Parameters.Add(SqlHelper.AddParameter("@COQ_Status", SqlDbType.Int, (int)item.Status));
cmd.Parameters.Add(SqlHelper.AddParameter("@COQ_InsertedDate", SqlDbType.DateTime, item.InsertedDate));
if (item.LookID.HasValue)
cmd.Parameters.Add(SqlHelper.AddParameter("@COQ_LookID", SqlDbType.UniqueIdentifier, item.LookID.Value));
else
cmd.Parameters.Add(SqlHelper.AddParameter("@COQ_LookID", SqlDbType.UniqueIdentifier, DBNull.Value));
cmd.Parameters.Add(SqlHelper.AddParameter("@OBJ_ID", SqlDbType.UniqueIdentifier, item.ObjectID.Value));
cmd.Parameters.Add(SqlHelper.AddParameter("@OBJ_Type", SqlDbType.Int, (int)item.ObjectType));
if (item.LastTimeStamp > DateTime.MinValue)
cmd.Parameters.Add(SqlHelper.AddParameter("@COQ_LastTimeStamp", SqlDbType.DateTime, item.LastTimeStamp));
else
cmd.Parameters.Add(SqlHelper.AddParameter("@COQ_LastTimeStamp", SqlDbType.DateTime, DBNull.Value));
cmd.Parameters.Add(SqlHelper.AddParameter("@COQ_TryingCount", SqlDbType.Int, item.TryingCount));
cmd.Parameters.Add(SqlHelper.AddParameter("@COQ_ServerName", SqlDbType.NVarChar, 250, item.ServerName));
cmd.Parameters.Add(SqlHelper.AddParameter("@COQ_UserEmail", SqlDbType.NVarChar, 250, item.UserEmail));
cmd.Parameters.Add(SqlHelper.AddParameter("@COQ_VideoPreviewPictureTimepointSec", SqlDbType.Float, item.VideoPreviewPictureTimepointSec));
cmd.Parameters.Add(SqlHelper.AddParameter("@COQ_EstimatedWorkTimeSec", SqlDbType.Int, item.EstimatedWorkTimeSec));
cmd.Parameters.Add(SqlHelper.AddParameter("@COQ_ConvertMessage", SqlDbType.NVarChar, 500, item.ConvertMessage));
cmd.Parameters.Add(SqlHelper.AddParameter("@COQ_StatisticFileExtension", SqlDbType.NVarChar, 10, item.StatisticFileExtension));
cmd.Parameters.Add(SqlHelper.AddParameter("@COQ_StatisticFileSizeByte", SqlDbType.Int, item.StatisticFileSizeByte));
cmd.Parameters.Add(SqlHelper.AddParameter("@COQ_StatisticWorkTimeSec", SqlDbType.Int, item.StatisticWorkTimeSec));
Conn.Open();
cmd.ExecuteNonQuery();
}
finally
{
Conn.Close();
}
}
