public Factuur(Ticket ticket)
{
this.ticket = ticket;
prijs = 0;
}
public Ticket SaveTicket(int klantnr, double verwachteKosten, int verwachteReparatieTijd, TicketStatus status, Registratie registratie, string probleem, string afdelingsAfkorting, string categorie)
{
//try
//{
connection.Open();
string query = "INSERT INTO ticket (ticketnr, status, opmerking, locatie, verw_oplostijd, verw_kosten, klantnr) VALUES " +
"(ticketseq.nextval, " + ((int)status).ToString() + ", '" + probleem + "', '" + afdelingsAfkorting + "', " + verwachteReparatieTijd.ToString() + ", " + verwachteKosten.ToString() + ", " + klantnr.ToString() + ")";
OracleCommand command = new OracleCommand(query, connection);
command.ExecuteNonQuery();
string selectQuery = "SELECT Max(ticketnr) FROM ticket";
command = new OracleCommand(selectQuery, connection);
OracleDataReader reader = command.ExecuteReader();
reader.Read();
Ticket t = new Ticket(
Convert.ToInt32(reader["ticketnr"]),
klantnr,
verwachteReparatieTijd,
verwachteKosten,
status,
afdelingsAfkorting,
probleem,
categorie
);
connection.Close();
return t;
//}
//catch (Exception e)
//{
// System.Windows.Forms.MessageBox.Show(e.ToString());
// return null;
//}
//finally
//{
// connection.Close();
//}
}
public bool WijzigTicket(Ticket ticket, int serienr)
{
if (database.WijzigTicket(ticket, serienr))
{
Klant k = database.GetKlantByTicketnr(Convert.ToInt32(ticket.Ticketnr));
MailMessage mailmessage = new MailMessage();
mailmessage.Body = "De nieuwe status is :" + ticket.Status.ToString();
mailmessage.From = new MailAddress("*****@*****.**");
mailmessage.Subject = "Status wijziging";
mailmessage.To.Add(new MailAddress(k.Email));
mailServer.SendMail(mailmessage);
return true;
}
return false;
}
public List<Ticket> GetTicketsByKlant(int klantnr)
{
List<Ticket> result = new List<Ticket>();
//try
//{
connection.Open();
string query = "SELECT * FROM ticket WHERE klantnr = " + klantnr.ToString();
OracleCommand command = new OracleCommand(query, connection);
OracleDataReader reader = command.ExecuteReader();
Ticket t;
while (reader.Read())
{
t = new Ticket(
Convert.ToInt32(reader["ticketnr"]),
Convert.ToInt32(reader["klantnr"]),
Convert.ToInt32(reader["verw_oplostijd"]),
Convert.ToDouble(reader["verw_kosten"]),
(TicketStatus)Convert.ToInt32(reader["status"]),
(string)reader["locatie"],
(string)reader["opmerking"],
(string)reader["categorie"]
);
result.Add(t);
}
connection.Close();
return result;
//}
//catch (Exception e)
//{
// System.Windows.Forms.MessageBox.Show(e.ToString());
// return null;
//}
//finally
//{
// connection.Close();
//}
}
public List<Ticket> GetTickets()
{
List<Ticket> result = new List<Ticket>();
try
{
connection.Open();
string query = "SELECT * FROM ticket";
OracleCommand command = new OracleCommand(query, connection);
OracleDataReader reader = command.ExecuteReader();
Ticket t;
while (reader.Read())
{
t = new Ticket(
Convert.ToInt32(reader["ticketnr"]),
Convert.ToInt32(reader["klantnr"]),
Convert.ToInt32(reader["verw_oplostijd"]),
Convert.ToDouble(reader["verw_kosten"]),
(TicketStatus)Convert.ToInt32(reader["status"]),
(string)reader["afdeling"],
(string)reader["probleem"],
(string)reader["categorie"]
);
result.Add(t);
}
return result;
}
catch (Exception e)
{
System.Windows.Forms.MessageBox.Show(e.ToString());
return null;
}
finally
{
connection.Close();
}
}