private void executeAdd(object obj)
{
Address address = new Address()
{
City = City, State = State, Country = Country, Zipcode = Zipcode
};
Examinee examinee = new Examinee()
{
Name = Name, Surname = Surname, Pesel = Pesel, BirthDate = (DateTime)BirthDate, Address = address
};
Exam exam = new Exam()
{
Examinee = examinee, Examiner = Examiner, Category = Category, Date = (DateTime)ExamDate
};
db.AddExam(exam);
Name = null;
Surname = null;
Pesel = null;
BirthDate = null;
City = null;
State = null;
Zipcode = null;
Country = null;
Category = null;
Examiner = null;
ExamDate = null;
}
public Examinee Create(Examinee examinee)
{
EExaminee eExaminee = EExaminee(examinee);
eExaminee = _iDExaminee.Create(eExaminee);
return(Examinee(eExaminee));
}
public ActionResult Create(string Firstname, string positionName, string firstName, string middleName, string lastName, string referencecode)
{
try
{
var examinee = new Examinee
{
ReferenceCode = referencecode,
Lastname = lastName,
Firstname = firstName,
Middlename = middleName,
};
var position = _iFPosition.Read(positionName);
if (position.PositionId != 0)
{
examinee.PositionId = position.PositionId;
examinee = _iFExaminee.Create(examinee);
Session["ExamineeId"] = null;
Session["ExamineeId"] = examinee.ExamineeId;
return(RedirectToAction("SelectExam", JsonRequestBehavior.AllowGet));
}
else
{
return(View(examinee));
}
}
catch (Exception ex)
{
return(RedirectToAction("Create"));
}
}
public ActionResult DeleteConfirmed(int id)
{
Examinee examinee = db.Examinees.Find(id);
db.Examinees.Remove(examinee);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public void CreateExam(string title, int subjId, string instruction, string descr, string examDate, string examType, int pMark, int timeLimit)
{
Main.fileManagement("EXEC [uspCreateExam] @instrID = '" + Session["id"] + "', @title = '" + title.Replace("'", "''").Trim() + "', @subjID = " + subjId + ", @instruction = '" + instruction.Replace("'", "''").Trim() + "', @description = '" + descr.Replace("'", "''").Trim() + "', @examDate = '" + examDate + "', @examType = '" + examType + "', @pMark = " + pMark + ", @timeLimit = " + timeLimit);
Examinee readExaminee = new Examinee((string)Session["id"]);
readExaminee.ReadyExaminee(subjId);
}
public void UpdateExaminee(Examinee examinee)
{
using (_context = new ExaminationContext())
{
_context.Entry(examinee).State = EntityState.Modified;
//_context.Entry(examinee).Property(p => p.DateTimeAdded).IsModified = false; // DateTimeAdded should not be modified
_context.SaveChanges();
}
}
public void InsertExaminee(Examinee examinee)
{
using (_context = new ExaminationContext())
{
examinee.DateTimeAdded = GetServerDateTime(_context);
_context.Examinee.Add(examinee); //_context.Entry(examinee).State = EntityState.Added;
_context.SaveChanges();
}
}
public void IncreaseExamineeExamTaken(int examineeId)
{
using (_context = new ExaminationContext())
{
Examinee examinee = _context.Examinee.Find(examineeId);
examinee.ExamTakes += 1;
_context.SaveChanges();
}
}
public ActionResult Edit([Bind(Include = "ExamineeID,Name,EntryDate,DOB,Address,Phone,Email")] Examinee examinee)
{
if (ModelState.IsValid)
{
db.Entry(examinee).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(examinee));
}
public ActionResult Create([Bind(Include = "ExamineeID,Name,EntryDate,DOB,Address,Phone,Email")] Examinee examinee)
{
if (ModelState.IsValid)
{
db.Examinees.Add(examinee);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(examinee));
}
public ActionResult Create(Examinee examinee)
{
try
{
examinee = _iFExaminee.Create(examinee);
return(View(examinee));
}
catch (Exception ex)
{
return(Json(ex));
}
}
public ActionResult Create(Examinee examinee)
{
Session["ExamineeId"] = null;
try
{
examinee = _iFExaminee.Create(examinee);
Session["ExamineeId"] = examinee.ExamineeId;
return(RedirectToAction("SelectExam"));
}
catch (Exception ex)
{
return(Json(ex));
}
}
// GET: Examinee/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Examinee examinee = db.Examinees.Find(id);
if (examinee == null)
{
return(HttpNotFound());
}
return(View(examinee));
}
public ActionResult Create(Examinee examinee)
{
try
{
//delete
examinee = _iFExaminee.Create(examinee);
Session[id] = examinee.ExamineeId;
return(RedirectToAction("SelectExam", new { id = examinee.ExamineeId }));
}
catch (Exception ex)
{
return(Json(ex));
}
}
private EExaminee EExaminee(Examinee examinee)
{
EExaminee returnEExaminee = new EExaminee
{
ExamineeId = examinee.ExamineeId,
PositionId = examinee.PositionId,
ReferenceCode = examinee.ReferenceCode,
Lastname = examinee.Lastname,
Firstname = examinee.Firstname,
Middlename = examinee.Middlename
};
return(returnEExaminee);
}
public void ViewExaminee(int iDisplayLength, int iDisplayStart, int iSortCol_0, string sSortDir_0, string sSearch, int examID)
{
Examinee examinee = new Examinee(iDisplayLength, iDisplayStart, iSortCol_0, sSortDir_0, sSearch);
int noOfExaminee = Main.dataCounter("SELECT COUNT(*)" +
"FROM [examinee]" +
"WHERE [exam_id] = " + examID);
//List<Examinee> examineeResult = examinee.ViewExaminee(examID);
var result = new
{
aaData = examinee.ViewExaminee(examID),
iTotalDisplayRecords = noOfExaminee,//Convert.ToInt32(examineeResult.ElementAt(0).TotalCount),
iTotalRecords = noOfExaminee
};
Context.Response.Write(js.Serialize(result));
}
public bool InsertExaminee(Examinee examinee, out List <string> errorList)
{
errorList = new List <string>();
_objectValidator = new ValueObjectValidator();
_isValid = _objectValidator.TryValidate(examinee, out _validationResults);
if (!_isValid)
{
foreach (var error in _validationResults)
{
errorList.Add(error.ErrorMessage);
}
return(false);
}
_examineeDAL.InsertExaminee(examinee);
return(true);
}
public bool UpdateExaminee(Examinee examinee, out List <string> errorList)
{
errorList = new List <string>();
_objectValidator = new ValueObjectValidator();
_isValid = _objectValidator.TryValidate(examinee, out _validationResults);
if (!_isValid)
{
foreach (var error in _validationResults)
{
errorList.Add(error.ErrorMessage);
}
return(false);
}
//Console.WriteLine("BLL " + examinee.DateTimeAdded.ToString());
_examineeDAL.UpdateExaminee(examinee);
return(true);
}
public async Task <List <Exam> > GetFutureExams(Examiner examiner = null, Examinee examinee = null, string category = null, DateTime?date = null)
{
using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(ConnectionString))
{
string sql = "dbo.GetFutureExams @Examiner_Id, @Examinee_Id, @Category, @Date";
int? examiner_id = examiner == null ? null : (int?)examiner.Id;
int? examinee_id = examinee == null ? null : (int?)examinee.Id;
var p = new { Examiner_Id = examiner_id, Examinee_Id = examinee_id, Category = category, Date = date };
var exams = await connection.QueryAsync <Exam, int, int, Exam>(sql,
(exam, ee_id, er_id) =>
{
var x = GetExamineeById(ee_id);
var y = GetExaminerById(er_id);
exam.Examinee = x;
exam.Examiner = y;
return(exam);
},
param : p,
splitOn : "Examinee_Id, Examiner_Id");
return(exams.ToList());
}
}
private void btnRegister_Click(object sender, EventArgs e)
{
if (InputsAreValid())
{
Examinee examinee = new Examinee
{
LastName = txtLastName.Text,
FirstName = txtFirstName.Text,
MiddleName = txtMiddleName.Text,
Address = txtAddress.Text,
City = txtCity.Text,
ContactNo = txtContactNo.Text,
Email = txtEmail.Text,
LastSchoolAttended = txtLastSchoolAttended.Text,
YearGraduated = (int)numYearGraduated.Value,
ExamTakes = 0
}; // create new Examinee
//examinee.DateTimeAdded = DateTime.Now; // to DAL
ExamineeBLL examineeBLL = new ExamineeBLL();
examineeBLL.InsertExaminee(examinee);
txtLastName.Text = string.Empty;
txtFirstName.Text = string.Empty;
txtMiddleName.Text = string.Empty;
txtAddress.Text = string.Empty;
txtCity.Text = string.Empty;
txtContactNo.Text = string.Empty;
txtEmail.Text = string.Empty;
txtLastSchoolAttended.Text = string.Empty;
lblStatus.Text = string.Empty;
MessageBox.Show(this, "Successfully registered!\nPlease get your exam code then start your exam.\nThank you.", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public Examinee Update(Examinee examinee)
{
var eExaminee = _iDExaminee.Update(EExaminee(examinee));
return(Examinee(eExaminee));
}
public void UpdateExaminee(Examinee examinee)
{
_examineeDAL.UpdateExaminee(examinee);
}
public void InsertExaminee(Examinee examinee)
{
_examineeDAL.InsertExaminee(examinee);
}
private void btnSave_Click(object sender, EventArgs e)
{
Examinee examinee;
if (btnAdd.Text == "&CANCEL") // ADD NEW=====
{
if (InputsAreValid())
{
examinee = new Examinee(); // create new Examinee
examinee.LastName = txtLastName.Text;
examinee.FirstName = txtFirstName.Text;
examinee.MiddleName = txtMiddleName.Text;
examinee.Address = txtAddress.Text;
examinee.City = txtCity.Text;
examinee.ContactNo = txtContactNo.Text;
examinee.Email = txtEmail.Text;
examinee.LastSchoolAttended = txtSchoolName.Text;
examinee.YearGraduated = (int)numYearGraduated.Value;
examinee.ExamTakes = 0;
//examinee.DateTimeAdded = DateTime.Now; // to DAL
_examineeBLL.InsertExaminee(examinee);
SetDatasourceSearchModeOrDefault();
SetUIProperty(Operation.Clear);
// message adding user success
lblStatus.Text = " Successfuly added new examinee";
}
}
if (btnEdit.Text == "&CANCEL") // EDIT=====
{
if (InputsAreValid())
{
// editing so get user from the selected user in the datagridview
examinee = _examineeViewModelList.Results.Where(ex => ex.ExamineeId == _examineeId)
.Select(ex => new Examinee
{
ExamineeId = ex.ExamineeId, // assign user id (Primary Key) so it can be tracked by EF
LastName = ex.LastName,
FirstName = ex.FirstName,
MiddleName = ex.MiddleName,
Address = ex.Address,
City = ex.City,
ContactNo = ex.ContactNo,
Email = ex.Email,
LastSchoolAttended = ex.LastSchoolAttended,
YearGraduated = ex.YearGraduated,
ExamTakes = ex.ExamTakes,
DateTimeAdded = ex.DateTimeAdded
}).SingleOrDefault();
examinee.LastName = txtLastName.Text;
examinee.FirstName = txtFirstName.Text;
examinee.MiddleName = txtMiddleName.Text;
examinee.Address = txtAddress.Text;
examinee.City = txtCity.Text;
examinee.ContactNo = txtContactNo.Text;
examinee.Email = txtEmail.Text;
examinee.LastSchoolAttended = txtSchoolName.Text;
examinee.YearGraduated = (int)numYearGraduated.Value;
_examineeBLL.UpdateExaminee(examinee); // save edited examinee
ExamineeViewModel examineeViewModel = _examineeViewModelList.Results.Where(ex => ex.ExamineeId == _examineeId).SingleOrDefault();
examineeViewModel.LastName = txtLastName.Text;
examineeViewModel.FirstName = txtFirstName.Text;
examineeViewModel.MiddleName = txtMiddleName.Text;
examineeViewModel.Address = txtAddress.Text;
examineeViewModel.City = txtCity.Text;
examineeViewModel.ContactNo = txtContactNo.Text;
examineeViewModel.Email = txtEmail.Text;
examineeViewModel.LastSchoolAttended = txtSchoolName.Text;
examineeViewModel.YearGraduated = (int)numYearGraduated.Value;
RefreshDataSource();
SetUIProperty(Operation.Clear);
// message edit user success
lblStatus.Text = " Successfuly updated examinee";
}
}
}
public void ViewBannedExaminee()
{
Examinee examinee = new Examinee((string)Session["id"]);
Context.Response.Write(js.Serialize(examinee.BannedExaminee()));
}
partial void InsertExaminee(Examinee instance);
partial void UpdateExaminee(Examinee instance);
partial void DeleteExaminee(Examinee instance);
public JsonResult Update(Examinee Examinee)
{
return(Json(_iFExaminee.Update(Examinee)));
}
public ActionResult Register(SessionModel model)
{
if (model != null)
{
Session["SessionModel"] = model;
}
if (model == null || string.IsNullOrEmpty(model.UserName) || model.TestId < 1)
{
TempData["messager"] = "Invalid Registration details. Please try again";
return(RedirectToAction("Index"));
}
var _ctx = new ApplicationDbContext();
// To register the user to the system
// to register the user For the test
Examinee _user = _ctx.Examinees.Where(x => x.Name.Equals(model.UserName, StringComparison.InvariantCultureIgnoreCase) &&
((string.IsNullOrEmpty(model.Email) && string.IsNullOrEmpty(x.Email)) || (x.Email == model.Email))).FirstOrDefault();
if (_user == null)
{
_user = new Examinee()
{
Name = model.UserName,
Email = model.Email,
EntryDate = DateTime.UtcNow
};
_ctx.Examinees.Add(_user);
_ctx.SaveChanges();
}
Registration registration = _ctx.Registrations.Where(x => x.ExamineeId == _user.ExamineeID &&
x.TestId == model.TestId &&
x.TokenExpireTime > DateTime.UtcNow).FirstOrDefault();
if (registration != null)
{
this.Session["TOKEN"] = registration.Token;
this.Session["TOKENEXPIRE"] = registration.TokenExpireTime;
}
else
{
Test test = _ctx.Tests.Where(x => x.IsActive && x.Id == model.TestId).FirstOrDefault();
if (test != null)
{
Registration newRegistration = new Registration()
{
RegistrationDate = DateTime.UtcNow,
TestId = model.TestId,
Token = Guid.NewGuid(),
TokenExpireTime = DateTime.UtcNow.AddMinutes(test.DurationInMinute)
};
_user.Registrations.Add(newRegistration);
_ctx.Registrations.Add(newRegistration);
_ctx.SaveChanges();
this.Session["TOKEN"] = newRegistration.Token;
this.Session["TOKENEXPIRE"] = newRegistration.TokenExpireTime;
}
}
return(RedirectToAction("EvalPage", new { @token = Session["TOKEN"] }));
}
