Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public static bool CheckLogin(string _username, string _password)
- {
- try
- {
- string query = $"SELECT count(*), gebruikerid, gen_length FROM gebruiker WHERE username = '{_username}' AND password = '{_password}' GROUP BY gebruikerid, gen_length";
- DataRowCollection data = Database.getData(query);
- if (Convert.ToInt32(data[0][0]) >= 1)
- {
- Datas.Clear();
- User loggedInUser = new User(
- _username,
- _password,
- DateTime.Now,
- Convert.ToInt32(data[0][1]),
- Convert.ToInt32(data[0][2])
- );
- CurrentLoggedInUser = loggedInUser;
- string qry2 = $"SELECT * FROM gegevens WHERE gebruiker_fk = {CurrentLoggedInUser.ID}";
- DataRowCollection dataRows = Database.getData(qry2);
- foreach (System.Data.DataRow item in dataRows)
- {
- DataRow newRow = new DataRow(
- item.Field<String>("domain"),
- item.Field<String>("username"),
- item.Field<String>("password"),
- item.Field<DateTime>("dateCreated"),
- item.Field<Int32>("iddata")
- );
- Datas.Add(newRow);
- }
- return true;
- }else
- return false;
- }
- #region Exceptions
- catch (System.Data.SqlClient.SqlException SE)
- {
- return BadExceptionHandler(SE.Message);
- }
- catch (InvalidOperationException IOE)
- {
- return BadExceptionHandler(IOE.Message);
- }
- catch (IndexOutOfRangeException IORE)
- {
- return BadExceptionHandler(/*IORE+*/"No User found for those login credentials\nPlease try again!\nLog in Failed");
- }
- #endregion
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement