// GET: Staff
public ActionResult GetStaffList(int id)
{
using (var db = new UATEntities())
{
List <ContactViewModel> list = new List <ContactViewModel>();
list = (from user in db.Users
join user_con in db.User_Contact on user.Id equals user_con.UserId
join con in db.Contacts on user_con.ContactId equals con.Id
where user.Id == id
select new ContactViewModel
{
Name = con.FirstName + "" + con.MiddleName + "" + con.LastName,
Address = con.Address,
Mobile = con.Mobile,
PoliceCheck = con.PoliceCheck
}).ToList();
return(View(list));
}
}
public ActionResult GetStaffList(int id)
{
using (var db = new UATEntities())
{
var staffHaft = (from user in db.Users
join con in db.Contacts on user.ContactId equals con.Id
where (user.Id == id && user.IsActive)
select new
{
Id = user.Id,
staffName = con.FirstName + " " + con.MiddleName + " " + con.LastName,
Address = con.Address,
Mobile = con.Mobile,
PoliceCheck = con.PoliceCheck
}).Distinct().ToList();
var emergency = (from user in db.Users
join user_con in db.User_Contact on user.Id equals user_con.UserId
join con in db.Contacts on user_con.ContactId equals con.Id
where (user.Id == id && (user_con.ContactTypeId == 11 || user_con.ContactTypeId == 12) &&
user.IsActive)
select new EmergencyViewModel
{
EmergencyId = user.Id,
EmergencyName = con.FirstName + " " + con.LastName,
}).ToList();
var staff = (from st in staffHaft
join em in emergency on st.Id equals em.EmergencyId
select new ContactViewModel()
{
Name = st.staffName,
Address = st.Address,
Mobile = st.Mobile,
PoliceCheck = st.PoliceCheck,
EmergencyList = emergency,
}).ToList();
ViewData["staffs"] = staff;
return(View());
}
}
public ActionResult GetParentList(int id, int siteId)
{
using (var db = new UATEntities())
{
var parent = (from user in db.Users
join con in db.Contacts on user.ContactId equals con.Id
join lookup in db.Lookups on user.RoleId equals lookup.Id
where (user.Id == id && lookup.Id == 9 && user.IsActive)
select new
{
Id = user.Id,
pName = con.FirstName + " " + con.LastName,
Addres = con.Address,
}).ToList();
var secondparent = (from user in db.Users
join user_con in db.User_Contact on user.Id equals user_con.UserId
join con in db.Contacts on user_con.ContactId equals con.Id
where (user.Id == id && user_con.ContactTypeId == 10 && user.IsActive)
select new
{
Id = user.Id,
Name = (con.FirstName + " " + con.LastName),
Address = string.Empty,
}).ToList();
var childList = (from user in db.Users
join user_child in db.User_Child on user.Id equals user_child.UserId
join child in db.Children on user_child.ChildId equals child.Id
where (user.Id == id && user.IsActive)
select new ChildViewModel()
{
ParentId = user.Id,
ChildId = child.Id,
ChildName = child.Name,
}).ToList();
if (secondparent.Count == 0 || childList.Count == 0)
{
var parentList = (from p1 in parent
select new ParentViewModel()
{
ParentId = p1.Id,
FullName = p1.pName,
Address = p1.Addres,
Parent2 = string.Empty,
ChildList = new List <ChildViewModel>()
{
new ChildViewModel()
{
ParentId = id,
ChildId = 0,
ChildName = string.Empty,
}
},
SiteId = siteId,
}).FirstOrDefault();
return(View(parentList));
}
else
{
var parentList = (from p1 in parent
join p2 in secondparent on p1.Id equals p2.Id
select new ParentViewModel()
{
FullName = p1.pName,
Parent2 = p2.Name,
ParentId = p1.Id,
Address = p1.Addres,
ChildList = childList,
SiteId = siteId,
}).FirstOrDefault();
return(View(parentList));
}
}
}
