private void blgnl_Click(object sender, EventArgs e)
{
inf.Username = tbuname.Text;
inf.Password = tbpass.Text;
dt = opr.Login(inf);
if (dt.Rows.Count > 0)
{
usertype = dt.Rows[0][8].ToString().Trim();
string id = dt.Rows[0][0].ToString().Trim();
string status = dt.Rows[0][9].ToString().Trim();
if (usertype == "A")
{
this.Hide();
admin AD = new admin(id);
AD.Show();
}
else if (usertype == "L")
{
this.Hide();
LibraryEmploye le = new LibraryEmploye(id);
le.Show();
}
else if (usertype == "S")
{
if (status == "valid")
{
this.Hide();
Std st = new Std(id);
st.Show();
}
else
{
MessageBox.Show("You are Invalid : Please Wait For Confirmation");
}
}
}
else
{
MessageBox.Show("Invalid Password or Username", "Stooped ", MessageBoxButtons.OK, MessageBoxIcon.Stop);
}
}
private void btnEnter_Click(object sender, EventArgs e)
{
SqlCommand sqlcmd = new SqlCommand();
sqlcmd.Connection = sqlcon;
sqlcmd.CommandType = CommandType.StoredProcedure;
//اسم تابعی که در فایل های sql نوشته ایم
sqlcmd.CommandText = "Logedin";
sqlcmd.Parameters.Add("@UserName", SqlDbType.NVarChar, 15).Value = txtUsername.Text;
sqlcmd.Parameters.Add("@PassWord", SqlDbType.NVarChar, 15).Value = txtPassword.Text;
sqlcmd.Parameters.Add("@r", SqlDbType.Int).Direction = ParameterDirection.ReturnValue;
sqlcon.Open();
sqlcmd.ExecuteNonQuery();
string id = sqlcmd.Parameters["@r"].Value.ToString();
if (id == "1")
{
admin mya = new admin();
mya.Show();
this.Hide();
}
else if (id == "0")
{
MessageBox.Show("نام کاربری یا کلمه عبور اشتباه میباشد", "هشدار", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
Members mym = new Members();
mym.ID = id;
mym.Show();
this.Hide();
}
sqlcon.Close();
txtPassword.Text = "";
txtUsername.Text = "";
}
private void button1_Click(object sender, EventArgs e)
{
this.Hide();
ad.Show();
}
private void btnback_Click(object sender, EventArgs e)
{
this.Hide();
ad.Show();
}