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