public ActionResult SaveEducation(EmployeeEducationsViewModel model)
        {
            DateTime StDate            = new DateTime();
            DateTime EdDate            = new DateTime();
            var      startDateToString = DateTime.ParseExact(model.StartDate, inputFormat, CultureInfo.InvariantCulture);

            StDate = Convert.ToDateTime(startDateToString.ToString(outputFormat));
            var EndDateToString = DateTime.ParseExact(model.EndDate, inputFormat, CultureInfo.InvariantCulture);

            EdDate = Convert.ToDateTime(EndDateToString.ToString(outputFormat));

            if (model.Id == 0)
            {
                Employee_Educations mm = new Employee_Educations();
                mm.EmployeeID           = model.EmployeeID;
                mm.CourseName           = model.CourseName;
                mm.InstitutionName      = model.InstitutionName;
                mm.StartDate            = StDate;
                mm.EndDate              = EdDate;
                mm.OtherInformation     = model.OtherInformation;
                mm.Archived             = false;
                mm.CreatedDate          = DateTime.Now;
                mm.LastModified         = DateTime.Now;
                mm.UserIDCreatedBy      = SessionProxy.UserId;
                mm.UserIDLastModifiedBy = SessionProxy.UserId;
                _db.Employee_Educations.Add(mm);
                _db.SaveChanges();
            }
            else
            {
                var data = _db.Employee_Educations.Where(x => x.Id == model.Id).FirstOrDefault();
                data.CourseName           = model.CourseName;
                data.InstitutionName      = model.InstitutionName;
                data.StartDate            = StDate;
                data.EndDate              = EdDate;
                data.OtherInformation     = model.OtherInformation;
                data.Archived             = false;
                data.LastModified         = DateTime.Now;
                data.UserIDLastModifiedBy = SessionProxy.UserId;
                _db.SaveChanges();
            }

            EmployeeResumeViewModel models = AllDetailsList(model.EmployeeID);

            return(PartialView("_partialResumeDetailsList", models));
        }
        public ActionResult AddEditEducation(int Id, int employeeId)
        {
            EmployeeEducationsViewModel model = new EmployeeEducationsViewModel();

            if (Id == 0)
            {
                model.Id         = 0;
                model.EmployeeID = employeeId;
                model.StartDate  = String.Format("{0:dd-MM-yyyy}", DateTime.Now);
                model.EndDate    = String.Format("{0:dd-MM-yyyy}", DateTime.Now);
            }
            else
            {
                var data = _db.Employee_Educations.Where(x => x.Id == Id).FirstOrDefault();
                model.Id               = data.Id;
                model.EmployeeID       = data.EmployeeID;
                model.CourseName       = data.CourseName;
                model.InstitutionName  = data.InstitutionName;
                model.StartDate        = String.Format("{0:dd-MM-yyyy}", data.StartDate);
                model.EndDate          = String.Format("{0:dd-MM-yyyy}", data.EndDate);
                model.OtherInformation = data.OtherInformation;
            }
            return(PartialView("_partialAddEditEducation", model));
        }
        public EmployeeResumeViewModel AllDetailsList(int EmployeeId)
        {
            EmployeeResumeViewModel modelList = new EmployeeResumeViewModel();

            modelList.EmployeeID = EmployeeId;
            var workdetails        = _db.Employee_Experiences.Where(x => x.EmployeeID == EmployeeId && x.Archived == false).ToList();
            var educationDetails   = _db.Employee_Educations.Where(x => x.EmployeeID == EmployeeId && x.Archived == false).ToList();
            var qualificationlist  = _db.Employee_Qualifications.Where(x => x.EmployeeID == EmployeeId && x.Archived == false).ToList();
            var laguageDetailsList = _db.Employee_Languages.Where(x => x.EmployeeID == EmployeeId && x.Archived == false).ToList();
            var resumeText         = _db.Employee_Resume.Where(x => x.EmployeeID == EmployeeId).FirstOrDefault();

            if (resumeText != null)
            {
                modelList.ResumeID   = resumeText.Id;
                modelList.ResumeText = resumeText.ResumeText;
            }
            if (workdetails.Count > 0)
            {
                foreach (var item in workdetails)
                {
                    EmployeeExperienceViewModel model = new EmployeeExperienceViewModel();
                    model.Id               = item.Id;
                    model.EmployeeID       = item.EmployeeID;
                    model.CompanyName      = item.CompanyName;
                    model.JobTitle         = item.JobTitle;
                    model.JobStartDate     = String.Format("{0:MMM-yyyy}", item.JobStartDate);
                    model.JobEndDate       = String.Format("{0:MMM-yyyy}", item.JobEndDate);
                    model.OtherInformation = item.OtherInformation;
                    modelList.WorkExperienceList.Add(model);
                }
            }
            if (educationDetails.Count > 0)
            {
                foreach (var item in educationDetails)
                {
                    EmployeeEducationsViewModel model = new EmployeeEducationsViewModel();
                    model.Id               = item.Id;
                    model.EmployeeID       = item.EmployeeID;
                    model.CourseName       = item.CourseName;
                    model.InstitutionName  = item.InstitutionName;
                    model.StartDate        = String.Format("{0:MMM-yyyy}", item.StartDate);
                    model.EndDate          = String.Format("{0:MMM-yyyy}", item.EndDate);
                    model.OtherInformation = item.OtherInformation;
                    modelList.EductionList.Add(model);
                }
            }
            if (qualificationlist.Count > 0)
            {
                foreach (var item in qualificationlist)
                {
                    EmployeeQualificationsViewModel model = new EmployeeQualificationsViewModel();
                    model.Id         = item.Id;
                    model.EmployeeID = item.EmployeeID;
                    model.Detail     = item.Detail;
                    modelList.QualificationList.Add(model);
                }
            }
            if (laguageDetailsList.Count > 0)
            {
                foreach (var item in laguageDetailsList)
                {
                    var languageName = _otherSettingMethod.getSystemListValueById((int)item.LanguageID);
                    //var SpeakingName = _otherSettingMethod.getSystemListValueById((int)item.SpeakingID);
                    //var ListeningName = _otherSettingMethod.getSystemListValueById((int)item.ListeningID);
                    //var WritingName = _otherSettingMethod.getSystemListValueById((int)item.WritingID);
                    //var ReadingName = _otherSettingMethod.getSystemListValueById((int)item.ReadingID);

                    EmployeeLanguagesViewModel model = new EmployeeLanguagesViewModel();
                    model.Id           = item.Id;
                    model.EmployeeID   = item.EmployeeID;
                    model.LanguageID   = (int)item.LanguageID;
                    model.LanguageName = languageName.Value;
                    modelList.LanguageDetailsList.Add(model);
                    //model.SpeakingID = (int)item.SpeakingID;
                    //model.SpeakingName = SpeakingName.Value;
                    //model.ListeningID = (int)item.ListeningID;
                    //model.ListeningName = ListeningName.Value;
                    //model.WritingID = (int)item.WritingID;
                    //model.WritingName = WritingName.Value;
                    //model.ReadingID = (int)item.ReadingID;
                    //model.ReadingName = ReadingName.Value;
                }
            }
            return(modelList);
        }