Beispiel #1
0
        public void Khoitao()
        {
            using (var _context = new DBLapTrinhWin())
            {
                var x = (from u in _context.TienDoes
                         where u.IDDeAn == key
                         select u).FirstOrDefault();

                TienDoBaoCao present = new TienDoBaoCao();
                present.SoBuoi = x.SoBuoi;
                txtSoBuoi.Text = (present.SoBuoi).ToString();
                if (cbSoBuoi.Items.Count <= 0)
                {
                    for (int i = 1; i <= present.SoBuoi; i++)
                    {
                        cbSoBuoi.Items.Add(i);
                    }
                }


                var m = from u in _context.DeAns
                        where u.IDDeAn == key
                        select u;
                if (m.Count() != 0)
                {
                    var n = m.First();
                    if (!(n.Diem is null))
                    {
                        txtDiem.Text = n.Diem.ToString();
                    }
                    if (!(n.DateStart is  null || n.DateEnd is null))
                    {
                        dtpDateStart.Value = DateTime.Parse(n.DateStart.Value.ToString());
                        dtpDateEnd.Value   = DateTime.Parse(n.DateEnd.Value.ToString());
                    }
                }
            }
        }
Beispiel #2
0
        public void TaoDTG()
        {
            using (var _context = new DBLapTrinhWin())
            {
                int sobuoi = 0;
                var x      = from u in _context.TienDoes
                             where u.IDDeAn == key
                             select u;
                if (x.Count() != 0)
                {
                    if (x.First().SoBuoi != null)
                    {
                        sobuoi = (int)x.First().SoBuoi;
                    }
                }


                var sobuoihientai = from u in _context.TienDoes
                                    where u.HoanThanh == null && u.IDDeAn == key
                                    select u;
                if (sobuoihientai.Count() == 1)
                {
                    List <TienDoBaoCao> dtg = new List <TienDoBaoCao>();
                    for (int j = 0; j < sobuoi; j++)
                    {
                        TienDoBaoCao k    = new TienDoBaoCao();
                        string       buoi = "Buổi " + (j + 1).ToString();

                        k.Buoi = buoi;
                        dtg.Add(k);
                    }
                    dtgTienDo.DataSource = dtg;
                    return;
                }

                string xnd    = "";
                string xlink  = "";
                string xcheck = "";
                if ((x.First().BaoCao != null))
                {
                    xnd = x.First().BaoCao;
                }
                if ((x.First().LinkTaiLieu != null))
                {
                    xlink = x.First().LinkTaiLieu;
                }
                if ((x.First().HoanThanh != null))
                {
                    xcheck = x.First().HoanThanh;
                }
                List <string>       noidung   = BaoCaoTienDoController.GetDanhSachNoiDungBaoCao(xnd);
                List <string>       link      = BaoCaoTienDoController.GetDanhSachLinkTaiLieu(xlink);
                List <bool>         check     = BaoCaoTienDoController.GetHoanThanh(xcheck);
                List <TienDoBaoCao> dtgsource = new List <TienDoBaoCao>();
                for (int i = 0; i < sobuoi; i++)
                {
                    TienDoBaoCao k    = new TienDoBaoCao();
                    string       buoi = "Buổi " + (i + 1).ToString();
                    k.Buoi = buoi;
                    if (i < noidung.Count())
                    {
                        k.NoiDung = noidung[i];
                    }
                    if (i < link.Count())
                    {
                        k.Link = link[i];
                    }
                    if (i < check.Count())
                    {
                        k.HoanThanh = check[i];
                    }
                    dtgsource.Add(k);
                }

                dtgTienDo.DataSource = dtgsource;
            }
        }