Exemple #1
0
        public static void AddVenue(Venue venue, out int? venueId, out DateTime createdDate)
        {
            using (SqlConnection conn = Helper.GetConnection())
            {
                using (SqlCommand cmd = new SqlCommand(Constants.StoredProcedures.VenueManager.AddVenue, conn))
                {
                    cmd.CommandType = CommandType.StoredProcedure;
                    cmd.Parameters.AddWithValue("@Name", venue.Name);
                    if (!string.IsNullOrEmpty(venue.Name))
                        cmd.Parameters.AddWithValue("@Profile", venue.Profile);
                    if (!string.IsNullOrEmpty(venue.PostalCode))
                        cmd.Parameters.AddWithValue("@PostalCode", venue.PostalCode);
                    if (venue.PriceAverage.HasValue)
                        cmd.Parameters.AddWithValue("@PriceAverage", venue.PriceAverage.Value);
                    SqlParameter prmVenueId = new SqlParameter();
                    prmVenueId.Direction = ParameterDirection.Output;
                    prmVenueId.DbType = DbType.Int32;
                    prmVenueId.ParameterName = "@VenueID";
                    cmd.Parameters.Add(prmVenueId);
                    SqlParameter prmCreatedDate = new SqlParameter();
                    prmCreatedDate.Direction = ParameterDirection.Output;
                    prmCreatedDate.DbType = DbType.DateTime;
                    prmCreatedDate.ParameterName = "@CreatedDate";
                    cmd.Parameters.Add(prmCreatedDate);

                    conn.Open();

                    cmd.ExecuteScalar();

                    venueId = (int)cmd.Parameters["@VenueID"].Value;
                    createdDate = (DateTime)cmd.Parameters["@CreatedDate"].Value;
                }
            }
        }
Exemple #2
0
 private void LoadViewVenue()
 {
     if (ItemID.HasValue)
     {
         ViewVenue = VenueManager.GetVenue(ItemID.Value);
     }
 }
Exemple #3
0
        public static void UpdateVenue(Venue venue)
        {
            using (SqlConnection conn = Helper.GetConnection())
            {
                using (SqlCommand cmd = new SqlCommand(Constants.StoredProcedures.VenueManager.UpdateVenue, conn))
                {
                    cmd.CommandType = CommandType.StoredProcedure;
                    cmd.Parameters.AddWithValue("@VenueID", venue.ID);
                    cmd.Parameters.AddWithValue("@Name", venue.Name);
                    if (!string.IsNullOrEmpty(venue.Profile))
                        cmd.Parameters.AddWithValue("@Profile", venue.Profile);
                    if (!string.IsNullOrEmpty(venue.PostalCode))
                        cmd.Parameters.AddWithValue("@PostalCode", venue.PostalCode);
                    if (venue.PriceAverage.HasValue)
                        cmd.Parameters.AddWithValue("@PriceAverage", venue.PriceAverage.Value);

                    conn.Open();

                    cmd.ExecuteNonQuery();
                }
            }
        }
Exemple #4
0
 public static void RemoveVenue(Venue venue)
 {
     if (venue.ID.HasValue)
         RemoveVenue(venue.ID.Value);
     else
         throw new Exception("Venue has not been saved and thus cannot be removed.");
 }