// GET: public ActionResult Index(string searchString, string Filter_Value, int?Page_No) { List <ViewUserDetail> model = new List <ViewUserDetail>(); if (searchString != null) { Page_No = 1; } else { searchString = Filter_Value; } ViewBag.FilterValue = searchString; var userInfo = db.UserProfileInfo.ToList(); var userInfos = from u in db.UserProfileInfo select u; if (!String.IsNullOrEmpty(searchString)) { userInfos = userInfos.Where(s => s.FirstName.Contains(searchString)); } foreach (var item in userInfo) { var viewmodelx = new ViewUserDetail(); viewmodelx.userInfo = item; var userAddress = db.UserAddress.Find(item.addressId); viewmodelx.userAddress = userAddress; //var userGlycemi = db.UserGlycemics.Find(item.userGlycemicId); //viewmodelx.userGlycemic = userGlycemi; //var userMedicine = db.Medicines.Find(item.userMedicineId); model.Add(viewmodelx); } int Size_Of_Page = 2; int No_Of_Page = (Page_No ?? 1); //var view = from a in db.UserProfileInfo // join b in db.UserGlycemics on a.id equals b.UserId // where a.id.Equals(b.UserId) // select new ViewUserDetail { userInfo = a, userGlycemic = b }; return(View(model.ToPagedList(No_Of_Page, Size_Of_Page))); }
public IHttpActionResult GetUsers(string id) { string sqlquery = @"SELECT U.Id, U.Email, U.Username, U.Password, U.Name, U.PhoneNumber, U.EditTime, R.RoleName, S.StatusName FROM dbo.Users AS U INNER JOIN dbo.Roles AS R ON R.Id = U.Roles_Id INNER JOIN dbo.Status AS S ON S.Id = U.Status_Id WHERE Id = {0}"; ViewUserDetail viewUserDetail = db.Database.SqlQuery <ViewUserDetail>(sqlquery, id).First(); //ViewUserDetail viewUserDetail = db.ViewUserDetail.FirstOrDefault(x => x.Id == id); if (viewUserDetail == null) { return(NotFound()); } return(Ok(viewUserDetail)); }