/// <summary> /// Add a new entry to the RegisterPayout table /// </summary> public static RegisterPayout Add(int registerDrawerId, int employeeId, double amount, string reason, DateTime payoutTime) { RegisterPayout result = null; DateTime purchaseTime = DateTime.Now; SqlConnection cn = GetConnection(); string cmd = "AddRegisterPayout"; using (SqlCommand sqlCmd = new SqlCommand(cmd, cn)) { sqlCmd.CommandType = CommandType.StoredProcedure; BuildSqlParameter(sqlCmd, "@RegisterPayoutRegisterDrawerId", SqlDbType.Int, registerDrawerId); BuildSqlParameter(sqlCmd, "@RegisterPayoutEmployeeId", SqlDbType.Int, employeeId); BuildSqlParameter(sqlCmd, "@RegisterPayoutAmount", SqlDbType.Float, amount); BuildSqlParameter(sqlCmd, "@RegisterPayoutReason", SqlDbType.Text, reason); BuildSqlParameter(sqlCmd, "@RegisterPayoutTime", SqlDbType.DateTime, payoutTime); BuildSqlParameter(sqlCmd, "@RegisterPayoutId", SqlDbType.Int, ParameterDirection.ReturnValue); if (sqlCmd.ExecuteNonQuery() > 0) { result = new RegisterPayout(Convert.ToInt32(sqlCmd.Parameters["@RegisterPayoutId"].Value), registerDrawerId, employeeId, amount, reason, payoutTime); } } FinishedWithConnection(cn); return(result); }
/// <summary> /// Update an entry in the RegisterPayout table /// </summary> public static bool Update(RegisterPayout registerPayout) { bool result = false; SqlConnection cn = GetConnection(); result = Update(cn, registerPayout); FinishedWithConnection(cn); return(result); }
/// <summary> /// Get an entry from the RegisterPayout table /// </summary> public static RegisterPayout Get(int id) { RegisterPayout result = null; SqlConnection cn = GetConnection(); result = Get(cn, id); FinishedWithConnection(cn); return(result); }
private static RegisterPayout Get(SqlConnection cn, int id) { RegisterPayout result = null; using (SqlCommand cmd = new SqlCommand("SELECT * FROM RegisterPayout WHERE RegisterPayoutId=" + id, cn)) { using (SqlDataReader rdr = cmd.ExecuteReader()) { if (rdr.Read()) { result = BuildRegisterPayout(rdr); } } } return(result); }
/// <summary> /// Delete an entry from the RegisterPayout table /// </summary> public static bool Delete(int id) { Int32 rowsAffected = 0; SqlConnection cn = GetConnection(); RegisterPayout registerPayout = Get(cn, id); if (registerPayout != null) { using (SqlCommand sqlCmd = cn.CreateCommand()) { sqlCmd.CommandText = "DELETE FROM RegisterPayout WHERE RegisterPayoutId=" + id; rowsAffected = sqlCmd.ExecuteNonQuery(); } } FinishedWithConnection(cn); return(rowsAffected != 0); }
private static bool Update(SqlConnection cn, RegisterPayout registerPayout) { Int32 rowsAffected = 0; using (SqlCommand sqlCmd = cn.CreateCommand()) { sqlCmd.CommandText = "UPDATE RegisterPayout SET RegisterPayoutRegisterDrawerId=@RegisterPayoutRegisterDrawerId,RegisterPayoutEmployeeId=@RegisterPayoutEmployeeId,RegisterPayoutAmount=@RegisterPayoutAmount,RegisterPayoutReason=@RegisterPayoutReason,RegisterPayoutTime=@RegisterPayoutTime WHERE RegisterPayoutId=@RegisterPayoutId"; BuildSqlParameter(sqlCmd, "@RegisterPayoutId", SqlDbType.Int, registerPayout.Id); BuildSqlParameter(sqlCmd, "@RegisterPayoutRegisterDrawerId", SqlDbType.Int, registerPayout.RegisterDrawerId); BuildSqlParameter(sqlCmd, "@RegisterPayoutEmployeeId", SqlDbType.Int, registerPayout.EmployeeId); BuildSqlParameter(sqlCmd, "@RegisterPayoutAmount", SqlDbType.Float, registerPayout.Amount); BuildSqlParameter(sqlCmd, "@RegisterPayoutReason", SqlDbType.Float, registerPayout.Reason); BuildSqlParameter(sqlCmd, "@RegisterPayoutTime", SqlDbType.DateTime, registerPayout.When); rowsAffected = sqlCmd.ExecuteNonQuery(); } return(rowsAffected != 0); }