/// <summary>
/// All Users last Login Station
/// </summary>
/// <returns></returns>
public List <cstUserCurrentStationAndDeviceID> LastLoginStationAllUsers()
{
List <cstUserCurrentStationAndDeviceID> lsUstation = new List <cstUserCurrentStationAndDeviceID>();
try
{
var UserName = from user in ent.Users
join Us in ent.UserStations
on user.UserID equals Us.UserID
group Us by user.UserID into Gusers
select new
{
User = Gusers.Key,
StationTime = Gusers.Max(i => i.LoginDateTime),
StaionID = Gusers.FirstOrDefault(i => i.UserID == Gusers.Key && i.LoginDateTime == Gusers.Max(j => j.LoginDateTime)).StationID
};
var StaionName = from Station in UserName
join Station2 in ent.Stations
on Station.StaionID equals Station2.StationID
join User in ent.Users
on Station.User equals User.UserID
select new
{
UserID = User.UserID,
UserName = User.UserFullName,
Station.StationTime,
Station2.StationName,
Station2.DeviceNumber,
};
foreach (var Useritem in StaionName)
{
cstUserCurrentStationAndDeviceID UserStation = new cstUserCurrentStationAndDeviceID();
UserStation.UserID = Useritem.UserID;
UserStation.UserName = Useritem.UserName;
UserStation.StationName = Useritem.StationName;
UserStation.Datetime = Useritem.StationTime.ToString("MMM dd, yyyy hh:mm tt");
UserStation.DeviceID = Useritem.DeviceNumber;
lsUstation.Add(UserStation);
}
}
catch (Exception)
{ }
return(lsUstation);
}
/// <summary>
/// All Users last Login Station
/// </summary>
/// <returns></returns>
public List <cstUserCurrentStationAndDeviceID> LastLoginStationAllUsers()
{
List <cstUserCurrentStationAndDeviceID> lsUstation = new List <cstUserCurrentStationAndDeviceID>();
try
{
var StaionName = Service.Get.LastLoginStationAllUsers();
foreach (var Useritem in StaionName)
{
cstUserCurrentStationAndDeviceID UserStation = new cstUserCurrentStationAndDeviceID();
UserStation.UserID = Useritem.UserID;
UserStation.UserName = Useritem.UserName;
UserStation.StationName = Useritem.StationName;
UserStation.Datetime = Useritem.Datetime;
UserStation.DeviceID = Useritem.DeviceID;
lsUstation.Add(UserStation);
}
}
catch (Exception)
{ }
return(lsUstation);
}
