コード例 #1
0
        public ActionResult Edit([Bind(Include = "MaDA,TenDA,DonGia,AnhDA,MoTa,NgayCapNhat,SoLuongTon,TrangThaiDA,DanhGiaDoAn,MaDM")] DoAn doAn, HttpPostedFileBase fileupload)
        {
            if (fileupload != null)
            {
                var fileName = Path.GetFileName(fileupload.FileName);
                //Luu duong dan cua file
                var path = Path.Combine(Server.MapPath("~/images"), fileName);
                if (System.IO.File.Exists(path))
                {
                    //Xoa hinh cu trong duong dan
                    System.IO.File.Delete(path);
                    //Luu hinh anh moi vao duong dan
                    fileupload.SaveAs(path);
                }
                doAn.AnhDA = fileName;
            }

            db.SaveChanges();

            HttpResponseMessage response = client.PutAsJsonAsync(url + @"doan/" + doAn.MaDA, doAn).Result;

            response.EnsureSuccessStatusCode();

            return(RedirectToAction("Index"));
        }
コード例 #2
0
        private void prepareComboBox(DoAn da)
        {
            GVHD[] gvhds = gvhdBll.getAllGVHD();
            HuongNghienCuu[] hncs = hcnBll.getAllHNC();

            for (int i = 0; i < gvhds.Length; i ++)
            {
                if (da.ID_GVHD == gvhds[i].ID_GVHD)
                {
                    cbxGVHD.SelectedIndex = i;
                    break;
                }
            }

            for (int i = 0; i < hncs.Length; i++)
            {
                if (da.Ma_Huong_NC == hncs[i].Ma_Huong_NC)
                {
                    cbxHNC.SelectedIndex = i;
                    break;
                }
            }

            for (int i = 1; i <= 100; i++)
            {
                if(1990 + i == da.NamThucHien)
                {
                    cbxNamBaoVe.SelectedIndex = i - 1;
                    break;
                }

            }
        }
コード例 #3
0
ファイル: DoAnRepository.cs プロジェクト: MariettaEcseri/GTMS
        public async Task <DoAn> UpdateById(int id, DoAnForUpdateDto doAn)
        {
            var oldRecord = await _context.DanhSachDoAn.AsNoTracking().FirstOrDefaultAsync(x => x.MaDoAn == id);

            var doAnToUpdate = new DoAn
            {
                MaDoAn           = id,
                TenDoAn          = doAn.TenDoAn,
                MoTa             = doAn.MoTa,
                MaHuongNghienCuu = doAn.MaHuongNghienCuu,
                LienKetTaiDoAn   = doAn.LienKetTaiDoAn,
                ThoiGianBaoCao   = doAn.ThoiGianBaoCao,
                MaHocKy          = doAn.MaHocKy,
                DiemTongKet      = doAn.DiemTongKet,
                NhanXetChung     = doAn.NhanXetChung,
                DiaDiemBaoCao    = doAn.DiaDiemBaoCao,
                ThoiGianTao      = oldRecord.ThoiGianTao,
                ThoiGianCapNhat  = DateTime.Now,
            };

            _context.DanhSachDoAn.Update(doAnToUpdate);
            await _context.SaveChangesAsync();

            return(doAnToUpdate);
        }
コード例 #4
0
        public IHttpActionResult PutDoAn(int id, DoAn doAn)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            if (id != doAn.MaDA)
            {
                return(BadRequest());
            }

            db.Entry(doAn).State = EntityState.Modified;

            try
            {
                db.SaveChanges();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!DoAnExists(id))
                {
                    return(NotFound());
                }
                else
                {
                    throw;
                }
            }

            return(StatusCode(HttpStatusCode.NoContent));
        }
