public ActionResult EdituserProfile()
{
var UserID = User.Identity.GetUserId();
var user = db.Users.Where(a => a.Id == UserID).SingleOrDefault();
ViewAllUsers profile = new ViewAllUsers();
profile.UserName = user.UserName;
profile.Email = user.Email;
profile.ssn = user.ssn;
profile.PhoneNumber = user.PhoneNumber;
profile.wallet = user.wallet;
profile.PhoneNumber = user.PhoneNumber;
profile.Usertype = user.Usertype;
return(View(profile));
}
public ActionResult EdituserProfile(ViewAllUsers profile)
{
var UserID = User.Identity.GetUserId();
var user = db.Users.Where(a => a.Id == UserID).SingleOrDefault();
var NewPasswordHash = UserManager.PasswordHasher.HashPassword(profile.NewPassword);
user.Email = profile.Email;
user.UserName = profile.UserName;
user.ssn = profile.ssn;
user.PhoneNumber = profile.PhoneNumber;
user.wallet = profile.wallet;
user.PasswordHash = NewPasswordHash;
db.Entry(user).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
ViewBag.Massage = "update successfully ";
return(View());
}
//get userlist by joining various table
public IEnumerable <ViewAllUsers> GetAllUsers()
{
List <ViewAllUsers> UserList = new List <ViewAllUsers>();
using (SqlConnection con = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand("SpTbleUserView", con);
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
ViewAllUsers user = new ViewAllUsers();
user.PISNo = Convert.ToInt32(rdr["PISNo"]);
user.Name = rdr["Name"].ToString();
user.CoyName = rdr["CoyName"].ToString();
user.RankName = rdr["RankName"].ToString();
UserList.Add(user);
}
con.Close();
}
return(UserList);
}
