private string loginMsSql()
{
cKoneksi koneksi = new cKoneksi();
string role = string.Empty;
var con = new SqlConnection(koneksi.konekMsSql('1'));//// konek ke 10.0.1.64 db parkir
cQuery qr = new cQuery();
SqlCommand cmd = new SqlCommand(qr.qSelectUserLoginMsSql(), con);
cmd.Parameters.AddWithValue("@username", this.textBox_username.Text);
cmd.Parameters.AddWithValue("@password", this.textBox_pass.Text);
try
{
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
if (dr.HasRows == true)
{
role = dr.GetString(1);
cVarGlobal.isAplication = dr.GetString(2);//set hak akses aplikasi
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
role = string.Empty;
}
finally
{
con.Close();
con.Dispose();
}
return(role);
}
