private void Window_Loaded(object sender, RoutedEventArgs e)
{
try
{
using (WFAEntity.API.MyDBContext objectMyDBContext = new WFAEntity.API.MyDBContext())
{
try
{
if (objectMyDBContext.Database.Exists() == false)
{
WFAEntity.API.DatabaseRequest.Fill();
//objectMyDBContext.Database.Create();
//WFAEntity.API.Employees objectUser = new WFAEntity.API.Employees();
//objectUser.Name = "user name";
//objectUser.Login = "******";
//objectUser.Password = "******";
//objectMyDBContext.Employees.Add(objectUser);
objectMyDBContext.SaveChanges();
}
//WFAEntity.API.DatabaseRequest.Fill();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Создание базы данных");
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Подключение к базе данных");
}
this.ShowAll();
}
private void ButtonAddEditServices_Click(object sender, RoutedEventArgs e)
{
if (!IsEdit)
{
if (textBlockAddEditName.Text != string.Empty)
{
WFAEntity.API.Other_services objectServices = new WFAEntity.API.Other_services(
textBlockAddEditName.Text,
textBlockAddEditThe_cost.Text,
(WFAEntity.API.Employees)ComboBoxAddEditName.SelectedItem
);
try
{
using (WFAEntity.API.MyDBContext objectMyDBContext =
new WFAEntity.API.MyDBContext())
{
objectMyDBContext.Other_services.Add(objectServices);
objectMyDBContext.SaveChanges();
}
MessageBox.Show("Услуга добавлена");
this.DialogResult = true;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "ОШИБКА", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
else
{
MessageBox.Show("Заполните все поля!", "Ошибка!");
this.DialogResult = false;
}
}
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
//var tmp = MyDBContext.DBContext.Other_services.ToList();
//List<string> Strings = new List<string>();
//for (int i = 0; i < tmp.Count; i++)
//{
// Strings.Add(tmp[0].Name + " " + tmp[0].The_cost);
//}
//ComboBoxAddEditServices.ItemsSource = Strings;
//var tmp1 = MyDBContext.DBContext.Employees.ToList();
//List<string> Strings1 = new List<string>();
//for (int i = 0; i < tmp1.Count; i++)
//{
// Strings1.Add(tmp1[0].Name + " " + tmp1[0].Surname);
//}
//ComboBoxAddEditEmployees.ItemsSource = Strings1;
using (WFAEntity.API.MyDBContext objectMyDBContext =
new WFAEntity.API.MyDBContext())
{
ComboBoxAddEditEmployees.ItemsSource = WFAEntity.API.DatabaseRequest.GetEmployees(objectMyDBContext);
ComboBoxAddEditEmployees.Text = "{Binging Name}";
ComboBoxAddEditServices.ItemsSource = WFAEntity.API.DatabaseRequest.GetServices(objectMyDBContext);
ComboBoxAddEditServices.Text = "{Binging Name}";
}
}
private void deleteSkatesButton_Click(object sender, RoutedEventArgs e)
{
if (SkatesGrid.SelectedItems.Count > 0)
{
for (int i = 0; i < SkatesGrid.SelectedItems.Count; i++)
{
WFAEntity.API.Skates_hire objectSkates = SkatesGrid.SelectedItems[i] as WFAEntity.API.Skates_hire;
// if (objectSkates != null)
try
{
using (WFAEntity.API.MyDBContext objectMyDBContext =
new WFAEntity.API.MyDBContext())
{
WFAEntity.API.Skates_hire Skates = WFAEntity.API.DatabaseRequest.GetSkatesById(objectMyDBContext, objectSkates.ID_skates_hire);
objectMyDBContext.Skates_hire.Attach(Skates);
objectMyDBContext.Skates_hire.Remove(Skates);
objectMyDBContext.SaveChanges();
}
//this.ShowAll(SELECTED_TAB.STUDENT);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "ОШИБКА", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
}
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
using (WFAEntity.API.MyDBContext objectMyDBContext =
new WFAEntity.API.MyDBContext())
{
ComboBoxAddEditName.ItemsSource = WFAEntity.API.DatabaseRequest.GetEmployees(objectMyDBContext);
ComboBoxAddEditName.Text = "{Binging Name}";
}
}
private void ShowAll()
{
try
{
using (WFAEntity.API.MyDBContext objectMyDBContext = new WFAEntity.API.MyDBContext())
{
//var list = WpfApplicationEntity.API.DatabaseRequest.GetMatType(objectMyDBContext);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Тип материалов", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
using (WFAEntity.API.MyDBContext objectMyDBContext =
new WFAEntity.API.MyDBContext())
{
ComboBoxAddEditClient.ItemsSource = WFAEntity.API.DatabaseRequest.GetClients(objectMyDBContext);
ComboBoxAddEditClient.Text = "{Binging Name}";
ComboBoxAddEditShedule.ItemsSource = WFAEntity.API.DatabaseRequest.GetShedule(objectMyDBContext);
ComboBoxAddEditShedule.Text = "{Binging Date}";
ComboBoxAddEditServices.ItemsSource = WFAEntity.API.DatabaseRequest.GetServices(objectMyDBContext);
ComboBoxAddEditServices.Text = "{Binging Name}";
ComboBoxAddEditSkates.ItemsSource = WFAEntity.API.DatabaseRequest.GetSkates(objectMyDBContext);
ComboBoxAddEditSkates.Text = "{Binging Size}";
}
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
/*var tmp = MyDBContext.DBContext.Employees.ToList();
* List<string> Strings = new List<string>();
* for (int i = 0; i < tmp.Count; i++)
* {
* Strings.Add(tmp[i].Name);
* }
* ComboBoxAddEditEmployess.ItemsSource = Strings;*/
using (WFAEntity.API.MyDBContext objectMyDBContext =
new WFAEntity.API.MyDBContext())
{
ComboBoxAddEditEmployess.ItemsSource = WFAEntity.API.DatabaseRequest.GetEmployees(objectMyDBContext);
ComboBoxAddEditEmployess.Text = "{Binging Name}";
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
using (WFAEntity.API.MyDBContext MyDBContext = new WFAEntity.API.MyDBContext())
{
var tmp = (
from tmpEmployees in MyDBContext.Employees.ToList <Employees>()
where tmpEmployees.Login.CompareTo(Log.Text) == 0 && tmpEmployees.Password.CompareTo(Pas.Text) == 0
select tmpEmployees
).ToList();
if (tmp.Count > 0)
{
if (tmp[0].Login == "Администратор")
{
Forms.SheduleWindow g = new Forms.SheduleWindow(new MainWindow());
if (g.ShowDialog() == true)
{
this.ShowAll();
}
}
else if (tmp[0].Login == "Кассир")
{
SkatesWindow g = new SkatesWindow(new MainWindow());
if (g.ShowDialog() == true)
{
this.ShowAll();
}
}
else if (tmp[0].Login == "Посетитель")
{
MainWindow g = new MainWindow();
if (g.ShowDialog() == true)
{
this.ShowAll();
}
}
}
else
{
MessageBox.Show("Ошибочка");
}
}
}
public void ShowAll()
{
try
{
using (WFAEntity.API.MyDBContext objectMyDBContext =
new WFAEntity.API.MyDBContext())
{
ClientGrid.ItemsSource = WFAEntity.API.DatabaseRequest.GetClients(objectMyDBContext);
EmployeesGrid.ItemsSource = WFAEntity.API.DatabaseRequest.GetEmployees(objectMyDBContext);
SkatesGrid.ItemsSource = WFAEntity.API.DatabaseRequest.GetEmployeesWithTicket(objectMyDBContext);
SheduleGrid.ItemsSource = WFAEntity.API.DatabaseRequest.GetEmployeesWithSchedule(objectMyDBContext);
TicketsGrid.ItemsSource = WFAEntity.API.DatabaseRequest.GetClientWithTicket(objectMyDBContext);
ServiceGrid.ItemsSource = WFAEntity.API.DatabaseRequest.GetEmployeesWithServices(objectMyDBContext);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Клиент", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private void deleteTicketButton_Click(object sender, RoutedEventArgs e)
{
// var itm = (Ticket)TicketsGrid.SelectedItem;
// var tmp = (
//from tmpTicket in MyDBContext.DBContext.Ticket.ToList<Ticket>()
//where tmpTicket.ID_Ticket == itm.ID_Ticket
//select tmpTicket
// ).ToList();
// MyDBContext.DBContext.Ticket.Remove(tmp[0]);
// MyDBContext.DBContext.SaveChanges();
// ShowAll();
if (TicketsGrid.SelectedItems.Count > 0)
{
for (int i = 0; i < TicketsGrid.SelectedItems.Count; i++)
{
WFAEntity.API.Ticket objectSkatesTicket = TicketsGrid.SelectedItems[i] as WFAEntity.API.Ticket;
//if (objectSkates != null)
try
{
using (WFAEntity.API.MyDBContext objectMyDBContext =
new WFAEntity.API.MyDBContext())
{
//WFAEntity.API.Ticket Skates = WFAEntity.API.DatabaseRequest.GetSkatesById(objectMyDBContext, objectSkates.ID_skates_hire);
//objectMyDBContext.Skates_hire.Attach(Skates);
//objectMyDBContext.Skates_hire.Remove(Skates);
objectMyDBContext.SaveChanges();
}
//this.ShowAll(SELECTED_TAB.STUDENT);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "ОШИБКА", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
}
}
private void ButtonAddEditTicket_Click(object sender, RoutedEventArgs e)
{
if (!IsEdit)
{
if (textBlockAddEditCost.Text != string.Empty)
{
using (WFAEntity.API.MyDBContext objectMyDBContext =
new WFAEntity.API.MyDBContext())
{
WFAEntity.API.Ticket objectTicket = new WFAEntity.API.Ticket(
textBlockAddEditCost.Text,
textBlockAddEditAmount.Text,
textBlockAddEditStatus.Text,
(WFAEntity.API.Client)ComboBoxAddEditClient.SelectedItem,
(WFAEntity.API.MK_schedule)ComboBoxAddEditShedule.SelectedItem,
(WFAEntity.API.Other_services)ComboBoxAddEditServices.SelectedItem,
(WFAEntity.API.Skates_hire)ComboBoxAddEditSkates.SelectedItem
);
try
{
objectMyDBContext.Ticket.Add(objectTicket);
objectMyDBContext.SaveChanges();
MessageBox.Show("Билет добавлен");
this.DialogResult = true;
AF.ShowAll();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "ОШИБКА", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
}
else
{
MessageBox.Show("Заполните все поля!", "Ошибка!");
this.DialogResult = false;
}
}
else
{
using (WFAEntity.API.MyDBContext objectMyDBContext =
new WFAEntity.API.MyDBContext())
{
WFAEntity.API.Employees objectTicket = new WFAEntity.API.Employees();
EditTicket.Cost = textBlockAddEditCost.Text;
EditTicket.Amount = textBlockAddEditAmount.Text;
EditTicket.Status = textBlockAddEditStatus.Text;
try
{
objectMyDBContext.Ticket.AddOrUpdate(EditTicket);
objectMyDBContext.SaveChanges();
MessageBox.Show("Билет Редактирован");
this.DialogResult = true;
AF.ShowAll();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "ОШИБКА", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
}
}
private void ButtonAddEditSkates_Click(object sender, RoutedEventArgs e)
{
if (!IsEdit)
{
if (textBlockAddEditSize.Text != string.Empty)
{
using (WFAEntity.API.MyDBContext objectMyDBContext =
new WFAEntity.API.MyDBContext())
{
WFAEntity.API.Skates_hire objectSkates = new WFAEntity.API.Skates_hire(
textBlockAddEditSize.Text,
textBlockAddEditTime.Text,
textBlockAddEditCount.Text,
textBlockAddEditType.Text,
(WFAEntity.API.Employees)ComboBoxAddEditEmployess.SelectedItem
);
try
{
objectMyDBContext.Skates_hire.Add(objectSkates);
objectMyDBContext.SaveChanges();
MessageBox.Show("Коньки добавлены");
this.DialogResult = true;
AF.ShowAll();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "ОШИБКА", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
}
else
{
MessageBox.Show("Заполните все поля!", "Ошибка!");
this.DialogResult = false;
}
}
else
{
using (WFAEntity.API.MyDBContext objectMyDBContext =
new WFAEntity.API.MyDBContext())
{
WFAEntity.API.Skates_hire objectSkates = new WFAEntity.API.Skates_hire(
textBlockAddEditSize.Text,
textBlockAddEditTime.Text,
textBlockAddEditType.Text,
textBlockAddEditCount.Text,
(WFAEntity.API.Employees)ComboBoxAddEditEmployess.SelectedItem
);
try
{
objectMyDBContext.Skates_hire.AddOrUpdate(EditSkates);
objectMyDBContext.SaveChanges();
MessageBox.Show("Клиент Редактирован");
this.DialogResult = true;
AF.ShowAll();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "ОШИБКА", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
}
}
private void ButtonAddEditShedule_Click(object sender, RoutedEventArgs e)
{
if (!IsEdit)
{
if (textBlockAddEditDate.Text != string.Empty)
{
using (WFAEntity.API.MyDBContext objectMyDBContext =
new WFAEntity.API.MyDBContext())
{
WFAEntity.API.MK_schedule objectShedule = new WFAEntity.API.MK_schedule(
textBlockAddEditDate.Text,
textBlockAddEditPrice.Text,
textBlockAddEditStart.Text,
textBlockAddEditEnd.Text,
(WFAEntity.API.Employees)ComboBoxAddEditEmployees.SelectedItem,
(WFAEntity.API.Other_services)ComboBoxAddEditServices.SelectedItem
);
try
{
objectMyDBContext.MK_schedule.Add(objectShedule);
objectMyDBContext.SaveChanges();
MessageBox.Show("Расписание добавлено");
this.DialogResult = true;
AF.ShowAll();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "ОШИБКА", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
}
else
{
MessageBox.Show("Заполните все поля!", "Ошибка!");
this.DialogResult = false;
}
}
else
{
using (WFAEntity.API.MyDBContext objectMyDBContext =
new WFAEntity.API.MyDBContext())
{
WFAEntity.API.MK_schedule objectShedule = new WFAEntity.API.MK_schedule();
objectShedule.Date = textBlockAddEditDate.Text;
objectShedule.Price = textBlockAddEditPrice.Text;
objectShedule.Start_time = textBlockAddEditStart.Text;
objectShedule.End_time = textBlockAddEditEnd.Text;
try
{
objectMyDBContext.MK_schedule.AddOrUpdate(EditShedule);
objectMyDBContext.SaveChanges();
MessageBox.Show("Расписание Редактировано");
this.DialogResult = true;
AF.ShowAll();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "ОШИБКА", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
}
}
private void ButtonAddEditEmployees_Click(object sender, RoutedEventArgs e)
{
if (!IsEdit)
{
if (textBlockAddEditSurname.Text != string.Empty)
{
using (WFAEntity.API.MyDBContext objectMyDBContext =
new WFAEntity.API.MyDBContext())
{
WFAEntity.API.Employees objectEmployees = new WFAEntity.API.Employees();
objectEmployees.ID_employees = objectMyDBContext.Employees.Count();
objectEmployees.ID_employees++;
objectEmployees.Surname = textBlockAddEditSurname.Text;
objectEmployees.Name = textBlockAddEditName.Text;
objectEmployees.Patronymic = textBlockAddEditPatronymic.Text;
objectEmployees.Address = textBlockAddEditAddress.Text;
objectEmployees.Telephone = textBlockAddEditTelephone.Text;
objectEmployees.Position = textBlockAddEditPosition.Text;
objectEmployees.Date = textBlockAddEditDate.Text;
objectEmployees.Password = textBlockAddEditPassword.Text;
objectEmployees.Login = textBlockAddEditLogin.Text;
try
{
objectMyDBContext.Employees.Add(objectEmployees);
objectMyDBContext.SaveChanges();
MessageBox.Show("Сотрудник добавлен");
this.DialogResult = true;
AF.ShowAll();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "ОШИБКА", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
}
else
{
MessageBox.Show("Заполните все поля!", "Ошибка!");
this.DialogResult = false;
}
}
else
{
using (WFAEntity.API.MyDBContext objectMyDBContext =
new WFAEntity.API.MyDBContext())
{
WFAEntity.API.Employees objectEmployees = new WFAEntity.API.Employees();
EditEmployees.Surname = textBlockAddEditSurname.Text;
EditEmployees.Name = textBlockAddEditName.Text;
EditEmployees.Patronymic = textBlockAddEditPatronymic.Text;
EditEmployees.Address = textBlockAddEditAddress.Text;
EditEmployees.Telephone = textBlockAddEditTelephone.Text;
EditEmployees.Position = textBlockAddEditPosition.Text;
EditEmployees.Date = textBlockAddEditDate.Text;
EditEmployees.Login = textBlockAddEditLogin.Text;
EditEmployees.Password = textBlockAddEditPassword.Text;
try
{
objectMyDBContext.Employees.AddOrUpdate(EditEmployees);
objectMyDBContext.SaveChanges();
MessageBox.Show("Клиент Редактирован");
this.DialogResult = true;
AF.ShowAll();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "ОШИБКА", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
}
}
private void ButtonAddEditGroup_Click(object sender, RoutedEventArgs e)
{
if (!IsEdit)
{
if (textBlockAddEditSurname.Text != string.Empty)
{
using (WFAEntity.API.MyDBContext objectMyDBContext =
new WFAEntity.API.MyDBContext())
{
WFAEntity.API.Client objectClient = new WFAEntity.API.Client();
objectClient.Surname = textBlockAddEditSurname.Text;
objectClient.Name = textBlockAddEditName.Text;
objectClient.Patronymic = textBlockAddEditPatronymic.Text;
objectClient.Address = textBlockAddEditAdress.Text;
objectClient.Number = textBlockAddEditTelephone.Text;
try
{
objectMyDBContext.Client.Add(objectClient);
objectMyDBContext.SaveChanges();
MessageBox.Show("Клиент добавлен");
this.DialogResult = true;
AF.ShowAll();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "ОШИБКА", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
}
else
{
MessageBox.Show("Заполните все поля!", "Ошибка!");
this.DialogResult = false;
}
}
else
{
using (WFAEntity.API.MyDBContext objectMyDBContext =
new WFAEntity.API.MyDBContext())
{
WFAEntity.API.Client objectClient = new WFAEntity.API.Client();
EditClient.Surname = textBlockAddEditSurname.Text;
EditClient.Name = textBlockAddEditName.Text;
EditClient.Patronymic = textBlockAddEditPatronymic.Text;
EditClient.Address = textBlockAddEditAdress.Text;
EditClient.Number = textBlockAddEditTelephone.Text;
try
{
objectMyDBContext.Client.AddOrUpdate(EditClient);
objectMyDBContext.SaveChanges();
MessageBox.Show("Клиент Редактирован");
this.DialogResult = true;
AF.ShowAll();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "ОШИБКА", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
}
}
