public async Task <IHttpActionResult> CreateDiemDanh(string MaUser)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
DateTime date = new DateTime();
date = DateTime.Now;
string buoi = date.Hour < 12 ? "sa" : "ch";
var dk = db.DuKienTTs.FirstOrDefault(x => x.Ngay == date.Day.ToString() && x.Thang == date.Month.ToString() && x.MaUser == MaUser);
string ma = "DD_" + dk.MaDuKien + "_" + date.Day.ToString() + date.Month.ToString() + "_" + buoi.ToUpper();
if (db.DiemDanhs.FirstOrDefault(x => x.MaDD == ma) == null)
{
DiemDanh dd = new DiemDanh();
dd.MaDD = ma;
dd.MaDuKien = dk.MaDuKien;
dd.Ngay = date;
dd.Buoi = buoi;
db.DiemDanhs.Add(dd);
await db.SaveChangesAsync();
return(Ok(new { Code = 200 }));
}
else
{
return(Ok(new { Code = 201 }));
}
}
public async Task <IActionResult> Edit(int id, [Bind("MaDD,Thang,Tuan,TenNV,T2,T3,T4,T5,T6")] DiemDanh diemDanh)
{
if (id != diemDanh.MaDD)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(diemDanh);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!DiemDanhExists(diemDanh.MaDD))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(diemDanh));
}
public ActionResult DeleteConfirmed(int id)
{
DiemDanh diemdanh = db.DiemDanhs.Find(id);
db.DiemDanhs.Remove(diemdanh);
db.SaveChanges();
return(RedirectToAction("Index"));
}
//
// GET: /DiemDanh/Details/5
public ActionResult Details(int id = 0)
{
DiemDanh diemdanh = db.DiemDanhs.Find(id);
if (diemdanh == null)
{
return(HttpNotFound());
}
return(View(diemdanh));
}
public IActionResult DiemDanhNhanVien(LayDiemDanhNhanVienId model)
{
var url = $"{Common.Common.ApiUrl}/quanly/LayDiemDanhNhanVienId";
var responseData = GetMethod(url, model);
var diemDanh = new DiemDanh();
diemDanh = JsonConvert.DeserializeObject <DiemDanh>(responseData);
return(View(diemDanh));
}
public DiemDanh getTableDIEMDANHByIdMaHocPhan(String id, String mahp)
{
DiemDanh result = new DiemDanh();
DataTable dt = new DataTable();
String strSqlDuLieuChuan = string.Format(@"EXEC getListDIEMDANHByMASINHVIENMaHocPhan '{0}', '{1}'", id, mahp);
dt = DataProvider.Instance.LoadAllTable(strSqlDuLieuChuan);
result = new DiemDanh(dt.Rows[0]);
return(result);
}
public ActionResult Edit([Bind(Include = "MaPhieuDD,Ngay,Buoi,MaSV,MaLopTC")] DiemDanh diemDanh)
{
if (ModelState.IsValid)
{
contextDiemDanh.Edit(diemDanh);
return(RedirectToAction("Index"));
}
ViewBag.MaLopTC = new SelectList(contextLopTC.GetAll(), "MaLopTC", "NienKhoa", diemDanh.MaLopTC);
ViewBag.MaSV = new SelectList(contextSinhVien.GetAll(), "MaSV", "HoVaTenLot", diemDanh.MaSV);
return(View(diemDanh));
}
/// <summary>
/// Tạo mới 1 record
/// </summary>
/// <param name="dd">Điểm danh</param>
public void Create(DiemDanh dd)
{
try
{
context.Create(dd);
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
}
public async Task <IActionResult> Create([Bind("MaDD,Thang,Tuan,TenNV,T2,T3,T4,T5,T6")] DiemDanh diemDanh)
{
if (ModelState.IsValid)
{
_context.Add(diemDanh);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(diemDanh));
}
public IActionResult DiemDanhNhanVienAjax([FromBody] LayDiemDanhNhanVienId model)
{
var url = $"{Common.Common.ApiUrl}/quanly/LayDiemDanhNhanVienId";
var responseData = GetMethod(url, model);
var diemDanh = new DiemDanh();
diemDanh = JsonConvert.DeserializeObject <DiemDanh>(responseData);
return(Json(new { response = diemDanh, code = 1 }));
}
public ActionResult Ed(string bhoc)
{
string maGV = Session["MaGV"] as string;
string maKh = Session["MaKH"] as string;
// Tao buoi hoc
int bh = taobuoi(maKh);
//---------------------------
var Fch = Request.Form.AllKeys.Where(k => k != "bhoc");
//string day = DateTime.Now.DayOfWeek.ToString();
//var query = (from pro in db.BangBuoiHocs where pro.maKH == maKh && pro.day == day select pro.maBH).FirstOrDefault();
string date = DateTime.Now.ToString("yyyy/MM/dd");
string time = DateTime.Now.ToString("HH:mm:ss");
//CreateSessionID create = new CreateSessionID();
//int getID = (create.GetLastID("DiemDanh", "sessionID", maKh) + 1);
foreach (var fea in Fch)
{
try
{
if (fea.Trim().Length == 7)
{
DiemDanh dd = new DiemDanh();
bool stt = Request.Form[fea.Trim()] != "false";
dd.ID_BuoiHoc = bh;
dd.MSSV = fea.Trim();
dd.status = stt;
db.DiemDanhs.Add(dd);
db.SaveChanges();
}
}
catch (Exception)
{
}
}
//var monhoc = connect.TestCourse(maGV);
var idbt = db.BuoiHocs.Where(x => x.ID_BH == bh).FirstOrDefault();
string ids = idbt.Buoi_thu.ToString();
//ViewBag.Subject = monhoc;
return(RedirectToAction("ListDiemDanh", new RouteValueDictionary(
new { controller = "Course", action = "ListDiemDanh", id = ids })));
//return View();
}
public ActionResult Attendance(string id)
{
Session["maKH"] = id;
var bhoc = db.BangBuoiHocs.Where(b => b.maKH == id).ToList();
var svien = db.SinhViens.Where(v => v.maKH == id).ToList();
var max = db.DiemDanhs.Where(m => m.MaKH == id).Max(x => x.sessionID) + 1;
Session["ss"] = max;
// xử lí lưu vào bang điểm danh
foreach (var bh in bhoc)
{
foreach (var sv in svien)
{
DiemDanh atten = new DiemDanh();
atten.maBH = bh.maBH;
atten.MaKH = id;
atten.MSSV = sv.MSSV;
if (max == 0 || max == null)
{
atten.sessionID = 1;
}
else
{
atten.sessionID = max;
}
atten.Date = DateTime.Now.Date;
atten.Time = TimeSpan.Parse(DateTime.Now.ToString("HH:mm:ss"));
atten.diemDanh1 = false;
db.DiemDanhs.Add(atten);
db.SaveChanges();
}
}
string maGV = Session["MaGV"] as string;
var monhoc = db.MonHocs.Where(mh => mh.GiangViens.Count(gv => gv.maGV == maGV) > 0).ToList();
var sinhvien = db.SinhViens.Where(sv => sv.maKH == id).ToList();
var buoihoc = db.BangBuoiHocs.Where(bh => bh.maKH == id).ToList();
var mabuoihoc = buoihoc.Select(mh => mh.maBH).ToArray();
string mbh = mabuoihoc[0];
var diemdanh = db.DiemDanhs.Where(dd => dd.maBH == mbh);
ViewBag.Student = sinhvien;
ViewBag.Diemdanh = diemdanh.ToList();
ViewBag.CountStudent = sinhvien.Count();
ViewBag.Buoihoc = buoihoc;
ViewBag.Subject = monhoc;
ViewBag.MaKH = id;
return(View());
}
public ActionResult Edit(DiemDanh diemdanh)
{
if (ModelState.IsValid)
{
db.Entry(diemdanh).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("EditDiemDanh", new { id = diemdanh.IdBuoiHoc }));
}
ViewBag.IdBuoiHoc = new SelectList(db.BuoiHocs, "IdBuoiHoc", "IdBuoiHoc", diemdanh.IdBuoiHoc);
ViewBag.IdNguoiDung = new SelectList(db.NguoiDungs, "IdNguoiDung", "DuongDanAnh", diemdanh.IdNguoiDung);
ViewBag.IdTinhTrangDiHoc = new SelectList(db.TinhTrangDiHocs, "IdTinhTrangDiHoc", "NoiDung", diemdanh.IdTinhTrangDiHoc);
return(RedirectToAction("EditDiemDanh", new { id = diemdanh.IdBuoiHoc }));
}
/// <summary>
/// Lấy 1 record dựa vào mã phiếu điểm danh
/// </summary>
/// <param name="maPDD"></param>
/// <returns>Khoa</returns>
public DiemDanh GetById(string maPDD)
{
try
{
DiemDanh dd = context.GetById(maPDD);
return(dd);
}
catch (Exception ex)
{
Console.WriteLine(ex);
return(null);
}
}
public ActionResult Create(DiemDanh diemdanh)
{
if (ModelState.IsValid)
{
db.DiemDanhs.Add(diemdanh);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.IdBuoiHoc = new SelectList(db.BuoiHocs, "IdBuoiHoc", "IdBuoiHoc", diemdanh.IdBuoiHoc);
ViewBag.IdNguoiDung = new SelectList(db.NguoiDungs, "IdNguoiDung", "DuongDanAnh", diemdanh.IdNguoiDung);
ViewBag.IdTinhTrangDiHoc = new SelectList(db.TinhTrangDiHocs, "IdTinhTrangDiHoc", "NoiDung", diemdanh.IdTinhTrangDiHoc);
return(View(diemdanh));
}
public ActionResult Details(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
DiemDanh diemDanh = contextDiemDanh.GetById(id);
if (diemDanh == null)
{
return(HttpNotFound());
}
return(View(diemDanh));
}
/// <summary>
/// Chỉnh sửa 1 record
/// </summary>
/// <param name="dd">Điểm danh</param>
public void Edit(DiemDanh dd)
{
if (dd == null)
{
return;
}
try
{
context.Edit(dd);
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
}
//
// GET: /DiemDanh/Edit/5
public ActionResult Edit(int idbuoihoc = 0, int idnguoidung = 0)
{
DiemDanh diemdanh = (DiemDanh)(from d in db.DiemDanhs
where d.IdBuoiHoc == idbuoihoc && d.IdNguoiDung == idnguoidung
select d).First();
if (diemdanh == null)
{
return(HttpNotFound());
}
ViewBag.IdBuoiHoc = new SelectList(db.BuoiHocs, "IdBuoiHoc", "IdBuoiHoc", diemdanh.IdBuoiHoc);
ViewBag.IdNguoiDung = new SelectList(db.NguoiDungs, "IdNguoiDung", "DuongDanAnh", diemdanh.IdNguoiDung);
ViewBag.IdTinhTrangDiHoc = new SelectList(db.TinhTrangDiHocs, "IdTinhTrangDiHoc", "NoiDung", diemdanh.IdTinhTrangDiHoc);
return(View(diemdanh));
}
public void _Vang(object parameter)
{
using (var db = new QuanLyPhanBonEntities())
{
DiemDanh diemDanh = new DiemDanh();
diemDanh.isCoMat = false;
diemDanh.isVang = true;
diemDanh.NgayLam = DateTime.Now;
diemDanh.NhanVien = _SelectedNhanVien.IDNhanVien;
db.DiemDanhs.Add(diemDanh);
_ListNhanVien.Remove(_SelectedNhanVien);
OnPropertyChanged("ListNhanVien");
db.SaveChanges();
}
}
public ActionResult Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
DiemDanh diemDanh = contextDiemDanh.GetById(id);
if (diemDanh == null)
{
return(HttpNotFound());
}
ViewBag.MaLopTC = new SelectList(contextLopTC.GetAll(), "MaLopTC", "NienKhoa", diemDanh.MaLopTC);
ViewBag.MaSV = new SelectList(contextSinhVien.GetAll(), "MaSV", "HoVaTenLot", diemDanh.MaSV);
return(View(diemDanh));
}
public ActionResult DanhSachDiemDanh(int idsv, int idlhp)
{
DiemDanhService a = new DiemDanhService();
SinhVienService b = new SinhVienService();
LopHocPhanService c = new LopHocPhanService();
List <DiemDanh> lst = new List <DiemDanh>();
foreach (var item in a.GetbyIDSV(idsv, idlhp))
{
DiemDanh m = new DiemDanh();
m = item;
lst.Add(m);
}
ViewBag.ten = b.getById(idsv).tenSinhVien;
ViewBag.mon = c.getById(idlhp).tenLopHocPhan;
return(View(lst));
}
public ActionResult DiemDanhCf(int idsv, int idlhp, int tt)
{
DiemDanhService a = new DiemDanhService();
KetQuaHocTapService aa = new KetQuaHocTapService();
DiemDanh dd = new DiemDanh();
dd.kqhtID = aa.getIDkqht(idsv, idlhp);
if (tt == 0)
{
dd.tragthai = ComMon_BaiTapLon.EnumsHelper.TrangThaiDD.CoMat;
}
else
{
dd.tragthai = ComMon_BaiTapLon.EnumsHelper.TrangThaiDD.Vang;
}
dd.ngayDD = DateTime.Now;
var temp = a.GetbyIDSV(idsv, idlhp).Where(x => x.ngayDD.Day == dd.ngayDD.Day && x.ngayDD.Month == dd.ngayDD.Month && x.ngayDD.Year == dd.ngayDD.Year).FirstOrDefault();
if (temp != null)
{
if (dd.tragthai == ComMon_BaiTapLon.EnumsHelper.TrangThaiDD.CoMat)
{
TempData["tb"] = "Hom nay da diem danh";
}
else if (dd.tragthai == ComMon_BaiTapLon.EnumsHelper.TrangThaiDD.Vang)
{
TempData["tb"] = "Hom nay da bi vang";
}
}
else
{
a.Add(dd);
if (dd.tragthai == ComMon_BaiTapLon.EnumsHelper.TrangThaiDD.CoMat)
{
TempData["tb"] = "Diem danh thanh cong";
}
else if (dd.tragthai == ComMon_BaiTapLon.EnumsHelper.TrangThaiDD.Vang)
{
TempData["tb"] = "Sinh vien da duoc danh vang";
}
}
return(RedirectToAction("DiemDanh", new { id = idlhp }));
}
public ActionResult DiemDanhthucong(string makh) // id truyen ma khoa hoc dang chon
{
int ids = taobuoi(makh);
var list = db.ThamDus.Where(x => x.MaKH == makh).ToList();
foreach (var dd in list)
{
// var makh
DiemDanh ddanh = new DiemDanh();
ddanh.MSSV = dd.MSSV;
ddanh.status = false;
ddanh.ID_BuoiHoc = ids;
db.DiemDanhs.Add(ddanh);
db.SaveChanges();
// db.Dispose();
}
return(View(list));
}
//
// GET: /DanhSach/DiemDanhMoi
public ActionResult DiemDanhMoi()
{
int IdDiHoc = 1; // idtinhtrangdihoc = đi học
List <SelectListItem> ListTrangThai = new List <SelectListItem>();
List <DiemDanh> ListDiemDanh = new List <DiemDanh>();
if (Session["LopMonHocCurrent"] != null)
{
int IdLopMonHoc = ((LopMonHoc)Session["LopMonHocCurrent"]).IdLopMonHoc;
LopMonHoc LopMonHocCurrent = (LopMonHoc)((from t in db.LopMonHocs
where t.IdLopMonHoc == IdLopMonHoc
select t).ToList().First());
List <NguoiDung> ListSinhVienTrongLop = (List <NguoiDung>)((from t in db.DanhSaches
where t.IdLopMonHoc == IdLopMonHoc
select t.NguoiDung).ToList());
foreach (NguoiDung n in ListSinhVienTrongLop)
{
DiemDanh NewDiemDanh = new DiemDanh();
NewDiemDanh.NguoiDung = n;
NewDiemDanh.IdNguoiDung = n.IdNguoiDung;
TinhTrangDiHoc TinhTrangDiHoc = (TinhTrangDiHoc)(from t in db.TinhTrangDiHocs
where IdDiHoc == t.IdTinhTrangDiHoc
select t).ToList().First();
NewDiemDanh.TinhTrangDiHoc = TinhTrangDiHoc;
NewDiemDanh.IdTinhTrangDiHoc = IdDiHoc;
ListDiemDanh.Add(NewDiemDanh);
}
}
else
{
// chưa chọn lớp môn học
}
ViewBag.DanhSach = ListDiemDanh;
ViewBag.ListTrangThai = new SelectList(db.TinhTrangDiHocs, "IdTinhTrangDiHoc", "NoiDung", IdDiHoc);
return(View(ListDiemDanh));
}
protected void btnCaphat_Click(object sender, EventArgs e)
{
Dangkyhoc dkh = new Dangkyhoc();
dkh.MaMon = DrMaHP.SelectedValue.ToString();
dkh.Mssv = txtMasv.Text;
db.Dangkyhocs.InsertOnSubmit(dkh);
db.SubmitChanges();
DrMaHP_SelectedIndexChanged(sender, e);
mymodal.Visible = false;
int rowclass = GridView1.Rows.Count - 1;
string mdk = GridView1.Rows[rowclass].Cells[7].Text;
DiemDanh dd = new DiemDanh();
dd.MaDK = Convert.ToInt32(mdk);
dd.Buoi = 1;
db.DiemDanhs.InsertOnSubmit(dd);
db.SubmitChanges();
}
public ActionResult Edit(string bhocc)
{
string maGV = Session["MaGV"] as string;
string maKh = Session["MaKH"] as string;
var Fch = Request.Form.AllKeys.Where(k => k != "bhocc");
string day = DateTime.Now.DayOfWeek.ToString();
var query = (from pro in db.DiemDanhs where pro.MaKH == maKh select pro).ToList();
ViewBag.Date = query;
//var query = (from pro in db.BangBuoiHocs where pro.maKH == maKh select pro.maBH).FirstOrDefault();
string date = DateTime.Now.ToString("yyyy/MM/dd");
string time = DateTime.Now.ToString("HH:mm:ss");
CreateSessionID create = new CreateSessionID();
int getID = int.Parse(Session["SessionID"].ToString());
DiemDanh push = null;
foreach (var fea in Fch)
{
{
string x = Request.Form[fea.Trim()];
var diemDanh1 = Request.Form[fea.Trim()] != "false";
conn = ut.OpenDb();
conn.Open();
cmd = new SqlCommand("select *from DiemDanh", conn);
cmd.CommandType = CommandType.Text;
cmd.CommandText = "update DiemDanh set diemDanh = '" + diemDanh1 + "' Where MSSV = '" + fea.Trim() + "' and MaKH = '" + maKh + "' and sessionID = '" + getID + "'";
//values('" + query + "',N'" + maKh + "',N'" + fea.Trim().ToString() + "','" + date + "','" + time + "','" + diemDanh1 + "','" + getID + "')";
cmd.ExecuteNonQuery();
cmd.Dispose();
}
}
return(RedirectToAction("Course", "Home", new { id = Session["MaKH"].ToString() }));
}
public ArrayList addArray(DiemDanh dd)
{
ArrayList arl = new ArrayList();
arl.Add((dd.Tuan_1) != null ? dd.Tuan_1 : "");
arl.Add((dd.Tuan_2) != null ? dd.Tuan_2 : "");
arl.Add((dd.Tuan_3) != null ? dd.Tuan_3 : "");
arl.Add((dd.Tuan_4) != null ? dd.Tuan_4 : "");
arl.Add((dd.Tuan_5) != null ? dd.Tuan_5 : "");
arl.Add((dd.Tuan_6) != null ? dd.Tuan_6 : "");
arl.Add((dd.Tuan_7) != null ? dd.Tuan_7 : "");
arl.Add((dd.Tuan_8) != null ? dd.Tuan_8 : "");
arl.Add((dd.Tuan_9) != null ? dd.Tuan_9 : "");
arl.Add((dd.Tuan_10) != null ? dd.Tuan_10 : "");
arl.Add((dd.Tuan_11) != null ? dd.Tuan_11 : "");
arl.Add((dd.Tuan_12) != null ? dd.Tuan_12 : "");
arl.Add((dd.Tuan_13) != null ? dd.Tuan_13 : "");
arl.Add((dd.Tuan_14) != null ? dd.Tuan_14 : "");
arl.Add((dd.Tuan_15) != null ? dd.Tuan_15 : "");
arl.Add((dd.Tuan_16) != null ? dd.Tuan_16 : "");
arl.Add((dd.Tuan_17) != null ? dd.Tuan_17 : "");
return(arl);
}
public DiemDanh Add(DiemDanh dd)
{
return(diemdanhrepository.Add(dd));
}
public ActionResult BrowseDanhSach(FormCollection formCollection)
{
if (Request != null)
{
HttpPostedFileBase file = Request.Files["UploadedDanhSach"];
if ((file != null) && (file.ContentLength > 0) && !string.IsNullOrEmpty(file.FileName))
{
string fileName = file.FileName;
string fileContentType = file.ContentType;
byte[] fileBytes = new byte[file.ContentLength];
var data = file.InputStream.Read(fileBytes, 0, Convert.ToInt32(file.ContentLength));
// Khai báo biến
if (Session["LopMonHocCurrent"] != null)
{
int IdLopMonHocCurrent = ((LopMonHoc)Session["LopMonHocCurrent"]).IdLopMonHoc;
List <DanhSach> ListDanhSachThanhCong = new List <DanhSach>();
List <DanhSachThemThatBai> ListDanhSachThatBai = new List <DanhSachThemThatBai>();
string MaSinhVienFromFile = "";
using (var package = new ExcelPackage(file.InputStream))
{
var currentSheet = package.Workbook.Worksheets;
var workSheet = currentSheet.First();
var noOfCol = workSheet.Dimension.End.Column;
var noOfRow = workSheet.Dimension.End.Row;
for (int rowIterator = 2; rowIterator <= noOfRow; rowIterator++)
{
DanhSach DanhSach = new DanhSach();
DanhSach.IdLopMonHoc = IdLopMonHocCurrent;
MaSinhVienFromFile = workSheet.Cells[rowIterator, 2].Value.ToString();
if (KiemTraTonTaiNguoiDung(MaSinhVienFromFile))
{
DanhSach.IdNguoiDung = (from t in db.NguoiDungs
where t.UserName == MaSinhVienFromFile
select t.IdNguoiDung).ToList().First();
if (KiemTraLaSinhVien(DanhSach.IdNguoiDung))
{
if (false == KiemTraDanhSachTrung(DanhSach.IdLopMonHoc, DanhSach.IdNguoiDung))
{
db.DanhSaches.Add(DanhSach);
db.SaveChanges();
ListDanhSachThanhCong.Add(DanhSach);
// Nếu lớp này đã bắt đầu và có buổi điểm danh
var LopCurrent = db.LopMonHocs.Find(((LopMonHoc)Session["LopMonHocCurrent"]).IdLopMonHoc);
if (LopCurrent.BuoiHocs.Count() > 0)
{
// Thì với mỗi buổi học đã điểm danh,
// Gán cho sinh viên này tình trạng nghỉ có phép và ghi chú là nhập học muộn
foreach (var buoihoc in LopCurrent.BuoiHocs)
{
DiemDanh newDiemDanh = new DiemDanh();
newDiemDanh.IdBuoiHoc = buoihoc.IdBuoiHoc;
newDiemDanh.IdNguoiDung = DanhSach.IdNguoiDung;
newDiemDanh.IdTinhTrangDiHoc = 3; //3 = nghỉ có phép
newDiemDanh.NhanXet = "Đăng ký vào lớp muộn";
db.DiemDanhs.Add(newDiemDanh);
db.SaveChanges();
}
}
}
else
{
// sinh viên đã có trong lớp học
DanhSachThemThatBai BanGhiThatBai = new DanhSachThemThatBai();
BanGhiThatBai.MaNguoiDung = workSheet.Cells[rowIterator, 2].Value.ToString();
BanGhiThatBai.MoTa = "đã có trong lớp học";
ListDanhSachThatBai.Add(BanGhiThatBai);
}
}
else
{
// nếu không phải là sinh viên
DanhSachThemThatBai BanGhiThatBai = new DanhSachThemThatBai();
BanGhiThatBai.MaNguoiDung = workSheet.Cells[rowIterator, 2].Value.ToString();
BanGhiThatBai.MoTa = "không phải là sinh viên";
ListDanhSachThatBai.Add(BanGhiThatBai);
}
}
else
{
// nếu người dùng k tồn tại
DanhSachThemThatBai BanGhiThatBai = new DanhSachThemThatBai();
BanGhiThatBai.MaNguoiDung = workSheet.Cells[rowIterator, 2].Value.ToString();
BanGhiThatBai.MoTa = "không tồn tại";
ListDanhSachThatBai.Add(BanGhiThatBai);
}
}
}
Session["ListDanhSachThanhCong"] = ListDanhSachThanhCong;
Session["ListDanhSachThatBai"] = ListDanhSachThatBai;
return(RedirectToAction("KetQuaThemVaoDanhSach", new
{
ListDanhSachThanhCong = ListDanhSachThanhCong,
ListDanhSachThatBai = ListDanhSachThatBai
}));
}
else
{
// Chưa chọn lớp môn học
}
}
}
return(View("BrowseDanhSach"));
}
//
// GET: /YeuCauThamGia/Accept
public ActionResult Accept(int id = 0)
{
LopMonHoc LopMonHocCurrent = (LopMonHoc)Session["LopMonHocCurrent"];
DanhSachController DanhSachCon = new DanhSachController();
YeuCauThamGia yeucauthamgia = db.YeuCauThamGias.Find(id);
DanhSach newDanhSach = new DanhSach();
// dummydata
newDanhSach.IdLopMonHoc = LopMonHocCurrent.IdLopMonHoc;
if (DanhSachCon.KiemTraTonTaiNguoiDung(yeucauthamgia.NguoiDung.UserName))
{
newDanhSach.IdNguoiDung = yeucauthamgia.IdNguoiDung;
if (DanhSachCon.KiemTraLaSinhVien(yeucauthamgia.IdNguoiDung))
{
if (false == DanhSachCon.KiemTraDanhSachTrung(newDanhSach.IdLopMonHoc, newDanhSach.IdNguoiDung))
{
db.DanhSaches.Add(newDanhSach);
db.SaveChanges();
TempData["Message"] = "Sinh viên '"
+ yeucauthamgia.NguoiDung.HoTen
+ "-"
+ yeucauthamgia.NguoiDung.UserName
+ "' đã được thêm vào lớp thành công";
// Nếu lớp này đã bắt đầu và có buổi điểm danh
var LopCurrent = db.LopMonHocs.Find(((LopMonHoc)Session["LopMonHocCurrent"]).IdLopMonHoc);
if (LopCurrent.BuoiHocs.Count() > 0)
{
// Thì với mỗi buổi học đã điểm danh,
// Gán cho sinh viên này tình trạng nghỉ có phép và ghi chú là nhập học muộn
foreach (var buoihoc in LopCurrent.BuoiHocs)
{
DiemDanh newDiemDanh = new DiemDanh();
newDiemDanh.IdBuoiHoc = buoihoc.IdBuoiHoc;
newDiemDanh.IdNguoiDung = newDanhSach.IdNguoiDung;
newDiemDanh.IdTinhTrangDiHoc = 3; //3 = nghỉ có phép
newDiemDanh.NhanXet = "Đăng ký vào lớp muộn";
db.DiemDanhs.Add(newDiemDanh);
db.SaveChanges();
}
}
}
else
{
// sinh viên đã có trong lớp học
DanhSachThemThatBai BanGhiThatBai = new DanhSachThemThatBai();
BanGhiThatBai.MaNguoiDung = yeucauthamgia.NguoiDung.UserName;
TempData["Message"] = "Sinh viên "
+ yeucauthamgia.NguoiDung.HoTen
+ "-"
+ yeucauthamgia.NguoiDung.UserName
+ " đã có trong lớp học";
}
}
else
{
// nếu không phải là sinh viên
DanhSachThemThatBai BanGhiThatBai = new DanhSachThemThatBai();
BanGhiThatBai.MaNguoiDung = yeucauthamgia.NguoiDung.UserName;
TempData["Message"] = "Sinh viên "
+ yeucauthamgia.NguoiDung.HoTen
+ "-"
+ yeucauthamgia.NguoiDung.UserName
+ " không phải là sinh viên";
}
}
else
{
// nếu người dùng k tồn tại
DanhSachThemThatBai BanGhiThatBai = new DanhSachThemThatBai();
BanGhiThatBai.MaNguoiDung = yeucauthamgia.NguoiDung.UserName;
TempData["Message"] = "Sinh viên "
+ yeucauthamgia.NguoiDung.HoTen
+ "-"
+ yeucauthamgia.NguoiDung.UserName
+ " không tồn tại";
}
db.YeuCauThamGias.Remove(yeucauthamgia);
db.SaveChanges();
int YeuCauCount = (from y in db.YeuCauThamGias
where y.IdLopMonHoc == LopMonHocCurrent.IdLopMonHoc
select y).Count();
Session["YeuCauCount"] = YeuCauCount;
return(RedirectToAction("Index"));
}
