public List <UserOfferDetail> GetAllUsers() { using (OnboardEntities db = new OnboardEntities()) { List <UserOfferDetail> allUsers = db.UserOfferDetails.ToList(); return(allUsers); } }
public string VerifyAdminDetails(string email, string password) { String status = string.Empty; using (OnboardEntities db = new OnboardEntities()) { AdminData user = db.AdminDatas.Where(x => (x.email == email && x.password == password)).FirstOrDefault(); status = user != null ? "Submitted" : "NoRecord"; return(status); } }
internal string SaveUserProfileData(UserProfileData userProfile, string email) { using (OnboardEntities db = new OnboardEntities()) { try { if (db.UserOfferDetails.Where(x => x.emailID == email).SingleOrDefault().isSubmitted == false) { UserProfile profiledata = db.UserProfiles.Include("AdditionalDatas") .Include("FunctionalSkillDatas") .Include("CertificationDatas") .Include("EmployerDatas") .Include("InsuranceDatas") .Include("MembershipDatas") .Include("PersonalDatas") .Include("QualificationDatas") .Include("TainingDatas") .Include("FileDatas") .Include("TechnicalSkillDatas").Where(s => s.email == email).FirstOrDefault(); if (profiledata != null) { profiledata = UpdateProfileData(userProfile, profiledata); db.SaveChanges(); } else { UserProfile profile = GenerateProfileData(userProfile, email); db.UserProfiles.Add(profile); db.SaveChanges(); } return("Data is saved Successfully"); } else { return("Data is already submitted cannot make any further changes"); } } catch (Exception ex) { throw ex; } } }
public void SetLoginAccess(int index) { using (OnboardEntities db = new OnboardEntities()) { UserOfferDetail selectedUser = db.UserOfferDetails.SingleOrDefault(x => x.id == index); if (selectedUser.isEditable == true) { selectedUser.isEditable = false; } else if (selectedUser.isEditable == false) { selectedUser.isEditable = true; selectedUser.isSubmitted = false; } db.SaveChanges(); } }
internal UserProfile GetUserProfileData(string email) { using (OnboardEntities db = new OnboardEntities()) { var upid = db.UserProfiles.Where(s => s.email == email).First(); UserProfile userProfile = db.UserProfiles.Include("AdditionalDatas") .Include("FunctionalSkillDatas") .Include("CertificationDatas") .Include("EmployerDatas") .Include("InsuranceDatas") .Include("MembershipDatas") .Include("PersonalDatas") .Include("QualificationDatas") .Include("TainingDatas") .Include("FileDatas") .Include("TechnicalSkillDatas").First(s => s.UPID == upid.UPID); return(userProfile); } }
public string VerifyUserDetails(string email, string fullname) { string status = string.Empty; try { using (OnboardEntities db = new OnboardEntities()) { UserOfferDetail user = db.UserOfferDetails.Where(x => (x.emailID == email && x.name == fullname)).FirstOrDefault(); if (user.isEditable == false) { status = "Disabled"; if (user.isSubmitted == true) { status = "Submitted"; } } else if (user.isEditable == true) { status = "NotSubmitted"; if (user.isSubmitted == true) { status = "Submitted"; } } else { status = "NoRecord"; } //status = user != null ? (user.isEditable == true && user.isSubmitted == false ? (user.isSubmitted == true ? "Submitted" : "NotSubmitted") : "Disabled") : "NoRecord"; return(status); } } catch (Exception ex) { throw ex; } }
internal string SubmitUserData(string email) { try { using (OnboardEntities db = new OnboardEntities()) { var data = db.UserOfferDetails.Where(x => x.emailID == email).Single(); if (!data.isSubmitted == true) { db.SaveChanges(); return("Data is submitted successfully"); } else { return("Already Submitted"); } } } catch (Exception ex) { throw ex; } }