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