private void matBtnLogin_Click(object sender, EventArgs e)
{
//NEW CODE WITH VERIFICATION
IDBHandler handler = new DBHandler();
string username = matTextUsername.Text;
string password = "";
if (username != "")
{
try
{
uspLogin log = new uspLogin();
log = handler.BLL_Login(matTextUsername.Text);
password = log.PersonnelPassword;
if (password == matTextPass.Text)
{
frmLoading loading = new frmLoading();
frmLogin login = this;
lblIncorrect.Visible = false;
login.Hide();
loading.Show();
}
else
{
lblIncorrect.Visible = true;
matTextPass.Text = "";
}
}
catch (Exception)
{
lblIncorrect.Visible = true;
}
}
else
{
lblIncorrect.Visible = true;
}
}
public uspLogin Login(string userID)
{
uspLogin l = null;
SqlParameter[] pars = new SqlParameter[]
{
new SqlParameter("@Username", userID),
};
using (DataTable table = DBHelper.ParamSelect("uspLogin",
CommandType.StoredProcedure, pars))
{
if (table.Rows.Count == 1)
{
DataRow row = table.Rows[0];
l = new uspLogin
{
PersonnelPassword = Convert.ToString(row["PersonnelPassword"])
};
}
}
return(l);
}//EndLogin
