public IEnumerable <GetViewDoctor> getAllDoctor()
{
var AllUserInfo = (from n in DBcontext.UserLoginRoles
join b in DBcontext.UserLogins on n.LoginId equals b.LoginId
join c in DBcontext.Roles on n.RoleId equals c.RoleId
join ls in DBcontext.UserLoginSpecialitys on b.LoginId equals ls.LoginId
join s in DBcontext.Specialitys on ls.SpecialityID equals s.SpecialityID
join d in DBcontext.DoctorsClinicInfos on b.LoginId equals d.LoginId into bd
from d in bd.DefaultIfEmpty()
join u in DBcontext.upgradeServices on b.LoginId equals u.LoginId into bu
from u in bu.DefaultIfEmpty()
join m in DBcontext.Memberships on u.MembershipId equals m.MembershipId into um
from m in um.DefaultIfEmpty()
where n.RoleId == 4 && b.InactiveFlag == "N"
select new
{
LoginId = b.LoginId,
//UserName = b.UserName,
FirstName = b.FirstName,
LastName = b.LastName,
Speciality = s.SpecialityName,
ClinicName = d.ClinicName,
MembershipType = m.MembershipType,
EmailID = b.EmailID,
MobileNo = b.UserPhone,
Role = c.RoleName
}).ToList();
List <GetViewDoctor> allUsers = new List <GetViewDoctor>();
foreach (var item in AllUserInfo)
{
var s = new GetViewDoctor();
s.LoginId = item.LoginId;
//s.UserName = item.UserName;
s.FirstName = item.FirstName;
s.LastName = item.LastName;
s.SpecialityName = item.Speciality;
s.ClinicName = item.ClinicName;
s.MembershipType = item.MembershipType;
s.EmailID = item.EmailID;
s.UserPhone = item.MobileNo;
s.RoleName = item.Role;
allUsers.Add(s);
}
return(allUsers.ToList());
}
public IEnumerable <GetViewDoctor> getAllDoctor()
{
var AllUserInfo = (from n in DBcontext.UserLoginRoles
join b in DBcontext.UserLogins on n.LoginId equals b.LoginId
join c in DBcontext.Roles on n.RoleId equals c.RoleId
join ls in DBcontext.UserLoginSpecialitys on b.LoginId equals ls.LoginId
join s in DBcontext.Specialitys on ls.SpecialityID equals s.SpecialityID
join d in DBcontext.DoctorsClinicInfos on b.LoginId equals d.LoginId into bd
from d in bd.DefaultIfEmpty()
join p in DBcontext.DoctorsPersonals on b.LoginId equals p.LoginId into dp
from p in dp.DefaultIfEmpty()
join u in DBcontext.upgradeServices on b.LoginId equals u.LoginId into bu
from u in bu.DefaultIfEmpty()
join m in DBcontext.Memberships on u.MembershipId equals m.MembershipId into um
from m in um.DefaultIfEmpty()
where n.RoleId == 4 && b.InactiveFlag == "N"
orderby b.FirstName ascending
orderby d.ClinicName ascending
select new
{
LoginId = b.LoginId == null ? 0 : b.LoginId,
FirstName = b.FirstName == null ? null : b.FirstName,
LastName = b.LastName == null ? null : b.LastName,
Speciality = s.SpecialityName == null ? null : s.SpecialityName,
ClinicName = d.ClinicName == null ? null : d.ClinicName,
ClinicAddress = d.ClinicAddress == null ? null : d.ClinicAddress,
ClinicPhoneNo = d.ClinicPhoneNo == null ? null : d.ClinicPhoneNo,
ClinicFees = d.ClinicFees == null ? 0 : d.ClinicFees,
City = d.City == null ? 0 : d.City,
ZipCode = d.ZipCode == null ? 0 : d.ZipCode,
ClinicServices = d.ClinicServices == null ? null : d.ClinicServices,
AwardsAndRecognization = d.AwardsAndRecognization == null ? null : d.AwardsAndRecognization,
AboutClinic = d.AboutClinic == null ? null : d.AboutClinic,
MiddleName = p.MiddleName == null ? null : p.MiddleName,
Qualification = p.Qualification == null ? null : p.Qualification,
RegistrationNo = p.RegistrationNo == null ? null : p.RegistrationNo,
Affiliation = p.Affiliation == null ? null : p.Affiliation,
AboutMe = p.AboutMe == null ? null : p.AboutMe,
ExperienceInYear = p.ExperienceInYear == null ? null : p.ExperienceInYear,
ExperienceInMonth = p.ExperienceInMonth == null ? null : p.ExperienceInMonth,
MembershipType = m.MembershipType == null ? null : m.MembershipType,
EmailID = b.EmailID == null ? null : b.EmailID,
MobileNo = b.UserPhone == null ? null : b.UserPhone,
Role = c.RoleName == null ? null : c.RoleName
}).ToList();
List <GetViewDoctor> allUsers = new List <GetViewDoctor>();
foreach (var item in AllUserInfo)
{
var s = new GetViewDoctor();
s.LoginId = item.LoginId;
s.FirstName = CultureInfo.CurrentCulture.TextInfo.ToTitleCase(item.FirstName + " " + item.LastName);
s.LastName = item.LastName;
s.SpecialityName = item.Speciality;
s.ClinicName = item.ClinicName;
s.ClinicAddress = item.ClinicAddress;
s.ClinicPhoneNo = item.ClinicPhoneNo;
s.ClinicFees = item.ClinicFees;
s.City = item.City;
s.ZipCode = item.ZipCode;
s.ClinicServices = item.ClinicServices;
s.AwardsAndRecognization = item.AwardsAndRecognization;
s.AboutClinic = item.AboutClinic;
s.MiddleName = item.MiddleName;
s.Qualification = item.Qualification;
s.RegistrationNo = item.RegistrationNo;
s.Affiliation = item.Affiliation;
s.AboutMe = item.AboutMe;
s.ExperienceInYear = item.ExperienceInYear;
s.ExperienceInMonth = item.ExperienceInMonth;
s.MembershipType = item.MembershipType;
s.EmailID = item.EmailID;
s.UserPhone = item.MobileNo;
s.RoleName = item.Role;
allUsers.Add(s);
}
return(allUsers.OrderBy(x => x.FirstName).ToList());
}
