private void deleteGroupButton_Click(object sender, RoutedEventArgs e)
{
if (gropiesGrid.SelectedItems.Count > 0)
{
for (int i = 0; i < gropiesGrid.SelectedItems.Count; i++)
{
WFAEntity.API.Group objectGroup = gropiesGrid.SelectedItems[i] as WFAEntity.API.Group;
if (objectGroup != null)
{
try
{
using (WFAEntity.API.MyDBContext objectMyDBContext =
new WFAEntity.API.MyDBContext())
{
WFAEntity.API.Group group = WFAEntity.API.DatabaseRequest.GetGroupById(objectMyDBContext, objectGroup.Id);
objectMyDBContext.Groups.Attach(group);
objectMyDBContext.Groups.Remove(group);
objectMyDBContext.SaveChanges();
}
this.ShowAll(SELECTED_TAB.GROUP);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "ОШИБКА", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
}
}
}
private void ButtonAddEditGroup_Click(object sender, RoutedEventArgs e)
{
try
{
if (this.IsDataCorrcet() == true)
{
using (WFAEntity.API.MyDBContext objectMyDBContext =
new WFAEntity.API.MyDBContext())
{
WFAEntity.API.Group objectGroup = new WFAEntity.API.Group();
objectGroup.Name = textBlockAddEditGroup.Text;
if (this.add_edit == true)
{
objectMyDBContext.Groups.Add(objectGroup);
}
else
{
WFAEntity.API.Group objectGroupFromDataBase = new WFAEntity.API.Group();
objectGroupFromDataBase = WFAEntity.API.DatabaseRequest.GetGroupById(objectMyDBContext, this.id);
objectMyDBContext.Entry(objectGroupFromDataBase).CurrentValues.SetValues(objectGroup);
}
objectMyDBContext.SaveChanges();
this.DialogResult = true;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "ОШИБКА (Группа)", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
try
{
using (WFAEntity.API.MyDBContext objectMyDBContext = new WFAEntity.API.MyDBContext())
{
if (objectMyDBContext.Database.Exists() == false)
{
objectMyDBContext.Database.Create();
WFAEntity.API.User objectUser = new WFAEntity.API.User();
objectUser.Name = "user name";
objectUser.Login = "******";
objectUser.Password = "******";
objectMyDBContext.Users.Add(objectUser);
objectMyDBContext.SaveChanges();
WFAEntity.API.DatabaseRequest.CreateDefaultDataBase();
}
}
//WFAEntity.API.DatabaseRequest.CreateDefaultDataBase();
//WFAEntity.API.DatabaseRequest.ChangeDefaultDataBase();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
this.ShowAll(SELECTED_TAB.GROUP);
}
private void deleteStudentButton_Click(object sender, RoutedEventArgs e)
{
if (studentsGrid.SelectedItems.Count > 0)
{
for (int i = 0; i < studentsGrid.SelectedItems.Count; i++)
{
WFAEntity.API.Student objectStudent = studentsGrid.SelectedItems[i] as WFAEntity.API.Student;
if (objectStudent != null)
{
try
{
using (WFAEntity.API.MyDBContext objectMyDBContext =
new WFAEntity.API.MyDBContext())
{
WFAEntity.API.Student student = WFAEntity.API.DatabaseRequest.GetStudentById(objectMyDBContext, objectStudent.Id);
objectMyDBContext.Students.Attach(student);
objectMyDBContext.Students.Remove(student);
objectMyDBContext.SaveChanges();
}
this.ShowAll(SELECTED_TAB.STUDENT);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "ОШИБКА", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
}
}
}
private void ButtonAddEditGroup_Click(object sender, RoutedEventArgs e)
{
WFAEntity.API.Group objectGroup = new WFAEntity.API.Group();
if (this.add_edit == true)
{
objectGroup.Name = textBlockAddEditGroup.Text;
try
{
if (this.IsDataCorrcet() == true)
{
using (WFAEntity.API.MyDBContext objectMyDBContext =
new WFAEntity.API.MyDBContext())
{
objectMyDBContext.Groups.Add(objectGroup);
objectMyDBContext.SaveChanges();
}
MessageBox.Show("Группа добавлена");
this.DialogResult = true;
}
else
{
MessageBox.Show("Ввод данных", "ОШИБКА", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "ОШИБКА", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
else
{
try
{
if (this.IsDataCorrcet())
{
using (WFAEntity.API.MyDBContext objectMyDBContext =
new WFAEntity.API.MyDBContext())
{
WFAEntity.API.Group group = new WFAEntity.API.Group();
group = WFAEntity.API.DatabaseRequest.GetGroupById(objectMyDBContext, this.id);
group.Name = textBlockAddEditGroup.Text;
objectMyDBContext.Entry(group).State = System.Data.Entity.EntityState.Modified;
objectMyDBContext.SaveChanges();
}
MessageBox.Show("Группа изменена");
this.DialogResult = true;
}
else
{
MessageBox.Show("Ввод данных", "ОШИБКА", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "ОШИБКА", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
}
public static void ChangeDefaultDataBase()
{
using (WFAEntity.API.MyDBContext objectMyDBContext = new WFAEntity.API.MyDBContext())
{
Student objectStudent5 = WFAEntity.API.DatabaseRequest.GetStudentById(objectMyDBContext, 2);
Group gr = WFAEntity.API.DatabaseRequest.GetGroupById(objectMyDBContext, 2);
Group newGroup = new Group("G3*******", 2);
Student newStudent = new Student(objectStudent5.Name, objectStudent5.Surname, objectStudent5.Patronymic, newGroup, 2, 2);
objectMyDBContext.Entry(objectStudent5).CurrentValues.SetValues(newStudent);
objectMyDBContext.Entry(gr).CurrentValues.SetValues(newGroup);
objectMyDBContext.SaveChanges();
}
}
public GroupWindow(bool add_edit, int id = 0)
{
InitializeComponent();
this.add_edit = add_edit;
this.id = id;
if (this.add_edit == false)
{
using (WFAEntity.API.MyDBContext objectMyDBContext =
new WFAEntity.API.MyDBContext())
{
WFAEntity.API.Group group = WFAEntity.API.DatabaseRequest.GetGroupById(objectMyDBContext, this.id);
textBlockAddEditGroup.Text = group.Name;
}
ButtonAddEditGroup.Content = "Изменить";
}
}
public static void CreateDefaultDataBase()
{
/*Group objectGroup2 = new Group();
* objectGroup1.Name = "G2";
* Group objectGroup3 = new Group();
* objectGroup1.Name = "G3";
* Group objectGroup4 = new Group();
* objectGroup1.Name = "G4";
* Group objectGroup5 = new Group();
* objectGroup1.Name = "G5";*/
using (WFAEntity.API.MyDBContext objectMyDBContext = new WFAEntity.API.MyDBContext())
{
Group objectGroup1 = new Group("G 1");
Group objectGroup2 = new Group("G 2");
Group objectGroup3 = new Group("G 3");
Group objectGroup4 = new Group("G 4");
Group objectGroup5 = new Group("G 5");
objectMyDBContext.Groups.Add(objectGroup1);
objectMyDBContext.SaveChanges();
objectMyDBContext.Groups.Add(objectGroup2);
objectMyDBContext.SaveChanges();
objectMyDBContext.Groups.Add(objectGroup3);
objectMyDBContext.SaveChanges();
objectMyDBContext.Groups.Add(objectGroup4);
objectMyDBContext.SaveChanges();
objectMyDBContext.Groups.Add(objectGroup5);
objectMyDBContext.SaveChanges();
Student objectStudent1 = new Student("S1", "N1", "P1", objectGroup1, 1);
Student objectStudent2 = new Student("S2", "N2", "P2", objectGroup2, 2);
Student objectStudent3 = new Student("S3", "N3", "P3", objectGroup3, 3);
Student objectStudent4 = new Student("S4", "N4", "P4", objectGroup4, 4);
Student objectStudent5 = new Student("S5", "N5", "P5", objectGroup5, 5);
objectMyDBContext.Students.Add(objectStudent1);
objectMyDBContext.SaveChanges();
objectMyDBContext.Students.Add(objectStudent2);
objectMyDBContext.SaveChanges();
objectMyDBContext.Students.Add(objectStudent3);
objectMyDBContext.SaveChanges();
objectMyDBContext.Students.Add(objectStudent4);
objectMyDBContext.SaveChanges();
objectMyDBContext.Students.Add(objectStudent5);
objectMyDBContext.SaveChanges();
}
}
public static void Fill()
{
using (WFAEntity.API.MyDBContext objectMyDBContext = new WFAEntity.API.MyDBContext())
{
if (objectMyDBContext.Database.Exists() == false)
{
Employees employe1 = new Employees("Владимир", "Савин", "Алексеевич", "Пушкина, 4", "02.15.2003", "Администратор", "KING", "1111", "29541514");
objectMyDBContext.Employees.Add(employe1);
objectMyDBContext.SaveChanges();
Employees employe2 = new Employees("Мишуто", "Максим", "Витальевич", "Блохина, 2", "06.04.2004", "Посетитель", "Maks", "1234", "1445124785");
objectMyDBContext.Employees.Add(employe2);
objectMyDBContext.SaveChanges();
Employees employe3 = new Employees("Абрамович", "Даниил", "Владимирович", "Пушкина, 2", "03.09.2003", "Кассир", "ABR", "1234", "1445124785");
objectMyDBContext.Employees.Add(employe3);
objectMyDBContext.SaveChanges();
Skates_hire skatesHire1 = new Skates_hire("1", "10:00", "1", "м", employe1);
objectMyDBContext.Skates_hire.Add(skatesHire1);
objectMyDBContext.SaveChanges();
Skates_hire skatesHire2 = new Skates_hire("2", "20:00", "2", "м", employe2);
objectMyDBContext.Skates_hire.Add(skatesHire2);
objectMyDBContext.SaveChanges();
Skates_hire skatesHire3 = new Skates_hire("3", "11:00", "3", "м", employe1);
objectMyDBContext.Skates_hire.Add(skatesHire3);
objectMyDBContext.SaveChanges();
Skates_hire skatesHire4 = new Skates_hire("4", "12:00", "4", "м", employe2);
objectMyDBContext.Skates_hire.Add(skatesHire4);
objectMyDBContext.SaveChanges();
Client client1 = new Client("Игорев", "Игорь", "Игоревич", "Блохина 46", "294512486");
objectMyDBContext.Client.Add(client1);
objectMyDBContext.SaveChanges();
Other_services service1 = new Other_services("Коньки на прокат", "10", employe2);
objectMyDBContext.Other_services.Add(service1);
objectMyDBContext.SaveChanges();
MK_schedule MK_schedule1 = new MK_schedule("16.02.2020", "200", "17:00", "18:00", employe2, service1);
objectMyDBContext.MK_schedule.Add(MK_schedule1);
objectMyDBContext.SaveChanges();
Ticket ticket1 = new Ticket("5", "200", "Есть", client1, MK_schedule1, service1, skatesHire2);
objectMyDBContext.Ticket.Add(ticket1);
objectMyDBContext.SaveChanges();
}
}
}
public StudentAddEditWindow(bool add_edit, int id = 0)
{
InitializeComponent();
this.add_edit = add_edit;
this.id = id;
using (WFAEntity.API.MyDBContext objectMyDBContext =
new WFAEntity.API.MyDBContext())
{
if (this.add_edit == false)
{
WFAEntity.API.Student objectStudent = WFAEntity.API.DatabaseRequest.GetStudentById(objectMyDBContext, this.id);
textBlockAddEditSurname.Text = objectStudent.Surname;
textBlockAddEditName.Text = objectStudent.Name;
textBlockAddEditPatranomyc.Text = objectStudent.Patronymic;
ButtonAddEditGroup.Content = "Изменить";
}
comboBoxAddEditGroup.ItemsSource = WFAEntity.API.DatabaseRequest.GetGroups(objectMyDBContext);
comboBoxAddEditGroup.Text = "{Binging Name}";
}
}
private void ButtonAddEditGroup_Click(object sender, RoutedEventArgs e)
{
try
{
if (this.IsDataCorrect() == true)
{
using (WFAEntity.API.MyDBContext objectMyDBContext =
new WFAEntity.API.MyDBContext())
{
WFAEntity.API.Student objectStudent = new WFAEntity.API.Student(
textBlockAddEditName.Text,
textBlockAddEditSurname.Text,
textBlockAddEditPatranomyc.Text,
(WFAEntity.API.Group)comboBoxAddEditGroup.SelectedItem
);
if (this.add_edit == true)
{
objectMyDBContext.Students.Add(objectStudent);
}
else
{
objectStudent.Id = WFAEntity.API.DatabaseRequest.GetStudentById(objectMyDBContext, this.id).Id;
WFAEntity.API.Student objectStudentFromDataBase = new WFAEntity.API.Student();
objectStudentFromDataBase = WFAEntity.API.DatabaseRequest.GetStudentById(objectMyDBContext, this.id);
objectMyDBContext.Entry(objectStudentFromDataBase).CurrentValues.SetValues(objectStudent);
objectMyDBContext.SaveChanges();
}
objectMyDBContext.SaveChanges();
this.DialogResult = true;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "ОШИБКА (Студент)", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private void ShowAll(SELECTED_TAB tab)
{
try
{
using (WFAEntity.API.MyDBContext objectMyDBContext =
new WFAEntity.API.MyDBContext())
{
switch (tab)
{
case SELECTED_TAB.GROUP:
gropiesGrid.ItemsSource = WFAEntity.API.DatabaseRequest.GetGroups(objectMyDBContext);
break;
case SELECTED_TAB.STUDENT:
studentsGrid.ItemsSource = WFAEntity.API.DatabaseRequest.GetStudentsWithGroups(objectMyDBContext);
break;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "ОШИБКА ShowAll", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
