public ActionResult Create([Bind(Include = "ID,LastName,FirstName,FatherName,TotalIncome,IncomeEvidence,StudentAddress,StudentCity,StudentProvince,ContactNumber,DateOfBirth")] Students students)
{
if (ModelState.IsValid)
{
db.Students.Add(students);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(students));
}
public ActionResult Create([Bind(Include = "ID,SchoolName,StudentAddress,StudentCity,StudentProvince,ContactNumber1,ContactNumber2,TotalEnrollment,FocalPersonName,FocalPersonContact")] School school)
{
if (ModelState.IsValid)
{
db.Schools.Add(school);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(school));
}
public ActionResult Create([Bind(Include = "Id,Email,Password,Role,Avatar")] User user)
{
if (ModelState.IsValid)
{
db.Users.Add(user);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Id = new SelectList(db.UserInfors, "Id", "Name", user.Id);
return(View(user));
}
public ActionResult CreateQiuzz(Quizz newQuizz)
{
using (EducationDBContext db = new EducationDBContext())
{
db.Quizzs.Add(newQuizz);
db.SaveChanges();
}
return(RedirectToAction("Index", "Home"));
}
public ActionResult CreateLession(Lession newLession)
{
using (EducationDBContext db = new EducationDBContext())
{
db.Lessions.Add(newLession);
db.SaveChanges();
}
return(RedirectToAction("Index", "Home"));
}
public ActionResult CreateSubject(Subject newSubject)
{
using (EducationDBContext db = new EducationDBContext())
{
db.Subjects.Add(newSubject);
db.SaveChanges();
}
//dang loi o line 71 phan View khi get select item
return(RedirectToAction("Index", "Home"));
}
public bool Form(Candidate c, List <string> Lang, List <Education> edu, List <Employeer> emp, List <string> Skills, List <Reference> refer)
{
try
{
c.UploadResume = file_path;
CAND.Candidates.Add(c);
CAND.SaveChanges();
var c_id = c.ID;
foreach (string lang in Lang)
{
Language l = new Language()
{
CID = c_id, Lang = lang
};
LANG.Languages.Add(l);
LANG.SaveChanges();
}
foreach (Education ed in edu)
{
ed.CID = c_id;
EDU.Educations.Add(ed);
EDU.SaveChanges();
}
foreach (Employeer em in emp)
{
em.CID = c_id;
EMP.Employeers.Add(em);
EMP.SaveChanges();
}
foreach (string s in Skills)
{
Skill sk = new Skill()
{
CID = c_id, Skills = s
};
SKILL.Skills.Add(sk);
SKILL.SaveChanges();
}
foreach (Reference r in refer)
{
r.CID = c_id;
REF.References.Add(r);
REF.SaveChanges();
}
file.SaveAs(file_path);
return(true);
}
catch (Exception e)
{
return(false);
}
}
public ActionResult CreateCourse(Course newCourse)
{
using (EducationDBContext db = new EducationDBContext())
{
//get data then check data // then create and forward
db.Courses.Add(newCourse);
db.SaveChanges();
}
//forward value of id to create subject
return(RedirectToAction("Index", "Home"));
}
public ActionResult Content()
{
int id = Convert.ToInt32(Request["Id"]);
var content = (from s in db.Lessions where s.Id == id select s).ToList();
foreach (var contents in content)
{
ViewBag.contents = content;
contents.View++;
}
db.SaveChanges();
ViewBag.contents = content;
return View();
}
public ActionResult Subject(int subjecId)
{
//get new rate
int UserRate = Convert.ToInt32(Request["new_rating_star"]);
//cal and response: totalrate+1
//get value
var recordeSubjectId = (from s in db.Subjects where s.Id == subjecId select s).ToList();
Subject currentSubject = recordeSubjectId[0];
double newSubjectRate = Convert.ToDouble((currentSubject.Total_rate * currentSubject.Rate + UserRate) / (currentSubject.Total_rate + 1));
//update
var result = db.Subjects.SingleOrDefault(b => b.Id == currentSubject.Id);
if (result != null)
{
result.Rate = newSubjectRate;
result.Total_rate = result.Total_rate + 1;
db.SaveChanges();
}
return(RedirectToAction("Index", "Home"));
}
public ActionResult Register(string name, string email, int mobile, string pass)
{
//moi lan tao moi la phai tao moi ca 2 bang
using (EducationDBContext db = new EducationDBContext())
{
User principal = new User()
{
Email = email,
Password = pass,
Role = 2,
};
UserInfor ui = new UserInfor()
{
Name = name,
Phone = mobile
};
ui.Id = db.Users.Add(principal).Id;
db.UserInfors.Add(ui);
db.SaveChanges();
return(View("Contact"));
}
}
public ActionResult AfterSubmit(List<AnswerOnSubmitDTO> data, int id, string time)
{
int userId = Convert.ToInt32(Session["id"]);
int correctAns = 0;
double pointTotalCorrect = 0;
double pointTotal = 0;
data = data != null ? data : new List<AnswerOnSubmitDTO>();
PointAfterSubmitDTO pointAfter;
List<ResultDTO> ResultDTO = new List<ResultDTO>();
double timeQuizz;
double timeRemaind;
double timeDo;
List<QuestionsGivenDTO> lstDTO= new List<QuestionsGivenDTO>();
//data handle
using (EducationDBContext db = new EducationDBContext())
{
//get list ques
var lst = (from qs in db.Questions where qs.CurrentQuizzId == id orderby qs.Id select qs).ToList();
lstDTO = AutoMap.Mapper.Map<List<QuestionsGivenDTO>>(lst);
//time handle
string[] str = time.Split(':');
timeQuizz = (from q in db.Quizzs where q.Id == id select q).First().time * 60*60;
timeRemaind = int.Parse(str[0])*60 + int.Parse(str[1]);
timeDo = timeQuizz - timeRemaind;
int currentIdQues = -1;
//check question
foreach (AnswerOnSubmitDTO item in data)
{
var ansCorrect = (from an in db.Answers where an.CurrentQuestionId == item.Ques && an.IsCorrect select an).First();
double? point = (from q in db.Questions where q.Id == item.Ques select q).FirstOrDefault().Point;
if(currentIdQues != item.Ques)
{
pointTotal += point.HasValue ? point.Value : 0;
currentIdQues = item.Ques;
}
if (ansCorrect.Id == item.Ans)
{
pointTotalCorrect += point.HasValue ? point.Value : 0;
correctAns += 1;
}
ResultDTO.Add(new ResultDTO()
{
AnsChoosed = item.Ans,
CorrectAns = ansCorrect.Id,
QuesId = item.Ques,
QuizzId = id,
});
}
UserInfor user = (from u in db.UserInfors where u.Id == userId select u).FirstOrDefault();
Quizz quizz = (from q in db.Quizzs where q.Id == id select q).FirstOrDefault();
pointAfter = new PointAfterSubmitDTO()
{
Quizz = quizz,
Score = pointTotalCorrect,
UserInfor = user,
CorrectAnswer = correctAns
};
Point score = (from p in db.points where p.UserInfor.Id == userId && p.Quizz.Id == id select p).FirstOrDefault();
if (score != null)
{
score.CorrectAnswer = pointAfter.CorrectAnswer;
score.Quizz = pointAfter.Quizz;
score.Score = pointAfter.Score;
score.UserInfor = pointAfter.UserInfor;
}
else
{
db.points.Add(AutoMap.Mapper.Map<Point>(pointAfter));
}
db.SaveChanges();
}
return Json(new
{
lisQues=lstDTO,
data = ResultDTO,
timetotal = timeQuizz,
timeDo = timeDo,
point= pointTotalCorrect,
pointTotal= pointTotal
},
JsonRequestBehavior.AllowGet) ;
}
