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