public List<Status> GetAllStatussen()
{
List<Status> Statussen = new List<Status>();
try
{
conn.Open();
string select = @"select * from tbl_order_status";
MySqlCommand cmd = new MySqlCommand(select, conn);
MySqlDataReader datareader = cmd.ExecuteReader();
while (datareader.Read())
{
int id = datareader.GetInt16("order_status_id");
string naam = datareader.GetString("status");
Status status = new Status { ID = id, Naam = naam };
Statussen.Add(status);
}
return Statussen;
}
catch (Exception e)
{
return null;
}
finally
{
conn.Close();
}
}
public Status GetStatus(int oid)
{
Status status = null;
try
{
conn.Open();
string select = @"select s.order_status_id, status from tbl_order o join tbl_order_status s on o.order_status_id = s.order_status_id where order_id = @id";
MySqlCommand cmd = new MySqlCommand(select, conn);
MySqlParameter idParam = new MySqlParameter("@id", MySqlDbType.Int16);
idParam.Value = oid;
cmd.Parameters.Add(idParam);
MySqlDataReader datareader = cmd.ExecuteReader();
while (datareader.Read())
{
int statusid = datareader.GetInt16("order_status_id");
string naam = datareader.GetString("status");
status = new Status { ID = statusid, Naam = naam };
}
return status;
}
catch (Exception e)
{
return null;
}
finally
{
conn.Close();
}
}
