private void button1_Click(object sender, EventArgs e) { PlayerForm plForm = new PlayerForm(); // из команд в бд формируем список List <Team> teams = db.Teams.ToList(); plForm.comboBox2.DataSource = teams; plForm.comboBox2.ValueMember = "Id"; plForm.comboBox2.DisplayMember = "Name"; DialogResult result = plForm.ShowDialog(this); if (result == DialogResult.Cancel) { return; } Player player = new Player(); player.Age = (int)plForm.numericUpDown1.Value; player.Name = plForm.textBox1.Text; //player.Position = plForm.comboBox1.SelectedItem.ToString(); player.Team = (Team)plForm.comboBox2.SelectedItem; db.Players.Add(player); db.SaveChanges(); MessageBox.Show("Новый футболист добавлен"); }
private void button1_Click(object sender, EventArgs e) { // запускаем форму с командами TeamForm tmForm = new TeamForm(); DialogResult dialogResult = tmForm.ShowDialog(this); if (dialogResult == DialogResult.Cancel) { return; } // создаем команду Team team = new Team { Name = tmForm.textBox1.Text, Coach = tmForm.textBox3.Text }; // добавляем команду в БД db.Teams.Add(team); db.SaveChanges(); // покажем что сохранилось MessageBox.Show("Команда добавлена"); }
public ActionResult Create(Player player) { db.Players.Add(player); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Create(Player player) { //Добавляем игрока в таблицу db.Players.Add(player); db.SaveChanges(); return(RedirectToAction("Index")); }
public int Add(Reward item) { var t = _dbset.Add(item); _dataContext.SaveChanges(); return(t.Entity.RewardId); }
public ActionResult Delete(int id) { Player player = db.Players.Find(id); db.Entry(player).State = EntityState.Deleted; db.SaveChanges(); return(RedirectToAction("Index")); }
public int Add(Team team) { var t = _dbset.Add(team); _dataContext.SaveChanges(); return(t.Entity.TeamId); }
public int Add(Player item) { var t = _dbset.Add(item); _dataContext.SaveChanges(); return(t.Entity.PlayerId); }
public ActionResult Create(Player player) { // Добавляем игрока в таблицу db.Players.Add(player); db.SaveChanges(); // перенаправляем на главную страницу return(RedirectToAction("Index")); }
public int Add(Tournament item) { var t = _dbset.Add(item); var db = _dbset.ToList(); _dataContext.SaveChanges(); return(t.Entity.TournamentId); }
public void Add(T item) { try { AddItem(item); Context.SaveChanges(); } catch (Exception exception) { throw new Exception(string.Format("add {0} failed, {1}", EntityName, exception.InnerException.Message)); } }
public async Task <ActionResult <User> > PutUser(int id, User user) { if (id != user.UserID) { return(BadRequest()); } var thisUser = _context.Users.Find(id); if (!user.Email.Equals(thisUser.Email)) { var users = await _context.Users.ToListAsync(); foreach (User checkUser in users) { if (checkUser.Email.Equals(user.Email)) { return(BadRequest(new { message = "This email is already in use." })); } } } _context.Entry(thisUser).State = EntityState.Detached; _context.UserRoles.RemoveRange(_context.UserRoles.Where(ur => ur.UserID == user.UserID).ToList()); foreach (var role in user.Roles) { UserRole userRole = new UserRole(); userRole.UserRoleID = 0; userRole.UserID = user.UserID; userRole.RoleID = role.RoleID; _context.UserRoles.Add(userRole); } _context.SaveChanges(); _context.Entry(user).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!UserExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public void AddGoal(int gameDataId, DateTime?time = null) { var goal = new Goal { Time = time ?? DateTime.Now, GameDataId = gameDataId }; try { Context.Goals.Add(goal); Context.SaveChanges(); } catch (Exception e) { throw new Exception($"Add goal failed, {e.Message}"); } }
private void buttonCreate_Click(object sender, EventArgs e) { FormElementCurrencies formElementCurrencies = new FormElementCurrencies(); DialogResult result = formElementCurrencies.ShowDialog(this); if (result == DialogResult.OK) { Currencies Currencies = new Currencies(); Currencies.name = formElementCurrencies.textBoxName.Text.ToString(); db.Currencies.Add(Currencies); db.SaveChanges(); checkFilter(); dataGridView.Refresh(); } }
private void buttonCreate_Click(object sender, EventArgs e) { FormElementWarehouse formElementWarehouse = new FormElementWarehouse(); DialogResult result = formElementWarehouse.ShowDialog(this); if (result == DialogResult.OK) { Warehouse Warehouse = new Warehouse(); Warehouse.name = formElementWarehouse.textBoxName.Text.ToString(); Warehouse.address = formElementWarehouse.textBoxAddress.Text.ToString(); db.Warehouse.Add(Warehouse); db.SaveChanges(); checkFilter(); dataGridView.Refresh(); } }
private void buttonCreate_Click(object sender, EventArgs e) { FormElementBills formElementBills = new FormElementBills(); DialogResult result = formElementBills.ShowDialog(this); if (result == DialogResult.OK) { Bills Bills = new Bills(); Bills.id_currency = Int32.Parse(formElementBills.textBoxCurrency.Text.ToString()); Bills.number_bill = formElementBills.textBoxNumberBill.Text.ToString(); db.Bills.Add(Bills); db.SaveChanges(); checkFilter(); dataGridView.Refresh(); } }
private void buttonCreate_Click(object sender, EventArgs e) { FormElementNomenclature formElementNomenclature = new FormElementNomenclature(); DialogResult result = formElementNomenclature.ShowDialog(this); if (result == DialogResult.OK) { Nomenclature nomenclature = new Nomenclature(); nomenclature.name = formElementNomenclature.textBoxName.Text.ToString(); nomenclature.manufacturer = formElementNomenclature.textBoxManufacturer.Text.ToString(); nomenclature.country = formElementNomenclature.textBoxCountry.Text.ToString(); db.Nomenclature.Add(nomenclature); db.SaveChanges(); checkFilterNomenclature(); dataGridView.Refresh(); } }
// Add private void button1_Click(object sender, EventArgs e) { TeamForm tmForm = new TeamForm(); DialogResult result = tmForm.ShowDialog(this); if (result == DialogResult.Cancel) { return; } Team team = new Team(); team.Name = tmForm.textBox1.Text; team.Coach = tmForm.textBox2.Text; db.Teams.Add(team); db.SaveChanges(); MessageBox.Show("Объект добавлен"); }
private void buttonCreate_Click(object sender, EventArgs e) { FormElementEmployees formElementEmployees = new FormElementEmployees(); DialogResult result = formElementEmployees.ShowDialog(this); if (result == DialogResult.OK) { Employees Employees = new Employees(); Employees.email = formElementEmployees.textBoxEmail.Text.ToString(); Employees.fio = formElementEmployees.textBoxFIO.Text.ToString(); Employees.position = formElementEmployees.textBoxPosition.Text.ToString(); Employees.phone = formElementEmployees.textBoxPhone.Text.ToString(); db.Employees.Add(Employees); db.SaveChanges(); checkFilter(); dataGridView.Refresh(); } }
private void buttonAdd_Click(object sender, EventArgs e) { FormCreateTeam createTeam = new FormCreateTeam(); DialogResult result = createTeam.ShowDialog(this); if (result == DialogResult.Cancel) { return; } Team team = new Team(); team.Name = createTeam.textBoxTeamName.Text; team.Coach = createTeam.textBoxCoach.Text; db.Teams.Add(team); db.SaveChanges(); MessageBox.Show("New object was added"); }
private void buttonCreate_Click(object sender, EventArgs e) { FormElementPartner formElementPartner = new FormElementPartner(); DialogResult result = formElementPartner.ShowDialog(this); if (result == DialogResult.OK) { Partner Partner = new Partner(); Partner.supplier = formElementPartner.checkBoxSupplier.Checked; Partner.email = formElementPartner.textBoxEmail.Text.ToString(); Partner.fio = formElementPartner.textBoxFIO.Text.ToString(); Partner.address = formElementPartner.textBoxAddress.Text.ToString(); Partner.phone = formElementPartner.textBoxPhone.Text.ToString(); Partner.country = formElementPartner.textBoxCountry.Text.ToString(); db.Partner.Add(Partner); db.SaveChanges(); checkFilter(); dataGridView.Refresh(); } }
private void button1_Click(object sender, EventArgs e) { PlayerForm playerForm = new PlayerForm(); List <Team> teams = db.Teams.ToList(); playerForm.listBox1.DataSource = teams; playerForm.listBox1.ValueMember = "Id"; playerForm.listBox1.DisplayMember = "Name"; DialogResult result = playerForm.ShowDialog(this); // отмена if (result == DialogResult.Cancel) { return; } Player player = new Player(); // добавляем имя player.Name = playerForm.textBox1.Text; // добавляем возраст через поле в форме PlayerForm player.Age = (int)playerForm.numericUpDown1.Value; // очистить список и заново заполнить teams.Clear(); foreach (var item in playerForm.listBox1.SelectedItems) { teams.Add((Team)item); } // присваиваем значение player.Teams = teams; // добавляем игрока в БД db.Players.Add(player); // сохраняем изменения db.SaveChanges(); MessageBox.Show("Игрок добавлен"); }
public async Task <ActionResult> Results(int id, string UserId) { Team team = db.Teams.Include(t => t.Players).FirstOrDefault(p => p.Id == id); await UserManager.SendEmailAsync(UserId, "Мероприятие", "Спасибо что зарегестировались на мероприятие: " + team.Name + ", которое пройдет " + team.Dates + " в " + team.Times + "<br> Ждем Вас!! <br><br><br><br> P.S.: не отвечайте на данное сообщение, оно было отправлено с сервера!"); PlTeam plTeam = new PlTeam(); plTeam.TeamId = id; plTeam.UserId = UserId; db.PlTeams.Add(plTeam); db.SaveChanges(); return(View()); }
public ActionResult Edit(PlayerViewModel playerModel) { Player player = db.Players.Find(playerModel.Id); if (player == null) { return(HttpNotFound()); } player.Position = playerModel.Position; player.Age = playerModel.Age; db.SaveChanges(); return(RedirectToAction("Index")); }
private void button1_Click(object sender, EventArgs e) { PlayerForm plForm = new PlayerForm(); // из команд в бд формируем список List <Team> teams = db.Teams.ToList(); // присваиваем поле для списка plForm.comboBox3.DataSource = teams; plForm.comboBox3.ValueMember = "Id"; plForm.comboBox3.DisplayMember = "Name"; DialogResult result = plForm.ShowDialog(this); if (result == DialogResult.Cancel) { return; } Player player = new Player(); // добавляем возраст через поле в форме PlayerForm player.Age = (int)plForm.numericUpDown1.Value; // добавляем имя player.Name = plForm.textBox1.Text; // выбираем позицию игрока // добавить позиции в поле player.Position = plForm.comboBox1.SelectedItem.ToString(); // добавляем игрока в БД db.Players.Add(player); // сохраняем изменения db.SaveChanges(); MessageBox.Show(" Новый объект добавлен"); }
private void buttonDelete_Click(object sender, EventArgs e) { var currentRow = dataGridView.CurrentRow; if (currentRow != null) { int idCustomerOrder = Int32.Parse(currentRow.Cells["id"].Value.ToString()); CustomerOrder CustomerOrder = db.CustomerOrder.Find(idCustomerOrder); db.CustomerOrder.Remove(CustomerOrder); db.SaveChanges(); checkFilter(); dataGridView.Refresh(); } }
public ActionResult Play() { //Hier wordt een lijst aangemaakt die alleen het type Team accepteert //Vervolgens worden de teams uit de database opgehaald en in een lijstje gepropt. List <Team> t = new List <Team>(); t = context.Teams.ToList(); Queue <Team> matchups = TeamMatchUps(t); List <Game> games = new List <Game>(); Dictionary <Team, int> PouleResults = new Dictionary <Team, int>(); //Poule is voor nu nog statisch, want de opdracht is om wedstrijden te simuleren Poule p = new Poule { Name = "E", PouleResults = PouleResults }; for (int i = 0; i < (t.Count * 1.5); i++) { //Hier wordt een game aangemaakt in een for-loop, de team.count * 1.5 zorgt ervoor dat alle mogelijke match-ups worden bereikt var game = new Game { Home = matchups.Dequeue(), Away = matchups.Dequeue(), Date = DateTime.Now, Poule = p }; //Hieronder voegen we de games toe aan een lijst en sturen die door naar de view games.Add(game); game.simGame(); //Hieronder worden de games toegevoegd aan de entiteit in de database context en vervolgens worden ze opgeslagen in de database context.Games.Add(game); context.SaveChanges(); } ViewBag.results = PouleResults; return(View(games)); }
public ActionResult Create(int?id, Team team) { if (id != null) { db.Entry(team).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } else { db.Teams.Add(team); db.SaveChanges(); return(RedirectToAction("Index")); } }
public async Task <ActionResult <Team> > DeleteTeam(int id) { var team = await _context.Teams.FindAsync(id); if (team == null) { return(NotFound()); } team.TeamStatusID = 4; _context.Entry(team).State = EntityState.Modified; await _context.SaveChangesAsync(); var userteams = _context.UserTeam.Where(ut => ut.TeamID == id).ToList(); foreach (var userteam in userteams) { _context.UserTeam.Remove(userteam); } _context.SaveChanges(); return(team); }
public void SavePlayer(Player player) { context.Players.Add(player); context.SaveChanges(); }