/* 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;
}
}
}
