public ActionResult AddEditEducationDetails(int EducationId = 0, bool IsReadOnly = false) { ViewBag.Classes = GetClasses(); ViewBag.Discipline = GetDiscipline(0); ViewBag.Colleges = GetColleges(); ViewBag.EducationCategory = GetEducationCategory(); ViewBag.Specialization = GetSpecialization(); ViewBag.University = GetUniversity(); ViewBag.Months = GetMonths(); ViewBag.Years = GetYears(); ViewBag.IsReadOnly = IsReadOnly; ViewBag.IsEditPage = false; if (System.Web.HttpContext.Current.Request.IsAuthenticated) { userId = Convert.ToInt32(System.Web.HttpContext.Current.User.Identity.Name.Split('|')[1]); userName = System.Web.HttpContext.Current.User.Identity.Name.Split('|')[0]; //var res = user.Where(u => u.Password == details.Password && u.Email.ToLower() == details.Email.ToLower()).SingleOrDefault(); var eduDetails_lst = _IEducationService.GetAll(null, null, ""); Session["eduDetails_lst"] = eduDetails_lst; var obj = eduDetails_lst.Where(u => u.UserID == userId && u.EduDetID == EducationId).FirstOrDefault(); if (obj != null) { _educationDetails = obj; } } Models.EducationDetails model = new EducationDetails(); if (EducationId != 0) { Mapper.CreateMap <Data.EmployeeEducationDetail, Models.EducationDetails>(); model = Mapper.Map <Data.EmployeeEducationDetail, Models.EducationDetails>(_educationDetails); //By Sachin Khot //model.EducationCategoryId = Convert.ToInt32(model.EducationCategory); model.EducationCategoryId = Convert.ToInt32(model.EducationCategoryId); //model.InstituteNameId = Convert.ToInt32(model.InstituteName); model.InstituteNameId = Convert.ToInt32(model.CollegeID); //model.University_BoardNameId = Convert.ToInt32(model.University_BoardName); model.University_BoardNameId = Convert.ToInt32(model.UniversityID); //model.ClassId = Convert.ToInt32(model.Class); model.ClassId = Convert.ToInt32(model.ClassId); //ViewBag.Discipline = GetDiscipline(Convert.ToInt32(model.TypeofDegreeDeploma)); ViewBag.Discipline = GetDiscipline(Convert.ToInt32(model.DisciplineID)); //model.TypeofDegreeDeplomaId = Convert.ToInt32(model.TypeofDegreeDeploma); model.TypeofDegreeDeplomaId = Convert.ToInt32(model.DisciplineID); //model.SpecializationId = Convert.ToInt32(model.Specialization); model.SpecializationId = Convert.ToInt32(model.SpecializationId); ViewBag.IsEditPage = true; } //Mapper.CreateMap<List<GetEducationList_Result>, List<EducationDetailsHistory>>(); //user.EducationalDetailsList = EducationListPagedList(userId); return(View("EducationalDetails", model)); }
public bool UpdateEmployeeEducation(EmployeeEducationDetail obj) { using (var context = new IPDEntities()) { //db.SaveChanges(); var local = context.EmployeeEducationDetails.Find(obj.EduDetID); context.Entry(local).CurrentValues.SetValues(obj); context.Entry(local).State = EntityState.Modified; bool status = Save(); return(status); } }
public ActionResult EducationalDetails(string EducationCategoryId = "1") { ViewBag.Classes = GetClasses(); ViewBag.Discipline = GetDiscipline(0); ViewBag.Colleges = GetColleges(); ViewBag.EducationCategory = GetEducationCategory(); ViewBag.Specialization = GetSpecialization(); ViewBag.University = GetUniversity(); ViewBag.Months = GetMonths(); ViewBag.Years = GetYears(); if (System.Web.HttpContext.Current.Request.IsAuthenticated) { userId = Convert.ToInt32(System.Web.HttpContext.Current.User.Identity.Name.Split('|')[1]); userName = System.Web.HttpContext.Current.User.Identity.Name.Split('|')[0]; var eduDetails_lst = _IEducationService.GetAll(null, null, ""); Session["eduDetails_lst"] = eduDetails_lst; var obj = eduDetails_lst.Where(u => u.UserID == userId && u.EducationCategoryID == Convert.ToInt16(EducationCategoryId)).FirstOrDefault(); if (obj != null) { _educationDetails = obj; } } Mapper.CreateMap <Data.EmployeeEducationDetail, Models.EducationDetails>(); var user = Mapper.Map <Data.EmployeeEducationDetail, Models.EducationDetails>(_educationDetails); //Commented by Sachin khot //user.EducationCategoryId = Convert.ToInt32(user.EducationCategory); //user.InstituteNameId = Convert.ToInt32(user.InstituteName); //user.University_BoardNameId = Convert.ToInt32(user.University_BoardName); //user.ClassId = Convert.ToInt32(user.Class); //user.TypeofDegreeDeplomaId = Convert.ToInt32(user.TypeofDegreeDeploma); //user.SpecializationId = Convert.ToInt32(user.Specialization); //Update Code by Sachin Khot user.EducationCategoryId = Convert.ToInt32(user.EducationCategoryId); user.InstituteNameId = Convert.ToInt32(user.InstituteNameId); user.University_BoardNameId = Convert.ToInt32(user.University_BoardNameId); user.ClassId = Convert.ToInt32(user.ClassId); user.TypeofDegreeDeplomaId = Convert.ToInt32(user.TypeofDegreeDeplomaId); user.SpecializationId = Convert.ToInt32(user.SpecializationId); //Mapper.CreateMap<List<GetEducationList_Result>, List<EducationDetailsHistory>>(); //user.EducationalDetailsList = EducationListPagedList(userId); return(View("NewEducationDetails", user)); }
public EducationController(IUserService IUserService, IEducationService IEducationService, IClassService IClassService, ICollegeService ICollegeService, IDisciplineService IDisciplineService, IEducationCategoryService IEducationCategoryService, ISpecializationService ISpecializationService, IUniversityService IUniversityService, IEducationCategoryUniversityBoardMappingService IEducationCategoryUniversityBoardMappingService) { this._IUserService = IUserService; this._IEducationService = IEducationService; _educationDetails = new EmployeeEducationDetail(); this._IClassService = IClassService; _class = new Master_Class(); this._ICollegeService = ICollegeService; _college = new Master_College(); this._IDisciplineService = IDisciplineService; _discipline = new Master_Discipline(); this._IEducationCategoryService = IEducationCategoryService; _educationCategory = new Master_EducationCategory(); this._ISpecializationService = ISpecializationService; _specialization = new Master_Specialization(); this._IUniversityService = IUniversityService; _university = new Master_University(); this._IEducationCategoryUniversityBoardMappingService = IEducationCategoryUniversityBoardMappingService; _educationCategoryUniversityBoardMapping = new EducationCategoryUniversityBoardMapping(); }
public bool DeleteEducationDetail(int ID, string userName) { bool result; using (IPDEntities ctx = new IPDEntities()) { try { EmployeeEducationDetail educationdetail = ctx.EmployeeEducationDetails.Where(m => m.EduDetID == ID).FirstOrDefault(); educationdetail.IsActive = false; educationdetail.UpdatedDate = DateTime.UtcNow; educationdetail.UpdatedBy = userName; ctx.SaveChanges(); result = true; } catch (Exception ex) { result = false; } } return(result); }
public bool Update(EmployeeEducationDetail obj, string[] param, string spName) { return(_IEducationRepository.Update(obj, param, spName)); }
public bool Insert(EmployeeEducationDetail obj, string[] param, string spName) { return(_IEducationRepository.Insert(obj, param, spName)); }
public IEnumerable <EmployeeEducationDetail> GetAll(EmployeeEducationDetail obj, string[] param, string spName) { return(_IEducationRepository.GetAll(obj, param, spName)); }
public ActionResult EducationalDetails(EducationDetails empdetails) { try { EducationDetails details = new EducationDetails(); if (empdetails.educationDetialslist != null && empdetails.educationDetialslist.Count == 1) { details = (EducationDetails)empdetails.educationDetialslist[0]; } else { details = empdetails; } details.EducationCategoryId = details.EducationCategoryId; details.OtherEducationCategory = details.OtherEducationCategory; details.DisciplineID = details.TypeofDegreeDeplomaId; details.OtherDiscipline = details.OtherDiscipline; details.UniversityID = details.University_BoardNameId; details.OtherUniversityName = details.OtherUniversityName; details.ClassId = details.ClassId; details.CollegeID = details.InstituteNameId; details.OtherCollegeName = details.OtherCollegeName; details.SpecializationId = _ISpecializationService.GetAll(null, null, "").Where(i => i.Specialization == "Other").Select(x => x.SpecializationID).FirstOrDefault(); if (!string.IsNullOrWhiteSpace(details.FromDate.ToString()) && !string.IsNullOrWhiteSpace(details.ToDate.ToString())) { details.FromDate = details.FromDate; details.ToDate = details.ToDate; } bool status = false; string userName = null; ModelState.Remove("PassingMonth"); ModelState.Remove("PassingYear"); ModelState.Remove("Percentage"); ModelState.Remove("AttndedToMonth"); ModelState.Remove("AttndedToYear"); //if (ModelState.IsValid) //{ details.UserId = Convert.ToInt32(System.Web.HttpContext.Current.User.Identity.Name.Split('|')[1]); userName = System.Web.HttpContext.Current.User.Identity.Name.Split('|')[0]; details.UpdatedBy = userName; details.UpdatedDate = DateTime.UtcNow; Mapper.CreateMap <EducationDetails, Data.EmployeeEducationDetail>(); EmployeeEducationDetail eduDetail = Mapper.Map <EducationDetails, Data.EmployeeEducationDetail>(details); var obj = _IEducationService.GetEmployeeEducationDetailsByUserID(Convert.ToInt32(details.UserId)); //educationList.Where(u => u.UserID == details.UserId).ToList(); var objUpdate = obj.Where(u => u.UserID == details.UserId).ToList(); if (obj != null) { var overlappedRecord = obj.Where(u => Convert.ToDateTime(u.FromDate) <= Convert.ToDateTime(details.ToDate) && Convert.ToDateTime(details.FromDate) <= Convert.ToDateTime(u.ToDate) && u.IsActive == true && u.EduDetID != details.EduDetID).ToList(); if (overlappedRecord.Count > 0) { return(Json(new { result = false, Message = "Education duration should not fall between previous education duration." }, JsonRequestBehavior.AllowGet)); } obj = obj.Where(u => u.UserID == details.UserId && u.EducationCategoryID == Convert.ToInt16(details.EducationCategoryId) && u.CollegeID == details.InstituteNameId && u.OtherSpecialization == Convert.ToString(details.OtherSpecialization) && u.PassingYear == details.PassingYear && u.IsActive == true).ToList(); } //check if user have alredy added record for this category if (obj.Count > 0 && details.EduDetID != obj.FirstOrDefault().EduDetID) { return(Json(new { result = false, Message = "Data for this Education Category is already Added" }, JsonRequestBehavior.AllowGet)); } //if (eduDetail.CreatedBy == null || eduDetail.CreatedBy == null) // eduDetail.CreatedBy = userName; //if (eduDetail.CreatedDate == DateTime.MinValue || eduDetail.CreatedDate == null) // eduDetail.CreatedDate = DateTime.UtcNow; if (details.EduDetID == 0) { eduDetail.CreatedBy = userName; eduDetail.CreatedDate = DateTime.UtcNow; eduDetail.UpdatedBy = userName; eduDetail.UpdatedDate = DateTime.UtcNow; eduDetail.IsActive = true; status = _IEducationService.Insert(eduDetail, null, ""); return(Json(new { result = false, Message = "Success" }, JsonRequestBehavior.AllowGet)); } else { eduDetail.UpdatedBy = userName; eduDetail.UpdatedDate = DateTime.UtcNow; eduDetail.IsActive = true; status = _IEducationService.Update(eduDetail, null, ""); return(Json(new { result = false, Message = "Success" }, JsonRequestBehavior.AllowGet)); } } catch (Exception ex) { return(Json(new { result = false, Message = "Error" }, JsonRequestBehavior.AllowGet)); } }