private void cbOptions_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
int a = cbOptions.SelectedIndex;
switch (a)
{
case 0: listDormVerti = DormDatabase.GetAllListDormNew(); listViewVerti.ItemsSource = listDormVerti; break;
case 1: listDormVerti = DormDatabase.GetAllListDormIncreasingPrice(); listViewVerti.ItemsSource = listDormVerti; break;
case 2: listDormVerti = DormDatabase.GetAllListDormDecreasingPrice(); listViewVerti.ItemsSource = listDormVerti; break;
case 3: listDormVerti = DormDatabase.GetAllListDormIncreasingBookTimes(); listViewVerti.ItemsSource = listDormVerti; break;
case 4: listDormVerti = DormDatabase.GetAllListDormDecreasingBookTimes(); listViewVerti.ItemsSource = listDormVerti; break;
case 5: listDormVerti = DormDatabase.GetAllListDormIncreasingLike(); listViewVerti.ItemsSource = listDormVerti; break;
case 6: listDormVerti = DormDatabase.GetAllListDormDecreasingLike(); listViewVerti.ItemsSource = listDormVerti; break;
case 7: listDormVerti = DormDatabase.GetAllListDormIncreasingRating(); listViewVerti.ItemsSource = listDormVerti; break;
case 8: listDormVerti = DormDatabase.GetAllListDormDecreasingRating(); listViewVerti.ItemsSource = listDormVerti; break;
}
CollectionViewSource.GetDefaultView(listViewVerti.ItemsSource).Refresh();
}
private void updateStateDorm(object sender, string msg, int state)
{
Button button = sender as Button;
BookDorm dorm = button.DataContext as BookDorm;
if (BookDatabase.UpdateDormWhenBook(dorm.EmailOwner, dorm.EmailUser, dorm.IdDorm, state))
{
if (BookDatabase.DeleteDormWhenBook(dorm.EmailOwner, dorm.EmailUser, dorm.IdDorm))
{
Helpers.MakeConfirmMessage(Window.GetWindow(this), $"The Dorm has been {msg} to { dorm.EmailUser}", "Notify");
int count = DormDatabase.GetCount(dorm.IdDorm) + 1;
DormDatabase.UpdateCountDorm(dorm.IdDorm, count);
MainControl mainControl = (MainControl)Window.GetWindow(this);
mainControl.MainHomeLayout.Children.Clear();
mainControl.MainHomeLayout.VerticalAlignment = VerticalAlignment.Top;
mainControl.MainHomeLayout.HorizontalAlignment = HorizontalAlignment.Left;
mainControl.MainHomeLayout.Width = 1150;
mainControl.MainHomeLayout.Height = 720;
mainControl.MainHomeLayout.Children.Add(new MyDorm(mainControl.user));
}
else
{
Helpers.MakeErrorMessage(Window.GetWindow(this), $"Failed {msg} to {dorm.EmailUser}", "Error");
}
}
}
private void btnDelete_Click(object sender, RoutedEventArgs e)
{
Button button = sender as Button;
Dorm dorm = button.DataContext as Dorm;
MessageBoxResult result = MessageBox.Show("Would you like to delete this dorm?", "Notify", MessageBoxButton.YesNo);
switch (result)
{
case MessageBoxResult.Yes:
if (DormDatabase.Delete(dorm.Id))
{
BookDatabase.DeleteByIdDorm(dorm.Id);
OwnerDormDatabase.DeleteByDormId(dorm.Id);
LikeDatabase.DeleteById(dorm.Id);
CommentDatabase.DeleteByIdDorm(dorm.Id);
MainControl mainControl = (MainControl)Window.GetWindow(this);
mainControl.MainHomeLayout.Children.Clear();
mainControl.MainHomeLayout.VerticalAlignment = VerticalAlignment.Top;
mainControl.MainHomeLayout.HorizontalAlignment = HorizontalAlignment.Left;
mainControl.MainHomeLayout.Width = 1150;
mainControl.MainHomeLayout.Height = 720;
mainControl.MainHomeLayout.Children.Add(new MyDorm(mainControl.user));
}
break;
}
}
private void setUpListViewVerti()
{
listDormVerti = DormDatabase.GetAllListDorm();
listViewVerti.ItemsSource = listDormVerti;
CollectionView view = (CollectionView)CollectionViewSource.GetDefaultView(listViewVerti.ItemsSource);
view.Filter = DormFilter;
}
private void listViewDormBook_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
BookDorm dormB = listViewDormBook.SelectedItem as BookDorm;
Dorm dorm = DormDatabase.Get(dormB.IdDorm);
MainControl mainControl = (MainControl)Window.GetWindow(this);
mainControl.MainHomeLayout.Children.Clear();
TransitioningContentSlide.OnApplyTemplate();
mainControl.MainHomeLayout.VerticalAlignment = VerticalAlignment.Top;
mainControl.MainHomeLayout.HorizontalAlignment = HorizontalAlignment.Left;
mainControl.MainHomeLayout.Width = 1150;
mainControl.MainHomeLayout.Height = 720;
mainControl.MainHomeLayout.Children.Add(new ShowDorm(dorm, BookDatabase.GetOwnerByIdDorm(dorm.Id), 2));
}
private void btnComment_Click(object sender, RoutedEventArgs e)
{
if (user.Email.Equals(owner.Email))
{
Helpers.MakeErrorMessage(Window.GetWindow(this), "You are owner so can't rating", "Error");
}
else
{
if (BookDatabase.GetEmailBookDorm(owner.Email, dorm.Id).Equals(user.Email))
{
ValueRating = ratingBar.Value;
Comment = tbComment.Text.Trim();
if (ValueRating == 0)
{
Helpers.MakeErrorMessage(Window.GetWindow(this), "You must rating dorm ", "Error");
}
else
{
if (CommentDatabase.Insert(owner.Email, dorm.Id, user.Email, Comment, ValueRating))
{
Helpers.MakeConfirmMessage(Window.GetWindow(this), "Thanks you bro", "Notify");
if (CommentDatabase.GetAvgRating(owner.Email, dorm.Id) != -1)
{
DormDatabase.UpdateRating(dorm.Id, CommentDatabase.GetAvgRating(owner.Email, dorm.Id));
dorm.Quality = (dorm.Quality + ValueRating) / DormDatabase.GetCount(dorm.Id);
MainControl mainControl = (MainControl)Window.GetWindow(this);
mainControl.MainHomeLayout.Children.Clear();
mainControl.MainHomeLayout.VerticalAlignment = VerticalAlignment.Top;
mainControl.MainHomeLayout.HorizontalAlignment = HorizontalAlignment.Left;
mainControl.MainHomeLayout.Width = 1150;
mainControl.MainHomeLayout.Height = 720;
mainControl.MainHomeLayout.Children.Add(new ShowDorm(dorm, user, 1));
}
}
else
{
Helpers.MakeErrorMessage(Window.GetWindow(this), "You already rating this dorm", "Error");
}
}
}
else
{
Helpers.MakeErrorMessage(Window.GetWindow(this), "You can't comment because you have never book this dorm", "Error");
}
}
}
private void PackIcon_MouseDown(object sender, MouseButtonEventArgs e)
{
try
{
if (LikeDatabase.Insert(user.Email, dorm.Id, 1))
{
AnimationLikeOpacity();
likeIcon.Foreground = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#E34853"));
CountLikeDorm++;
dorm.CountLike++;
DormDatabase.UpdateLikeDorm(dorm);
}
else
{
bool click = LikeDatabase.GetStateLike(user.Email, dorm.Id);
if (!click)
{
likeIcon.Foreground = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#E34853"));
CountLikeDorm++;
dorm.CountLike++;
AnimationLikeOpacity();
DormDatabase.UpdateLikeDorm(dorm);
LikeDatabase.Update(user.Email, dorm.Id, 1);
}
else
{
likeIcon.Foreground = new SolidColorBrush(Colors.Gray);
CountLikeDorm--;
if (CountLikeDorm == -1)
{
LikeDatabase.DeleteById(dorm.Id);
CountLikeDorm = 0;
}
dorm.CountLike = CountLikeDorm;
DormDatabase.UpdateLikeDorm(dorm);
LikeDatabase.Update(user.Email, dorm.Id, 0);
}
}
}
catch (Exception exec)
{
MessageBox.Show("Error while processing Like....");
}
}
private void btnUpload_Click(object sender, RoutedEventArgs e)
{
DormDb dorm = new DormDb();
dorm.Owner = OwnerDorm;
dorm.Address = AddressDorm;
dorm.Price = PriceDorm;
dorm.Size = AreaDorm;
dorm.Sale = SaleDorm;
dorm.Quality = 0;
dorm.Count = 0;
dorm.CountLike = 0;
dorm.Description = DesDorm;
dorm.Image = Helpers.ConvertImageToBinary(ImageDorm);
dorm.IsWifi = Helpers.ConverBoolToByte(WifiDorm);
dorm.IsParking = Helpers.ConverBoolToByte(ParkingDorm);
dorm.IsTelevision = Helpers.ConverBoolToByte(TelevisionDorm);
dorm.IsBathroom = Helpers.ConverBoolToByte(BathDorm);
dorm.IsAirCondiditioner = Helpers.ConverBoolToByte(AirConDorm);
dorm.IsWaterHeater = Helpers.ConverBoolToByte(WaterHeaterDorm);
if (!check)
{
if (DormDatabase.Insert(dorm))
{
Helpers.MakeConfirmMessage(Window.GetWindow(this), "Post Dorm Successfully~", "Notify");
OwnerDormDatabase.Insert(user.Email, DormDatabase.GetAllListDorm()[DormDatabase.GetAllListDorm().Count - 1].Id);
}
}
else
{
if (DormDatabase.Update(dorm, dormSend.Id))
{
Helpers.MakeConfirmMessage(Window.GetWindow(this), "Update Dorm Successfully~", "Notify");
}
else
{
Helpers.MakeErrorMessage(Window.GetWindow(this), "Failure update Dorm", "Error");
}
}
}
private void btnCanel_Click(object sender, RoutedEventArgs e)
{
Button button = sender as Button;
BookDorm dormB = button.DataContext as BookDorm;
Dorm dorm = DormDatabase.Get(dormB.IdDorm);
MainControl mainControl = (MainControl)Window.GetWindow(this);
MessageBoxResult result = MessageBox.Show("Would you like to cancel booking this dorm?", "Notify", MessageBoxButton.YesNo);
switch (result)
{
case MessageBoxResult.Yes:
if (BookDatabase.DeleteDormWhenBookUser(mainControl.user.Email, dorm.Id))
{
mainControl.MainHomeLayout.Children.Clear();
mainControl.MainHomeLayout.VerticalAlignment = VerticalAlignment.Top;
mainControl.MainHomeLayout.HorizontalAlignment = HorizontalAlignment.Left;
mainControl.MainHomeLayout.Width = 1150;
mainControl.MainHomeLayout.Height = 720;
mainControl.MainHomeLayout.Children.Add(new MyDorm(mainControl.user));
}
break;
}
}
private void setUpListViewHori()
{
listDorm = DormDatabase.GetAllListDormPopular();
listViewHori.ItemsSource = listDorm;
}
