/// <summary> /// Add a new entry to the TicketVoid table /// </summary> public static TicketVoid Add(int employeeId, YearId ticketPrimaryKey, int?ticketItemId, double amount) { TicketVoid result = null; DateTime voidTime = DateTime.Now; SqlConnection cn = GetConnection(); string cmd = "AddTicketVoid"; using (SqlCommand sqlCmd = new SqlCommand(cmd, cn)) { sqlCmd.CommandType = CommandType.StoredProcedure; BuildSqlParameter(sqlCmd, "@TicketVoidYear", SqlDbType.Int, ticketPrimaryKey.Year); BuildSqlParameter(sqlCmd, "@TicketVoidEmployeeId", SqlDbType.Int, employeeId); BuildSqlParameter(sqlCmd, "@TicketVoidTicketId", SqlDbType.Int, ticketPrimaryKey.Id); BuildSqlParameter(sqlCmd, "@TicketVoidTicketItemId", SqlDbType.Int, ticketItemId); BuildSqlParameter(sqlCmd, "@TicketVoidTime", SqlDbType.DateTime, voidTime); BuildSqlParameter(sqlCmd, "@TicketVoidAmount", SqlDbType.Float, amount); BuildSqlParameter(sqlCmd, "@TicketVoidId", SqlDbType.Int, ParameterDirection.ReturnValue); if (sqlCmd.ExecuteNonQuery() > 0) { result = new TicketVoid( new YearId(ticketPrimaryKey.Year, Convert.ToInt32(sqlCmd.Parameters["@TicketVoidId"].Value)), employeeId, ticketPrimaryKey.Id, ticketItemId, voidTime, amount); } } FinishedWithConnection(cn); return(result); }
/// <summary> /// Get an entry from the TicketVoid table /// </summary> public static TicketVoid Get(YearId primaryKey) { TicketVoid result = null; SqlConnection cn = GetConnection(); result = Get(cn, primaryKey); FinishedWithConnection(cn); return(result); }
private static TicketVoid Get(SqlConnection cn, YearId primaryKey) { TicketVoid result = null; using (SqlCommand cmd = new SqlCommand("SELECT * FROM TicketVoid WHERE (TicketVoidId=" + primaryKey.Id + " AND TicketVoidYear=" + primaryKey.Year + ")", cn)) { using (SqlDataReader rdr = cmd.ExecuteReader()) { if (rdr.Read()) { result = BuildTicketVoid(rdr); } } } return(result); }