public ActionResult Create([Bind(Include = "reviewId,review1,status,interviewDate")] Review review)
{
if (ModelState.IsValid)
{
review.dt_created = DateTime.Now;
review.applicationId = (int)Session["applicationId"];
review.cd_creater = (int)Session["userId"];
Application application = db.Applications.Find(review.applicationId);
review.userId = application.userId;
review.paperId = application.paperId;
review.jobId = application.jobId;
application.status = review.status;
db.Reviews.Add(review);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.applicationId = new SelectList(db.Applications, "applicationId", "status", review.applicationId);
ViewBag.paperId = new SelectList(db.InterviewQuestionPapers, "paperId", "answer1", review.paperId);
ViewBag.jobId = new SelectList(db.Jobs, "jobId", "applicantList", review.jobId);
ViewBag.userId = new SelectList(db.Users, "userId", "name", review.userId);
return(View(review));
}
public ActionResult Create(User user)
{
if (ModelState.IsValid)
{
try
{
// Check for email is already in use or not.
bool alreadyexists = false;
// Iterate in Database
foreach (User u in db.Users.ToList())
{
if (u.email.Equals(user.email))
{
// If already in use break the loop and change match data.
alreadyexists = true;
break;
}
}
if (alreadyexists)
{
// In case of duplicate emails, produce an error message and return back to register page.
ModelState.AddModelError(string.Empty, "This email already in use.");
return(View());
}
if (Session["userName"] == null)
{
// If create accesed by register.
user.BoolValue = false;
}
// Creating time log stored.
user.dt_created = DateTime.Now;
db.Users.Add(user);
db.SaveChanges();
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
throw;
}
return(RedirectToAction("Index", "Home", null));
}
return(View(user));
}
public ActionResult Create([Bind(Include = "jobId,applicantList,jobName,applicationStart,applicationFinish,SelectedCategories,questionNumber")] Job job)
{
if (ModelState.IsValid)
{
job.categories = string.Join(",", job.SelectedCategories);
db.Jobs.Add(job);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(job));
}
public ActionResult Create([Bind(Include = "category, question1")] Question question)
{
if (ModelState.IsValid)
{
question.cd_creater = (int)Session["userId"];
question.dt_created = DateTime.Now;
db.Questions.Add(question);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(question));
}
public ActionResult Create([Bind(Include = "paperId,applicationId,userId,jobId,cd_creater,dt_created,cd_modifier,dt_modified")] InterviewQuestionPaper interviewQuestionPaper)
{
if (ModelState.IsValid)
{
db.InterviewQuestionPapers.Add(interviewQuestionPaper);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.applicationId = new SelectList(db.Applications, "applicationId", "applicationId", interviewQuestionPaper.applicationId);
ViewBag.userId = new SelectList(db.Users, "userId", "name", interviewQuestionPaper.userId);
return(View(interviewQuestionPaper));
}
public ActionResult Create([Bind(Include = "categoryId,categoryName")] Category category)
{
if (Session["userName"] == null)
{
// If non user person wants to reach Edit page.
return(RedirectToAction("NotAuthorized", "Home"));
}
if ((int)Session["isAdmin"] == 0)
{
return(RedirectToAction("NotAuthorized", "Home"));
}
if (ModelState.IsValid)
{
db.Categories.Add(category);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(category));
}
public ActionResult Create([Bind(Include = "newId,header,text,imageFile,BoolValue,featuredList,dt_created,dt_modified,cd_creater,cd_modifier")] New @new)
{
if (Session["userName"] == null)
{
// If non user person wants to reach Edit page.
return(RedirectToAction("NotAuthorized", "Home"));
}
if ((int)Session["isAdmin"] == 0)
{
return(RedirectToAction("NotAuthorized", "Home"));
}
if (ModelState.IsValid)
{
if (@new.imageFile != null && @new.imageFile.ContentLength > 0)
{
string FileExtension = Path.GetExtension(@new.imageFile.FileName).ToUpper();
if (FileExtension == ".JPG" || FileExtension == ".PNG" || FileExtension == ".JPEG")
{
byte[] bytes;
using (BinaryReader br = new BinaryReader(@new.imageFile.InputStream))
{
bytes = br.ReadBytes(@new.imageFile.ContentLength);
}
@new.image = bytes;
}
}
@new.dt_created = DateTime.Now;
@new.cd_creater = (int)Session["userId"];
db.News.Add(@new);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(@new));
}
public ActionResult Create([Bind(Include = "applicationId,cvFile,paperId")] Application application)
{
if (ModelState.IsValid)
{
if (application.cvFile != null && application.cvFile.ContentLength > 0)
{
string FileExtension = Path.GetExtension(application.cvFile.FileName).ToUpper();
if (FileExtension == ".PDF")
{
byte[] bytes;
using (BinaryReader br = new BinaryReader(application.cvFile.InputStream))
{
bytes = br.ReadBytes(application.cvFile.ContentLength);
}
application.cv = bytes;
}
}
application.userId = (int)Session["userId"];
application.status = "Interview";
User user = db.Users.Where(a => a.userId == (application.userId)).FirstOrDefault();
application.dt_created = DateTime.Now;
user.Applications.Add(application);
application.jobId = (int)Session["jobId"];
Job job = db.Jobs.Find(application.jobId);
InterviewQuestionPaper paper = new InterviewQuestionPaper();
int totalQuestions = (int)job.questionNumber;
string[] categoriesArray = job.categories.Split(',');
//var questionIds = db.Questions.OrderBy(h => Guid.NewGuid()).Select(c => c.questionId).Take(3).ToList();
int[] numbers = new int[categoriesArray.Length];
List <int> allquestions = new List <int>();
for (int i = 0; i < totalQuestions; i++)
{
numbers[i % (categoriesArray.Length)]++;
}
for (int i = 0; i < categoriesArray.Length; i++)
{
int question = int.Parse(categoriesArray[i]);
var list = db.Questions.Where(a => a.category == question);
var questionIds = list.OrderBy(h => Guid.NewGuid()).Select(c => c.questionId).Take(numbers[i]).ToList();
allquestions.AddRange(questionIds);
}
paper.questionList = string.Join(",", allquestions);
paper.userId = application.userId;
paper.jobId = application.jobId;
paper.dt_created = DateTime.Now;
paper.cd_creater = application.userId;
db.InterviewQuestionPapers.Add(paper);
db.SaveChanges();
application.paperId = paper.paperId;
paper.applicationId = application.applicationId;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.userId = new SelectList(db.Users, "userId", "name", application.userId);
return(View(application));
}