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