public async Task <VenueViewModel> AddVenueDetails(VenueDetailsModel venue) { if (venue.VenueLocation != null) { VenueDetails saveVenue = _mapper.Map <VenueDetails>(venue); await _db.VenueDetails.AddAsync(saveVenue); await _db.SaveChangesAsync(); return(new VenueViewModel { VenueLocation = saveVenue.VenueLocation }); } else { throw new ConsoleCommonException("AddVenue Failed"); } }
public static List <VenueDetails> Get(int CustomerId) { List <VenueDetails> datalist = new List <VenueDetails>(); try { using (SqlConnection con = new SqlConnection(conString)) { if (con.State == ConnectionState.Closed) { con.Open(); } string query = "select VenueName,VenueCost, BookDate from VenueDetails, BookingVenue " + "where VenueDetails.VenueId = BookingVenue.VenueId and CustomerId = @CustomerId ; "; SqlCommand cmd = new SqlCommand(query, con); cmd.Parameters.Add(new SqlParameter("@CustomerId", CustomerId)); SqlDataReader reader = cmd.ExecuteReader(); if (reader != null) { if (reader.HasRows) { while (reader.Read()) { VenueDetails data = new VenueDetails() { VenueName = reader["VenueName"].ToString(), VenueCost = int.Parse(reader["VenueCost"].ToString()), BookDate = DateTime.Parse(reader["BookDate"].ToString()), }; datalist.Add(data); } reader.Close(); } } if (con.State == ConnectionState.Open) { con.Close(); } } } catch (Exception ex) { throw ex; } return(datalist); }
public static bool Update(string VenueId, VenueDetails venuedetails) { bool status = false; try { using (SqlConnection con = new SqlConnection(conString)) { if (con.State == ConnectionState.Closed) { con.Open(); } string query = "UPDATE VenueDetails SET VenueName=@VenueName," + " VenueCost=@VenueCost, VenueCapacity=@VenueCapacity, VenueContact= @VenueContact, VenueAddress=@VenueAddress " + "WHERE VenueId=@VenueId"; SqlCommand cmd = new SqlCommand(query, con); cmd.Parameters.Add(new SqlParameter("@VenueId", venuedetails.VenueId)); cmd.Parameters.Add(new SqlParameter("@VenueName", venuedetails.VenueName)); //cmd.Parameters.Add(new SqlParameter("@VenueFileName", venuedetails.VenueFileName)); //cmd.Parameters.Add(new SqlParameter("@VenueFilePath", venuedetails.VenueFilePath)); cmd.Parameters.Add(new SqlParameter("@VenueCost", venuedetails.VenueCost)); cmd.Parameters.Add(new SqlParameter("@VenueContact", venuedetails.VenueContact)); cmd.Parameters.Add(new SqlParameter("@VenueCapacity", venuedetails.VenueCapacity)); cmd.Parameters.Add(new SqlParameter("@VenueAddress", venuedetails.VenueAddress)); cmd.ExecuteNonQuery(); if (con.State == ConnectionState.Open) { con.Close(); } status = true; } } catch (Exception ex) { throw ex; } return(status); }
public static bool Insert(VenueDetails venuedetails) { bool status = false; try { using (SqlConnection con = new SqlConnection(conString)) { if (con.State == ConnectionState.Closed) { con.Open(); } string qyery = "Insert into VenueDetails(VenueId,VenueName,VenueCost,VenueCapacity,VenueContact,VenueAddress) " + "Values(@VenueId,@VenueName,@VenueCost,@VenueCapacity,@VenueContact,@VenueAddress)"; SqlCommand cmd = new SqlCommand(qyery, con); cmd.Parameters.Add(new SqlParameter("@VenueId", venuedetails.VenueId)); cmd.Parameters.Add(new SqlParameter("@VenueName", venuedetails.VenueName)); //cmd.Parameters.Add(new SqlParameter("@VenueFileName", venuedetails.VenueFileName)); //cmd.Parameters.Add(new SqlParameter("@VenueFilePath", venuedetails.VenueFilePath)); cmd.Parameters.Add(new SqlParameter("@VenueCost", venuedetails.VenueCost)); cmd.Parameters.Add(new SqlParameter("@VenueCapacity", venuedetails.VenueCapacity)); cmd.Parameters.Add(new SqlParameter("@VenueContact", venuedetails.VenueContact)); cmd.Parameters.AddWithValue("@VenueAddress", venuedetails.VenueAddress); cmd.ExecuteNonQuery(); if (con.State == ConnectionState.Open) { con.Close(); } status = true; } } catch (Exception ex) { throw ex; } return(status); }
public void DisplayVenueDetails(Venue userVenue) { VenueAccess va = new VenueAccess(connectionString); VenueDetails venueInfo = va.Details(userVenue); Console.WriteLine(userVenue.Name); Console.WriteLine("Location: " + venueInfo.CityName + ", " + venueInfo.StateAbbreviation); Console.Write("Categories: "); if (venueInfo.Categories.Count == 0) { Console.WriteLine("No Category associated with this venue."); } else { for (int i = 0; i < venueInfo.Categories.Count; i++) { if (i == venueInfo.Categories.Count - 1) { Console.WriteLine(venueInfo.Categories[i]); } else { Console.Write(venueInfo.Categories[i] + ", "); } } } Console.WriteLine(); Console.WriteLine(userVenue.Description); Console.WriteLine(); int pick = 0; bool done = false; while (!done) { Console.WriteLine("What would you like to do next?"); Console.WriteLine("1) View Spaces"); Console.WriteLine("2) Search for reservation availability"); Console.WriteLine("R) Return to previous screen"); string choice = Console.ReadLine(); string choiceUp = choice.ToUpper(); switch (choiceUp) { case "1": done = true; pick = 1; break; case "2": done = true; pick = 2; break; case "R": done = true; pick = 3; break; default: Console.WriteLine("Please input a valid selection."); break; } } if (pick == 1) { ViewSpaces(userVenue); } else if (pick == 2) { ReservationSearch(userVenue, true); } else if (pick == 3) { DisplayVenueItems(); } }