protected override void Seed(MySQLModel context) { // Заполняем тестовые данные и создаем пользователя для дальнейшей работы с прогой JobPosition jobPosition = new JobPosition() { Name = "TestJobPos" }; context.JobPositions.Add(jobPosition); Office office = new Office() { Name = "TestOffice", Address = "UtitsaPushkinaDom..." }; context.Offices.Add(office); Employee employee = new Employee() { Name = "admin", Surname = "admin", Patronymic = "admin", JobPosition = jobPosition, Birthdate = DateTime.Now, Office = office }; context.Employees.Add(employee); User user = new User() { AccessLVL = User.E_Access.Administrator, Employee = employee, Username = "******", Password = Utilities.GenerateHash("Admin") }; context.Users.Add(user); TypeOfServer typeOfItem = new TypeOfServer() { Name = "ТестовыйТипСервера" }; context.TypeOfServers.Add(typeOfItem); Server server = new Server() { Details = "Тестовый данные о сервере", Name = "ТестовыйСервер", Ip = "168.212.226.204", Office = office, TypeOfServer = typeOfItem }; context.Servers.Add(server); Client client = new Client() { FullName = "Тестовое имя клиента", PhoneNumber = "88005553535" }; context.Clients.Add(client); Order order = new Order() { Client = client, Cost = 123, Currency = "$", Domen = "фасоль.рф", DateTime = DateTime.Now, DateOfEnd = DateTime.Now.AddDays(31), Employee = employee, Server = server }; context.Orders.Add(order); base.Seed(context); }
private void buttonAddTypeOfServerAdd_Click(object sender, EventArgs e) { if (panelAddTypеOfServer.CheckFullnessOfContols()) { TypeOfServer typeOfServer = new TypeOfServer(); typeOfServer.Name = textBoxAddTypeOfServer.Text; context.TypeOfServers.Add(typeOfServer); context.SaveChanges(); textBoxAddTypeOfServer.Text = String.Empty; dataGridTypeOfServer.AddClearRange(context.TypeOfServers.ToList()); comboBoxTypeOfServer.AddClearEntities <TypeOfServer>(context, "Name"); comboBoxEditTypeOfServer.AddClearEntities <TypeOfServer>(context, "Name"); } }
private void buttonAddTypeOfServerDelete_Click(object sender, EventArgs e) { if (dataGridTypeOfServer.SelectedRows.Count > 0) { DialogResult dialogResult = MessageBox.Show("Вы уверенны что хотите удалить тип сервера?", "Потверждение", MessageBoxButtons.YesNo); if (dialogResult == DialogResult.Yes) { TypeOfServer server = (TypeOfServer)dataGridTypeOfServer.SelectedRows[0].Tag; context.TypeOfServers.Remove(server); context.SaveChanges(); dataGridTypeOfServer.AddClearRange(context.TypeOfServers.ToList()); comboBoxTypeOfServer.AddClearEntities <TypeOfServer>(context, "Name"); comboBoxEditTypeOfServer.AddClearEntities <TypeOfServer>(context, "Name"); } } else { MessageBox.Show("Не выбран тип сервера"); } }