/// <summary> /// Insert by providing a populated data contract /// </summary> /// <param name="row">The table row data to use</param> /// <param name="connection">The SqlConnection to use</param> /// <param name="transaction">The SqlTransaction to use</param> /// <returns>1, if insert was successful</returns> public int Insert(ContentInspectionContract row, SqlConnection connection, SqlTransaction transaction) { int?result = null; using ( var cmd = new SqlCommand("[Data].[ContentInspection_Insert]", connection) { CommandType = CommandType.StoredProcedure, Transaction = transaction }) { cmd.Parameters.AddRange(new[] { new SqlParameter("@IsArchived", row.IsArchived) , new SqlParameter("@IsBeingProposed", row.IsBeingProposed) , new SqlParameter("@ProposedByUserId", row.ProposedByUserId) , new SqlParameter("@ConfirmedByUserId", row.ConfirmedByUserId) , new SqlParameter("@FalseInfoCount", row.FalseInfoCount) , new SqlParameter("@TrueInfoCount", row.TrueInfoCount) , new SqlParameter("@AdminInpsected", row.AdminInpsected) , new SqlParameter("@DateLastChecked", row.DateLastChecked) , new SqlParameter("@SourceUrl", row.SourceUrl) }); result = (int?)cmd.ExecuteScalar(); row.ContentInspectionId = result; } return(result != null ? 1 : 0); }
/// <summary> /// Saves the row, either by inserting (when the identity key is null) or by updating (identity key has value). /// </summary> /// <param name="row">The data to save</param> /// <param name="connection">The SqlConnection to use</param> /// <param name="transaction">The SqlTransaction to use</param> /// <returns>The number of rows affected.</returns> public static int SaveNow(ContentInspectionContract row, SqlConnection connection, SqlTransaction transaction) { if (row.ContentInspectionId == null) { return(InsertNow(row, connection, transaction)); } else { return(UpdateNow(row, connection, transaction)); } }
/// <summary> /// Saves the row, either by inserting (when the identity key is null) or by updating (identity key has value). /// </summary> /// <param name="row">The data to save</param> /// <returns>The number of rows affected.</returns> public static int SaveNow(ContentInspectionContract row) { if (row.ContentInspectionId == null) { return(InsertNow(row)); } else { return(UpdateNow(row)); } }
/// <summary> /// Saves the row, either by inserting (when the identity key is null) or by updating (identity key has value). /// </summary> /// <param name="row">The data to save</param> /// <param name="connection">The SqlConnection to use</param> /// <param name="transaction">The SqlTransaction to use</param> /// <returns>The number of rows affected.</returns> public virtual int Save(ContentInspectionContract row, SqlConnection connection, SqlTransaction transaction) { if (row == null) { return(0); } if (row.ContentInspectionId != null) { return(Update(row, connection, transaction)); } return(Insert(row, connection, transaction)); }
/// <summary> /// Saves the row, either by inserting (when the identity key is null) or by updating (identity key has value). /// </summary> /// <param name="row">The data to save</param> /// <returns>The number of rows affected.</returns> public virtual int Save(ContentInspectionContract row) { if (row == null) { return(0); } if (row.ContentInspectionId != null) { return(Update(row)); } return(Insert(row)); }
/// <summary> /// Update by providing a populated data row container /// </summary> /// <param name="row">The table row data to use</param> /// <returns>The number of rows affected.</returns> public virtual int Update(ContentInspectionContract row) { var rowCount = 0; VotingInfoDb.ConnectThen(x => { using ( var cmd = new SqlCommand("[Data].[ContentInspection_Update]", x) { CommandType = CommandType.StoredProcedure, CommandTimeout = DefaultCommandTimeout }) { cmd.Parameters.AddRange(new[] { new SqlParameter("@ContentInspectionId", row.ContentInspectionId) , new SqlParameter("@IsArchived", row.IsArchived) , new SqlParameter("@IsBeingProposed", row.IsBeingProposed) , new SqlParameter("@ProposedByUserId", row.ProposedByUserId) , new SqlParameter("@ConfirmedByUserId", row.ConfirmedByUserId) , new SqlParameter("@FalseInfoCount", row.FalseInfoCount) , new SqlParameter("@TrueInfoCount", row.TrueInfoCount) , new SqlParameter("@AdminInpsected", row.AdminInpsected) , new SqlParameter("@DateLastChecked", row.DateLastChecked) , new SqlParameter("@SourceUrl", row.SourceUrl) }); rowCount = cmd.ExecuteNonQuery(); } }); return(rowCount); }
/// <summary> /// Delete by providing a populated data contract /// </summary> /// <param name="row">The table row data to use</param> /// <param name="connection">The SqlConnection to use</param> /// <param name="transaction">The SqlTransaction to use</param> /// <returns>The number of rows affected.</returns> public virtual int Delete(ContentInspectionContract row, SqlConnection connection, SqlTransaction transaction) { var rowCount = 0; using ( var cmd = new SqlCommand("[Data].[ContentInspection_Delete]", connection) { CommandType = CommandType.StoredProcedure, Transaction = transaction }) { cmd.Parameters.AddRange(new[] { new SqlParameter("@ContentInspectionId", row.ContentInspectionId) }); rowCount = cmd.ExecuteNonQuery(); } return(rowCount); }
/// <summary> /// Delete by providing a populated data row container /// </summary> /// <param name="row">The table row data to use</param> /// <returns>The number of rows affected.</returns> public virtual int Delete(ContentInspectionContract row) { var rowCount = 0; VotingInfoDb.ConnectThen(x => { using ( var cmd = new SqlCommand("[Data].[ContentInspection_Delete]", x) { CommandType = CommandType.StoredProcedure, CommandTimeout = DefaultCommandTimeout }) { cmd.Parameters.AddRange(new[] { new SqlParameter("@ContentInspectionId", row.ContentInspectionId) }); rowCount = cmd.ExecuteNonQuery(); } }); return(rowCount); }
/// <summary> /// Insert by providing a populated data row container /// </summary> /// <param name="row">The table row data to use</param> /// <returns>The number of rows affected.</returns> public static int InsertNow(ContentInspectionContract row) { return((new ContentInspectionLogic()).Insert(row)); }
/// <summary> /// Delete by providing a populated data contract /// </summary> /// <param name="row">The table row data to use</param> /// <param name="connection">The SqlConnection to use</param> /// <param name="transaction">The SqlTransaction to use</param> /// <returns>The number of rows affected.</returns> public static int DeleteNow(ContentInspectionContract row, SqlConnection connection, SqlTransaction transaction) { return((new ContentInspectionLogic()).Delete(row, connection, transaction)); }
/// <summary> /// Delete by providing a populated data row container /// </summary> /// <param name="row">The table row data to use</param> /// <returns>The number of rows affected.</returns> public static int DeleteNow(ContentInspectionContract row) { return((new ContentInspectionLogic()).Delete(row)); }