public ReviewService(ReviewDal reviewDal, ItemDal itemDal, UserDal userDal, IMapper mapper)
{
_reviewDal = reviewDal;
_itemDal = itemDal;
_userDal = userDal;
_mapper = mapper;
}
public async Task AfterRequestDescriptionAsync(IDialogContext context, IAwaitable <string> argument)
{
_description = await argument;
await ReviewDal.AddNewReviewToTable(new ReviewModel(_city, _depertment)
{
TypeOfProblem = _typeOfProblem,
Description = _description
});
await context.PostAsync("Ваш відгук збережено");
context.Wait(MessageReceivedAsync);
}
public void ChooseActionForReviews()
{
ReviewDal reviewDal = new ReviewDal();
Console.Clear();
Console.WriteLine("TABLE: REVIEWS\n\n");
Console.WriteLine("What action you want to choose?\n" +
"1. View all reviews\n" +
"2. Get review by Id\n" +
"3. Get review by name of column\n" +
"4. Add review\n" +
"5. Edit info about review\n" +
"6. Delete review by Id\n" +
"7. Delete review by name of column\n" +
"8. Back to start menu");
Console.Write("\nYour selection: ");
string ch = Console.ReadLine();
switch (ch)
{
case "1":
{
try
{
Console.Clear();
Console.WriteLine("TABLE: REVIEWS\n\n");
reviewDal.PrintListOfReviews(reviewDal.GetAll());
Console.ReadKey();
break;
}
finally
{
Menu menu = new Menu();
menu.ChooseActionForReviews();
}
}
case "2":
{
try
{
Console.Clear();
Console.WriteLine("TABLE: REVIEWS\n\nId: ");
int id = Convert.ToInt32(Console.ReadLine());
reviewDal.PrintReview(reviewDal.GetById(id));
Console.ReadKey();
break;
}
finally
{
Menu menu = new Menu();
menu.ChooseActionForReviews();
}
}
case "3":
{
try
{
Console.Clear();
Console.WriteLine("TABLE: REVIEWS\n\nName of column: ");
string fieldName = Console.ReadLine();
Console.WriteLine("\nValue: ");
string text = Console.ReadLine();
reviewDal.PrintListOfReviews(reviewDal.GetByFieldName(fieldName, text));
Console.ReadKey();
break;
}
finally
{
Menu menu = new Menu();
menu.ChooseActionForReviews();
}
}
case "4":
{
try
{
Console.Clear();
Console.WriteLine("TABLE: REVIEWS\n\n");
Console.WriteLine("USER_ID: ");
int userId = Convert.ToInt32(Console.ReadLine());
Console.WriteLine("ITEM_ID: ");
int itemId = Convert.ToInt32(Console.ReadLine());
Console.WriteLine("TEXT OF REVIEW: ");
string text = Console.ReadLine();
DateTime dateTime = DateTime.Now;
Review review = new Review(userId, itemId, text, dateTime);
reviewDal.Insert(review);
Console.WriteLine("Review succesfully inserted :)");
Console.ReadKey();
break;
}
finally
{
Menu menu = new Menu();
menu.ChooseActionForReviews();
}
}
case "5":
{
try
{
Console.Clear();
Console.WriteLine("TABLE: REVIEWS\n\n");
Console.WriteLine("Name of column (set): ");
string fieldName = Console.ReadLine();
Console.WriteLine("Value (set): ");
string text = Console.ReadLine();
Console.WriteLine("Name of column (condition): ");
string fieldCondition = Console.ReadLine();
Console.WriteLine("Value (condition): ");
string textCondition = Console.ReadLine();
reviewDal.UpdateByFieldName(fieldName, text, fieldCondition, textCondition);
Console.WriteLine("Review succesfully updated :)");
Console.ReadKey();
break;
}
finally
{
Menu menu = new Menu();
menu.ChooseActionForReviews();
}
}
case "6":
{
try
{
Console.Clear();
Console.WriteLine("TABLE: REVIEWS\n\nId: ");
int id = Convert.ToInt32(Console.ReadLine());
reviewDal.DeleteById(id);
Console.WriteLine("Review succesfully deleted :)");
Console.ReadKey();
break;
}
finally
{
Menu menu = new Menu();
menu.ChooseActionForReviews();
}
}
case "7":
{
try
{
Console.Clear();
Console.WriteLine("TABLE: REVIEWS\n\n ");
Console.WriteLine("Name of column (condition): ");
string fieldCondition = Console.ReadLine();
Console.WriteLine("Value (condition): ");
string textCondition = Console.ReadLine();
reviewDal.DeleteByFieldName(fieldCondition, textCondition);
Console.WriteLine("Review succesfully deleted :)");
Console.ReadKey();
break;
}
finally
{
Menu menu = new Menu();
menu.ChooseActionForReviews();
}
}
case "8":
{
Menu menu = new Menu();
menu.ChooseTable();
break;
}
default:
Console.WriteLine("Invalid selection. Please select 1, 2, 3, 4, 5, 6, 7 or 8.");
break;
}
}
