public DataTable userControl(user user) { string username = user.userName; string pas = user.passwordd; createConnection(); SqlDataAdapter adapter = new SqlDataAdapter("Select name,surname,userName from userdb Where userName= '******' AND passwordd='"+pas+"'", connection); adapter.Fill(table); return table; }
public void UserAdd(user user) { createConnection(); connection.Open(); SqlCommand command = new SqlCommand(); command.Connection = connection; command.CommandType = CommandType.StoredProcedure; command.CommandText = "UserAdd"; command.Parameters.Add("@name", SqlDbType.NVarChar, 50); command.Parameters["@name"].Value = user.name; command.Parameters.Add("@surname", SqlDbType.NVarChar, 50); command.Parameters["@surname"].Value = user.surname; command.Parameters.Add("@userName", SqlDbType.NVarChar, 50); command.Parameters["@userName"].Value = user.userName; command.Parameters.Add("@passwordd", SqlDbType.NVarChar,50); command.Parameters["@passwordd"].Value = user.passwordd; command.ExecuteNonQuery(); connection.Close(); connection.Dispose(); }
private void button1_Click(object sender, EventArgs e) { bool user = false; //string line; //System.IO.StreamReader database = new System.IO.StreamReader("users.in"); //while (!database.EndOfStream) { user = true; user currentUser = new user(); //line=database.ReadLine(); //string username = ""; //int i = 0; //for(i=0;line[i]!=' ';i++) //{ linqtoregdbDataContext db = new linqtoregdbDataContext(); bool valid = false; var queryIsUsername = from usr in db.users select usr; List <string> allUsernames = new List <string>(); foreach (var c in queryIsUsername) { allUsernames.Add(c.username.ToLower()); if (c.username.ToLower() == maskedTextBox1.Text.ToLower()) { User.username = c.username; valid = true; currentUser = c; } } if (currentUser.password != Hasher.GetHash(maskedTextBox2.Text).ToString()) { MessageBox.Show("Invalid username/password combination!"); } else { //username += line[i]; //if (maskedTextBox1.Text.ToString().ToLower()[i] != char.ToLower(line[i])) //{ // user = false; // break; //} //} //if (user) //{ // User.username = username; // i = 11; // user = false; // foreach (char c in maskedTextBox2.Text.ToString()) // { // user = true; // if (c != line[i]) // { // user = false; // break; // } // i++; // } // if (user) //{ //i = 70; //string status=""; //for(i=70;i<line.Length&&line[i]!='\n'&&line[i]!=' ';i++) // status+=line[i]; string name = "Welcome,\n"; name += currentUser.lastName + ", " + currentUser.firstName; //for (i = 22; line[i] != ' '; i++) // name += line[i]; MessageBox.Show(name); User.type = currentUser.usertype; //if (User.type == "admin") //{ // AdminWindow adminScreen = new AdminWindow(this, User); // adminScreen.Show(); //} //else if (User.type == "faculty") //{ // FacultyHome facultyScreen = new FacultyHome(User, this); // facultyScreen.Show(); //} //else //{ Home screen = new Home(this, User); screen.Show(); //} this.Hide(); } } //if (maskedTextBox2.Text.ToString() == "pong") //{ // linqtoregdbDataContext db = new linqtoregdbDataContext(); // var queryUsername = from usr in db.users // where usr.username.ToLower()==maskedTextBox1.Text.ToLower() // select usr.username; // if (queryUsername.Count() == 1) // { // PongForm pongWindow = new PongForm(this,queryUsername.First()); // pongWindow.Show(); // this.Hide(); // } // /*MessageBox.Show("Welcome"); // Classes screen = new Classes(this); // screen.Show(); // this.Hide();*/ //} //database.Close(); maskedTextBox2.Text = ""; //maskedTextBox1.Text=""; }