コード例 #5
0
        public ActionResult Create(HttpPostedFileBase Image, [Bind(Include = "Id,Image,Name,MDA,Human,Score,Humans,SinhVienId")] DoAn doAn)
        {
            string imagePath = "/Scripts/DoAn/doan.jpg";

            if (Image != null && Image.ContentLength > 0)
            {
                imagePath = "/Scripts/DoAn/" + Image.FileName;
                string path = Path.Combine(Server.MapPath("~/Scripts/DoAn"), Image.FileName);
                Image.SaveAs(path);
                doAn.Image = imagePath;
            }

            var newdoAn = new DoAn()
            {
                Name       = doAn.Name,
                MDA        = doAn.MDA,
                Human      = doAn.Human,
                Score      = doAn.Score,
                Humans     = doAn.Humans,
                SinhVienId = doAn.SinhVienId,
                Image      = imagePath,
            };

            if (ModelState.IsValid)
            {
                db.DoAns.Add(newdoAn);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            ViewBag.SinhVienId = new SelectList(db.SinhViens, "Id", "Name");
            return(View(doAn));
        }
コード例 #6
0
        public void remove(DoAn da)
        {
            string sqlCmd = "DELETE FROM DoAN WHERE Ma_Do_An = ";

            sqlCmd += "'" + da.MaDoAn.Trim() + "'";

            DBHelper.DBExcuteNonQuery(sqlCmd);
        }
コード例 #7
0
        public ActionResult DeleteConfirmed(int id)
        {
            DoAn doAn = db.DoAns.Find(id);

            db.DoAns.Remove(doAn);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
コード例 #8
0
        public Item(int MaDA)
        {
            iMaDA = MaDA;
            DoAn doan = db.DoAns.Single(n => n.MaDA == iMaDA);

            sTenDA   = doan.TenDA;
            Quantity = 1;
        }
コード例 #9
0
        public IHttpActionResult GetDoAn(int id)
        {
            DoAn doAn = db.DoAns.Find(id);

            if (doAn == null)
            {
                return(NotFound());
            }

            return(Ok(doAn));
        }
コード例 #10
0
 public ActionResult Edit([Bind(Include = "Id,Image,Name,MDA,Human,Score,Humans,SinhVienId")] DoAn doAn)
 {
     if (ModelState.IsValid)
     {
         db.Entry(doAn).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     ViewBag.SinhVienId = new SelectList(db.SinhViens, "Id", "Name");
     return(View(doAn));
 }
コード例 #11
0
        // GET: DoAn/Details/5
        public async Task <ActionResult> Details(int?id)
        {
            DoAn doAn = null;
            HttpResponseMessage response = await client.GetAsync(url + @"doan/" + id);

            if (response.IsSuccessStatusCode)
            {
                doAn = await response.Content.ReadAsAsync <DoAn>();
            }
            return(View(doAn));
        }
コード例 #12
0
 private DoAn getFormData()
 {
     DoAn da = new DoAn();
     da.MaDoAn = txtMaDATN.Text;
     da.TenSV = txtSVTH.Text;
     da.TenDoAn = txtTenDATN.Text;
     da.ID_GVHD = ((GVHD)cbxGVHD.SelectedItem).ID_GVHD;
     da.Ma_Huong_NC = ((HuongNghienCuu)cbxHNC.SelectedItem).Ma_Huong_NC;
     da.TinhTrang = true;
     da.NamThucHien = (int) cbxNamBaoVe.SelectedItem;
     return da;
 }
コード例 #13
0
        public IHttpActionResult PostDoAn(DoAn doAn)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            db.DoAns.Add(doAn);
            db.SaveChanges();

            return(CreatedAtRoute("DefaultApi", new { id = doAn.MaDA }, doAn));
        }
コード例 #14
0
        private DoAn GetDoAnFromDataRow(DataRow row)
        {
            DoAn s = new DoAn();

            s.MaDoAn      = row["Ma_Do_An"].ToString();
            s.TenDoAn     = row["Ten_Do_An"].ToString();
            s.TenSV       = row["Ten_SV"].ToString();
            s.NamThucHien = (int)row["Nam_Thuc_Hien"];
            s.TinhTrang   = (row["Tinh_Trang"]  as int? == 1) ? true : false;
            s.Ma_Huong_NC = row["Ma_Huong_NC"].ToString();
            s.ID_GVHD     = row["ID_GVHD"].ToString();
            return(s);
        }
コード例 #15
0
        public ActionResult Delete(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            DoAn doAn = db.DoAns.Find(id);

            if (doAn == null)
            {
                return(HttpNotFound());
            }
            return(View(doAn));
        }
コード例 #16
0
        public DoAn[] findByName(string name)
        {
            string    sqlCmd = "SELECT * FROM DoAN WHERE DoAN.Ten_Do_An LIKE " + "'%" + name + "%'";
            DataTable d      = DBHelper.DBExcuteQuery(sqlCmd);
            int       count  = d.Rows.Count;

            DoAn[] doAns = new DoAn[count];
            for (int i = 0; i < count; i++)
            {
                doAns[i] = GetDoAnFromDataRow(d.Rows[i]);
            }

            return(doAns);
        }
コード例 #17
0
        public DoAn[] getAllDoAn()
        {
            string    sqlCmd = "SELECT * FROM DoAN";
            DataTable d      = DBHelper.DBExcuteQuery(sqlCmd);
            int       count  = d.Rows.Count;

            DoAn[] doAns = new DoAn[count];
            for (int i = 0; i < count; i++)
            {
                doAns[i] = GetDoAnFromDataRow(d.Rows[i]);
            }

            return(doAns);
        }
コード例 #18
0
        public IHttpActionResult DeleteDoAn(int id)
        {
            DoAn doAn = db.DoAns.Find(id);

            if (doAn == null)
            {
                return(NotFound());
            }

            db.DoAns.Remove(doAn);
            db.SaveChanges();

            return(Ok(doAn));
        }
コード例 #19
0
        public ActionResult Edit(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            DoAn doAn = db.DoAns.Find(id);

            if (doAn == null)
            {
                return(HttpNotFound());
            }
            ViewBag.SinhVienId = new SelectList(db.SinhViens, "Id", "Name");
            return(View(doAn));
        }
コード例 #20
0
        public void setData(DoAn da)
        {
            txtMaDATN.Text = da.MaDoAn;
            txtSVTH.Text = da.TenSV;
            txtTenDATN.Text = da.TenDoAn;
            
            if (da.TinhTrang)
            {
                rbnDaBaoVe.Select();
            }
            else
            {
                rbnChuaBaoVe.Select();
            }

            prepareComboBox(da);
        }
コード例 #21
0
        public void save(DoAn da)
        {
            string sqlCmd = "INSERT INTO DoAN(Ma_Do_An , Ten_Do_An , Ten_SV, Nam_Thuc_Hien, Tinh_Trang , Ma_Huong_NC , ID_GVHD) "
                            + "VALUES( @MDA,@TDA ,@TSV,@NTH,@TT,@MHNC,@ID_GVHD)";

            DBHelper.OpenConnection();
            SqlCommand cmd = DBHelper.GetSqlCommand(sqlCmd);

            cmd.Parameters.AddWithValue("@MDA", da.MaDoAn);
            cmd.Parameters.AddWithValue("@TDA", da.TenDoAn);
            cmd.Parameters.AddWithValue("@TSV", da.TenSV);
            cmd.Parameters.AddWithValue("@NTH", da.NamThucHien);
            cmd.Parameters.AddWithValue("@TT", da.TinhTrang);
            cmd.Parameters.AddWithValue("@MHNC", da.Ma_Huong_NC);
            cmd.Parameters.AddWithValue("@ID_GVHD", da.ID_GVHD);

            cmd.ExecuteNonQuery();
            DBHelper.CloseConnection();
        }
コード例 #22
0
        public List <DoAn> getDoAn(string trangthaidoan)
        {
            List <THONGTINDOAN> listThongtindoan;
            List <Domain>       listQuanHuyen;

            List <ListDoAn> ListThongTinDoAn;
            ListDoAn        doanMenu;
            List <DoAn>     listDoAnQuyHoach = new List <DoAn>();

            DoAn doAnQuyHoach;

            listQuanHuyen = this.gISRepository.getDomain("DMHuyenTPThiXa").ToList();

            listQuanHuyen = listQuanHuyen.OrderBy(qh => qh.value).ToList();

            for (int q = 0; q < listQuanHuyen.Count; q++)
            {
                Domain QuanHuyen = listQuanHuyen[q];

                listThongtindoan = this.gISRepository.getThongTinDoAn().Where(da => da.MaQuanHuyen.Trim() == QuanHuyen.code.Trim() &&
                                                                              da.TrangThaiDoAn == trangthaidoan).ToList();

                ListThongTinDoAn = new List <dataHelper.ListDoAn>();

                for (int i = 0; i < listThongtindoan.Count; i++)
                {
                    THONGTINDOAN doan = listThongtindoan[i];
                    doanMenu         = new ListDoAn();
                    doanMenu.MaDoAn  = doan.MaDoAn;
                    doanMenu.TenDoAn = doan.TenDoAn;
                    ListThongTinDoAn.Add(doanMenu);
                }

                doAnQuyHoach                  = new DoAn();
                doAnQuyHoach.MaQuanHuyen      = QuanHuyen.code;
                doAnQuyHoach.TenQuanHuyen     = QuanHuyen.value;
                doAnQuyHoach.ListDoAnQuyHoach = ListThongTinDoAn;
                listDoAnQuyHoach.Add(doAnQuyHoach);
            }


            return(listDoAnQuyHoach);
        }
コード例 #23
0
    public DoAn getDoAn(int id)
    {
        conn.Open();
        string     sql = "select * from doan where id=@id";
        SqlCommand cmd = new SqlCommand(sql, conn);

        cmd.Parameters.AddWithValue("id", id);
        SqlDataReader reader = cmd.ExecuteReader();
        DoAn          doan   = new DoAn();

        while (reader.Read())
        {
            doan.ID       = id;
            doan.TenDoAn  = Convert.ToString(reader["tendoan"]);
            doan.AuthorID = Convert.ToString(reader["authorID"]);
            doan.MoTa     = Convert.ToString(reader["mota"]);
        }
        conn.Close();
        return(doan);
    }
コード例 #24
0
        public ActionResult Create(DoAn doAn, HttpPostedFileBase fileupload)
        {
            if (fileupload == null)
            {
                ViewBag.Thongbao = "Vui lòng chọn ảnh";
                return(View());
            }
            //Them vao CSDL
            else
            {
                if (ModelState.IsValid)
                {
                    var fileName = Path.GetFileName(fileupload.FileName);
                    //Luu duong dan cua file
                    var path = Path.Combine(Server.MapPath("~/images"), fileName);
                    //Kiem tra hình anh ton tai chua?
                    if (System.IO.File.Exists(path))
                    {
                        ViewBag.Thongbao = "Hình ảnh đã tồn tại";
                        return(View(doAn));
                    }
                    else
                    {
                        //Luu hinh anh vao duong dan
                        fileupload.SaveAs(path);
                    }
                    doAn.AnhDA = fileName;
                    //Luu vao CSDL
                    db.DoAns.Add(doAn);
                    db.SaveChanges();
                    ViewBag.MaDM      = new SelectList(db.DanhMucDoAns.ToList().OrderBy(n => n.TenDM), "MaDM", "TenDM");
                    ViewBag.doan      = listda;
                    ViewBag.CountDoan = listda.Count;
                    HttpResponseMessage response = client.PostAsJsonAsync(url + @"doan/", doAn).Result;

                    response.EnsureSuccessStatusCode();
                    SetAlert("Thêm sản phẩm thành công!!!", "success");
                }
                return(RedirectToAction("Index"));
            }
        }
コード例 #25
0
        public ActionResult Create(DoAn doAn, HttpPostedFileBase fileupload)
        {
            if (fileupload == null)
            {
                ViewBag.Thongbao = "Vui lòng chọn ảnh";
                return(View());
            }
            //Them vao CSDL
            else
            {
                if (ModelState.IsValid)
                {
                    var fileName = Path.GetFileName(fileupload.FileName);
                    //Luu duong dan cua file
                    var path = Path.Combine(Server.MapPath("~/images"), fileName);
                    //Kiem tra hình anh ton tai chua?
                    if (System.IO.File.Exists(path))
                    {
                        ViewBag.Thongbao = "Hình ảnh đã tồn tại";
                        return(View(doAn));
                    }
                    else
                    {
                        //Luu hinh anh vao duong dan
                        fileupload.SaveAs(path);
                    }
                    doAn.AnhDA = fileName;
                    //Luu vao CSDL
                    db.DoAns.Add(doAn);
                    db.SaveChanges();
                    HttpResponseMessage response = client.PostAsJsonAsync(url + @"doan/", doAn).Result;

                    response.EnsureSuccessStatusCode();
                }


                TempData["SuccsessMessage"] = "Thêm mới thành công!!!";
                return(RedirectToAction("Index"));
            }
        }
コード例 #26
0
        public void update(DoAn da)
        {
            string updateCmdString = "";

            updateCmdString = " UPDATE DoAN"
                              + " SET Ten_Do_An = @TDA , Ten_SV = @TSV, Nam_Thuc_Hien = @NTH, Tinh_Trang = @TT, Ma_Huong_NC = @MHNC, ID_GVHD = @ID_GVHD"
                              + " WHERE Ma_Do_An = @MDA";

            DBHelper.OpenConnection();
            SqlCommand cmd = DBHelper.GetSqlCommand(updateCmdString);

            cmd.Parameters.AddWithValue("@MDA", da.MaDoAn);
            cmd.Parameters.AddWithValue("@TDA", da.TenDoAn);
            cmd.Parameters.AddWithValue("@TSV", da.TenSV);
            cmd.Parameters.AddWithValue("@NTH", da.NamThucHien);
            cmd.Parameters.AddWithValue("@TT", da.TinhTrang);
            cmd.Parameters.AddWithValue("@MHNC", da.Ma_Huong_NC);
            cmd.Parameters.AddWithValue("@ID_GVHD", da.ID_GVHD);

            cmd.ExecuteNonQuery();
            DBHelper.CloseConnection();
        }
コード例 #27
0
 public void save(DoAn da)
 {
     doAnDAL.save(da);
 }
コード例 #28
0
ファイル: DoAnRepository.cs プロジェクト: MariettaEcseri/GTMS
        public async Task <DoAn> Create(DoAnForCreateDto doAn)
        {
            var danhSachDoAn = await _context.DanhSachDoAn.OrderByDescending(x => x.MaDoAn).FirstOrDefaultAsync();

            var maDoAn = 0;

            if (danhSachDoAn == null)
            {
                maDoAn = 0;
            }
            else
            {
                maDoAn = danhSachDoAn.MaDoAn + 1;
            }

            var newDoAn = new DoAn
            {
                MaDoAn           = maDoAn,
                TenDoAn          = doAn.TenDoAn,
                MoTa             = doAn.MoTa,
                MaHuongNghienCuu = doAn.MaHuongNghienCuu,
                LienKetTaiDoAn   = doAn.LienKetTaiDoAn,
                ThoiGianBaoCao   = doAn.ThoiGianBaoCao,
                MaHocKy          = doAn.MaHocKy,
                DiemTongKet      = 8,
                NhanXetChung     = doAn.NhanXetChung,
                DiaDiemBaoCao    = doAn.DiaDiemBaoCao,
                ThoiGianTao      = DateTime.Now,
                ThoiGianCapNhat  = DateTime.Now,
                TrangThai        = 1
            };

            await _context.DanhSachDoAn.AddAsync(newDoAn);

            await _context.SaveChangesAsync();

            // Hướng dẫn đồ án
            for (int i = 0; i < doAn.HuongDanDoAn.Count; i++)
            {
                var record = new HuongDanDoAn
                {
                    MaDoAn      = maDoAn,
                    MaGiangVien = doAn.HuongDanDoAn.ElementAt(i).MaGiangVien,
                    NhanXet     = doAn.HuongDanDoAn.ElementAt(i).NhanXet
                };

                await _context.DanhSachHuongDanDoAn.AddAsync(record);

                await _context.SaveChangesAsync();
            }

            // Phản biện đồ án
            for (int i = 0; i < doAn.PhanBienDoAn.Count; i++)
            {
                var record = new PhanBienDoAn
                {
                    MaDoAn      = maDoAn,
                    MaGiangVien = doAn.PhanBienDoAn.ElementAt(i).MaGiangVien,
                    NhanXet     = doAn.PhanBienDoAn.ElementAt(i).NhanXet
                };

                await _context.DanhSachPhanBienDoAn.AddAsync(record);

                await _context.SaveChangesAsync();
            }

            // Hội đồng bảo vệ
            for (int i = 0; i < doAn.BaoVeDoAn.Count; i++)
            {
                var record = new ThanhVienHDBV
                {
                    MaDoAn      = maDoAn,
                    MaGiangVien = doAn.BaoVeDoAn.ElementAt(i).MaGiangVien,
                    ChucVu      = doAn.BaoVeDoAn.ElementAt(i).ChucVu
                };

                await _context.DanhSachThanhVienHDBV.AddAsync(record);

                await _context.SaveChangesAsync();
            }

            // Điểm đồ án
            for (int i = 0; i < doAn.DiemDoAn.Count; i++)
            {
                var record = new DiemDoAn
                {
                    MaDoAn      = maDoAn,
                    MaGiangVien = doAn.DiemDoAn.ElementAt(i).MaGiangVien,
                    Diem        = doAn.DiemDoAn.ElementAt(i).Diem,
                    HeSo        = doAn.DiemDoAn.ElementAt(i).HeSo
                };

                await _context.DanhSachDiemDoAn.AddAsync(record);

                await _context.SaveChangesAsync();
            }

            // Thực hiện đồ án
            for (int i = 0; i < doAn.ThucHienDoAn.Count; i++)
            {
                var oldRecord        = _context.DanhSachSinhVien.AsNoTracking().FirstOrDefault(x => x.MaSinhVien == doAn.ThucHienDoAn.ElementAt(i));
                var sinhVienToUpdate = new SinhVien
                {
                    MaSinhVien      = doAn.ThucHienDoAn.ElementAt(i),
                    HoVaTen         = oldRecord.HoVaTen,
                    MaLop           = oldRecord.MaLop,
                    GioiTinh        = oldRecord.GioiTinh,
                    NgaySinh        = oldRecord.NgaySinh,
                    Email           = oldRecord.Email,
                    QueQuan         = oldRecord.QueQuan,
                    DiaChi          = oldRecord.DiaChi,
                    SoDienThoai     = oldRecord.SoDienThoai,
                    ThoiGianTao     = oldRecord.ThoiGianTao,
                    ThoiGianCapNhat = DateTime.Now,
                    TrangThai       = oldRecord.TrangThai,
                    MaDoAn          = maDoAn
                };

                _context.DanhSachSinhVien.Update(sinhVienToUpdate);
                await _context.SaveChangesAsync();
            }

            return(newDoAn);
        }
コード例 #29
0
 public void createData(DoAn da)
 {
     doAnBll.save(da);
     dataGridView.DataSource = doAnBll.getListDoAn();
 }
コード例 #30
0
 public void update(DoAn da)
 {
     doAnDAL.update(da);
 }