private void btnOK_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(cbmname.Text))
{
TfSQL con = new TfSQL();
string sqlpass = "******" + cbmname.Text + "' and user_pass = '******' ";
{
DataTable dt = new DataTable();
dt = con.sqlExecuteReader(sqlpass);
//if (con.sqlExecuteScalarString(sqlpass) == cbmname.Text)
if (dt.Rows.Count > 0 && dt.Rows[0]["user_name"].ToString() == cbmname.Text && dt.Rows[0]["user_pass"].ToString() == txtpass.Text)
{
UserData.usercode = dt.Rows[0]["user_name"].ToString();
UserData.username = dt.Rows[0]["full_name"].ToString();
UserData.isadmin = bool.Parse(dt.Rows[0]["admin_flag"].ToString());
MainFrm dg = new MainFrm();
this.Hide();
dg.ShowDialog();
this.Close();
}
else
{
MessageBox.Show("Pass is not correct", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
else
{
MessageBox.Show("User name is null.", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void Login_Load(object sender, EventArgs e)
{
if (System.Deployment.Application.ApplicationDeployment.IsNetworkDeployed)
{
Version deploy = System.Deployment.Application.ApplicationDeployment.CurrentDeployment.CurrentVersion;
StringBuilder version = new StringBuilder();
version.Append("VERSION: ");
version.Append(deploy.Major);
version.Append("_");
version.Append(deploy.Build);
version.Append("_");
version.Append(deploy.Revision);
lbVersion.Text = version.ToString();
}
cbmname.Focus();
TfSQL con = new TfSQL();
string sql = "select distinct user_name from iqc_user order by user_name";
con.getComboBoxData(sql, ref cbmname);
AcceptButton = btnOK;
}