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