/// <summary>
/// Add a new entry to the TicketDelivery table
/// </summary>
public static TicketDelivery Add(YearId ticketPrimaryKey, int deliveryDriverId)
{
TicketDelivery result = null;
DateTime departTime = DateTime.Now;
SqlConnection cn = GetConnection();
string cmd = "AddTicketDelivery";
using (SqlCommand sqlCmd = new SqlCommand(cmd, cn))
{
sqlCmd.CommandType = CommandType.StoredProcedure;
BuildSqlParameter(sqlCmd, "@TicketDeliveryYear", SqlDbType.SmallInt, ticketPrimaryKey.Year);
BuildSqlParameter(sqlCmd, "@TicketDeliveryTicketId", SqlDbType.Int, ticketPrimaryKey.Id);
BuildSqlParameter(sqlCmd, "@TicketDeliveryDeliveryDriverId", SqlDbType.Int, deliveryDriverId);
BuildSqlParameter(sqlCmd, "@TicketDeliveryDepartTime", SqlDbType.DateTime, departTime);
BuildSqlParameter(sqlCmd, "@TicketDeliveryId", SqlDbType.Int, ParameterDirection.ReturnValue);
if (sqlCmd.ExecuteNonQuery() > 0)
{
result = new TicketDelivery(
new YearId(ticketPrimaryKey.Year,
Convert.ToInt32(sqlCmd.Parameters["@TicketDeliveryId"].Value)),
ticketPrimaryKey.Id, deliveryDriverId, departTime, null);
}
}
FinishedWithConnection(cn);
return(result);
}
/// <summary>
/// Update an entry in the TicketDelivery table
/// </summary>
public static bool Update(TicketDelivery deliveryDispatch)
{
bool result = false;
SqlConnection cn = GetConnection();
result = Update(cn, deliveryDispatch);
FinishedWithConnection(cn);
return(result);
}
/// <summary>
/// Get an entry from the TicketDelivery table
/// </summary>
public static TicketDelivery Get(YearId primaryKey)
{
TicketDelivery result = null;
SqlConnection cn = GetConnection();
result = Get(cn, primaryKey);
FinishedWithConnection(cn);
return(result);
}
private static TicketDelivery Get(SqlConnection cn, YearId primaryKey)
{
TicketDelivery result = null;
using (SqlCommand cmd = new SqlCommand("SELECT * FROM TicketDelivery WHERE (TicketDeliveryId=" + primaryKey.Id + " AND TicketDeliveryYear=" + primaryKey.Year + ")", cn))
{
using (SqlDataReader rdr = cmd.ExecuteReader())
{
if (rdr.Read())
{
result = BuildTicketDelivery(rdr);
}
}
}
return(result);
}
/// <summary>
/// Delete an entry from the TicketDelivery table
/// </summary>
public static bool Delete(YearId primaryKey)
{
Int32 rowsAffected = 0;
SqlConnection cn = GetConnection();
TicketDelivery deliveryDispatch = Get(cn, primaryKey);
if (deliveryDispatch != null)
{
using (SqlCommand sqlCmd = cn.CreateCommand())
{
sqlCmd.CommandText = "DELETE FROM TicketDelivery WHERE (TicketDeliveryId=" + primaryKey.Id + " AND TicketDeliveryYear=" + primaryKey.Year + ")";
rowsAffected = sqlCmd.ExecuteNonQuery();
}
}
FinishedWithConnection(cn);
return(rowsAffected != 0);
}
private static bool Update(SqlConnection cn, TicketDelivery deliveryDispatch)
{
Int32 rowsAffected = 0;
using (SqlCommand sqlCmd = cn.CreateCommand())
{
sqlCmd.CommandText = "UPDATE TicketDelivery SET TicketDeliveryEmployeeId=@TicketDeliveryEmployeeId,TicketDeliveryTicketId=@TicketDeliveryTicketId,TicketDeliveryDepartTime=@TicketDeliveryDepartTime,TicketDeliveryReturnTime=@TicketDeliveryReturnTime WHERE (TicketDeliveryId=@TicketDeliveryId AND TicketDeliveryYear=@TicketDeliveryYear)";
BuildSqlParameter(sqlCmd, "@TicketDeliveryYear", SqlDbType.SmallInt, deliveryDispatch.PrimaryKey.Year);
BuildSqlParameter(sqlCmd, "@TicketDeliveryId", SqlDbType.Int, deliveryDispatch.PrimaryKey.Id);
BuildSqlParameter(sqlCmd, "@TicketDeliveryDeliveryDriverId", SqlDbType.Int, deliveryDispatch.DeliveryDriverId);
BuildSqlParameter(sqlCmd, "@TicketDeliveryTicketId", SqlDbType.Int, deliveryDispatch.TicketId);
BuildSqlParameter(sqlCmd, "@TicketDeliveryDepartTime", SqlDbType.DateTime, deliveryDispatch.DepartTime);
BuildSqlParameter(sqlCmd, "@TicketDeliveryReturnTime", SqlDbType.DateTime, deliveryDispatch.ReturnTime);
rowsAffected = sqlCmd.ExecuteNonQuery();
}
return(rowsAffected != 0);
}
