/// <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(ElectionCandidateContract row) { var rowCount = 0; VotingInfoDb.ConnectThen(x => { using ( var cmd = new SqlCommand("[Data].[ElectionCandidate_Update]", x) { CommandType = CommandType.StoredProcedure, CommandTimeout = DefaultCommandTimeout }) { cmd.Parameters.AddRange(new[] { new SqlParameter("@ElectionCandidateId", row.ElectionCandidateId) , new SqlParameter("@ContentInspectionId", row.ContentInspectionId) , new SqlParameter("@CandidateId", row.CandidateId) , new SqlParameter("@ElectionId", row.ElectionId) , new SqlParameter("@IsWinner", row.IsWinner) , new SqlParameter("@ReportedVoteCount", row.ReportedVoteCount) }); rowCount = cmd.ExecuteNonQuery(); } }); return(rowCount); }
/// <summary> /// Update 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 Update(ElectionCandidateContract row, SqlConnection connection, SqlTransaction transaction) { var rowCount = 0; using ( var cmd = new SqlCommand("[Data].[ElectionCandidate_Update]", connection) { CommandType = CommandType.StoredProcedure, Transaction = transaction }) { cmd.Parameters.AddRange(new[] { new SqlParameter("@ElectionCandidateId", row.ElectionCandidateId) , new SqlParameter("@ContentInspectionId", row.ContentInspectionId) , new SqlParameter("@CandidateId", row.CandidateId) , new SqlParameter("@ElectionId", row.ElectionId) , new SqlParameter("@IsWinner", row.IsWinner) , new SqlParameter("@ReportedVoteCount", row.ReportedVoteCount) }); 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>1, if insert was successful</returns> public int Insert(ElectionCandidateContract row) { int?result = null; VotingInfoDb.ConnectThen(x => { using ( var cmd = new SqlCommand("[Data].[ElectionCandidate_Insert]", x) { CommandType = CommandType.StoredProcedure, CommandTimeout = DefaultCommandTimeout }) { cmd.Parameters.AddRange(new[] { new SqlParameter("@ContentInspectionId", row.ContentInspectionId) , new SqlParameter("@CandidateId", row.CandidateId) , new SqlParameter("@ElectionId", row.ElectionId) , new SqlParameter("@IsWinner", row.IsWinner) , new SqlParameter("@ReportedVoteCount", row.ReportedVoteCount) }); result = (int?)cmd.ExecuteScalar(); row.ElectionCandidateId = 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>1, if insert was successful</returns> public int Insert(ElectionCandidateContract row, SqlConnection connection, SqlTransaction transaction) { int?result = null; using ( var cmd = new SqlCommand("[Data].[ElectionCandidate_Insert]", connection) { CommandType = CommandType.StoredProcedure, Transaction = transaction }) { cmd.Parameters.AddRange(new[] { new SqlParameter("@ContentInspectionId", row.ContentInspectionId) , new SqlParameter("@CandidateId", row.CandidateId) , new SqlParameter("@ElectionId", row.ElectionId) , new SqlParameter("@IsWinner", row.IsWinner) , new SqlParameter("@ReportedVoteCount", row.ReportedVoteCount) }); result = (int?)cmd.ExecuteScalar(); row.ElectionCandidateId = 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(ElectionCandidateContract row, SqlConnection connection, SqlTransaction transaction) { if (row.ElectionCandidateId == 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(ElectionCandidateContract row) { if (row.ElectionCandidateId == 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(ElectionCandidateContract row, SqlConnection connection, SqlTransaction transaction) { if (row == null) { return(0); } if (row.ElectionCandidateId != 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(ElectionCandidateContract row) { if (row == null) { return(0); } if (row.ElectionCandidateId != 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(ElectionCandidateContract row, SqlConnection connection, SqlTransaction transaction) { var rowCount = 0; using ( var cmd = new SqlCommand("[Data].[ElectionCandidate_Delete]", connection) { CommandType = CommandType.StoredProcedure, Transaction = transaction }) { cmd.Parameters.AddRange(new[] { new SqlParameter("@ElectionCandidateId", row.ElectionCandidateId) }); 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>The number of rows affected.</returns> public static int InsertNow(ElectionCandidateContract row, SqlConnection connection, SqlTransaction transaction) { return((new ElectionCandidateLogic()).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(ElectionCandidateContract row) { return((new ElectionCandidateLogic()).Insert(row)); }
/// <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(ElectionCandidateContract row) { return((new ElectionCandidateLogic()).Delete(row)); }