/// <summary> /// Insert by providing a populated data row container /// </summary> /// <param name="row">The table row data to use</param> /// <returns>1, if insert was successful</returns> public int Insert(ElectionLevelContract row) { int?result = null; VotingInfoDb.ConnectThen(x => { using ( var cmd = new SqlCommand("[Data].[ElectionLevel_Insert]", x) { CommandType = CommandType.StoredProcedure, CommandTimeout = DefaultCommandTimeout }) { cmd.Parameters.AddRange(new[] { new SqlParameter("@ContentInspectionId", row.ContentInspectionId) , new SqlParameter("@ElectionLevelTitle", row.ElectionLevelTitle) }); result = (int?)cmd.ExecuteScalar(); row.ElectionLevelId = result; } }); return(result != null ? 1 : 0); }
/// <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(ElectionLevelContract row) { var rowCount = 0; VotingInfoDb.ConnectThen(x => { using ( var cmd = new SqlCommand("[Data].[ElectionLevel_Update]", x) { CommandType = CommandType.StoredProcedure, CommandTimeout = DefaultCommandTimeout }) { cmd.Parameters.AddRange(new[] { new SqlParameter("@ElectionLevelId", row.ElectionLevelId) , new SqlParameter("@ContentInspectionId", row.ContentInspectionId) , new SqlParameter("@ElectionLevelTitle", row.ElectionLevelTitle) }); rowCount = cmd.ExecuteNonQuery(); } }); return(rowCount); }
/// <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(ElectionLevelContract row, SqlConnection connection, SqlTransaction transaction) { if (row.ElectionLevelId == 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(ElectionLevelContract row) { if (row.ElectionLevelId == 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(ElectionLevelContract row, SqlConnection connection, SqlTransaction transaction) { if (row == null) { return(0); } if (row.ElectionLevelId != 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(ElectionLevelContract row) { if (row == null) { return(0); } if (row.ElectionLevelId != null) { return(Update(row)); } return(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 virtual int Delete(ElectionLevelContract row, SqlConnection connection, SqlTransaction transaction) { var rowCount = 0; using ( var cmd = new SqlCommand("[Data].[ElectionLevel_Delete]", connection) { CommandType = CommandType.StoredProcedure, Transaction = transaction }) { cmd.Parameters.AddRange(new[] { new SqlParameter("@ElectionLevelId", row.ElectionLevelId) }); rowCount = cmd.ExecuteNonQuery(); } return(rowCount); }
/// <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(ElectionLevelContract row, SqlConnection connection, SqlTransaction transaction) { int?result = null; using ( var cmd = new SqlCommand("[Data].[ElectionLevel_Insert]", connection) { CommandType = CommandType.StoredProcedure, Transaction = transaction }) { cmd.Parameters.AddRange(new[] { new SqlParameter("@ContentInspectionId", row.ContentInspectionId) , new SqlParameter("@ElectionLevelTitle", row.ElectionLevelTitle) }); result = (int?)cmd.ExecuteScalar(); row.ElectionLevelId = result; } return(result != null ? 1 : 0); }
/// <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>The number of rows affected.</returns> public static int InsertNow(ElectionLevelContract row, SqlConnection connection, SqlTransaction transaction) { return((new ElectionLevelLogic()).Insert(row, connection, transaction)); }
/// <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(ElectionLevelContract row) { return((new ElectionLevelLogic()).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(ElectionLevelContract row, SqlConnection connection, SqlTransaction transaction) { return((new ElectionLevelLogic()).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(ElectionLevelContract row) { return((new ElectionLevelLogic()).Delete(row)); }