private void btnFill_Click(object sender, RoutedEventArgs e)
{
ds = new UserCityDataSet();
UsersTableAdapter daUser = new UsersTableAdapter();
daUser.Fill(ds.Users);
CitiesTableAdapter daCity = new CitiesTableAdapter();
daCity.Fill(ds.Cities);
dgUser.ItemsSource = ds.Users.DefaultView;
dgCity.ItemsSource = ds.Cities.DefaultView;
}
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);
}
}
protected void CreateNewUser()
{
UsersTableAdapter ta = new UsersTableAdapter();
ta.Fill(ds.Users);
DataRow dr = ds.Users.NewRow();
dr["userName"] = TextBoxUsername.Text;
dr["password"] = TextBoxPw.Text;
dr["personName"] = TextBoxName.Text;
dr["personAddress"] = TextBoxAddress.Text;
ds.Tables["Users"].Rows.Add(dr);
ta.Update(ds.Users);
LabelError.Text = "Account Created Successfully";
Response.Redirect("Default.aspx");
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
usersTableAdapter.Fill(dataSet.Users);
DataContext = dataSet.Users.DefaultView;
}
