/* public static LoginDTO searchUser(int id) * { * LoginDTO user = new LoginDTO(); * try * { * String query = "select * from login where id=@id;"; * MySqlCommand command = new MySqlCommand(query, conn); * command.Parameters.AddWithValue("@id", id); * conn.Open(); * * MySqlDataReader dataReader = command.ExecuteReader(); * //int result = command.ExecuteNonQuery(); * //using (SqlDataReader reader = command.ExecuteReader()) * //int count = 0; * * while (dataReader.Read()) * { * user.setPassword(dataReader["password"].ToString()); * user.setLoginid(Int32.Parse(dataReader["id"].ToString())); * user.setPosition(dataReader["position"].ToString()); * user.setUsername(dataReader["username"].ToString()); * //Console.WriteLine(dataReader["NIC"] + " " + dataReader["Name"] + " " + dataReader["Address"]); * //count++; * } * * * } * catch (Exception ex) * { * Console.WriteLine("Error: " + ex.Message); * return null; * } * * Console.Read(); * conn.Close(); * return user; * } */ public static UserLoginDTO searchUser(string username) { UserLoginDTO user = new UserLoginDTO(); try { String query = "select * from userlogin where username=@username;"; MySqlCommand command = new MySqlCommand(query, conn); command.Parameters.AddWithValue("@username", username); conn.Open(); MySqlDataReader dataReader = command.ExecuteReader(); //int result = command.ExecuteNonQuery(); //using (SqlDataReader reader = command.ExecuteReader()) //int count = 0; while (dataReader.Read()) { user.setPassword(dataReader["password"].ToString()); user.setName(dataReader["name"].ToString()); user.setPosition(dataReader["position"].ToString()); user.setUsername(dataReader["username"].ToString()); //Console.WriteLine(dataReader["NIC"] + " " + dataReader["Name"] + " " + dataReader["Address"]); //count++; } /*if(count==0) * MessageBox.Show("No relevant data..");*/ } catch (Exception ex) { Console.WriteLine("Error: " + ex.Message); conn.Close(); return(null); } Console.Read(); conn.Close(); return(user); }
public static Boolean createUser(UserLoginDTO userLoginDTO) { int result = 0; try { String query = "INSERT INTO pos.userlogin (username,name,password,position) VALUES (@username, @name, @password,@position)"; MySqlCommand command = new MySqlCommand(query, conn); //Console.WriteLine(custDTO.getNic()+" "+custDTO.getName()); command.Parameters.AddWithValue("username", userLoginDTO.getUsername()); command.Parameters.AddWithValue("@name", userLoginDTO.getName()); command.Parameters.AddWithValue("@password", userLoginDTO.getPassword()); command.Parameters.AddWithValue("@position", userLoginDTO.getPosition()); conn.Open(); result = command.ExecuteNonQuery(); } catch (Exception ex) { Console.WriteLine("Error: " + ex.Message); conn.Close(); return(false); } Console.Read(); conn.Close(); if (result == 1) { return(true); } else { return(false); } }
private void Loginbtn_Click(object sender, EventArgs e) { try { /*LoginDTO loginDTO = LoginController.searchUser(int.Parse(txtUserName.text)); * if (loginDTO.getLoginid() == int.Parse(txtUserName.text) && loginDTO.getPassword() == txtPassword.text) * { * this.Hide(); * main m = new main(loginDTO.getUsername()); * m.ShowDialog(); * } * else * { * MessageBox.Show("Invalid Username or password "); * txtUserName.text = ""; * txtPassword.text = ""; * txtUserName.Focus(); * }*/ UserLoginDTO loginDTO = LoginController.searchUser((txtUserName.text)); if (loginDTO.getUsername() == txtUserName.text && loginDTO.getPassword() == txtPassword1.Text) { this.Hide(); main m = new main(loginDTO.getName(), loginDTO.getPosition()); m.ShowDialog(); } else { MessageBox.Show("Invalid Username or password "); txtUserName.text = ""; txtPassword1.Text = ""; txtUserName.Focus(); } } catch (Exception ex) { MessageBox.Show("Invalid Username or password "); Console.WriteLine(ex.ToString()); } }
private void BtnUserSearch_Click(object sender, EventArgs e) { string searchUser = txtUserSearch.Text; UserLoginDTO userLoginDTO = LoginController.searchUser(searchUser); if (userLoginDTO == null) { MessageBox.Show("No user found...."); } else { txtUsername.Text = userLoginDTO.getUsername(); txtName.Text = userLoginDTO.getName(); if (userLoginDTO.getPosition() == "M") { rdbManager.Checked = true; } else { rdbUser.Checked = true; } } }