public async Task <IActionResult> Edit(string id, [Bind("Mahp,Tenmon,Siso,Phonghoc,Tiethoc,Thu,Ngaybd,Ngaykt")] HocPhan hocPhan) { if (id != hocPhan.Mahp) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(hocPhan); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!HocPhanExists(hocPhan.Mahp)) { return(NotFound()); } else { throw; } } return(RedirectToAction("Index")); } return(View(hocPhan)); }
public async Task <ActionResult <BaseResponse> > PutHocPhan(int id, HocPhan hocPhan) { var hocPhanSua = await _context.HocPhans.FindAsync(id); if (hocPhanSua == null) { return(new BaseResponse { ErrorCode = 1, Message = "Không tìm thấy" }); } hocPhanSua.DonViQuanLyId = hocPhan.DonViQuanLyId; hocPhanSua.DonViRaDeId = hocPhan.DonViRaDeId; hocPhanSua.MaHP = hocPhan.MaHP; hocPhanSua.SoTinChi = hocPhan.SoTinChi; hocPhanSua.TenHP = hocPhan.TenHP; _context.HocPhans.Update(hocPhanSua); await _context.SaveChangesAsync(); return(new BaseResponse { Message = "Cập nhật thành công", Data = hocPhan }); }
public async Task <List <HocPhanExtend> > getListUnRegistableAsync() { try { List <HocPhanExtend> listHocPhan = new List <HocPhanExtend>(); BaseConnector connector = BaseConnector.getInstance(); BaseResponse res = await connector.GetObject(DeployEnvironment.GetEnvironment().GetUnEnrolablePath()); if (res.status) { JsonAttributes jsonAttr = JsonAttributeGetter.GetJsonAttributes(); List <Object> listO = JsonGetter.getList(res.obj.ToString(), jsonAttr.RES_RESULT()); for (int i = 0; i < listO.Count; i++) { HocPhanExtend hocPhan = new HocPhanExtend() { hocPhan = HocPhan.Parse(JsonGetter.getObject(listO[i].ToString(), jsonAttr.RES_SUBJECT())), lyDo = JsonGetter.getString(listO[i].ToString(), jsonAttr.RES_REASON()) }; listHocPhan.Add(hocPhan); } } return(listHocPhan); } catch (Exception ex) { LogHelper.Log("ERROR: " + ex); return(null); } }
public async Task <HocPhan> UpdateHocPhan(HocPhan hocPhan) { _context.HocPhanContext.Update(hocPhan); await _context.SaveChangesAsync(); return(hocPhan); }
public async Task <HocPhan> CreateHocPhan(HocPhan hocPhan) { await _context.HocPhanContext.AddAsync(hocPhan); await _context.SaveChangesAsync(); return(hocPhan); }
public ActionResult EditHocPhan(HocPhan hocPhan, string Id_MonHoc, int position_hocphan, string id_hocphan) { MonHoc monHoc = model.find(Id_MonHoc); hocPhan.Id = ObjectId.Parse(id_hocphan); monHoc.DanhSachHocPhan[position_hocphan] = hocPhan; model.update(monHoc); return(RedirectToAction(Id_MonHoc, "MonHoc/XemDanhSachHocPhan")); }
//ham xoa hoc phan public bool XoaHP(HocPhan hp) { string sql = "delete HocPhan where maHP = @maHP"; SqlParameter[] sqlParameters = { new SqlParameter("@maHP", hp.maHP) }; return(dal.myExecute(sql, sqlParameters)); }
private void button9_Click(object sender, EventArgs e) { DataDAO dataDAO = new DataDAO(); HocPhan hocPhan = new HocPhan(); hocPhan.Ma_HP = textBox8.Text; hocPhan.Ten_HP = textBox9.Text; dataDAO.UpdateHP(textBox8.Text, hocPhan); Deletetextbox(); }
public async Task <IActionResult> Create([Bind("Mahp,Tenmon,Siso,Phonghoc,Tiethoc,Thu,Ngaybd,Ngaykt")] HocPhan hocPhan) { if (ModelState.IsValid) { _context.Add(hocPhan); await _context.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(hocPhan)); }
protected void btnCreate_Click(object sender, EventArgs e) { SaveCheckedValues(); grvCourse.AllowPaging = false; grvCourse.DataBind(); MoodleCourse course; XmlDocument doc = new XmlDocument(); ArrayList arrIDs = ConvertToArrayList(txtListId.Text); string idnum = "0"; DCVimaruDataContext dc = new DCVimaruDataContext(); HocPhan hocphan = dc.HocPhans.Single(t => t.MaHP == cboFilterSubject.SelectedValue); int parent = Convert.ToInt32(hocphan.Id); foreach (GridViewRow row in grvCourse.Rows) { idnum = grvCourse.DataKeys[row.RowIndex]["STT"].ToString(); if (arrIDs.Contains(idnum)) { if (row.Cells[2].Text != "0") { continue; } string fullname = HttpUtility.HtmlDecode(row.Cells[4].Text + " " + row.Cells[5].Text + "-" + row.Cells[6].Text); course = new MoodleCourse( fullname, fullname, parent, MoodleUtilites.GetIdNumber(fullname), fullname, MoodleUtilites.ConvertToTimestamp(row.Cells[6].Text) ); List <MoodleCourse> list = new List <MoodleCourse>(); list.Add(course); doc.LoadXml(MoodleCourse.CreateCourses(list, (string)Session["token"])); doc.Save("D:\\course_create_" + row.Cells[3].Text + ".xml"); if (doc.DocumentElement.Name == "RESPONSE") { long id = (long)Convert.ToUInt32(doc.DocumentElement.ChildNodes[0].ChildNodes[0].ChildNodes[0].ChildNodes[0].InnerText); ThoiKhoaBieu tkb = dc.ThoiKhoaBieus.Single(t => t.STT == Convert.ToInt32(row.Cells[3].Text)); tkb.Id = id; dc.SubmitChanges(); } } } grvCourse.AllowPaging = true; }
public List <HocPhan> GetListHocPhan() { List <HocPhan> list = new List <HocPhan>(); DataTable data = DataProvider.Instance.ExecuteQuery("USP_GetHocPhanList"); foreach (DataRow item in data.Rows) { HocPhan hocphan = new HocPhan(item); list.Add(hocphan); } return(list); }
/// <summary> /// Lấy Học phần bởi mã giảng viên và mã học phần, trả về danh sách HOCPHAN /// </summary> /// <param name="id">Mã giảng viên</param> /// <param name="Mahp">Mã học phần</param> /// <returns></returns> public List <HocPhan> getListHocPhanByIDGiangVienAndMaHP(String id, String Mahp) { List <HocPhan> result = new List <HocPhan>(); String sqlString = @"EXEC getListHocPhanByIDGiangVienAndMaHP '" + id + "', '" + Mahp + "'"; DataTable dt = DataProvider.Instance.LoadAllTable(sqlString); foreach (DataRow i in dt.Rows) { HocPhan hp = new HocPhan(i); result.Add(hp); } return(result); }
protected void btnCreate_Click(object sender, EventArgs e) { SaveCheckedValues(); grvSubject.AllowPaging = false; grvSubject.DataBind(); MoodleCategory category; XmlDocument doc = new XmlDocument(); ArrayList arrIDs = ConvertToArrayList(txtListId.Text); string idnum = "0"; DCVimaruDataContext dc = new DCVimaruDataContext(); BoMon bomon = dc.BoMons.Single(t => t.MaBoMon == Convert.ToInt32(cboFilterDepartment.SelectedValue)); int parent = Convert.ToInt32(bomon.Id); foreach (GridViewRow row in grvSubject.Rows) { if (row.Cells[2].Text != "0") { continue; } idnum = grvSubject.DataKeys[row.RowIndex]["MaHP"].ToString(); if (arrIDs.Contains(idnum)) { category = new MoodleCategory { Name = HttpUtility.HtmlDecode(row.Cells[4].Text), Parent = parent, IdNumber = HttpUtility.HtmlDecode(row.Cells[3].Text), Description = HttpUtility.HtmlDecode(row.Cells[4].Text), DescriptionFormat = 1, Theme = null }; List <MoodleCategory> lst = new List <MoodleCategory>(); lst.Add(category); doc.LoadXml(MoodleCategory.CreateCategories(lst, (string)Session["token"])); doc.Save("D:\\subject_" + category.IdNumber + ".xml"); if (doc.DocumentElement.Name == "RESPONSE") { long id = (long)Convert.ToUInt32(doc.DocumentElement.ChildNodes[0].ChildNodes[0].ChildNodes[0].ChildNodes[0].InnerText); HocPhan hocphan = dc.HocPhans.Single(t => t.MaHP == category.IdNumber); hocphan.Id = id; dc.SubmitChanges(); } } } grvSubject.AllowPaging = true; }
/// <summary> /// Lấy học phần bởi mã giảng viên, trả về sanh sách HOCPHAN /// </summary> /// <param name="id">Mã giảng viên</param> /// <returns></returns> public List <HocPhan> getListHocPhanByIDGiangVien(String id) { List <HocPhan> result = new List <HocPhan>(); String sqlString = string.Format(@"EXEC getListNhomHocPhanByIDGiangVien '{0}'", id); DataTable dt = DataProvider.Instance.LoadAllTable(sqlString); foreach (DataRow i in dt.Rows) { HocPhan hp = new HocPhan(i); result.Add(hp); } return(result); }
public void capnhathocphan(HocPhan HocPhan, IClientSessionHandle session) { HocPhanCollection.UpdateOne(session, Builders <HocPhan> .Filter.Eq("_id", ObjectId.Parse(HocPhan.Id.ToString())), Builders <HocPhan> .Update .Set("id_LopHoc", HocPhan.id_LopHoc) .Set("SiSo", HocPhan.SiSo) .Set("LyThuyet", HocPhan.LyThuyet) .Set("ThucHanh", HocPhan.ThucHanh) .Set("DanhSachSinhVien", HocPhan.DanhSachSinhVien) .Set("Status", HocPhan.Status) ); }
private void button1_Click(object sender, EventArgs e) { DataDAO dataDAO = new DataDAO(); HocPhan hocPhan = new HocPhan(); hocPhan.Ma_HP = textBox1.Text; hocPhan.Ten_HP = textBox2.Text; hocPhan.Ma_D = ""; hocPhan.Ma_SV = ""; hocPhan.ID_Khoa = MaKhoa(comboBox1.Text); dataDAO.Insert(hocPhan); Deletetextbox(); Close(); }
public List <HocPhan> SearchHPByTenKhoa(string makhoa) { List <HocPhan> list = new List <HocPhan>(); string query = string.Format("select * from HOCPHAN where [dbo].[GetUnsignString](MAKHOA) " + "like N'%'+[dbo].[GetUnsignString](N'{0}')+'%' ", makhoa); DataTable data = DataProvider.Instance.ExecuteQuery(query); foreach (DataRow item in data.Rows) { HocPhan hocphan = new HocPhan(item); list.Add(hocphan); } return(list); }
//ham sua giao vien public bool SuaHP(HocPhan hp) { string sql = "Update HocPhan set tenHP = @tenHP, soTC = @soTC, soDVHT = @soDVHT, maGV = @maGV where maHP = @maHP"; SqlParameter[] sqlParameters = { new SqlParameter("@maHP", hp.maHP), new SqlParameter("@tenHP", hp.tenHP), new SqlParameter("@soTC", hp.soTC), new SqlParameter("@soDVHT", hp.soDVHT), new SqlParameter("@maGV", hp.maGV) }; return(dal.myExecute(sql, sqlParameters)); }
public HocPhan GetHPByMaHP(string mahocphan) { HocPhan hocphan = null; string query = "select * from HOCPHAN where MAHOCPHAN = " + mahocphan; DataTable data = DataProvider.Instance.ExecuteQuery(query); foreach (DataRow item in data.Rows) { hocphan = new HocPhan(item); return(hocphan); } return(hocphan); }
//ham them hoc phan public bool ThemHP(HocPhan hp) { string sql = "insert into HocPhan(maHP, tenHP, soTC, soDVHT, maGV)" + "values (@maHP, @tenHP, @soTC, @soDVHT, @maGV)"; SqlParameter[] sqlParameters = { new SqlParameter("@maHP", hp.maHP), new SqlParameter("@tenHP", hp.tenHP), new SqlParameter("@soTC", hp.soTC), new SqlParameter("@soDVHT", hp.soDVHT), new SqlParameter("@maGV", hp.maGV) }; return(dal.myExecute(sql, sqlParameters)); }
public async Task <Response <HocPhan> > TaoHocPhan(TaoHocPhanRequest request) { var hocPhan = new HocPhan { TenHocPhan = request.TenHocPhan }; var newHocPhan = await _hocPhanRepo.CreateHocPhan(hocPhan); return(new Response <HocPhan> { StatusCode = 201, Success = true, Errors = null, Data = newHocPhan }); }
public ActionResult ThemHocPhan(HocPhan objectname, string id_monhoc) { MonHoc monHoc = model.find(id_monhoc); if (monHoc.DanhSachHocPhan == null) { monHoc.DanhSachHocPhan = new List <HocPhan>(); } ViewBag.id_monhoc = id_monhoc; monHoc.DanhSachHocPhan.Add(objectname); objectname.Id = ObjectId.GenerateNewId(); model.update(monHoc); return(RedirectToAction(id_monhoc, "MonHoc/XemDanhSachHocPhan")); }
/// <summary> /// Lấy học phần bởi mã học phần, trả về Kiểu HOCPHAN /// </summary> /// <param name="ID">Mã học phần</param> /// <returns></returns> public HocPhan getHocPhanByID(String ID) { HocPhan hp = new HocPhan(); String sqlString = "Exec getHocPhanByID " + "'" + ID + "'"; try { DataTable dt = DataProvider.Instance.LoadAllTable(sqlString); hp = new HocPhan(dt.Rows[0]); } catch (Exception ex) { MessageBox.Show(ex.Message); } return(hp); }
public ActionResult Edit(string id) { if (id == null) { return(RedirectToAction("Index")); } else if (model.find(id) == null) { return(RedirectToAction("Index")); } ViewBag.giangviens = new GiangVienModel().findAll(); ViewBag.lophocs = new LopHocModel().findAll(); ViewBag.id = id; HocPhan hocPhan = model.find(id); return(View("Edit", model.find(id))); }
public void UpdateHP(string s, HocPhan hocPhan) { var sql = "Update [SinhVien_BT].[dbo].[HocPhan] set Ten_HP = @Ten_HP ,Ma_HP = @Ma_HP where Ma_HP = '" + s + "'"; using (sqlConnection = new SqlConnection(Connect)) { try { sqlConnection.Open(); SqlCommand sqlCommand = new SqlCommand(sql, sqlConnection); sqlCommand.Parameters.AddWithValue("Ten_HP", hocPhan.Ten_HP); sqlCommand.Parameters.AddWithValue("Ma_HP", hocPhan.Ma_HP); sqlCommand.ExecuteNonQuery(); } catch (Exception) { MessageBox.Show("Nhap Lai Thong Tin"); } } }
private void txbMaLopHP_TextChanged(object sender, EventArgs e) { if (dtgvLopHP.SelectedCells.Count > 0) { string mahocphan = Convert.ToString(dtgvLopHP.SelectedCells[0].OwningRow.Cells["MaHocPhan"].Value); HocPhan hocphan = HocPhanDAO.Instance.GetHPByMaHP(mahocphan); cbHP.SelectedItem = mahocphan; int index = -1; int i = 0; foreach (HocPhan item in cbHP.Items) { if (item.MaHocPhan == hocphan.MaHocPhan) { index = i; break; } i++; } cbHP.SelectedIndex = index; } }
public async Task <ActionResult <BaseResponse> > PostHocPhan(HocPhan hocPhan) { try { _context.HocPhans.Add(hocPhan); await _context.SaveChangesAsync(); return(new BaseResponse { Message = "Thêm mới thành công", Data = hocPhan }); } catch { return(new BaseResponse { ErrorCode = 1, Message = "Thêm mới thất bại" }); } }
public void Insert(HocPhan hocPhan) { var sql = @"insert into [SinhVien_BT].[dbo].[HocPhan] values(@Ma_HP,@Ten_HP,@Ma_SV,@Ma_D,@ID_Khoa)"; using (sqlConnection = new SqlConnection(Connect)) { sqlConnection.Open(); try { SqlCommand sqlCommand = new SqlCommand(sql, sqlConnection); sqlCommand.Parameters.AddWithValue("Ma_HP", hocPhan.Ma_HP); sqlCommand.Parameters.AddWithValue("Ten_HP", hocPhan.Ten_HP); sqlCommand.Parameters.AddWithValue("Ma_SV", hocPhan.Ma_SV); sqlCommand.Parameters.AddWithValue("Ma_D", hocPhan.Ma_D); sqlCommand.Parameters.AddWithValue("ID_Khoa", hocPhan.ID_Khoa); sqlCommand.ExecuteNonQuery(); } catch (Exception) { MessageBox.Show("Nhap Lai Thong Tin "); } } }
private void SetUpComboBoxWithData() { cb_ky.Items.Clear(); cb_nam.Items.Clear(); InitComboBox(); List <int> listNam = new List <int>(); foreach (DangKyHocPhan d in data) { HocPhan h = d.hocPhan; for (int tiet = h.thoiGian.tietBatDau; tiet <= h.thoiGian.tietKetThuc; tiet++) { try { int nam = h.nam; int ky = h.hocKy; if (!listNam.Contains(nam)) { listNam.Add(nam); } } catch (IndexOutOfRangeException e) { LogHelper.Log("ERROR KetQuaUC: " + e); } } } listNam.Sort(); listNam.Reverse(); foreach (int nam in listNam) { cb_nam.Items.Add(nam); } cb_nam.SelectedIndex = 0; }
public ActionResult EditHocPhan(string Id_MonHoc, int position_hocphan) { if (Id_MonHoc == null) { return(RedirectToAction("Index")); } else if (model.find(Id_MonHoc) == null) { return(RedirectToAction("Index")); } MonHoc mon = model.find(Id_MonHoc); HocPhan hoc = mon.DanhSachHocPhan[position_hocphan]; ViewBag.position_hocphan = position_hocphan; ViewBag.Id_MonHoc = Id_MonHoc; ViewBag.TenMonHoc = mon.TenMonHoc; ViewBag.giangviens = new GiangVienModel().findAll(); ViewBag.lophocs = new LopHocModel().findAll(); ViewBag.id_hocphan = hoc.Id; return(View(hoc)); }