public List <Rit> AangevraagdeRitten(Models.Ouder ouder) { SqlCommand cmd = new SqlCommand("GetRitten"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("OuderEmail", ouder.email); try { List <DataRow> ritOverview = new List <DataRow>(); ritOverview.AddRange(Connector.ExecuteQueryCommand(cmd)); List <Rit> aangevraagdeRitten = new List <Rit>(); foreach (DataRow dr in ritOverview) { Rit rit = new Rit(Convert.ToDateTime(dr["Date"]), Convert.ToString(dr["BeginTijd"]), Convert.ToString(dr["Beginlocatie"]), Convert.ToString(dr["EindLocatie"]), Convert.ToInt32(dr["RitDuur"])); aangevraagdeRitten.Add(rit); } return(aangevraagdeRitten); } catch (Exception ex) { string message = ex.ToString(); return(null); } }
public bool RegisterUser(Models.Ouder User) { SqlCommand cmd = new SqlCommand("RegisterOuder"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Initialen", User.initialen); cmd.Parameters.AddWithValue("@Achternaam", User.achternaam); cmd.Parameters.AddWithValue("@LoginPin", User.loginPin); cmd.Parameters.AddWithValue("@MobielNr", User.mobielNr); cmd.Parameters.AddWithValue("@TelNr", User.telNr); cmd.Parameters.AddWithValue("@Email", User.email); cmd.Parameters.AddWithValue("@ThuisAdres", User.thuisAdres); cmd.Parameters.AddWithValue("@Leeftijd", User.leeftijd); try { _connector.ExecuteQueryCommand(cmd); return(true); } catch { return(false); } }
public Models.Ouder LoginOuder(string email, string wachtwoord) { SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "SELECT * FROM UserOuder WHERE Email = @Email AND LoginPin = @Login"; cmd.Parameters.AddWithValue("@Email", email); cmd.Parameters.AddWithValue("Login", wachtwoord); try { var ouderInfo = new List <DataRow>(); ouderInfo.AddRange(_connector.ExecuteQueryCommand(cmd)); if (ouderInfo.Count != 0) { foreach (DataRow dr in ouderInfo) { Models.Ouder oud = new Models.Ouder(Convert.ToString(dr["Initialen"]), Convert.ToString(dr["Achternaam"]), Convert.ToString(dr["Email"]), Convert.ToString(dr["TelNr"]), Convert.ToString(dr["MobielNr"]), Convert.ToString(dr["ThuisAdres"]), Convert.ToInt32(dr["Leeftijd"])); Ouder = oud; } return(Ouder); } else { return(null); } } catch (Exception ex) { return(null); } }