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;
}
}
