/// <summary> /// Update an entry in the DirectDepositTransaction table /// </summary> public static bool Update(DirectDepositTransaction directDepositTransaction) { bool result = false; SqlConnection cn = GetConnection(); result = Update(cn, directDepositTransaction); FinishedWithConnection(cn); return(result); }
/// <summary> /// Get an entry from the DirectDepositTransaction table /// </summary> public static DirectDepositTransaction Get(int id) { DirectDepositTransaction result = null; SqlConnection cn = GetConnection(); result = Get(cn, id); FinishedWithConnection(cn); return(result); }
private static DirectDepositTransaction Get(SqlConnection cn, int id) { DirectDepositTransaction result = null; using (SqlCommand cmd = new SqlCommand("SELECT * FROM DirectDepositTransaction WHERE DirectDepositTransactionId=" + id, cn)) { using (SqlDataReader rdr = cmd.ExecuteReader()) { if (rdr.Read()) { result = BuildDirectDepositTransaction(rdr); } } } return(result); }
private static bool Update(SqlConnection cn, DirectDepositTransaction directDepositTransaction) { Int32 rowsAffected = 0; using (SqlCommand sqlCmd = cn.CreateCommand()) { sqlCmd.CommandText = "UPDATE DirectDepositTransaction SET DirectDepositTransactionEmployeeId=@DirectDepositTransactionEmployeeId,DirectDepositTransactionAmount=@DirectDepositTransactionAmount,DirectDepositTransactionDate=@DirectDepositTransactionDate WHERE DirectDepositTransactionId=@DirectDepositTransactionId"; BuildSqlParameter(sqlCmd, "@DirectDepositTransactionId", SqlDbType.Int, directDepositTransaction.Id); BuildSqlParameter(sqlCmd, "@DirectDepositTransactionEmployeeId", SqlDbType.Int, directDepositTransaction.EmployeeId); BuildSqlParameter(sqlCmd, "@DirectDepositTransactionAmount", SqlDbType.Float, directDepositTransaction.Amount); BuildSqlParameter(sqlCmd, "@DirectDepositTransactionDate", SqlDbType.DateTime, directDepositTransaction.TransactionDateTime); rowsAffected = sqlCmd.ExecuteNonQuery(); } return(rowsAffected != 0); }
/// <summary> /// Delete an entry from the DirectDepositTransaction table /// </summary> public static bool Delete(int id) { Int32 rowsAffected = 0; SqlConnection cn = GetConnection(); DirectDepositTransaction directDepositTransaction = Get(cn, id); if (directDepositTransaction != null) { using (SqlCommand sqlCmd = cn.CreateCommand()) { sqlCmd.CommandText = "DELETE FROM DirectDepositTransaction WHERE DirectDepositTransactionId=" + id; rowsAffected = sqlCmd.ExecuteNonQuery(); } } FinishedWithConnection(cn); return(rowsAffected != 0); }
/// <summary> /// Add a new entry to the DirectDepositTransaction table /// </summary> public static DirectDepositTransaction Add(int employeeId, double amount) { DirectDepositTransaction result = null; DateTime transactionTime = DateTime.Now; SqlConnection cn = GetConnection(); string cmd = "AddDirectDepositTransaction"; using (SqlCommand sqlCmd = new SqlCommand(cmd, cn)) { sqlCmd.CommandType = CommandType.StoredProcedure; BuildSqlParameter(sqlCmd, "@DirectDepositTransactionEmployeeId", SqlDbType.Int, employeeId); BuildSqlParameter(sqlCmd, "@DirectDepositTransactionAmount", SqlDbType.Float, amount); BuildSqlParameter(sqlCmd, "@DirectDepositTransactionDate", SqlDbType.DateTime, transactionTime); BuildSqlParameter(sqlCmd, "@DirectDepositTransactionId", SqlDbType.Int, ParameterDirection.ReturnValue); if (sqlCmd.ExecuteNonQuery() > 0) { result = new DirectDepositTransaction(Convert.ToInt32(sqlCmd.Parameters["@DirectDepositTransactionId"].Value), employeeId, amount, transactionTime); } } FinishedWithConnection(cn); return(result); }
public bool Update() { return(DirectDepositTransaction.Update(this)); }