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);
}
}
