public UserDataViewModel Logon(String LoginID, String Pwd)
{
UserDataViewModel v = null;
var qry = db.ResponsibleClass.Where(x => x.Name == LoginID && x.UserData2.Pwd == Pwd);
foreach (ResponsibleClass o in qry)
{
v = new UserDataViewModel();
v.UserID = o.UserData2.UserID;
v.Password = o.UserData2.Pwd;
v.UserName = o.UserData2.UserName;
v.RoleID = o.UserData2.RoleID;
v.StartDate = o.UserData2.StartDate;
v.EndDate = o.UserData2.EndDate;
v.PwdError = o.UserData2.PwdError;
v.Phone1 = o.UserData2.Phone1;
v.Phone2 = o.UserData2.Phone2;
v.Phone3 = o.UserData2.Phone3;
v.Email = o.UserData2.Email;
v.ResponsibleID = o.UserData2.ResponsibleID;
v.LoginID = o.UserData2.LoginID;
}
if (v == null)
{
var qry2 = db.UserData.Where(x => x.LoginID == LoginID && x.Pwd == Pwd);
foreach (UserData o in qry2)
{
v = new UserDataViewModel();
v.UserID = o.UserID;
v.Password = o.Pwd;
v.UserName = o.UserName;
v.RoleID = o.RoleID;
v.StartDate = o.StartDate;
v.EndDate = o.EndDate;
v.PwdError = o.PwdError;
v.Phone1 = o.Phone1;
v.Phone2 = o.Phone2;
v.Phone3 = o.Phone3;
v.Email = o.Email;
v.ResponsibleID = o.ResponsibleID;
v.LoginID = o.LoginID;
}
}
return v;
}
public IQueryable<ViewModels.UserDataViewModel> Read()
{
List<UserDataViewModel> ret = new List<UserDataViewModel>();
var qry = db.UserData;
foreach (UserData o in qry)
{
UserDataViewModel user = new UserDataViewModel();
user.Email = o.Email;
user.EndDate = o.EndDate;
user.LoginID = o.LoginID;
user.Password = o.Pwd;
user.Phone1 = o.Phone1;
user.Phone2 = o.Phone2;
user.Phone3 = o.Phone3;
user.PwdError = o.PwdError;
user.ResponsibleID = o.ResponsibleID;
user.RoleID = o.RoleID;
user.RoleIDStr = o.RoleClass.Name;
user.StartDate = o.StartDate;
user.UserID = o.UserID;
user.UserName = o.UserName;
if(user.UserID != "t00000")
ret.Add(user);
}
return ret.AsQueryable();
}
