}//end getuserrole
public string getUserRoleById(int id)
{
string uId = id.ToString();
string username = "******";
using (EserviceDBEntities db = new EserviceDBEntities())
{
var user = db.APPUserProfiles.Where(o => o.UHCLID.Equals(uId));
if (user.Any())
{
username = user.FirstOrDefault().UHCLEmail;
}
}
using (EserviceDBEntities db = new EserviceDBEntities())
{
var user = db.APPUsers.Where(o => o.UHCLEmail.ToLower().Equals(username));
if (user.Any())
{
return(user.FirstOrDefault().UserRole);
}
else
{
return(String.Empty);
}
}
}//end getuserrole
public string updateUserDetails(string username, string newPassword)
{
using (EserviceDBEntities db = new EserviceDBEntities())
{
var user = db.APPUsers.Where(o => o.UHCLEmail.ToLower().Equals(username)).FirstOrDefault();
if (user != null)
{
user.UHCLEmail = username;
user.UHCLEmailPassword = newPassword;
db.SaveChanges();
}
else
{
return("fails");
}
var userProfile = db.APPUserProfiles.Where(o => o.UHCLEmail.ToLower().Equals(username)).FirstOrDefault();
if (userProfile != null)
{
userProfile.UHCLEmail = username;
userProfile.UHCLEmailPassword = newPassword;
db.SaveChanges();
return("success");
}
else
{
return("fails");
}
}
}
public bool IsLoginUserExist(string username)
{
using (EserviceDBEntities db = new EserviceDBEntities())
{
return(db.APPUsers.Where(o => o.UHCLEmail.Equals(username)).Any());
}
}
public string GetUserFullNamebyId(int id)
{
using (EserviceDBEntities db = new EserviceDBEntities())
{
var user = db.APPUserProfiles.Where(o => o.UHCLID.Equals(id));
if (user.Any())
{
return(user.FirstOrDefault().FirstName + " " + user.FirstOrDefault().LastName);
}
}
return(null);
}
public string GetUserLastName(string username)
{
using (EserviceDBEntities db = new EserviceDBEntities())
{
var user = db.APPUserProfiles.Where(o => o.UHCLEmail.ToLower().Equals(username));
if (user.Any())
{
return(user.FirstOrDefault().LastName);
}
else
{
return(String.Empty);
}
}
}
public string getUserRole(string username)
{
using (EserviceDBEntities db = new EserviceDBEntities())
{
var user = db.APPUsers.Where(o => o.UHCLEmail.ToLower().Equals(username));
if (user.Any())
{
return(user.FirstOrDefault().UserRole);
}
else
{
return(String.Empty);
}
}
}//end getuserrole
public int GetUserUHCLID(string username)
{
using (EserviceDBEntities db = new EserviceDBEntities())
{
var user = db.APPUserProfiles.Where(o => o.UHCLEmail.ToLower().Equals(username));
if (user.Any())
{
return(user.FirstOrDefault().UHCLID);
}
else
{
return(0);
}
}
}
public UserModel GetUserNameByID(int uid)
{
using (EserviceDBEntities db = new EserviceDBEntities())
{
var user = db.APPUserProfiles.Where(o => o.UHCLID.Equals(uid));
if (user.Any())
{
return(new UserModel {
FirstName = user.FirstOrDefault().FirstName, LastName = user.FirstOrDefault().LastName, UHCLID = uid.ToString(), UHCLEmail = user.FirstOrDefault().UHCLEmail
});
// return (user.FirstOrDefault().FirstName +" " +user.FirstOrDefault().LastName);
}
else
{
return(null);
}
}
}
