public CustomerDetailVM()
{
TicketTypes = TicketType.GetTicketTypes();
Tickets = Ticket.GetTickets();
SelectedCustomer = new Ticket();
Enabled = true;
ShowEdit = "Hidden";
ShowCancel = "Hidden";
ShowSave = "Visible";
}
public static void UpdateTicket(Ticket ticket)
{
// If _Tickets is null, create the Observable Collection
if (_Tickets == null) GetTickets();
try
{
// Update db
DbParameter param1 = Database.AddParameter("@id", ticket.ID);
DbParameter param2 = Database.AddParameter("@ticketholder", ticket.TicketHolder);
DbParameter param3 = Database.AddParameter("@ticketholderemail", ticket.TicketHolderEmail);
DbParameter param4 = Database.AddParameter("@tickettype", ticket.TicketType);
DbParameter param5 = Database.AddParameter("@amount", ticket.Amount);
int affectedRows = Database.ModifyData("UPDATE ticket SET TicketHolder = @ticketholder, TicketHolderEmail = @ticketholderemail, TicketType = @tickettype, Amount = @amount WHERE id = @id", param1, param2, param3, param4, param5);
if (affectedRows == 0) return;
// Update _Tickets
_Tickets[GetIndexByID(ticket.ID)] = ticket;
}
// Fail
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
public static ObservableCollection<Ticket> GetTickets()
{
// If _Tickets is null, create the Observable Collection
if (_Tickets == null)
{
try
{
// Create _Tickets
_Tickets = new ObservableCollection<Ticket>();
// Get data
DbDataReader reader = Database.GetData("SELECT * FROM ticket");
foreach (DbDataRecord record in reader)
{
// Create new Ticket
Ticket ticket = new Ticket();
// Get ID
if (DBNull.Value.Equals(record["ID"])) ticket.ID = -1;
else ticket.ID = Convert.ToInt32(record["ID"]);
// Get TicketHolder
if (DBNull.Value.Equals(record["TicketHolder"])) ticket.TicketHolder = "";
else ticket.TicketHolder = record["TicketHolder"].ToString();
// Get TicketHolderEmail
if (DBNull.Value.Equals(record["TicketHolderEmail"])) ticket.TicketHolderEmail = "";
else ticket.TicketHolderEmail = record["TicketHolderEmail"].ToString();
// Get TicketType
if (DBNull.Value.Equals(record["TicketType"])) ticket.TicketType = -1;
else ticket.TicketType = Convert.ToInt32(record["TicketType"].ToString());
// Get Amount
if (DBNull.Value.Equals(record["Amount"])) ticket.Amount = -1;
else ticket.Amount = Convert.ToInt32(record["Amount"].ToString());
// Add _Tickets
_Tickets.Add(ticket);
}
if (reader != null)
reader.Close();
}
// Fail
catch (Exception ex)
{
Console.WriteLine(ex.Message);
// Clear Contactpersons
_Tickets.Clear();
_Tickets = null;
}
}
// Return _Tickets
return _Tickets;
}
public static void DeleteTicket(Ticket ticket)
{
// If _Tickets is null, create the Observable Collection
if (_Tickets == null) GetTickets();
try
{
// Add to db
DbParameter param = Database.AddParameter("@id", ticket.ID);
int affectedRows = Database.ModifyData("DELETE FROM ticket WHERE id = @id", param);
if (affectedRows == 0) return;
// Update _Tickets
_Tickets.RemoveAt(GetIndexByID(ticket.ID));
}
// Fail
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
public static int AddTicket(Ticket ticket)
{
// If _Tickets is null, create the Observable Collection
if (_Tickets == null) GetTickets();
try
{
// Add to db
DbParameter param1 = Database.AddParameter("@ticketholder", ticket.TicketHolder);
DbParameter param2 = Database.AddParameter("@ticketholderemail", ticket.TicketHolderEmail);
DbParameter param3 = Database.AddParameter("@tickettype", ticket.TicketType);
DbParameter param4 = Database.AddParameter("@amount", ticket.Amount);
DbDataReader reader = Database.GetData("INSERT INTO ticket(TicketHolder, TicketHolderEmail, TicketType, Amount) VALUES(@ticketholder, @ticketholderemail, @tickettype, @amount); SELECT LAST_INSERT_ID() AS ID;", param1, param2, param3, param4);
foreach (DbDataRecord record in reader)
{
// Get ID
if (DBNull.Value.Equals(record["ID"])) ticket.ID = -1;
else ticket.ID = Convert.ToInt32(record["ID"]);
}
if (reader != null)
reader.Close();
_Tickets.Add(ticket);
return ticket.ID;
}
// Fail
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return -1;
}
private void SelectionChanged(CustomerDetailVM customervm)
{
if (SelectedCustomer == null) return;
if (ShowCancel == "Visible") CancelUpdateCustomer(this);
_oldCustomer = SelectedCustomer.Copy();
customervm.ShowEdit = "Visible";
customervm.ShowCancel = "Hidden";
customervm.ShowSave = "Hidden";
Enabled = false;
}
private void DeleteCustomer(CustomerDetailVM customervm)
{
if (SelectedCustomer == null) return;
// Add the removed tickets from the deleted order again
int ticketIndex = TicketType.GetIndexByID(_oldCustomer.TicketType);
TicketType updatedTicketType = TicketTypes[ticketIndex].Copy();
updatedTicketType.TicketsLeft = TicketTypes[ticketIndex].TicketsLeft + SelectedCustomer.Amount;
TicketType.UpdateTicketType(updatedTicketType);
// Remove the order
Ticket.DeleteTicket(SelectedCustomer);
SelectedCustomer = new Ticket();
Enabled = true;
ShowEdit = "Hidden";
ShowCancel = "Hidden";
ShowSave = "Visible";
}
private void AddCustomer(CustomerDetailVM customervm)
{
SelectedCustomer = new Ticket();
_oldCustomer = null;
customervm.ShowEdit = "Hidden";
customervm.ShowCancel = "Visible";
customervm.ShowSave = "Visible";
customervm.Enabled = true;
}