public static void AddResteraunt(Resteraunt res)
{
ResterauntRepository resterauntRepository = new ResterauntRepository();
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["DataContext"].ConnectionString);
SqlCommand cmd;
SqlDataAdapter da;
try
{
using (con)
{
string cmdText = $"Insert into Resteraunts(Name, City )values(' {res.Name}', '{res.City}')";
con.Open();
cmd = new SqlCommand(cmdText, con);
cmd.ExecuteNonQuery();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
con.Close();
}
}
public static void AddReview()
{
ResterauntFunctions resterauntFunctions = new ResterauntFunctions();
ReviewFunctions reviewFunctions = new ReviewFunctions();
ResterauntRepository resterauntRepo = new ResterauntRepository();
Console.WriteLine("What resteraunt Would you like to add a review to?");
try
{
string reviewRester = Console.ReadLine();
var resterauntResult = resterauntFunctions.searchByPartialName(reviewRester);
while (
resterauntResult.Count > 1)
{
Console.WriteLine("Please Specify which resteraunt you would like to review ");
reviewRester = Console.ReadLine();
resterauntResult = resterauntFunctions.searchByPartialName(reviewRester);
}
;
var singleResteraunt = resterauntFunctions.searchByPartialName(reviewRester).FirstOrDefault();
var ResterauntId = resterauntRepo.ConvertNameIntoId(singleResteraunt.Name).FirstOrDefault();
Console.WriteLine("Between 1 and 5 how would you rate the resteraunt");
Review review = new Review();
review.Rating = double.Parse(Console.ReadLine());
ResterauntCrudOps.AddReview(review, ResterauntId);
Console.WriteLine("you have succesfully added a review ");
Console.Read();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
