public ActionResult EditSchedule(ThoiKhoaBieu tkb) { try { // TODO: Add insert logic here if (ModelState.IsValid) { var _tkbDao = new ThoiKhoaBieuDao(); var res = _tkbDao.Update(tkb); if (res) { return(RedirectToAction("Index", "KhoaHoc")); } else { ModelState.AddModelError("", "Cập nhật lỗi"); } } return(View(tkb)); } catch { return(RedirectToAction("Index", "KhoaHoc")); } }
protected void btnGetEnrolledUsers_Click(object sender, EventArgs e) { DCVimaruDataContext dc = new DCVimaruDataContext(); //get courseId ThoiKhoaBieu tkb = dc.ThoiKhoaBieus.Single(t => t.STT == Convert.ToInt32(cboFilterCourse.SelectedValue)); int courseId = Convert.ToInt32(tkb.Id); //create options to get 4 fields of user is id, username, fullname, email List <KeyValuePair <string, string> > list = new List <KeyValuePair <string, string> >(); list.Add(new KeyValuePair <string, string>("userfields", "id")); list.Add(new KeyValuePair <string, string>("userfields", "username")); list.Add(new KeyValuePair <string, string>("userfields", "fullname")); list.Add(new KeyValuePair <string, string>("userfields", "email")); XmlDocument doc = new XmlDocument(); doc.LoadXml(MoodleEnrol.GetEnrolledUsers(courseId, list, (string)Session["token"])); doc.Save("D:\\enrolled_users_" + courseId + ".xml"); XmlNode xmlnode = doc.ChildNodes[1]; treeDetail.Nodes.Clear(); treeDetail.Nodes.Add(new TreeNode(doc.DocumentElement.Name)); TreeNode tNode; tNode = treeDetail.Nodes[0]; MoodleUtilites.AddNode(xmlnode, tNode); treeDetail.ExpandAll(); }
public ThoiKhoaBieu CreateThoiKhoaBieu(ThoiKhoaBieu tkb) { db = new GDUDataConnectionsDataContext(); db.ThoiKhoaBieus.InsertOnSubmit(tkb); db.SubmitChanges(); return(tkb); }
public void Create(ThoiKhoaBieu tkb) { LopTinChiBLL contextLTC = new LopTinChiBLL(); MonHocBLL contextMH = new MonHocBLL(); // lấy thông tin lớp tín chỉ của thời khóa biểu. LopTinChi ltc = contextLTC.GetById(tkb.MaLopTC); //Lasays thông tin môn học MonHoc mh = contextMH.GetById(ltc.MaMonHoc); int soBuoi = 0; int sotc = mh.SoTinChiLyThuyet + mh.SoTinChiThucHanh; if (sotc * 15 % 4 != 0) { soBuoi = (int)(sotc * 15 / 4) + 1; } else { soBuoi = sotc * 15 / 4; } try { for (int i = 0; i < soBuoi; i++) { context.Create(tkb); tkb.Ngay = tkb.Ngay.AddDays(7); } } catch (Exception ex) { Console.WriteLine(ex); } }
public ThoiKhoaBieu GetThoiKhoaBieuByMaLopMaMonHoc(string maLop, string maMH) { db = new GDUDataConnectionsDataContext(); ThoiKhoaBieu InfoTKB = new ThoiKhoaBieu(); InfoTKB = db.ThoiKhoaBieus.Single(p => p.MaLop == maLop && p.MaMonHoc == maMH); return(InfoTKB); }
//// GET: Admin/ThoiKhoaBieux/Edit/5 //public ActionResult Edit(ThoiKhoaBieu tkb) //{ // LopTinChiBLL contextLTC = new LopTinChiBLL(); // if (tkb == null) // { // return new HttpStatusCodeResult(HttpStatusCode.BadRequest); // } // LopTinChi lopTC = contextLTC.GetById(tkb.MaLopTC); // ViewBag.LopTC = lopTC; // return View(tkb); //} //// POST: Admin/ThoiKhoaBieux/Edit/5 //// To protect from overposting attacks, please enable the specific properties you want to bind to, for //// more details see http://go.microsoft.com/fwlink/?LinkId=317598. //[HttpPost] //[ValidateAntiForgeryToken] //public ActionResult Edit([Bind(Include = "Ngay,Buoi,TietBD,MaLopTC")] ThoiKhoaBieu thoiKhoaBieu) //{ // if (ModelState.IsValid) // { // contextTKB.Entry(thoiKhoaBieu).State = EntityState.Modified; // contextTKB.SaveChanges(); // return RedirectToAction("Index"); // } // ViewBag.MaLopTC = new SelectList(contextTKB.LopTinChis, "MaLopTC", "NienKhoa", thoiKhoaBieu.MaLopTC); // return View(thoiKhoaBieu); //} // GET: Admin/ThoiKhoaBieux/Delete/5 public ActionResult Delete(ThoiKhoaBieu tkb) { if (tkb == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } return(View(tkb)); }
public void DeleteThoiKhoaBieu(string maLop, string maMonHoc) { db = new GDUDataConnectionsDataContext(); ThoiKhoaBieu tkb = new ThoiKhoaBieu(); tkb = db.ThoiKhoaBieus.Single(p => p.MaLop == maLop && p.MaMonHoc == maMonHoc); db.ThoiKhoaBieus.DeleteOnSubmit(tkb); db.SubmitChanges(); }
protected void btnDelete_Click(object sender, EventArgs e) { SaveCheckedValues(); grvCourse.AllowPaging = false; grvCourse.DataBind(); XmlDocument doc = new XmlDocument(); ArrayList arrIDs = ConvertToArrayList(txtListId.Text); string idnum = "0"; DCVimaruDataContext dc = new DCVimaruDataContext(); foreach (GridViewRow row in grvCourse.Rows) { idnum = grvCourse.DataKeys[row.RowIndex]["STT"].ToString(); if (arrIDs.Contains(idnum)) { int id = Convert.ToInt32(row.Cells[2].Text); List <int> list = new List <int>(); if (id != 0) { list.Add(id); } else { continue; } doc.LoadXml(MoodleCourse.DeleteCourses(list, (string)Session["token"])); doc.Save("D:\\course_delete_" + row.Cells[3].Text + ".xml"); if (doc.DocumentElement.Name == "RESPONSE") { int maTKB = Convert.ToInt32(row.Cells[3].Text); // Reset Moodle Id of Thoi khoa bieu to 0 ThoiKhoaBieu tkb = dc.ThoiKhoaBieus.Single(t => t.STT == maTKB); tkb.Id = 0; // Reset GhiDanh of Dang ky to false and ID_Nhom to null dc.ExecuteCommand("UPDATE [dbo].[DangKy] SET GhiDanh = 0 , ID_Nhom = null WHERE MaTKB = {0}", maTKB); // Delete group dc.ExecuteCommand("DELETE FROM [dbo].[Nhom] WHERE MaTKB = {0}", maTKB); // Delete grouping dc.ExecuteCommand("DELETE FROM [dbo].[To] WHERE MaTKB = {0}", maTKB); dc.SubmitChanges(); } } } grvCourse.AllowPaging = true; }
public void Edit(ThoiKhoaBieu tkb) { try { context.Edit(tkb); } catch (Exception ex) { Console.WriteLine(ex); } }
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; }
private void EnrolUsers(int suspend) { SaveCheckedValues(); grvUser.AllowPaging = false; grvUser.DataBind(); DCVimaruDataContext dc = new DCVimaruDataContext(); //get courseId ThoiKhoaBieu tkb = dc.ThoiKhoaBieus.Single(t => t.STT == Convert.ToInt32(cboFilterCourse.SelectedValue)); int courseId = Convert.ToInt32(tkb.Id); //role: Học viên int roleId = 5; MoodleEnrol enrol; XmlDocument doc = new XmlDocument(); ArrayList arrIDs = ConvertToArrayList(txtMaSV.Text); string MaSV = "0"; foreach (GridViewRow row in grvUser.Rows) { MaSV = grvUser.DataKeys[row.RowIndex]["MaSV"].ToString(); if (arrIDs.Contains(MaSV)) { CheckBox chk = row.Cells[4].Controls[0] as CheckBox; if (row.Cells[3].Text == "0" || (suspend == 0 && chk.Checked) || (suspend == 1 && !chk.Checked)) { continue; } enrol = new MoodleEnrol { RoleId = roleId, UserId = Convert.ToInt32(row.Cells[3].Text), CourseId = courseId, TimeStart = 0, TimeEnd = 0, Suspend = suspend }; List <MoodleEnrol> list = new List <MoodleEnrol>(); list.Add(enrol); doc.LoadXml(MoodleEnrol.EnrolUsers(list, (string)Session["token"])); doc.Save("D:\\enrol_" + enrol.UserId + ".xml"); if (doc.DocumentElement.Name == "RESPONSE") { DangKy dk = dc.DangKies.Single(t => t.STT == Convert.ToInt64(row.Cells[2].Text)); dk.GhiDanh = !chk.Checked; dc.SubmitChanges(); } } } grvUser.AllowPaging = true; }
public ActionResult Create([Bind(Include = "Ngay,Buoi,TietBD,MaLopTC")] ThoiKhoaBieu thoiKhoaBieu) { if (ModelState.IsValid) { contextTKB.Create(thoiKhoaBieu); return(RedirectToAction("Index")); } List <LopTinChi> lstLTC = contextLTC.GetAll(); lstLTC = contextLTC.GetListLTCOpen(lstLTC); ViewBag.MaLopTC = new SelectList(lstLTC, "MaLopTC", "NienKhoa", thoiKhoaBieu.MaLopTC); return(View(thoiKhoaBieu)); }
public void UpdateThoiKhoaBieu(ThoiKhoaBieu tkb) { db = new GDUDataConnectionsDataContext(); ThoiKhoaBieu thoiKhoaBieu = new ThoiKhoaBieu(); thoiKhoaBieu = db.ThoiKhoaBieus.Single(p => p.MaLop == tkb.MaLop && p.MaMonHoc == tkb.MaMonHoc); thoiKhoaBieu.MaGV = tkb.MaGV; thoiKhoaBieu.NgayHoc = tkb.NgayHoc; Console.WriteLine("cahu vo day r"); thoiKhoaBieu.MaPhongHoc = tkb.MaPhongHoc; thoiKhoaBieu.ThoiGianHoc = tkb.ThoiGianHoc; thoiKhoaBieu.NgayBatDau = tkb.NgayBatDau; thoiKhoaBieu.NgayKetThuc = tkb.NgayKetThuc; thoiKhoaBieu.GhiChu = tkb.GhiChu; db.SubmitChanges(); }
protected void btnCreateGroup_Click(object sender, EventArgs e) { if (cboFilterCourse.Items.Count == 0) { return; } DCVimaruDataContext dc = new DCVimaruDataContext(); //get courseId ThoiKhoaBieu tkb = dc.ThoiKhoaBieus.Single(t => t.STT == Convert.ToInt32(cboFilterCourse.SelectedValue)); int courseId = Convert.ToInt32(tkb.Id); XmlDocument doc = new XmlDocument(); List <MoodleGroup> list = new List <MoodleGroup>(); MoodleGroup group = new MoodleGroup { CourseId = courseId, Name = txtGroupName.Text, Description = txtDescription.Text, DescriptionFormat = 1, EnrolmentKey = null }; list.Add(group); doc.LoadXml(MoodleGroup.CreateGroups(list, (string)Session["token"])); doc.Save("D:\\Group_Create_" + txtGroupName.Text + ".xml"); if (doc.DocumentElement.Name == "RESPONSE") { long idnhom = (long)Convert.ToUInt64(doc.DocumentElement.ChildNodes[0].ChildNodes[0].ChildNodes[0].ChildNodes[0].InnerText); Nhom nhom = new Nhom(); nhom.ID_Nhom = idnhom; nhom.TenNhom = txtGroupName.Text; nhom.MoTa = txtDescription.Text; nhom.MaTKB = (long)Convert.ToUInt64(cboFilterCourse.SelectedValue); dc.Nhoms.InsertOnSubmit(nhom); dc.SubmitChanges(); cboGroup.DataBind(); } }
public string CreateScheduleNotification(LICHHOC lichHoc) { var arrRegid = FireBaseDao.GetFireBaseTokenByClass(lichHoc.MaLopHocPhan); if (arrRegid.Length == 0) return null; var lopHocPhan = LopHocPhanDao.GetLopHocPhan(lichHoc.MaLopHocPhan); var phongHoc = LopHocPhanDao.GetPhongHoc(lichHoc.PhongHoc); var giangVien = LopHocPhanDao.GetGiangVien(lopHocPhan.GiangVienPhuTrach); ThoiKhoaBieu thoiKhoaBieu = new ThoiKhoaBieu() { MaLopHocPhan = lopHocPhan.MaLopHocPhan, TenLopHocPhan = lopHocPhan.TenLopHocPhan, NgayHoc = lichHoc.NgayHoc, HoVaTen = giangVien.HoVaTen, NgayTrongTuan = lichHoc.NgayHoc.DayOfWeek.GetHashCode() + 1, PhongHoc = phongHoc.MaPhong, TenPhong = phongHoc.TenPhong, TietHocBatDau = lichHoc.TietHocBatDau, TietHocKetThuc = lichHoc.TietHocKetThuc, HocKy = LopHocPhanDao.MaxMaHocKy(), MaSinhVien = "" }; string notiBody = JsonConvert.SerializeObject(thoiKhoaBieu); PushNotification notification = new PushNotification() { registration_ids = arrRegid, data = new Data() { title = "Lịch học bù", body = notiBody, postTime = DateTime.Now.ToString(), type = SCHEDULE_NOTIFICATION } }; string postData = JsonConvert.SerializeObject(notification); return postData; }
private void btnUpdateTKB_Click(object sender, EventArgs e) { if (checkDataTKB()) { ThoiKhoaBieu tkb = new ThoiKhoaBieu(); tkb.MaLop = maLop; tkb.MaHocKy = cboChonHocKy_TKB.SelectedValue.ToString(); tkb.MaMonHoc = cboChonMonHoc_TKB.SelectedValue.ToString(); tkb.MaGV = cboChonGV_TKB.SelectedValue.ToString(); tkb.NgayHoc = cboChonNgayHoc_TKB.Text.Trim(); tkb.MaPhongHoc = cboChonPhongHoc_TKB.Text.ToString(); tkb.ThoiGianHoc = thoiGianHoc; tkb.NgayBatDau = dtpStartDay.Text.ToString(); tkb.NgayKetThuc = dtpEndDay.Text.ToString(); tkb.GhiChu = rtxtGhiChu_TKB.Text; thoiKhoaBieuService.UpdateThoiKhoaBieu(tkb); LoadDanhSachThoiKhoaBieuToDgv(); } }
protected void btnUpdateGrouping_Click(object sender, EventArgs e) { if (cboFilterCourse.Items.Count == 0) { return; } DCVimaruDataContext dc = new DCVimaruDataContext(); //get courseId ThoiKhoaBieu tkb = dc.ThoiKhoaBieus.Single(t => t.STT == Convert.ToInt32(cboFilterCourse.SelectedValue)); int courseId = Convert.ToInt32(tkb.Id); XmlDocument doc = new XmlDocument(); List <MoodleGroup> list = new List <MoodleGroup>(); int id = Convert.ToInt32(cboGrouping.SelectedValue); MoodleGroup grouping = new MoodleGroup { Id = id, Name = txtGroupingName.Text, Description = txtDescription.Text, DescriptionFormat = 1, }; list.Add(grouping); doc.LoadXml(MoodleGroup.UpdateGroupings(list, (string)Session["token"])); doc.Save("D:\\Grouping_Update_" + txtGroupingName.Text + ".xml"); if (doc.DocumentElement.Name == "RESPONSE") { To t = dc.Tos.Single(i => i.ID_To == id); t.TenTo = txtGroupingName.Text; t.MoTa = txtDescription.Text; dc.SubmitChanges(); cboGrouping.DataBind(); } }
public bool Update(ThoiKhoaBieu tkb) { try { var _tkb = _context.ThoiKhoaBieux.Find(tkb.MaTKB); _tkb.ThoiGianHoc = tkb.ThoiGianHoc; _tkb.ThuHai = tkb.ThuHai; _tkb.ThuBa = tkb.ThuBa; _tkb.ThuTu = tkb.ThuTu; _tkb.ThuNam = tkb.ThuNam; _tkb.ThuSau = tkb.ThuSau; _tkb.ThuBa = tkb.ThuBa; _tkb.ChuNhat = tkb.ChuNhat; _context.SaveChanges(); return(true); } catch (Exception ex) { return(false); } }
public ActionResult CreateSchedule(ThoiKhoaBieu tkb, int id) { // TODO: Add insert logic here if (ModelState.IsValid) { tkb.MaKhoaHoc = id; var thoiKhoaBieuDao = new ThoiKhoaBieuDao(); int maTKB = thoiKhoaBieuDao.Insert(tkb); if (maTKB > 0) { return(RedirectToAction("Index", "KhoaHoc")); } else { ModelState.AddModelError("", "Thêm thất bại"); } } SetViewBagKH(); SetViewBagGV(); return(View(tkb)); }
//tạo mới thời khóa biểu public ThoiKhoaBieu CreateThoiKhoaBieu(ThoiKhoaBieu tkb) { return(TKBIdao.CreateThoiKhoaBieu(tkb)); }
public void AddToThoiKhoaBieux(ThoiKhoaBieu thoiKhoaBieu) { base.AddObject("ThoiKhoaBieux", thoiKhoaBieu); }
public static ThoiKhoaBieu CreateThoiKhoaBieu(int maTKB) { ThoiKhoaBieu thoiKhoaBieu = new ThoiKhoaBieu(); thoiKhoaBieu.MaTKB = maTKB; return thoiKhoaBieu; }
public int Insert(ThoiKhoaBieu tkb) { _context.ThoiKhoaBieux.Add(tkb); _context.SaveChanges(); return(tkb.MaTKB); }
public ActionResult CreateDetails(KhoaHocDetailsModels khoaHocDetails) { try { if (ModelState.IsValid) { // Create Data Access Object var _khoaHocDao = new KhoaHocDao(); var _tkbDao = new ThoiKhoaBieuDao(); var _danhMucDao = new DanhMucKhoaHocDao(); // Create Model var khoaHoc = new KhoaHoc(); var danhMuc = new DanhMucKhoaHoc(); var thoiKhoaBieu = new ThoiKhoaBieu(); // Thêm khóa học khoaHoc.TenKhoaHoc = khoaHocDetails.KhoaHoc.TenKhoaHoc; khoaHoc.SoLuong = khoaHocDetails.KhoaHoc.SoLuong; khoaHoc.TinhTrang = khoaHocDetails.KhoaHoc.TinhTrang; khoaHoc.GiaTien = khoaHocDetails.KhoaHoc.GiaTien; khoaHoc.MoTa = khoaHocDetails.KhoaHoc.MoTa; khoaHoc.LuaTuoiPhuHop = khoaHocDetails.KhoaHoc.LuaTuoiPhuHop; khoaHoc.MaDanhMuc = khoaHocDetails.MaDanhMuc; khoaHoc.MaGiaoVien = khoaHocDetails.MaGiaoVien; int idKH = _khoaHocDao.Insert(khoaHoc); //// Thêm thời khóa biểu thoiKhoaBieu.ThoiGianHoc = khoaHocDetails.ThoiGianHoc.ToString(); thoiKhoaBieu.ThuHai = khoaHocDetails.ThuHai; thoiKhoaBieu.ThuBa = khoaHocDetails.ThuBa; thoiKhoaBieu.ThuTu = khoaHocDetails.ThuTu; thoiKhoaBieu.ThuNam = khoaHocDetails.ThuNam; thoiKhoaBieu.ThuSau = khoaHocDetails.ThuSau; thoiKhoaBieu.ThuBay = khoaHocDetails.ThuBay; thoiKhoaBieu.ChuNhat = khoaHocDetails.ChuNhat; thoiKhoaBieu.MaKhoaHoc = idKH; int idTKB = _tkbDao.Insert(thoiKhoaBieu); if (idKH > 0 && idTKB > 0) { return(RedirectToAction("Index", "KhoaHoc")); } else { ModelState.AddModelError("", "Xảy ra lỗi khi thêm khóa học"); } SetViewBagKH(); SetViewBagGV(); return(View(khoaHoc)); } return(RedirectToAction("Index", "KhoaHoc")); } catch { return(View()); } }
public ActionResult DeleteConfirmed(ThoiKhoaBieu tkb) { contextTKB.Delete(tkb); return(RedirectToAction("Index")); }
//cập nhật thời khóa biểu public void UpdateThoiKhoaBieu(ThoiKhoaBieu tkb) { TKBIdao.UpdateThoiKhoaBieu(tkb); }
public ActionResult ManageSchedule1(int id, string username, string idmonhoc, string tenmonhoc) { try { var result = data.TKBs; if (id == 0) { var draw = HttpContext.Request.Form["draw"].FirstOrDefault(); // Skip number of Rows count var start = Request.Form["start"]; // Paging Length 10,20 var length = Request.Form["length"]; // Sort Column Name var sortColumn = Request.Form["columns[" + Request.Form["order[0][column]"].FirstOrDefault() + "][name]"]; // Sort Column Direction (asc, desc) var sortColumnDirection = Request.Form["order[0][dir]"]; // Search Value from (Search box) var searchValue = Request.Form["search[value]"]; //Paging Size(10, 20, 50,100) int pageSize = length != null?Convert.ToInt32(length) : 0; int skip = start != null?Convert.ToInt32(start) : 0; int recordsTotal = 0; if (idmonhoc == "" && tenmonhoc == "") { var customerData = result.Where(x => x.MAGIANGVIEN.Equals(username)); //total number of rows count recordsTotal = customerData.ToList().Count(); //Paging var kq = customerData.ToList().Skip(skip).Take(pageSize); var dssp = new List <ThoiKhoaBieu>(); foreach (var item in kq) { ThoiKhoaBieu sp = new ThoiKhoaBieu(); sp.id = item.ID.ToString(); sp.mamh = item.MAMH; sp.tenmh = item.MONHOC.TENMONHOC; sp.phong = item.PHONG; sp.lop = item.TENLOP; sp.ngaybatdau = item.NGAYBATDAU.ToString(); sp.ngayketthuc = item.NGAYKETHUC.ToString(); sp.cahoc = item.CA.ToString(); sp.thu = item.THU; sp.nhom = item.NHOM.ToString(); dssp.Add(sp); } //Returning Json Data return(Json(new { draw = draw, recordsFiltered = recordsTotal, recordsTotal = recordsTotal, data = dssp }, JsonRequestBehavior.AllowGet)); } else if (idmonhoc != "" && tenmonhoc == "") { var customerData = result.Where(x => x.MAGIANGVIEN.Equals(username) && x.MONHOC.IDMONHOC.Equals(idmonhoc)); //total number of rows count recordsTotal = customerData.ToList().Count(); //Paging var kq = customerData.ToList().Skip(skip).Take(pageSize); var dssp = new List <ThoiKhoaBieu>(); foreach (var item in kq) { ThoiKhoaBieu sp = new ThoiKhoaBieu(); sp.id = item.ID.ToString(); sp.mamh = item.MAMH; sp.tenmh = item.MONHOC.TENMONHOC; sp.phong = item.PHONG; sp.lop = item.TENLOP; sp.ngaybatdau = item.NGAYBATDAU.ToString(); sp.ngayketthuc = item.NGAYKETHUC.ToString(); sp.cahoc = item.CA.ToString(); sp.thu = item.THU; sp.nhom = item.NHOM.ToString(); dssp.Add(sp); } //Returning Json Data return(Json(new { draw = draw, recordsFiltered = recordsTotal, recordsTotal = recordsTotal, data = dssp }, JsonRequestBehavior.AllowGet)); } else if (idmonhoc == "" && tenmonhoc != "") { var customerData = result.Where(x => x.MAGIANGVIEN.Equals(username) && x.MONHOC.TENMONHOC.Equals(tenmonhoc)); //total number of rows count recordsTotal = customerData.ToList().Count(); //Paging var kq = customerData.ToList().Skip(skip).Take(pageSize); var dssp = new List <ThoiKhoaBieu>(); foreach (var item in kq) { ThoiKhoaBieu sp = new ThoiKhoaBieu(); sp.id = item.ID.ToString(); sp.mamh = item.MAMH; sp.tenmh = item.MONHOC.TENMONHOC; sp.phong = item.PHONG; sp.lop = item.TENLOP; sp.ngaybatdau = item.NGAYBATDAU.ToString(); sp.ngayketthuc = item.NGAYKETHUC.ToString(); sp.cahoc = item.CA.ToString(); sp.thu = item.THU; sp.nhom = item.NHOM.ToString(); dssp.Add(sp); } //Returning Json Data return(Json(new { draw = draw, recordsFiltered = recordsTotal, recordsTotal = recordsTotal, data = dssp }, JsonRequestBehavior.AllowGet)); } else { var customerData = result.Where(x => x.MAGIANGVIEN.Equals(username) && x.MONHOC.TENMONHOC.Equals(tenmonhoc) && x.MONHOC.IDMONHOC.Equals(tenmonhoc)); //total number of rows count recordsTotal = customerData.ToList().Count(); //Paging var kq = customerData.ToList().Skip(skip).Take(pageSize); var dssp = new List <ThoiKhoaBieu>(); foreach (var item in kq) { ThoiKhoaBieu sp = new ThoiKhoaBieu(); sp.id = item.ID.ToString(); sp.mamh = item.MAMH; sp.tenmh = item.MONHOC.TENMONHOC; sp.phong = item.PHONG; sp.lop = item.TENLOP; sp.ngaybatdau = item.NGAYBATDAU.ToString(); sp.ngayketthuc = item.NGAYKETHUC.ToString(); sp.cahoc = item.CA.ToString(); sp.thu = item.THU; sp.nhom = item.NHOM.ToString(); dssp.Add(sp); } //Returning Json Data return(Json(new { draw = draw, recordsFiltered = recordsTotal, recordsTotal = recordsTotal, data = dssp }, JsonRequestBehavior.AllowGet)); } } else { var draw = HttpContext.Request.Form["draw"].FirstOrDefault(); // Skip number of Rows count var start = Request.Form["start"]; // Paging Length 10,20 var length = Request.Form["length"]; // Sort Column Name var sortColumn = Request.Form["columns[" + Request.Form["order[0][column]"].FirstOrDefault() + "][name]"]; // Sort Column Direction (asc, desc) var sortColumnDirection = Request.Form["order[0][dir]"]; // Search Value from (Search box) var searchValue = Request.Form["search[value]"]; //Paging Size(10, 20, 50,100) int pageSize = length != null?Convert.ToInt32(length) : 0; int skip = start != null?Convert.ToInt32(start) : 0; int recordsTotal = 0; if (idmonhoc == "" && tenmonhoc == "") { var customerData = result.Where(x => x.MAGIANGVIEN.Equals(username)); //total number of rows count recordsTotal = customerData.ToList().Count(); //Paging var kq = customerData.ToList().Skip(skip).Take(pageSize); var dssp = new List <ThoiKhoaBieu>(); foreach (var item in kq) { ThoiKhoaBieu sp = new ThoiKhoaBieu(); sp.id = item.ID.ToString(); sp.mamh = item.MAMH; sp.tenmh = item.MONHOC.TENMONHOC; sp.phong = item.PHONG; sp.lop = item.TENLOP; sp.ngaybatdau = item.NGAYBATDAU.ToString(); sp.ngayketthuc = item.NGAYKETHUC.ToString(); sp.cahoc = item.CA.ToString(); sp.thu = item.THU; sp.nhom = item.NHOM.ToString(); dssp.Add(sp); } //Returning Json Data return(Json(new { draw = draw, recordsFiltered = recordsTotal, recordsTotal = recordsTotal, data = dssp }, JsonRequestBehavior.AllowGet)); } else if (idmonhoc != "" && tenmonhoc == "") { var customerData = result.Where(x => x.MAGIANGVIEN.Equals(username) && x.MONHOC.IDMONHOC.Equals(idmonhoc)); //total number of rows count recordsTotal = customerData.ToList().Count(); //Paging var kq = customerData.ToList().Skip(skip).Take(pageSize); var dssp = new List <ThoiKhoaBieu>(); foreach (var item in kq) { ThoiKhoaBieu sp = new ThoiKhoaBieu(); sp.id = item.ID.ToString(); sp.mamh = item.MAMH; sp.tenmh = item.MONHOC.TENMONHOC; sp.phong = item.PHONG; sp.lop = item.TENLOP; sp.ngaybatdau = item.NGAYBATDAU.ToString(); sp.ngayketthuc = item.NGAYKETHUC.ToString(); sp.cahoc = item.CA.ToString(); sp.thu = item.THU; sp.nhom = item.NHOM.ToString(); dssp.Add(sp); } //Returning Json Data return(Json(new { draw = draw, recordsFiltered = recordsTotal, recordsTotal = recordsTotal, data = dssp }, JsonRequestBehavior.AllowGet)); } else if (idmonhoc == "" && tenmonhoc != "") { var customerData = result.Where(x => x.MAGIANGVIEN.Equals(username) && x.MONHOC.TENMONHOC.Equals(tenmonhoc)); //total number of rows count recordsTotal = customerData.ToList().Count(); //Paging var kq = customerData.ToList().Skip(skip).Take(pageSize); var dssp = new List <ThoiKhoaBieu>(); foreach (var item in kq) { ThoiKhoaBieu sp = new ThoiKhoaBieu(); sp.id = item.ID.ToString(); sp.mamh = item.MAMH; sp.tenmh = item.MONHOC.TENMONHOC; sp.phong = item.PHONG; sp.lop = item.TENLOP; sp.ngaybatdau = item.NGAYBATDAU.ToString(); sp.ngayketthuc = item.NGAYKETHUC.ToString(); sp.cahoc = item.CA.ToString(); sp.thu = item.THU; sp.nhom = item.NHOM.ToString(); dssp.Add(sp); } //Returning Json Data return(Json(new { draw = draw, recordsFiltered = recordsTotal, recordsTotal = recordsTotal, data = dssp }, JsonRequestBehavior.AllowGet)); } else { var customerData = result.Where(x => x.MAGIANGVIEN.Equals(username) && x.MONHOC.TENMONHOC.Equals(tenmonhoc) && x.MONHOC.IDMONHOC.Equals(tenmonhoc)); //total number of rows count recordsTotal = customerData.ToList().Count(); //Paging var kq = customerData.ToList().Skip(skip).Take(pageSize); var dssp = new List <ThoiKhoaBieu>(); foreach (var item in kq) { ThoiKhoaBieu sp = new ThoiKhoaBieu(); sp.id = item.ID.ToString(); sp.mamh = item.MAMH; sp.tenmh = item.MONHOC.TENMONHOC; sp.phong = item.PHONG; sp.lop = item.TENLOP; sp.ngaybatdau = item.NGAYBATDAU.ToString(); sp.ngayketthuc = item.NGAYKETHUC.ToString(); sp.cahoc = item.CA.ToString(); sp.thu = item.THU; sp.nhom = item.NHOM.ToString(); dssp.Add(sp); } //Returning Json Data return(Json(new { draw = draw, recordsFiltered = recordsTotal, recordsTotal = recordsTotal, data = dssp }, JsonRequestBehavior.AllowGet)); } } } catch (Exception ex) { throw; } }
//hiện dữ liệu lên các field public void ShowDataToField() { thoiGianHoc = dgvDanhSachTKB.CurrentRow.Cells[7].Value.ToString(); cboChonNgayHoc_TKB.Text = dgvDanhSachTKB.CurrentRow.Cells[1].Value.ToString(); dtpStartDay.DataBindings.Clear(); dtpStartDay.DataBindings.Add("text", dgvDanhSachTKB.DataSource, "NgayBatDau"); dtpEndDay.DataBindings.Clear(); dtpEndDay.DataBindings.Add("text", dgvDanhSachTKB.DataSource, "NgayKetThuc"); //môn học MonHoc mh = new MonHoc(); mh = monHocService.GetMonHocByMaMonHoc(dgvDanhSachTKB.CurrentRow.Cells[2].Value.ToString()); cboChonMonHoc_TKB.Text = mh.TenMonHoc; //giảng viên GiangVien gv = new GiangVien(); gv = giangVienService.GetGiangVienByMaGV(dgvDanhSachTKB.CurrentRow.Cells[5].Value.ToString()); cboChonGV_TKB.Text = gv.TenGV; //phòng học ThoiKhoaBieu tkb = new ThoiKhoaBieu(); tkb = thoiKhoaBieuService.GetThoiKhoaBieuByMaLopMaMonHoc(maLop, dgvDanhSachTKB.CurrentRow.Cells[2].Value.ToString().Trim()); cboChonPhongHoc_TKB.Text = tkb.MaPhongHoc; //ngày học(thứ) switch (dgvDanhSachTKB.CurrentRow.Cells[1].Value.ToString().Trim()) { case "Thứ 2": cboChonNgayHoc_TKB.Text = "Thứ 2"; break; case "Thứ 3": cboChonNgayHoc_TKB.Text = "Thứ 3"; break; case "Thứ 4": cboChonNgayHoc_TKB.Text = "Thứ 4"; break; case "Thứ 5": cboChonNgayHoc_TKB.Text = "Thứ 5"; break; case "Thứ 6": cboChonNgayHoc_TKB.Text = "Thứ 6"; break; case "Thứ 7": cboChonNgayHoc_TKB.Text = "Thứ 7"; break; case "Chủ NHật": cboChonNgayHoc_TKB.Text = "Chủ NHật"; break; default: cboChonNgayHoc_TKB.Text = "Lỗi Hiển Thị..(-__-) ! !"; break; } //thời gian học switch (tkb.ThoiGianHoc) { case "Ca 1": chkCa1.Checked = true; chkCa2.Checked = false; chkCa3.Checked = false; chkCa4.Checked = false; break; case "Ca 2": chkCa1.Checked = false; chkCa2.Checked = true; chkCa3.Checked = false; chkCa4.Checked = false; break; case "Ca 3": chkCa1.Checked = false; chkCa2.Checked = false; chkCa3.Checked = true; chkCa4.Checked = false; break; case "Ca 4": chkCa1.Checked = false; chkCa2.Checked = false; chkCa3.Checked = false; chkCa4.Checked = true; break; case "Ca 1, Ca 2": chkCa1.Checked = true; chkCa2.Checked = true; chkCa3.Checked = false; chkCa4.Checked = false; break; case "Ca 1, Ca 3": chkCa1.Checked = true; chkCa2.Checked = false; chkCa3.Checked = true; chkCa4.Checked = false; break; case "Ca 1, Ca 4": chkCa1.Checked = true; chkCa2.Checked = false; chkCa3.Checked = false; chkCa4.Checked = true; break; case "Ca 1, Ca 2, Ca 3": chkCa1.Checked = true; chkCa2.Checked = true; chkCa3.Checked = true; chkCa4.Checked = false; break; case "Ca 1, Ca 2, Ca 4": chkCa1.Checked = true; chkCa2.Checked = true; chkCa3.Checked = false; chkCa4.Checked = true; break; case "Ca 1, Ca 3, Ca 4": chkCa1.Checked = true; chkCa2.Checked = false; chkCa3.Checked = true; chkCa4.Checked = true; break; case "Ca 1, Ca 2, Ca 3, Ca 4": chkCa1.Checked = true; chkCa2.Checked = true; chkCa3.Checked = true; chkCa4.Checked = true; break; case "Ca 2, Ca 3": chkCa1.Checked = false; chkCa2.Checked = true; chkCa3.Checked = true; chkCa4.Checked = false; break; case "Ca 2, Ca 4": chkCa1.Checked = false; chkCa2.Checked = true; chkCa3.Checked = false; chkCa4.Checked = true; break; case "Ca 2, Ca 3, Ca 4": chkCa1.Checked = false; chkCa2.Checked = true; chkCa3.Checked = true; chkCa4.Checked = true; break; case "Ca 3, Ca 4": chkCa1.Checked = false; chkCa2.Checked = false; chkCa3.Checked = true; chkCa4.Checked = true; break; } }