public List <Photographer> getPhotographers() { List <Photographer> photographerList = new List <Photographer>(); NpgsqlConnection db = DBConnection.Instance.initialize(); NpgsqlCommand cmd_photo = new NpgsqlCommand("Select * from fotograf", db); try { cmd_photo.Prepare(); } catch { Console.WriteLine("Invalid query"); } NpgsqlDataReader reader_photo = cmd_photo.ExecuteReader(); cmd_photo.Dispose(); while (reader_photo.Read()) { Photographer temp_photo = new Photographer(); temp_photo.setId(reader_photo.GetInt32(0)); temp_photo.setVorname(reader_photo.GetString(1)); temp_photo.setNachname(reader_photo.GetString(2)); temp_photo.setDate(reader_photo.GetDateTime(3)); if (!reader_photo.IsDBNull(4)) { temp_photo.setNotiz(reader_photo.GetString(4)); } photographerList.Add(temp_photo); } reader_photo.Close(); return(photographerList); }
public Photographer getPhotographerById(int Id) { Photographer temp_photo = new Photographer(); NpgsqlConnection db = DBConnection.Instance.initialize(); NpgsqlCommand cmd_getphoto = new NpgsqlCommand("Select * from fotograf WHERE pk_fotograf_id = @p;", db); cmd_getphoto.Parameters.AddWithValue("p", Id); try { cmd_getphoto.Prepare(); } catch { Console.WriteLine("Invalid query"); } NpgsqlDataReader reader_getphoto = cmd_getphoto.ExecuteReader(); cmd_getphoto.Dispose(); while (reader_getphoto.Read()) { temp_photo.setId(reader_getphoto.GetInt32(0)); temp_photo.setVorname(reader_getphoto.GetString(1)); temp_photo.setNachname(reader_getphoto.GetString(2)); temp_photo.setDate(reader_getphoto.GetDateTime(3)); if (!reader_getphoto.IsDBNull(4)) { temp_photo.setNotiz(reader_getphoto.GetString(4)); } } reader_getphoto.Close(); return(temp_photo); }
public void editPhotographer(Photographer photogr) { // setzt Fotografendaten, dient für einen void Unit test editPhoto.setVorname("Marius"); editPhoto.setNachname("Hochwald"); editPhoto.setVorname(photogr.getVorname()); editPhoto.setVorname(photogr.getNachname()); }
public void editPhotographer(Photographer photogr) { NpgsqlConnection db = DBConnection.Instance.initialize(); NpgsqlCommand cmd_editp = new NpgsqlCommand("UPDATE fotograf SET vorname = @p , nachname = @q , geburtsdatum = @r , notiz = @s WHERE pk_fotograf_id = @t", db); cmd_editp.Parameters.AddWithValue("p", photogr.getVorname()); cmd_editp.Parameters.AddWithValue("q", photogr.getNachname()); cmd_editp.Parameters.AddWithValue("r", photogr.getDate()); cmd_editp.Parameters.AddWithValue("s", photogr.getNotiz()); cmd_editp.Parameters.AddWithValue("t", photogr.getId()); cmd_editp.ExecuteNonQuery(); cmd_editp.Dispose(); }
public void AddPhotographer() { var p = new Photographer(); p.setDate(Geburtsdatum); p.setVorname(Vorname); p.setNachname(Nachname); p.setNotiz(Notiz); BL test = new BL(); test.addPhotographer(p); OnPropertyChanged("Names"); }
public List <Photographer> getPhotographers() { List <Photographer> test = new List <Photographer>(); // setzt Dummy Daten in eine Fotografenliste for (int i = 0; i < 3; i++) { Photographer temp = new Photographer(); temp.setDate(new DateTime(2012, 2, 12, 0, 0, 0)); temp.setVorname("Marius"); temp.setNachname("Hochwald"); temp.setNotiz("Das ist eine Notiz"); test.Add(temp); } return(test); }
public Photographer randomPhotographer() { var rand = new Random(); var p = new Photographer(); string[] vornamen = new string[5] { "Liam", "Noah", "William", "James", "Oliver" }; string[] nachnamen = { "Smith", "Johnson", "Williams", "Brown", "Jones" }; DateTime date = new DateTime(1980, rand.Next() % 13, rand.Next() % 30); p.setDate(date); p.setVorname(vornamen[(rand.Next()) % (vornamen.Length)]); p.setNachname(nachnamen[(rand.Next()) % (nachnamen.Length)]); p.setNotiz("das ist eine Notiz"); return(p); }
public void addPhotographer(Photographer newPhotographer) { NpgsqlConnection db = DBConnection.Instance.initialize(); NpgsqlCommand cmd_addphoto = new NpgsqlCommand("INSERT INTO fotograf(vorname, nachname, geburtsdatum, notiz) values (@p, @q, @r, @s)", db); // beim Prepare statement werden die übermittelten Parameter für die query so gesetzt. cmd_addphoto.Parameters.AddWithValue("p", newPhotographer.getVorname()); cmd_addphoto.Parameters.AddWithValue("q", newPhotographer.getNachname()); cmd_addphoto.Parameters.AddWithValue("r", newPhotographer.getDate()); cmd_addphoto.Parameters.AddWithValue("s", newPhotographer.getNotiz()); try { cmd_addphoto.Prepare(); } catch { Console.WriteLine("Invalid query"); } cmd_addphoto.ExecuteNonQuery(); cmd_addphoto.Dispose(); }
public void printReport(Picture p) { //setzt das Verzeichnis der Bilder und der Berichte string startupPath = System.IO.Directory.GetCurrentDirectory(); string pathReport = startupPath + "../../../../reports/"; string pathPicture = startupPath + "../../../../res/"; // holt sich Namen des Files und schneidet das .png/.jpg etc. raus string pic = p.getDirectory(); string name = pic.Split('.')[0]; // neue Instanz von HtmlToPdf wird erstellt // und dem String werden HTML Elemente mit den Bilderdaten hinzugefügt var htmlToPdf = new HtmlToPdf(); var html = @"<h1>" + name + "</h1><br>"; html += "<p>Iso Speed Ratings: " + p.getExif().getIsoSpeedRating() + "</p>"; html += "<p>Make: " + p.getExif().getMake() + "</p>"; html += "<p>Date Time: " + p.getExif().getDateTime() + "</p>"; html += "<p>Flash: " + p.getExif().getFlash() + "</p>"; html += "<p>Exposure Time: " + p.getExif().getExposureTime() + "</p>"; html += "<p>Date created: " + p.getIptc().getDate() + "</p>"; html += "<p>Time created: " + p.getIptc().getTime() + "</p>"; html += "<p>By-Line: " + p.getIptc().getByLine() + "</p>"; html += "<p>Copyright: " + p.getIptc().getCopyright() + "</p>"; html += "<img src='" + pathPicture + pic + "'>"; Photographer ph = _dal.getPhotographerById(p.getPhotographerId()); html += "<p>Fotograf: " + ph.getVorname() + " " + ph.getNachname() + "</p>"; // HTML zu PDF var pdf = htmlToPdf.RenderHtmlAsPdf(html); // Speichert das PDF pdf.SaveAs(pathReport + name + ".Pdf"); }
public void editPhotographData(Photographer ph) { //Daten eines Fotografen werden in der DB geändert _dal.editPhotographer(ph); }
public void addPhotographer(Photographer newPhotographer) { // fügt einen Fotografen der DB hinzu _dal.addPhotographer(newPhotographer); }
public void addPhotographer(Photographer temp) { //fügt den DUmmy Fotografen in der Dummy Liste hinzu addPhoto.Add(temp); }