Example #1
0
        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();
        }
Example #2
0
        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;
            }
        }