public HttpResponseMessage UpdateStudentById(int id, [FromBody] Student student) { try { using (StudentDBEntities entities = new StudentDBEntities()) { var entity = entities.Students.FirstOrDefault(e => e.ID == id); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Student with id = " + id.ToString() + " not found")); } else { entity.FirstName = student.FirstName; entity.LastName = student.LastName; entity.Gender = student.Gender; entity.NoOfSubjects = student.NoOfSubjects; entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, entity)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public ActionResult SignIn(Member SignInMember) { var db = new StudentDBEntities(); List <Member> dbInfo = db.Member.ToList(); foreach (Member info in dbInfo) { if (info.Account == SignInMember.Account && info.Password == SignInMember.Password && info.RealMember == 1 && info.Account == "admin") { ViewData["Message"] = info.UserName + "歡迎您回到本網站!"; Session["Login"] = "******"; Session["UserName"] = info.UserName; return(RedirectToAction("Index", new { msg = ViewData["Message"] })); } if (info.Account == SignInMember.Account && info.Password == SignInMember.Password && info.RealMember == 1) { ViewData["Message"] = info.UserName + "歡迎您回到本網站!"; Session["Login"] = "******"; Session["UserName"] = info.UserName; return(RedirectToAction("Index", new { msg = ViewData["Message"] })); } if (info.Account == SignInMember.Account && info.Password == SignInMember.Password && info.RealMember == 0) { ViewData["Message"] = "您的帳號尚未被驗證通過,暫時無法登入"; return(View()); } if (info.Account == SignInMember.Account && info.Password != SignInMember.Password) { ViewData["Message"] = "您的密碼輸入錯誤!"; return(View()); } } ViewData["Message"] = "您的帳號輸入錯誤!"; return(View()); }
public ActionResult Index(string msg) { if (!string.IsNullOrEmpty(msg)) { ViewData["Message"] = msg; } Session["Login"] = Session["Login"] != null ? Session["Login"].ToString() : "0"; Session["UserName"] = Session["UserName"] != null ? Session["UserName"].ToString() : null; var db = new StudentDBEntities(); List <RunningMessage> RunMessage = db.RunningMessage.ToList(); List <Contact> ContactList = db.Contact.ToList(); string TheNewestDate = "0"; //預設0的日期資料,以供比較日期資料 var tmpInfo = new ContactList(); foreach (Contact New in ContactList) { if (Int32.Parse(New.Date) > Int32.Parse(TheNewestDate)) //比較日期大小,找出數字最大(最新)的聯絡簿資料 { TheNewestDate = New.Date; tmpInfo.Date = New.Date; tmpInfo.SeeDate = New.SeeDate; tmpInfo.ContactOne = New.ContactOne; tmpInfo.ContactTwo = New.ContactTwo; tmpInfo.ContactThree = New.ContactThree; tmpInfo.ContactFour = New.ContactFour; tmpInfo.ContactFive = New.ContactFive; tmpInfo.ContactSix = New.ContactSix; tmpInfo.ContactSeven = New.ContactSeven; tmpInfo.ContactEight = New.ContactEight; } } tmpInfo.RunningMessage = RunMessage[0].Message; return(View(tmpInfo)); }
// GET: HomeController_Test #region List public ActionResult Contact() { Session["Login"] = Session["Login"] != null ? Session["Login"].ToString() : "0"; var db = new StudentDBEntities(); List <Contact> dbInfo = db.Contact.ToList(); var viewContactList = new List <ContactList>(); foreach (Contact info in dbInfo) { var tmpInfo = new ContactList() { Date = info.Date, SeeDate = info.SeeDate, ContactOne = info.ContactOne, ContactTwo = info.ContactTwo, ContactThree = info.ContactThree, ContactFour = info.ContactFour, ContactFive = info.ContactFive, ContactSix = info.ContactSix, ContactSeven = info.ContactSeven, ContactEight = info.ContactEight, }; viewContactList.Add(tmpInfo); } return(View(viewContactList)); }
public static bool Login(string username, string password) { using (StudentDBEntities entities = new StudentDBEntities()) { return(entities.Users.Any(user => user.Username.Equals(username, StringComparison.OrdinalIgnoreCase) && user.Password == password)); } }
public ActionResult DeleteMember(string id) { var db = new StudentDBEntities(); List <Member> dbInfo = db.Member.ToList(); db.Member.Remove(dbInfo[int.Parse(id)]); db.SaveChanges(); return(RedirectToAction("MemberList")); }
public ActionResult ChangeRunningMessage(ContactList NewMessage) { var db = new StudentDBEntities(); List <RunningMessage> RunMessage = db.RunningMessage.ToList(); RunMessage[0].Message = NewMessage.RunningMessage; db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult DeleteContact(string id) { var db = new StudentDBEntities(); List <Contact> dbInfo = db.Contact.ToList(); db.Contact.Remove(dbInfo[int.Parse(id)]); db.SaveChanges(); return(RedirectToAction("Contact")); }
public ActionResult DeleteConfirmed(int?id) { using (StudentDBEntities db = new StudentDBEntities()) { Student student = db.Studenti.Find(id); db.Studenti.Remove(student); db.SaveChanges(); } return(RedirectToAction("getStudent")); }
// GET: Student public ActionResult getStudent() { using (StudentDBEntities db = new StudentDBEntities()) { var student = db.Studenti.ToList(); if (student == null) { return(HttpNotFound()); } return(View(student)); } //StudentRepository StudRep = new StudentRepository(); //ModelState.Clear(); //return View(StudRep.getStudent()); }
public HttpResponseMessage LoadStudentById(int id) { using (StudentDBEntities entities = new StudentDBEntities()) { var entity = entities.Students.FirstOrDefault(e => e.ID == id); if (entity != null) { return(Request.CreateResponse(HttpStatusCode.OK, entity)); } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Student with id= " + id.ToString() + " not found")); } } }
public ActionResult EditMember(string id, Member info) { var db = new StudentDBEntities(); List <Member> dbInfo = db.Member.ToList(); dbInfo[int.Parse(id)].Account = info.Account; dbInfo[int.Parse(id)].Password = info.Password; dbInfo[int.Parse(id)].UserName = info.UserName; dbInfo[int.Parse(id)].Identity = info.Identity; dbInfo[int.Parse(id)].RealMember = info.RealMember; dbInfo[int.Parse(id)].Memo = info.Memo; db.SaveChanges(); ViewData["Message"] = "修改成功!"; return(RedirectToAction("MemberList", new { msg = ViewData["Message"] })); }
public List <StudentsDto> GetAllStudents(int districtId) { using (var context = new StudentDBEntities()) { return((from u in context.Students.Where(x => x.DistrictId == districtId) orderby u.FirstName select new StudentsDto() { StudentId = u.StudentId, FirstName = u.FirstName, LastName = u.LastName, SSN = u.SSN, DistrictId = u.DistrictId }).ToList()); } }
public void AddActorFailUserNameToolong() { StudentDBEntities db = new StudentDBEntities(); Actor actor = CreateMockedActor(); actor.UserName = "******"; try { ///try to add an existing username db.Actors.Add(actor); } catch (Exception ex) { Assert.IsNotNull(ex); } }
// GET: Ispit/Delete/5 public ActionResult Delete(int?id) { using (StudentDBEntities db = new StudentDBEntities()) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Student student = db.Studenti.Find(id); if (student == null) { return(HttpNotFound()); } return(View(student)); } }
public ActionResult Delete(string id) { try { var db = new StudentDBEntities(); List <Student> dbInfo = db.Student.ToList(); db.Student.Remove(dbInfo[int.Parse(id)]); db.SaveChanges(); return(RedirectToAction("StudentList_Complete")); } catch { ViewData["Message"] = "刪除失敗了唷!"; return(RedirectToAction("Detail", new { msg = ViewData["Message"] })); } }
public void AddStudentFailLastNameTooLong() { StudentDBEntities db = new StudentDBEntities(); Student student = CreateMockedStudent(); student.LastName = "Pacheco__________________________"; try { ///try to add an empty first name db.Students.Add(student); } catch (Exception ex) { Assert.IsNotNull(ex); } }
public void AddStudentFailInvalidEmailFormat() { StudentDBEntities db = new StudentDBEntities(); Student student = CreateMockedStudent(); student.Email = "email"; try { ///try to add an empty first name db.Students.Add(student); } catch (Exception ex) { Assert.IsNotNull(ex); } }
public void AddStudentFailEmptyStudentNumber() { StudentDBEntities db = new StudentDBEntities(); Student student = CreateMockedStudent(); student.StudentNumber = ""; try { ///try to add an empty first name db.Students.Add(student); } catch (Exception ex) { Assert.IsNotNull(ex); } }
public void AddStudentFailTooYoung() { StudentDBEntities db = new StudentDBEntities(); Student student = CreateMockedStudent(); student.Birthday = new DateTime(2001, 1, 1); try { ///try to add an empty first name db.Students.Add(student); } catch (Exception ex) { Assert.IsNotNull(ex); } }
public ActionResult MasterLista() { List <IspitiStudenataVM> sviIspiti = new List <IspitiStudenataVM>(); using (StudentDBEntities st = new StudentDBEntities()) { var s = st.Studenti.OrderByDescending(a => a.IdStudent).ToList(); foreach (var i in s) { var sviIspitiStudenata = st.Ispiti.Where(a => a.BiSt.Equals(i.BiStudent)).ToList(); sviIspiti.Add(new IspitiStudenataVM { Studenti = i, Ispiti = sviIspitiStudenata }); } } return(View(sviIspiti)); }
public ActionResult EditMember(string id) { var db = new StudentDBEntities(); List <Member> dbInfo = db.Member.ToList(); var tmpInfo = new Member() { Account = dbInfo[int.Parse(id)].Account, Password = dbInfo[int.Parse(id)].Password, UserName = dbInfo[int.Parse(id)].UserName, Identity = dbInfo[int.Parse(id)].Identity, RealMember = dbInfo[int.Parse(id)].RealMember, Memo = dbInfo[int.Parse(id)].Memo, }; return(View(tmpInfo)); }
public HttpResponseMessage CreateStudent([FromBody] Student student) { try { using (StudentDBEntities entities = new StudentDBEntities()) { entities.Students.Add(student); entities.SaveChanges(); var message = Request.CreateResponse(HttpStatusCode.Created, student); message.Headers.Location = new Uri(Request.RequestUri + student.ID.ToString()); return(message); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public ActionResult StudentInformation([ModelBinder(typeof(StudentModelBinder))] StudentViewModel studentViewModel) { try { var name = studentViewModel.Name; StudentDBEntities s = new StudentDBEntities(); s.InsertStudentInfo(studentViewModel.StudentId, studentViewModel.Name, studentViewModel.Address, studentViewModel.City, studentViewModel.State, studentViewModel.Country, studentViewModel.Department, studentViewModel.Marks); ViewBag.InsertMessage = "Record Inserted"; } catch (Exception ex) { } return(View("Index")); }
public List <StudentServiceDto> GetAllStudentServices(string schoolYear) { using (var context = new StudentDBEntities()) { return((from u in context.Services join od in context.Students on u.StudentId equals od.StudentId where u.SchoolYear == schoolYear orderby u.StudentId select new StudentServiceDto() { StudentId = u.StudentId, SchoolYear = u.SchoolYear, StartDate = u.StartDate, EndDate = u.EndDate, FirstName = od.FirstName, LastName = od.LastName }).ToList()); } }
public ActionResult EditContact(string id, Contact EditContact) { var db = new StudentDBEntities(); List <Contact> dbInfo = db.Contact.ToList(); dbInfo[int.Parse(id)].Date = EditContact.Date; dbInfo[int.Parse(id)].SeeDate = EditContact.SeeDate; dbInfo[int.Parse(id)].ContactOne = EditContact.ContactOne; dbInfo[int.Parse(id)].ContactTwo = EditContact.ContactTwo; dbInfo[int.Parse(id)].ContactThree = EditContact.ContactThree; dbInfo[int.Parse(id)].ContactFour = EditContact.ContactFour; dbInfo[int.Parse(id)].ContactFive = EditContact.ContactFive; dbInfo[int.Parse(id)].ContactSix = EditContact.ContactSix; dbInfo[int.Parse(id)].ContactSeven = EditContact.ContactSeven; dbInfo[int.Parse(id)].ContactEight = EditContact.ContactEight; db.SaveChanges(); ViewData["Message"] = "聯絡簿修改成功!"; return(RedirectToAction("Contact", new { msg = ViewData["Message"] })); }
// GET: Student/Edit/5 public ActionResult UpdateStudentDetails(int?id) { using (StudentDBEntities db = new StudentDBEntities()) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Student student = db.Studenti.Find(id); if (student == null) { return(HttpNotFound()); } return(View(student)); } // StudentRepository StudRepo = new StudentRepository(); // return View(StudRepo.getStudent().Find(Student => Student.IdStudent == IdStudent)); }
public ActionResult Create(Student info) { var db = new StudentDBEntities(); List <Student> dbInfo = db.Student.ToList(); var newuserinfo = new Student(); foreach (Student theinfo in dbInfo) { if (info.StudentID.Equals(theinfo.StudentID)) { ViewData["Message"] = "學生學號重複,請修改學號!"; return(View()); } } newuserinfo = info; db.Student.Add(newuserinfo); db.SaveChanges(); return(RedirectToAction("StudentList_Complete")); }
public ActionResult Edit(string id) { var db = new StudentDBEntities(); List <Student> dbInfo = db.Student.ToList(); var tmpInfo = new Student() { StudentID = dbInfo[int.Parse(id)].StudentID, ClassID = dbInfo[int.Parse(id)].ClassID, Name = dbInfo[int.Parse(id)].Name, Nickname = dbInfo[int.Parse(id)].Nickname, Phone = dbInfo[int.Parse(id)].Phone, Address = dbInfo[int.Parse(id)].Address, EmergencyContact = dbInfo[int.Parse(id)].EmergencyContact, EmergencyPhone = dbInfo[int.Parse(id)].EmergencyPhone, }; return(View(tmpInfo)); }
public ActionResult CreateMember(Member NewMember) { var db = new StudentDBEntities(); List <Member> dbInfo = db.Member.ToList(); var newmemberinfo = new Member(); foreach (Member info in dbInfo) { if (NewMember.Account.Equals(info.Account)) { ViewData["Message"] = "此帳號已經註冊,請更換帳號"; return(View("CreateMember")); } } newmemberinfo = NewMember; db.Member.Add(newmemberinfo); db.SaveChanges(); ViewData["Message"] = "帳號註冊成功!"; return(RedirectToAction("MemberList", new { msg = ViewData["Message"] })); }