/// <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);
}
