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(); }