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