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;
}
}
