public void Update()
{
CountService.Badge = CurrentUser.currentServices.Count.ToString();
var services = FurnitureStoreEntities.GetContext().Services.ToList();
switch (SortCategory.SelectedIndex)
{
case 0:
services = services.ToList();
break;
case 1:
services = services.Where(p => Convert.ToString(p.IdCategory).Contains("1")).ToList(); break;
case 2:
services = services.Where(p => Convert.ToString(p.IdCategory).Contains("2")).ToList(); break;
case 3:
services = services.Where(p => Convert.ToString(p.IdCategory).Contains("3")).ToList(); break;
case 4:
services = services.Where(p => Convert.ToString(p.IdCategory).Contains("4")).ToList(); break;
case 5:
services = services.Where(p => Convert.ToString(p.IdCategory).Contains("5")).ToList(); break;
}
services = services.Where(p => p.Name.ToLower().Contains(Search.Text.ToLower())).ToList();
ListServices.ItemsSource = services;
}
private void BtnAddservice_Click(object sender, RoutedEventArgs e)
{
if (_ccurrnetServices.Id == 0)
{
FurnitureStoreEntities.GetContext().Clients.Add(_ccurrnetServices);
}
try
{
FurnitureStoreEntities.GetContext().SaveChanges();
MessageBox.Show("Клиент успешно сохранен");
NavManager.AccountFrame.Navigate(new PageClients(NavManager.BtnServices.Content + ""));
}
catch (DbEntityValidationException ex)
{
if (ApplicationConfig.IsDev)
{
foreach (var errors in ex.EntityValidationErrors)
{
foreach (var validationError in errors.ValidationErrors)
{
MessageBox.Show(validationError.ErrorMessage);
}
}
}
else
{
MessageBox.Show("Произошла ошибка", "Внимание", MessageBoxButton.OK, MessageBoxImage.Warning);
}
}
}
private void AddOrder_Click(object sender, RoutedEventArgs e)
{
StringBuilder erros = new StringBuilder();
if (String.IsNullOrEmpty(FullName.Text))
{
erros.AppendLine("Введите ФИО");
}
else if (String.IsNullOrEmpty(Phone.Text))
{
erros.AppendLine("Введите телефон");
}
if (erros.Length > 0)
{
MessageBox.Show(erros.ToString());
return;
}
MessageBox.Show(FullName.Text + ", Ваш заказ успешно сформирован, скоро Вам перезвонит администратор");
var clients = FurnitureStoreEntities.GetContext().Clients.ToList();
clients = clients.Where(p => p.Fullname.Contains(FullName.Text)).ToList();
var client = clients.FirstOrDefault();
if (client == null)
{
Clients currnetClient = new Clients();
currnetClient.Fullname = FullName.Text;
currnetClient.Phone = Phone.Text;
FurnitureStoreEntities.GetContext().Clients.Add(currnetClient);
FurnitureStoreEntities.GetContext().SaveChanges();
var newClients = FurnitureStoreEntities.GetContext().Clients.ToList();
var newClient = newClients.LastOrDefault();
foreach (var component in CurrentUser.currentServices)
{
ClientService newSellService = new ClientService();
newSellService.IdService = component.Id;
newSellService.IdClient = newClient.Id;
newSellService.Date = DateTime.Now;
FurnitureStoreEntities.GetContext().ClientService.Add(newSellService);
FurnitureStoreEntities.GetContext().SaveChanges();
}
}
else
{
foreach (var component in CurrentUser.currentServices)
{
ClientService newSellService = new ClientService();
newSellService.IdService = component.Id;
newSellService.IdClient = client.Id;
newSellService.Date = DateTime.Now;
FurnitureStoreEntities.GetContext().ClientService.Add(newSellService);
FurnitureStoreEntities.GetContext().SaveChanges();
}
}
}
private void BtnSelectCategory_Click(object sender, RoutedEventArgs e)
{
Categoris name = (Categoris)(sender as Button).DataContext as Categoris;
var services = FurnitureStoreEntities.GetContext().Services.ToList();
services = services.Where(p => p.Categoris.Name.Contains(name.Name)).ToList();
ListServices.ItemsSource = services;
}
public void Update()
{
CountService.Badge = CurrentUser.currentServices.Count.ToString();
var services = FurnitureStoreEntities.GetContext().Services.ToList();
services = services.Where(p => p.Name.ToLower().Contains(Search.Text.ToLower())).ToList();
ListServices.ItemsSource = services;
}
public PageAddEditService(Services selectService)
{
InitializeComponent();
if (selectService != null)
{
_ccurrnetServices = selectService;
CBoxServices.SelectedItem = selectService.Categoris;
}
DataContext = _ccurrnetServices;
CBoxServices.ItemsSource = FurnitureStoreEntities.GetContext().Categoris.ToList();
}
public PageAddEditCientService(ClientService selectClientService)
{
InitializeComponent();
if (selectClientService != null)
{
_ccurrnetClientService = selectClientService;
CBoxServices.SelectedItem = selectClientService.Services;
CBoxClients.SelectedItem = selectClientService.Clients;
}
DataContext = _ccurrnetClientService;
CBoxServices.ItemsSource = FurnitureStoreEntities.GetContext().Services.ToList();
CBoxClients.ItemsSource = FurnitureStoreEntities.GetContext().Clients.ToList();
}
public PageReports(string header)
{
InitializeComponent();
Header.Text = header;
ChatPayments.ChartAreas.Add(new System.Windows.Forms.DataVisualization.Charting.ChartArea());
ChatPayments.Series.Add("Прибыль"); // Add this line
var payments = FurnitureStoreEntities.GetContext().ClientService.ToList();
foreach (var r in payments)
{
ChatPayments.Series["Прибыль"].Points.AddXY(r.Date, r.Services.Cost);
}
ChatPayments.DataBind();
}
private void BtndelClientService_Click(object sender, RoutedEventArgs e)
{
var serviceForDelete = DGridClientServices.SelectedItems.Cast <ClientService>().ToList();
if (MessageBox.Show($"Вы действительно хотите удалить {serviceForDelete.Count} элементов?", "Внимание!", MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.Yes)
{
try
{
FurnitureStoreEntities.GetContext().ClientService.RemoveRange(serviceForDelete);
FurnitureStoreEntities.GetContext().SaveChanges();
DGridClientServices.ItemsSource = FurnitureStoreEntities.GetContext().ClientService.ToList();
MessageBox.Show("Удаление выделенных элементов прошло успешно");
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
}
private void BtnAddservice_Click(object sender, RoutedEventArgs e)
{
if (_ccurrnetServices.Cost <= 0)
{
MessageBox.Show("Цена не должна быть < 0");
return;
}
Categoris p = (Categoris)CBoxServices.SelectedItem;
_ccurrnetServices.IdCategory = p.Id;
if (_ccurrnetServices.Id == 0)
{
FurnitureStoreEntities.GetContext().Services.Add(_ccurrnetServices);
}
try
{
FurnitureStoreEntities.GetContext().SaveChanges();
MessageBox.Show("Товар успешно сохранен");
NavManager.AccountFrame.Navigate(new PageServices(NavManager.BtnServices.Content + ""));
}
catch (DbEntityValidationException ex)
{
if (ApplicationConfig.IsDev)
{
foreach (var errors in ex.EntityValidationErrors)
{
foreach (var validationError in errors.ValidationErrors)
{
MessageBox.Show(validationError.ErrorMessage);
}
}
}
else
{
MessageBox.Show("Произошла ошибка", "Внимание", MessageBoxButton.OK, MessageBoxImage.Warning);
}
}
}
private void BtnSignInAdmin_Click(object sender, RoutedEventArgs e)
{
var user = FurnitureStoreEntities.GetContext().Admins.ToList();
if (ApplicationConfig.IsDev)
{
user = user.Where(p => p.Login.ToLower().Contains("director".ToLower())).ToList();
user = user.Where(p => p.Password.ToLower().Contains("1234".ToLower())).ToList();
}
else
{
StringBuilder erros = new StringBuilder();
if (String.IsNullOrEmpty(Login.Text))
{
erros.AppendLine("Введите логин");
}
else if (String.IsNullOrEmpty(Password.Password))
{
erros.AppendLine("Введите пароль");
}
if (erros.Length > 0)
{
MessageBox.Show(erros.ToString());
return;
}
user = user.Where(p => p.Login.ToLower().Contains(Login.Text.ToLower())).ToList();
user = user.Where(p => p.Password.ToLower().Contains(Password.Password.ToLower())).ToList();
}
Admins searchuser = user.FirstOrDefault();
if (searchuser == null)
{
MessageBox.Show("Наверный логин или пароль", "внимание", MessageBoxButton.OK, MessageBoxImage.Warning);
return;
}
CurrentUser.PermissionName = searchuser.Permissions.Name;
if (searchuser.Permissions.AccessClients == 1)
{
CurrentUser.AccessClients = true;
}
else
{
CurrentUser.AccessClients = false;
}
if (searchuser.Permissions.AccessServices == 1)
{
CurrentUser.AccessServices = true;
}
else
{
CurrentUser.AccessServices = false;
}
if (searchuser.Permissions.AccessClientService == 1)
{
CurrentUser.AccessClientsServicrs = true;
}
else
{
CurrentUser.AccessClientsServicrs = false;
}
if (searchuser.Permissions.AccessReports == 1)
{
CurrentUser.AccessReport = true;
}
else
{
CurrentUser.AccessReport = false;
}
NavManager.MainFrame.Navigate(new Account());
}
public Users()
{
InitializeComponent();
ListCategorys.ItemsSource = FurnitureStoreEntities.GetContext().Categoris.ToList();
Update();
}
public PageClients(string header)
{
InitializeComponent();
Header.Text = header;
DGridClients.ItemsSource = FurnitureStoreEntities.GetContext().Clients.ToList();
}
public PageServices(string header)
{
InitializeComponent();
DGridServices.ItemsSource = FurnitureStoreEntities.GetContext().Services.ToList();
Header.Text = header;
}
