/// <summary> /// Get an entry from the TicketItemReturn table /// </summary> public static TicketItemReturn Get(YearId primaryKey) { TicketItemReturn result = null; SqlConnection cn = GetConnection(); result = Get(cn, primaryKey); FinishedWithConnection(cn); return(result); }
private static TicketItemReturn Get(SqlConnection cn, YearId primaryKey) { TicketItemReturn result = null; using (SqlCommand cmd = new SqlCommand("SELECT * FROM TicketItemReturn WHERE (TicketItemReturnId=" + primaryKey.Id + " AND TicketItemReturnYear=" + primaryKey.Year + ")", cn)) { using (SqlDataReader rdr = cmd.ExecuteReader()) { if (rdr.Read()) { result = BuildTicketItemReturn(rdr); } } } return(result); }
/// <summary> /// Add a new entry to the TicketItemReturn table /// </summary> public static TicketItemReturn Add(int registerDrawerId, int employeeId, YearId ticketPrimaryKey, int itemId, int itemQuantity, double amount) { TicketItemReturn result = null; DateTime when = DateTime.Now; itemQuantity = itemQuantity.Clamp(1, short.MaxValue); SqlConnection cn = GetConnection(); string cmd = "AddTicketItemReturn"; using (SqlCommand sqlCmd = new SqlCommand(cmd, cn)) { sqlCmd.CommandType = CommandType.StoredProcedure; BuildSqlParameter(sqlCmd, "@TicketItemReturnYear", SqlDbType.SmallInt, ticketPrimaryKey.Year); BuildSqlParameter(sqlCmd, "@TicketItemReturnEmployeeId", SqlDbType.Int, employeeId); BuildSqlParameter(sqlCmd, "@TicketItemReturnRegisterDrawerId", SqlDbType.Int, registerDrawerId); BuildSqlParameter(sqlCmd, "@TicketItemReturnTicketId", SqlDbType.Int, ticketPrimaryKey.Id); BuildSqlParameter(sqlCmd, "@TicketItemReturnItemId", SqlDbType.Int, itemId); BuildSqlParameter(sqlCmd, "@TicketItemReturnItemQuantity", SqlDbType.SmallInt, itemQuantity); BuildSqlParameter(sqlCmd, "@TicketItemReturnAmount", SqlDbType.Float, amount); BuildSqlParameter(sqlCmd, "@TicketItemReturnWhen", SqlDbType.DateTime, when); BuildSqlParameter(sqlCmd, "@TicketItemReturnId", SqlDbType.Int, ParameterDirection.ReturnValue); if (sqlCmd.ExecuteNonQuery() > 0) { result = new TicketItemReturn( new YearId(ticketPrimaryKey.Year, Convert.ToInt32(sqlCmd.Parameters["@TicketItemReturnId"].Value)), registerDrawerId, employeeId, ticketPrimaryKey.Id, itemId, itemQuantity, amount, when); } } FinishedWithConnection(cn); return(result); }