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();
}
