public static Control showStudents()
{
List <SomerenModel.Student> sl = new List <SomerenModel.Student>();
//SomerenDB.
SomerenModel.Student s1 = new SomerenModel.Student();
s1.setName("Henk");
SomerenModel.Student s2 = new SomerenModel.Student();
s2.setName("Piet");
SomerenModel.Student s3 = new SomerenModel.Student();
s3.setName("Amber");
sl.Add(s1);
sl.Add(s2);
sl.Add(s3);
int aantal = sl.Count();
ListView c = new ListView();
c.Height = 1000;
ListViewItem li = new ListViewItem();
li.SubItems.Add(s1.getName());
li.SubItems.Add(s1.getId().ToString());
c.Items.Add(s1.getName());
c.Items.Add(s2.getName());
c.Items.Add(s3.getName());
c.Items.Add(li);
return(c);
}
//Door Juan
public void bestel(SomerenModel.Student student, SomerenModel.DrankVoorraad voorraad)
{
SqlConnection connection = openConnectieDB();
StringBuilder sb = new StringBuilder();
sb.Append("INSERT INTO [dbo].[B8_Verkopen] ([student] ,[datum] ,[drankId] ,[aantal])");
sb.Append(" VALUES (@student, @datum, @drankId, @aantal)");
String sql = sb.ToString();
SqlCommand command = new SqlCommand(sql, connection);
SqlParameter studentParam = new SqlParameter("@student", System.Data.SqlDbType.Int);
SqlParameter datum = new SqlParameter("@datum", System.Data.SqlDbType.DateTime);
SqlParameter drankId = new SqlParameter("@drankId", System.Data.SqlDbType.Int);
SqlParameter aantal = new SqlParameter("@aantal", System.Data.SqlDbType.Int);
studentParam.Value = student.getId();
datum.Value = DateTime.Now;
drankId.Value = voorraad.getId();
aantal.Value = 1;
command.Parameters.Add(studentParam);
command.Parameters.Add(datum);
command.Parameters.Add(drankId);
command.Parameters.Add(aantal);
command.Prepare();
command.ExecuteNonQuery();
sluitConnectieDB(connection);
}
public static Control showStudents()
{
List <SomerenModel.Student> sl = SomerenDB.DB_gettudents();
ListViewItem li = new ListViewItem();
ListView c = new ListView();
foreach (var item in sl)
{
SomerenModel.Student Student = new SomerenModel.Student();
Student.setNaam(item.getNaam());
li.SubItems.Add(Student.getNaam());
li.SubItems.Add(Student.getId().ToString());
c.Items.Add(Student.getNaam());
c.Items.Add(li);
}
int aantal = sl.Count();
c.Height = 1000;
return(c);
}
public static Control showDocent()
{
List <SomerenModel.Docent> dl = SomerenDB.DB_GetDocent();
ListViewItem li = new ListViewItem();
ListView c = new ListView();
foreach (var item in dl)
{
SomerenModel.Student Docent = new SomerenModel.Student();
Docent.setNaam(item.getNaam());
li.SubItems.Add(Docent.getNaam());
li.SubItems.Add(Docent.getId().ToString());
c.Items.Add(Docent.getNaam());
c.Items.Add(li);
}
int aantal = dl.Count();
c.Height = 1000;
return(c);
}
