public static void getKorisnikByUsernameAndPassword(DSLogin.KorisniksDataTable dtLogin, string username, string password)
{
SqlConnection cn = Connection.GetConnection();
if (cn.State == System.Data.ConnectionState.Closed)
{
cn.Open();
}
try
{
SqlCommand cmd = new SqlCommand("usp_Login", cn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
if (username != "")
{
cmd.Parameters.Add("@KorisnickoIme", SqlDbType.NVarChar).Value = username;
}
if (password != "")
{
cmd.Parameters.Add("@Lozinka", SqlDbType.NVarChar).Value = password;
}
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
adapter.Fill(dtLogin);
}
finally
{
}
}
private void btnLogin_Click(object sender, EventArgs e)
{
//send txt username and pw to getuserlogin function
var username = txtBox_Username.Text.Trim();
var password = txtBox_Password.Text.Trim();
DSLogin.KorisniksDataTable dtLogin = new DSLogin.KorisniksDataTable();
dtLogin.Clear();
DALogin.getKorisnikByUsernameAndPassword(dtLogin, username, password);
if (dtLogin.Rows.Count == 1)
{
FrmDashboard formDashboard = new FrmDashboard();
this.Hide();
formDashboard.Show();
}
else
{
MessageBox.Show("Check your username and password");
}
}
