/// <summary> /// Details of Registered Users /// </summary> /// <param name="id"></param> /// <returns></returns> public ActionResult RegisteredUserDetails(int?id) { NetUserViewModel objNetUserViewModel = new NetUserViewModel(); try { ViewBag.SendId = id; var getUser = (from d in objEntities.Address join c in objEntities.NetUsers on d.UserId equals c.UserId join s in objEntities.UserRole on c.UserId equals s.UserId join e in objEntities.SubjectInCourse on c.CourseId equals e.CourseId where d.UserId == id select new NetUserViewModel { UserId = c.UserId, FirstName = c.FirstName, LastName = c.LastName, Password = c.Password, RoleId = s.RoleId, Gender = c.Gender, DOB = c.DOB, Email = c.Email, IsVerified = c.IsVerified, IsActive = c.IsActive, DateCreated = c.DateCreated, CourseName = c.Courses.CourseName, CurrentAddress = d.CurrentAddress, PermanantAddress = d.PermanantAddress, Country = d.Countries.CountryName, States = d.States.StateName, Cities = d.Cities.CityName, Pincode = d.Pincode }).FirstOrDefault(); return(View(getUser)); } catch (Exception er) { Console.Write(er.Message); return(View()); } }
public ActionResult RegisterUser() { //TO GET ROLES FROM DATABASE var roles = (from b in objEntities.NetRoles select b).ToList(); var model = new NetUserViewModel { Role = roles.Select(x => new SelectListItem { Value = x.RoleId, Text = x.RoleName }).ToList() }; //GET : COURSE FOR USERS var course = (from b in objEntities.Courses select b).ToList(); model.Course = course.Select(x => new SelectListItem { Value = x.CourseId.ToString(), Text = x.CourseName }); //TO GET COUNTRY ,STATES AND CITY { var country = objEntities.Countries.ToList(); List <SelectListItem> listCountry = new List <SelectListItem>(); List <SelectListItem> listState = new List <SelectListItem>(); List <SelectListItem> listCity = new List <SelectListItem>(); foreach (var m in country) { listCountry.Add(new SelectListItem { Text = m.CountryName, Value = m.CountryId.ToString() }); } ViewBag.country = listCountry; ViewBag.State = listState; ViewBag.City = listCity; } return(View(model)); }
/// <summary> /// List of all Registered User /// </summary> /// <returns></returns> public ActionResult RegisteredUserList() { // Get user roles from DB ViewBag.Role = new SelectList(objEntities.NetRoles.ToList(), "RoleId", "RoleName"); List <NetUserViewModel> objNetUserViewModel = new List <NetUserViewModel>(); //Get List of users from DB var data = (from p in objEntities.NetUsers select p).ToList(); foreach (var item in data) { //To get Address From DB var userAddressInfo = (from p in objEntities.Address where p.UserId == item.UserId select p).FirstOrDefault(); if (userAddressInfo != null) { NetUserViewModel netUser = new NetUserViewModel { UserId = item.UserId, FirstName = item.FirstName, LastName = item.LastName, Gender = item.Gender, Email = item.Email, Password = item.Password, DOB = item.DOB, IsActive = item.IsActive, CurrentAddress = userAddressInfo.CurrentAddress, PermanantAddress = userAddressInfo.PermanantAddress, Country = userAddressInfo.Countries.CountryName, States = userAddressInfo.States.StateName, Cities = userAddressInfo.Cities.CityName, DateCreated = item.DateCreated }; objNetUserViewModel.Add(netUser); } } ; return(View(objNetUserViewModel)); }
public ActionResult RegisterUser(NetUserViewModel objNetUserViewModel) { using (var dbTransaction = objEntities.Database.BeginTransaction()) { ViewBag.Role = new SelectList(objEntities.NetRoles.ToList(), "RoleId", "RoleName"); try { if (ModelState.IsValid) { //Encrytion For Password var keyNew = "Test"; var password = Helper.EncodePassword(objNetUserViewModel.Password, keyNew); NetUsers objNetUsers = new NetUsers { FirstName = objNetUserViewModel.FirstName, LastName = objNetUserViewModel.LastName, Gender = objNetUserViewModel.Gender, CourseId = objNetUserViewModel.CourseId, Email = objNetUserViewModel.Email, Password = password, DOB = objNetUserViewModel.DOB, IsActive = objNetUserViewModel.IsActive, DateCreated = DateTime.Now, DateModified = DateTime.Now, }; objEntities.NetUsers.Add(objNetUsers); objEntities.SaveChanges(); //to get userId var userId = objNetUsers.UserId; // to specify UserRole according to their UserI UserRole objUserRole = new UserRole { RoleId = objNetUserViewModel.RoleId, UserId = userId }; objEntities.UserRole.Add(objUserRole); objEntities.SaveChanges(); //to add data in Address Table Address objAddress = new Address { CountryId = objNetUserViewModel.CountryId, StateId = objNetUserViewModel.StateId, CityId = objNetUserViewModel.CityId, CurrentAddress = objNetUserViewModel.CurrentAddress, PermanantAddress = objNetUserViewModel.PermanantAddress, Pincode = objNetUserViewModel.Pincode, UserId = userId }; objEntities.Address.Add(objAddress); objEntities.SaveChanges(); dbTransaction.Commit(); ModelState.Clear(); return(RedirectToAction("RegisteredUser", "LogIn")); } return(View(objNetUserViewModel)); } catch (Exception ex) { dbTransaction.Rollback(); Console.WriteLine("Exception source: {0} user is failed to register", ex.Message); return(View(ex)); } } }