Untitled

@{
   Layout = "~/Admin/_SiteLayout.cshtml";
   Page.Title = "- Login";

  var db = Database.Open("blog1.3");
  var selectQueryString = "SELECT * FROM users";

  var postId = UrlData[0];

  var row = db.QuerySingle(selectQueryString, postId);

  var username = row.username;
  var password = row.password;

  if (IsPost)
  {
    //read the username
    username = Request["username"];
     if (String.IsNullOrEmpty(username))
    {
      ModelState.AddError("username", "Username is required.");
    }

    if (username != row.username)
    {
      ModelState.AddError("username", "Username does not exist.");
    }

    //read the password
    password = Request["password"];
    if (String.IsNullOrEmpty(password))
    {
      ModelState.AddError("password", "Password is required.");
    }

    //Check inputted password against password on record.
    if (password != row.password)
    {
      ModelState.AddError("password", "Password is incorrect.");
    }

    if ((username == row.username) && (password == row.password))
    {
      Session["username"] = username;
      Response.Redirect(@Href("~/Admin/admin-index"));
    }
  }
 }


<!DOCTYPE html>

<html lang="en">
    <head>
        <meta charset="utf-8" />
        <title> Tattoo Admin Login</title>
    </head>
    <body>

      @Html.ValidationSummary("Errors with your submission:")

      <form method="post">
        <table width="100% " align="center" border="1">
          <tr>
            <td align="center">
              Username:
            </td>
            <td>
              <input type="text" name="username" size="50" maxlength="50" value="@username" />
            </td>
          </tr>
          <tr>
            <td align="center">
              Password:@row.password
            </td>
            <td>
              <input type="password" name="password" size="50" maxlength="50" value="@password" />
            </td>
          </tr>
          <tr>
            <td>
              &nbsp;
            </td>
            <td>
              <input type="submit" name="submit" value="Login" />
              <input type="reset" name="reset" value="Reset" />
              &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
              <a href="./forgotpass.cshtml">Forgot Password?</a>
            </td>
          </tr>
        </table>
      </form>
    </body>
</html>