public ActionResult SaveApplicationDetails(Applicaticant model)
        {
            string det = "Error";


            List <Vacancy> outputV = (from c in db.Vacancies
                                      where c.VacancyId == model.marks
                                      select c).ToList();

            model.vacancy = outputV[0];

            model.marks = 0;
            model.isDateTimeAsssigned = false;
            model.isSelected          = false;
            model.isBackListed        = false;
            model.isDateTimeAsssigned = false;
            model.InterviewDateTime   = DateTime.Now;

            if (ModelState.IsValid)
            {
                db.Applicaticants.Add(model);
                db.SaveChanges();
                det = "Success";
            }
            CurrentAplicantID = model.ApplicantId;
            return(Json(det));
        }
        public ActionResult LoadInterviewPanelMembers(Applicaticant model)
        {
            List <ApplicationUser> output = (from c in db.Users
                                             where c.UserName != "Admin"
                                             select c).ToList();

            return(Json(output));
        }
        public ActionResult SaveMarks(Applicaticant model)
        {
            string result = "ok";

            try
            {
                Applicaticant applicatModel = db.Applicaticants.Find(model.ApplicantId);
                applicatModel.marks = model.marks;
                if (ModelState.IsValid)
                {
                    db.Entry(applicatModel).State = EntityState.Modified;
                    db.SaveChanges();
                }
            }
            catch (Exception ex)
            {
                result = "not";
            }
            return(Json(result));
        }
        public ActionResult addMarks()
        {
            if (User.Identity.Name != "Admin")
            {
                ApplicationUser applicattionUserModel = (from c in db.Users
                                                         where c.UserName == User.Identity.Name
                                                         select c).ToList()[0];
                List <string>        ApplicantIdList = applicattionUserModel.InterviewMembers.Split(',').ToList();
                List <Applicaticant> AllApplicants   = new List <Applicaticant>();

                for (int i = 0; i < ApplicantIdList.Count - 1; i++)
                {
                    int           id = Int32.Parse(ApplicantIdList[i]);
                    Applicaticant x  = db.Applicaticants.Find(id);
                    AllApplicants.Add(x);
                }
                ViewBag.AssignApplications = AllApplicants;
            }

            return(View());
        }
        public ActionResult SendEmailsAndSaveDetails(Applicaticant model)
        {
            Applicaticant applicatModel = db.Applicaticants.Find(model.ApplicantId);

            applicatModel.InterviewDateTime = model.InterviewDateTime;
            List <string> members = model.City.Split(',').ToList();

            applicatModel.AssignInterviewMemberNames = model.City;

            model.email = Regex.Replace(model.email, @"\s+", "");

            applicatModel.isAssignedTimeShedule = true;
            applicatModel.TimeDuration          = Int32.Parse(model.ZipCode);

            if (ModelState.IsValid)
            {
                db.Entry(applicatModel).State = EntityState.Modified;
                db.SaveChanges();
            }



            string output            = "";
            bool   isSendToMember    = true;
            bool   isSendToApplicant = false;

            try
            {
                for (int i = 0; i < members.Count - 1; i++)
                {
                    string          memName = members[i];
                    ApplicationUser applicattionUserModel = (from c in db.Users
                                                             where c.UserName == memName
                                                             select c).ToList()[0];
                    applicattionUserModel.InterviewMembers += applicatModel.ApplicantId + ",";
                    applicattionUserModel.timeshedules     += applicatModel.InterviewDateTime.ToString() + ",";
                    if (ModelState.IsValid)
                    {
                        db.Entry(applicattionUserModel).State = EntityState.Modified;
                        db.SaveChanges();
                    }


                    string PanelMemberEmail = returnSystemUserEmailAddress(members[i]);
                    if (SendMailToInterViewPanel(PanelMemberEmail, model.Gender, model.InterviewDateTime.ToString()) == false)
                    {
                        isSendToMember = false;
                    }
                }

                if (SendMailToJOBApplicant(model.email, model.Gender, model.InterviewDateTime.ToString()))
                {
                    isSendToApplicant = true;
                }

                if (isSendToApplicant == true && isSendToMember == true)
                {
                    output = "AllSuccess";
                }
                if (isSendToApplicant == true && isSendToMember == false)
                {
                    output = "ApplicantSuccess";
                }
                if (isSendToApplicant == false && isSendToMember == true)
                {
                    output = "MemberSuccess";
                }
            }
            catch (Exception ex)
            {
                output = ex.ToString();
            }
            return(Json(output));
        }