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