public void setApplicantLogin(string fname, string lname, DateTime bdate)
{
ApplicantData n = new ApplicantData();
PromptModel promptModel = n.checkBooking(fname, lname, bdate);
Clients.All.getApplicantLogin(promptModel.functionMsg, promptModel.ifunctionVal);
if (promptModel.ifunctionVal == 0)
{
Clients.All.getApplicantList(n.getApplicantLoginbyCode(promptModel.applicantID));
}
}
private ViewResult view(HttpContext HttpContext, PromptModel model)
{
var ViewData = new ViewDataDictionary(new EmptyModelMetadataProvider(), new ModelStateDictionary())
{
Model = model
};
var TempData = Ioc.Create <ITempDataDictionaryFactory>()?.GetTempData(HttpContext);
var view = new ViewResult
{
ViewName = "Prompt",
ViewData = ViewData,
TempData = TempData
};
return(view);
}
public PromptModel checkBooking(string fname, string lname, DateTime bdate)
{
PromptModel pr = new PromptModel();
string applicantID = string.Empty;
try
{
using (ApplicantDBEntities dbcontext = new ApplicantDBEntities())
{
var qApplicantID = dbcontext.appool_applicant
.Where(aa => aa.first_name == fname && aa.last_name == lname && EntityFunctions.TruncateTime(aa.birth_date) == EntityFunctions.TruncateTime(bdate));
if (qApplicantID.Count() > 0)
{
applicantID = qApplicantID.First().applicant_id; //set applicant id
pr.applicantID = applicantID; //set applicantID in the model
if (dbcontext.appool_booking.Where(aa => aa.applicant_id == applicantID).Count() > 0)
{
var currentdate = DateTime.Now.Date;
var qCheckBookingExam = dbcontext.appool_booking.Where(aa => aa.applicant_id == applicantID && aa.exam_date == currentdate);
var qCheckBookingInterview = dbcontext.appool_booking.Where(aa => aa.applicant_id == applicantID && aa.interview_date == currentdate);
if (qCheckBookingExam.Count() > 0 && qCheckBookingInterview.Count() > 0)
{
//check if the user is already in logbox
var userLogboxInterview = dbcontext.appool_ApplicantCheckIn
.Where(aa => EntityFunctions.TruncateTime(aa.login_date) == EntityFunctions.TruncateTime(currentdate) &&
aa.applicant_id == applicantID && aa.purpose == "INTERVIEW")
.Count();
var userLogboxExam = dbcontext.appool_ApplicantCheckIn
.Where(aa => EntityFunctions.TruncateTime(aa.login_date) == EntityFunctions.TruncateTime(currentdate) &&
aa.applicant_id == applicantID && aa.purpose == "EXAM")
.Count();
if (userLogboxInterview > 0 && userLogboxExam > 0)
{
pr.ifunctionVal = 1;
pr.functionMsg = "Invalid: Duplicate log is not authorized!";
}
else
{
postApplicantLogin(applicantID, "INTERVIEW");
postApplicantLogin(applicantID, "EXAM");
pr.ifunctionVal = 0;
pr.functionMsg = "Thank's for coming...";
}
}
else if (qCheckBookingExam.Count() > 0 && qCheckBookingInterview.Count() == 0)
{
var userLogboxExam = dbcontext.appool_ApplicantCheckIn
.Where(aa => EntityFunctions.TruncateTime(aa.login_date) == EntityFunctions.TruncateTime(currentdate) &&
aa.applicant_id == applicantID && aa.purpose == "EXAM")
.Count();
if (userLogboxExam > 0)
{
pr.ifunctionVal = 1;
pr.functionMsg = "Invalid: Duplicate log is not authorized!";
}
else
{
postApplicantLogin(applicantID, "EXAM");
pr.ifunctionVal = 0;
pr.functionMsg = "Thank's for coming...";
}
}
else if (qCheckBookingExam.Count() == 0 && qCheckBookingInterview.Count() > 0)
{
var userLogboxInterview = dbcontext.appool_ApplicantCheckIn
.Where(aa => EntityFunctions.TruncateTime(aa.login_date) == EntityFunctions.TruncateTime(currentdate) &&
aa.applicant_id == applicantID && aa.purpose == "INTERVIEW")
.Count();
if (userLogboxInterview > 0)
{
pr.ifunctionVal = 1;
pr.functionMsg = "Invalid: Duplicate log is not authorized!";
}
else
{
postApplicantLogin(applicantID, "INTERVIEW");
pr.ifunctionVal = 0;
pr.functionMsg = "Thank's for coming...";
}
}
else
{
pr.ifunctionVal = 1;
pr.functionMsg = "No Event.";
}
}
else
{
pr.ifunctionVal = 1;
pr.functionMsg = "Applicant Not Found!";
}
}
else
{
pr.ifunctionVal = 1;
pr.functionMsg = "Applicant Not Found!";
}
return(pr);
}
}
catch (Exception ex)
{
pr.ifunctionVal = 1;
pr.functionMsg = ex.Message;
return(pr);
}
}
