protected void Login()
        {
            UsersTableAdapter ta = new UsersTableAdapter();

            DataSet1.UsersDataTable userDataTable = new DataSet1.UsersDataTable();
            ta.Fill(userDataTable);
            string passWord = (userDataTable.AsEnumerable().Where(x => x.userName == TextBoxUser.Text).Select(x => x.password.ToString()).First());

            if (TextBoxPw.Text == passWord)
            {
                Session["UserName"]   = TextBoxUser.Text;
                Session["PersonName"] = (userDataTable.AsEnumerable().Where(x => x.userName == TextBoxUser.Text).Select(x => x.personName.ToString()).First());
                Response.Redirect("OrderPage.aspx", true);
            }
        }
Example #2
0
 public Boolean IsSignUp(string TwitterID)
 {
     MyUsersDataTable = MyUsersTableAdapter.GetIDByTwitterID(TwitterID);
     if (MyUsersDataTable.Rows.Count > 0)
     {
         return true;
     }
     else
     {
         return false;
     }
 }
Example #3
0
 public string GetID(string TwitterID)
 {
     MyUsersDataTable = MyUsersTableAdapter.GetIDByTwitterID(TwitterID);
     foreach (DataSet1.UsersRow row in MyUsersDataTable.Rows)
     {
         return row.IdOfUser.ToString();
     }
     return "0";
 }