public SettingsModel getServiceSetting(string _username)
        {
            SettingsModel settings = new SettingsModel();
            using (var cn = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename" +
             "=|DataDirectory|\\Database.mdf; Integrated Security=True"))
            {
                string _sql = @"SELECT TOP 1 [Service], [Email] FROM [dbo].[Settings] " +
                       @"WHERE [Username] = @u";
                var cmd = new SqlCommand(_sql, cn);
                cmd.Parameters
                    .Add(new SqlParameter("@u", SqlDbType.NVarChar))
                    .Value = _username;
                cn.Open();
                var reader = cmd.ExecuteReader();
                if (reader.HasRows)
                {

                    while (reader.Read())
                    {
                        settings.Email = reader["Email"].ToString();
                        settings.UserName = _username;
                        settings.Service = Convert.ToBoolean(reader["Service"]);
                    }
                }
                reader.Dispose();
                cmd.Dispose();
                cn.Close();
            }
            return settings;
        }
        public ActionResult Settings(SettingsModel settings)
        {
            if (User.Identity.IsAuthenticated)
            {
                settings.SaveSettings(User.Identity.Name, settings.Service);
                return View(settings);
            }

            return RedirectToAction("Login", "Account");
        }
 public ActionResult Settings()
 {
     if (ModelState.IsValid)
     {
         if (User.Identity.IsAuthenticated)
         {
             SettingsModel settings = new SettingsModel();
             settings = settings.getServiceSetting(User.Identity.Name);
             return View(settings);
         }
     }
     return View();
 }