private void btnDeleteOnMainForm(object sender, EventArgs e) { var _context = new StageCalculator.Context.StageEntity(); var stage = _context.Stages.ToList(); if (stage.Count >= 1) { var IdStageToRemove = Convert.ToInt32(dateGridViewMain.CurrentRow.Cells[0].Value); foreach (var item in stage) { if (item.StageId == IdStageToRemove) { _context.Stages.Remove(item); _context.SaveChanges(); break; } } } ShowStage(); }
private void ShowStage() { var _context = new StageCalculator.Context.StageEntity(); var stage = _context.Stages.Include("Person").Include("Company").ToList(); if (stage.Count >= 1) { // Vrode treb sa mearga rindu ista dateGridViewMain.DataSource = stage.Select(x => new { idStage = x.StageId, namePerson = x.Person.GetName(), BeginDate = x.StageBeginDate.ToShortDateString(), EndDate = x.StageEndDate.ToShortDateString(), nameCompany = x.Company.GetName() // stagiu = calc.DeltaTime(x.StageBeginDate, x.StageEndDate) }).ToList(); dateGridViewMain.Columns[0].HeaderText = "ID"; dateGridViewMain.Columns[1].HeaderText = "Nume Prenume"; dateGridViewMain.Columns[2].HeaderText = "Begin"; dateGridViewMain.Columns[3].HeaderText = "End"; dateGridViewMain.Columns[4].HeaderText = "Company"; //dateGridViewMain.Columns[5].HeaderText = "Stagiu"; foreach (DataGridViewColumn col in dateGridViewMain.Columns) { col.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; col.HeaderCell.Style.Font = new Font("Arial", 12F, FontStyle.Bold, GraphicsUnit.Pixel); } dateGridViewMain.Columns[0].Width = 45; dateGridViewMain.Columns[1].Width = 150; dateGridViewMain.Columns[4].Width = 150; } else { dateGridViewMain.DataSource = null; } }