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