public static DetailsModel GetUserDetails() { SqlConnection sqlConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["DatabaseString"].ConnectionString); sqlConnection.Open(); SqlCommand sqlCommand = new SqlCommand("GetUserDetails", sqlConnection); sqlCommand.CommandType = CommandType.StoredProcedure; sqlCommand.Parameters.Add(new SqlParameter("@ID", System.Web.HttpContext.Current.Session["UserName"].ToString())); SqlDataReader sqlDataReader = sqlCommand.ExecuteReader(); sqlDataReader.Read(); DetailsModel details = new DetailsModel(); details.EMail = sqlDataReader[0].ToString(); details.Phone = sqlDataReader[1].ToString(); sqlConnection.Close(); return(details); }
public ActionResult UpdateDetails() { if (System.Web.HttpContext.Current.Session["UserName"] == null) { return(RedirectToAction("logon", "account")); } else { if (System.Web.HttpContext.Current.Session["UserName"].ToString().Equals("Admin")) { return(RedirectToAction("Index", "Admin")); } else { RoomValue.Models.DetailsModel details = UserModel.GetUserDetails(); ViewData["Details"] = details; return(View()); } } }