private void da_Click(object sender, EventArgs e)
{
dash frm = new dash();
this.Visible = false;
frm.ShowDialog();
this.Close();
}
private void metroButton1_Click(object sender, EventArgs e)
{
try
{
SQLCON.openConn();
//SQLCON.cnn.Open();
MySqlCommand cmd = new MySqlCommand("Select * from tbluser Where userName=@user And pwd=@pwd", SQLCON.cnn);
cmd.Parameters.AddWithValue("@user", txtUser.Text);
cmd.Parameters.AddWithValue("@pwd", txtPwd.Text);
MySqlDataAdapter da = new MySqlDataAdapter(cmd);
DataTable dtlogin = new DataTable();
da.Fill(dtlogin);
SQLCON.cnn.Close();
if (dtlogin.Rows.Count > 0)
{
//this.Hide();
dash frmMain = new dash();
// login ln = new login();
this.Hide();
frmMain.Show();
//ln.Close();
}
else
{
MessageBox.Show("Invalid");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
SQLCON.cnn.Close();
}
}
public static void login(TextBox un, TextBox pw, Label l, Form lgfrm, PictureBox p1, PictureBox p2)
{
DBconnect conn = new DBconnect();
conn.DBopen();
try
{
conn.SqlQuery("SELECT user_name,password,desig from login WHERE user_name = '" + un.Text + "' AND password ='******' ");
DataTable dt = conn.SelQryEx();
SqlDataReader re = conn.SelQryRedEx();
re.Read();
if (un.Text == "User Name" || pw.Text == "Password")
{
MessageBox.Show("Please enter the user name and the password");
p1.Image = Resources.userRed;
p2.Image = Resources.locked_padlockR;
un.Text = "User Name";
un.ForeColor = Color.FromArgb(218, 214, 218);
pw.Text = "Password";
pw.ForeColor = Color.FromArgb(218, 214, 218);
}
else
{
if (dt.Rows.Count == 0)
{
MessageBox.Show("Invalid Username or Password.");
un.Clear();
pw.Clear();
l.Text = "Wrong username or password.Try again.";
l.ForeColor = Color.FromArgb(232, 17, 35);
l.Visible = true;
lgfrm.ActiveControl = un;
p1.Image = Resources.userRed;
p2.Image = Resources.locked_padlockR;
}
else
{
l.Visible = false;
if (re.HasRows)
{
string desig = (string)(re[2]);
if (desig == "Sales")
{
dash frm = new dash();
lgfrm.Visible = false;
frm.ShowDialog();
}
else if (desig == "Account")
{
AccountingManagementSysem.Hm frm = new AccountingManagementSysem.Hm();
lgfrm.Visible = false;
frm.ShowDialog();
}
else if (desig == "Manu")
{
Manufacturing_Management_System.manudashboard frm = new Manufacturing_Management_System.manudashboard();
lgfrm.Visible = false;
frm.ShowDialog();
}
else if (desig == "Purch")
{
Project001.viewinvoice frm = new Project001.viewinvoice();
lgfrm.Visible = false;
frm.ShowDialog();
}
else if (desig == "Ship")
{
Package_and_shipment.homepage frm = new Package_and_shipment.homepage();
lgfrm.Visible = false;
frm.ShowDialog();
}
else if (desig == "Main")
{
AccountingManagementSysem.Hm frm = new AccountingManagementSysem.Hm();
lgfrm.Visible = false;
frm.ShowDialog();
}
}
}
}
}
catch (Exception er)
{
MessageBox.Show(er.Message);
}
finally
{
conn.DBclose();
}
}
private void button5_Click(object sender, EventArgs e)
{
dash frm = new dash();
frm.Show();
}