public void validateLogin(loginModel Obj) { try { dataAdapterObj = new SqlDataAdapter(); selectCommand = new SqlCommand(); parameterObj = new SqlParameter("@Password", Obj.Password); selectCommand.Parameters.Add(parameterObj); parameterObj1 = new SqlParameter("@Username", Obj.UserName); selectCommand.Parameters.Add(parameterObj1); selectCommand.CommandText = "select count(UserName) from LoginCredentials where UserName=@Username and Password=@Password"; selectCommand.Connection = connectionObj; dataAdapterObj.SelectCommand = selectCommand; dataSetObj = new DataSet(); dataAdapterObj.Fill(dataSetObj); var LoginStatus = (int)dataSetObj.Tables[0].Rows[0][0]; if (LoginStatus <= 0) { throw new LoginFailureException("Incorrect Password... Please try again"); } } catch (LoginFailureException e) { throw new LoginFailureException(e.Message); } catch (Exception e) { throw new LoginFailureException("Select a valid user name please dont enter"); } }
private void Button1_Click(object sender, EventArgs e) // Login Button { menuForm MenuObj = new menuForm(); try { loginModel LoginObj = new loginModel(comboBox1.SelectedValue.ToString(), textBox1.Text); ObjLogin.validateLogin(LoginObj); textBox1.Text = ""; this.Visible = false; DialogResult dr = MenuObj.ShowDialog(this); this.Visible = true; } catch (LoginFailureException s) { MessageBox.Show(s.Message); } }