public QtyForm(PosForm frmpos)
{
InitializeComponent();
connect = new MySqlConnection();
connect.ConnectionString = dbconnect.DataConnection();
fpos = frmpos;
}
public ChangePasswordForm(PosForm frm)
{
InitializeComponent();
connect = new MySqlConnection();
connect.ConnectionString = dbconnect.DataConnection();
f = frm;
}
public LookUpForm(PosForm frm)
{
InitializeComponent();
connect = new MySqlConnection();
connect.ConnectionString = dbconnect.DataConnection();
posform = frm;
this.KeyPreview = true;
}
public SettleForm(PosForm fp)
{
InitializeComponent();
connect = new MySqlConnection();
connect.ConnectionString = dbconnect.DataConnection();
fpos = fp;
this.KeyPreview = true;
}
public SeniorReceipt(PosForm frm)
{
InitializeComponent();
connect = new MySqlConnection();
connect.ConnectionString = dbconnect.DataConnection();
f = frm;
this.KeyPreview = true;
}
public DiscountForm(PosForm form)
{
InitializeComponent();
connect = new MySqlConnection();
connect.ConnectionString = dbconnect.DataConnection();
f = form;
this.KeyPreview = true;
}
private void LoginBtn_Click(object sender, EventArgs e)
{
string _username = "", _role = "", _name = "";
try
{
bool found = false;
connect.Open();
command = new MySqlCommand("SELECT * FROM users_tbl where username = @username AND password = @password", connect);
command.Parameters.AddWithValue("@username", usertxt.Text);
command.Parameters.AddWithValue("@password", passtxt.Text);
DataReader = command.ExecuteReader();
DataReader.Read();
if (DataReader.HasRows)
{
found = true;
_username = DataReader["username"].ToString();
_role = DataReader["role"].ToString();
_name = DataReader["name"].ToString();
}
else
{
found = false;
}
DataReader.Close();
connect.Close();
if (found == true)
{
if (_role == "Cashier")
{
MessageBox.Show("Welcome " + _name + "!", "Access Granted", MessageBoxButtons.OK, MessageBoxIcon.Information);
usertxt.Text = "";
passtxt.Text = "";
this.Hide();
PosForm pf = new PosForm(this);
pf.usernamelbl.Text = _username;
pf.cashierlbl.Text = _name + " | " + _role;
pf.ShowDialog();
}
else if (_role == "Administrator")
{
MessageBox.Show("Welcome " + _name + "!", "Access Granted", MessageBoxButtons.OK, MessageBoxIcon.Information);
usertxt.Text = "";
passtxt.Text = "";
this.Hide();
AdminPage frm = new AdminPage();
frm.nametxt.Text = _name;
frm.usernametxt.Text = _username;
frm.ShowDialog();
}
}
else
{
MessageBox.Show("Invalid username" + _name + "!", "Access Denied", MessageBoxButtons.OK, MessageBoxIcon.Warning);
usertxt.Text = "";
passtxt.Text = "";
}
}
catch (Exception ex)
{
connect.Close();
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}