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"] }));
}
