public OperationStatus UpdateWatermarkProcessingDetails(VIDEO_WATERMARK_DTO obj)
{
int effectedRows;
SqlTransaction transaction = null;
var connection = ConnectionStringHelper.getSqlConnection();
try
{
var query = @"
UPDATE VIDEO_WATERMARK
SET IS_PROCESSED = @IS_PROCESSED,
IS_PROCESSING = @IS_PROCESSING,
CONVERTED_DT_STAMP = @CONVERTED_DT_STAMP,
ERROR_MESSAGE = @ERROR_MESSAGE
WHERE UDTUNIQUEROW = @UDTUNIQUEROW
";
connection.Open();
transaction = connection.BeginTransaction();
using (var command = new SqlCommand(query, connection, transaction))
{
command.Parameters.AddRange(new SqlParameter[] {
new SqlParameter("@UDTUNIQUEROW", obj.UDTUNIQUEROW),
new SqlParameter("@IS_PROCESSED", Convert.ToInt32(obj.IS_PROCESSED)),
new SqlParameter("@IS_PROCESSING", Convert.ToInt32(obj.IS_PROCESSING)),
new SqlParameter("@CONVERTED_DT_STAMP", (object)obj.CONVERTED_DT_STAMP ?? DBNull.Value),
new SqlParameter("@ERROR_MESSAGE", (object)obj.ERROR_MESSAGE ?? DBNull.Value)
});
effectedRows = command.ExecuteNonQuery();
}
if (effectedRows == 1)
{
transaction.Commit();
return(new OperationStatus(true, $"Successfully updated {effectedRows} Rows"));
}
else
{
transaction.Rollback();
return(new OperationStatus(false, $"Executed {effectedRows} Records"));
}
}
catch (Exception ex)
{
if (transaction != null)
{
transaction.Rollback();
}
return(new OperationStatus(false, "Exception Occoured", ex.Message));
}
finally
{
connection.Close();
}
}
public OperationStatus GetNonConvertedDatas()
{
System.Data.DataTable datas = new System.Data.DataTable();
try
{
var query = "SELECT * FROM VIDEO_WATERMARK WHERE IS_PROCESSED = 0 AND IS_PROCESSING = 0";
using (var adapter = new SqlDataAdapter(query, ConnectionStringHelper.getSqlConnection()))
{
adapter.Fill(datas);
}
if (datas == null && datas.Rows.Count == 0)
{
return(new OperationStatus(true, null));
}
else
{
return(new OperationStatus(true, VIDEO_WATERMARK_DTO.ToList(datas)));
}
}
catch (Exception ex)
{
return(new OperationStatus(false, error: ex.Message));
}
}
