// danh sach sinh vien vaf danh sach bang tham du public ActionResult ListStudent(string id) { // ReturnmaKH(id); // int ID = int.Parse(id); var model = db.ThamDus.Where(x => x.MaKH == id); if (model.Count() == 0) { var data = api.GetMember(id); foreach (var item in data) { SinhVien nStudent = new SinhVien(); nStudent.MSSV = item.id; nStudent.Birthday = Convert.ToDateTime(item.birthday); nStudent.FullName = item.fullname; nStudent.LastName = item.lastname; nStudent.FirstName = item.firstname; db.SinhViens.Add(nStudent); ThamDu nThamDu = new ThamDu(); nThamDu.MSSV = item.id; nThamDu.MaKH = id; db.ThamDus.Add(nThamDu); db.SaveChanges(); } model = db.ThamDus.Where(x => x.MaKH == id); } ViewBag.ID = id; return(View(model)); }
// danh sach sinh vien vaf danh sach bang tham du public ActionResult ListStudent(string id) { Session["MaKH"] = id; // ReturnmaKH(id); // int ID = int.Parse(id); // var model = db.ThamDus.Where(x => x.MaKH == id); var data = api.GetMember(id); foreach (var item in data) { if (db.SinhViens.Where(x => x.MSSV == item.id).Count() == 0) { SinhVien nStudent = new SinhVien(); nStudent.MSSV = item.id; nStudent.Birthday = Convert.ToDateTime(item.birthday); nStudent.FullName = item.fullname; nStudent.LastName = item.lastname; nStudent.FirstName = item.firstname; db.SinhViens.Add(nStudent); db.SaveChanges(); } if (db.ThamDus.Where(x => x.MSSV == item.id && x.MaKH == id).Count() == 0) { ThamDu nThamDus = new ThamDu(); nThamDus.MSSV = item.id; nThamDus.MaKH = id; db.ThamDus.Add(nThamDus); db.SaveChanges(); } } ViewBag.ID = id; var masva = db.ThamDus.Where(x => x.MaKH == id); var mssv = masva.Select(p => p.MSSV); List <SinhVien> list = new List <SinhVien>(); foreach (var item in mssv) { var sv = db.SinhViens.FirstOrDefault(x => x.MSSV == item); list.Add(sv); } return(View(list)); }
// sync Members to API public async System.Threading.Tasks.Task <ActionResult> SynMember(string id) { // SYNC MEMBERS (can` string id cua course) // START Session["MaKH"] = id; var item = db.ThamDus.Where(x => x.MaKH == id).ToList(); string lecid = (string)Session["MaGV"]; string sec = (string)Session["secret"]; ThamDu Member = new ThamDu(); string[] sID = new string[item.Count()]; int i = 0; foreach (var items in item) { sID[i] = items.MSSV.ToString(); i++; } Members mem = new Members(); mem.course = id; mem.members = sID; string json = JsonConvert.SerializeObject(mem); var values = new Dictionary <string, string> { { "uid", lecid }, { "secret", sec }, { "data", json } }; var content = new FormUrlEncodedContent(values); var response = await client.PostAsync("https://entool.azurewebsites.net/SEP21/SyncMembers", content); var responseString = await response.Content.ReadAsStringAsync(); GetResponeMessage ResponeMessage = JsonConvert.DeserializeObject <GetResponeMessage>(responseString); Session["SynMessage"] = ResponeMessage.message.ToString(); // END return(RedirectToAction("ListStudent", "Course", new { id = (string)Session["MaKH"] })); }