/// <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(RolePermissionContract row) { int?result = null; VotingInfoDb.ConnectThen(x => { using ( var cmd = new SqlCommand("[Auth].[RolePermission_Insert]", x) { CommandType = CommandType.StoredProcedure, CommandTimeout = DefaultCommandTimeout }) { cmd.Parameters.AddRange(new[] { new SqlParameter("@RoleId", row.RoleId) , new SqlParameter("@PermissionId", row.PermissionId) }); result = (int?)cmd.ExecuteScalar(); row.RolePermissionId = 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(RolePermissionContract row) { var rowCount = 0; VotingInfoDb.ConnectThen(x => { using ( var cmd = new SqlCommand("[Auth].[RolePermission_Update]", x) { CommandType = CommandType.StoredProcedure, CommandTimeout = DefaultCommandTimeout }) { cmd.Parameters.AddRange(new[] { new SqlParameter("@RolePermissionId", row.RolePermissionId) , new SqlParameter("@RoleId", row.RoleId) , new SqlParameter("@PermissionId", row.PermissionId) }); 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(RolePermissionContract row, SqlConnection connection, SqlTransaction transaction) { if (row.RolePermissionId == 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(RolePermissionContract row) { if (row.RolePermissionId == 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(RolePermissionContract row, SqlConnection connection, SqlTransaction transaction) { if (row == null) { return(0); } if (row.RolePermissionId != 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(RolePermissionContract row) { if (row == null) { return(0); } if (row.RolePermissionId != 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(RolePermissionContract row, SqlConnection connection, SqlTransaction transaction) { var rowCount = 0; using ( var cmd = new SqlCommand("[Auth].[RolePermission_Delete]", connection) { CommandType = CommandType.StoredProcedure, Transaction = transaction }) { cmd.Parameters.AddRange(new[] { new SqlParameter("@RolePermissionId", row.RolePermissionId) }); 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(RolePermissionContract row, SqlConnection connection, SqlTransaction transaction) { int?result = null; using ( var cmd = new SqlCommand("[Auth].[RolePermission_Insert]", connection) { CommandType = CommandType.StoredProcedure, Transaction = transaction }) { cmd.Parameters.AddRange(new[] { new SqlParameter("@RoleId", row.RoleId) , new SqlParameter("@PermissionId", row.PermissionId) }); result = (int?)cmd.ExecuteScalar(); row.RolePermissionId = 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(RolePermissionContract row, SqlConnection connection, SqlTransaction transaction) { return((new RolePermissionLogic()).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(RolePermissionContract row) { return((new RolePermissionLogic()).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(RolePermissionContract row) { return((new RolePermissionLogic()).Delete(row)); }