public Ticket AddTicket(int accountId, string device, string problem) { Ticket t = new HardwareTicket() { AccountId = accountId, Text = problem, DateOpened = DateTime.Now, State = TicketState.Open, DeviceName = device }; return this.AddTicket(t); }
public Domain.Ticket AddTicket(int acountID, string device, string problem) { Ticket t = new HardwareTicket() { AccountId = acountID, Text = problem, DateOpened = DateTime.Now, State = TicketState.Open, DeviceName = device }; this.Validate(t); return repo.CreateTicket(t); }
static void Main(string[] args) { // (1) Ticket validation Ticket t1 = new Ticket() { TicketNumber = 1, AccountId = 1, Text = "", State = TicketState.Open, DateOpened = DateTime.Now }; // (2) HardwareTicket validation Ticket t2 = new HardwareTicket() { TicketNumber = 2, AccountId = 1, DeviceName = "LPT-9876", Text = "text", State = TicketState.Open, DateOpened = DateTime.Now }; // (3) TicketResponse with user-defined validation TicketResponse tr = new TicketResponse() { Id = 1, Text = "response", IsClientResponse = true, Date = new DateTime(2014, 1, 1), Ticket = new Ticket() { TicketNumber = 3, AccountId = 1, Text = "text", State = TicketState.Open, DateOpened = new DateTime(2015, 1, 1) } }; // Validatie controle var errors = new List<ValidationResult>(); Validator.TryValidateObject(tr, new ValidationContext(tr), errors, validateAllProperties: true); Console.ReadLine(); }
static void Main(string[] args) { Ticket t2 = new HardwareTicket() { TicketNumber = 2, AccountId = 1, DeviceName = "LPT-9876", Text = "text", State = TicketState.Open, DateOpened = DateTime.Now }; var errors = new List<ValidationResult>(); Validator.TryValidateObject(t2, new ValidationContext(t2), errors, validateAllProperties: true); Console.ReadLine(); }
public IEnumerable<Ticket> ReadTickets() { List<Ticket> tickets = new List<Ticket>(); string selectStatement = "SELECT TicketNumber, AccountId, [Text], DateOpened, State, DeviceName FROM Ticket"; using (var connection = this.GetConnection()) { SqlCommand command = new SqlCommand(selectStatement, connection); connection.Open(); using (SqlDataReader reader = command.ExecuteReader()) { int ticketNumberOrdinal = reader.GetOrdinal("TicketNumber"); int accountIdOrdinal = reader.GetOrdinal("AccountId"); int textOrdinal = reader.GetOrdinal("Text"); int dateOpenedOrdinal = reader.GetOrdinal("DateOpened"); int stateOrdinal = reader.GetOrdinal("State"); int deviceNameOrdinal = reader.GetOrdinal("DeviceName"); while (reader.Read()) { Ticket ticket; string deviceName = reader.IsDBNull(deviceNameOrdinal) ? null : reader.GetString(deviceNameOrdinal); if (deviceName == null) ticket = new Ticket(); else ticket = new HardwareTicket() { DeviceName = deviceName }; ticket.TicketNumber = reader.GetInt32(ticketNumberOrdinal); ticket.AccountId = reader.GetInt32(accountIdOrdinal); ticket.Text = reader.GetString(textOrdinal); ticket.DateOpened = reader.GetDateTime(dateOpenedOrdinal); ticket.State = (TicketState)reader.GetByte(stateOrdinal); tickets.Add(ticket); } reader.Close(); // good practice! } connection.Close(); // good practice! } return tickets; }
private void Seed() { tickets = new List<Ticket>(); responses = new List<TicketResponse>(); // Aanmaken eerste ticket met drie responses Ticket t1 = new Ticket() { TicketNumber = tickets.Count + 1, AccountId = 1, Text = "Ik kan mij niet aanmelden op de webmail", DateOpened = new DateTime(2012, 9, 9, 13, 5, 59), State = TicketState.Closed, Responses = new List<TicketResponse>() }; tickets.Add(t1); TicketResponse t1r1 = new TicketResponse() { Id = responses.Count + 1, Ticket = t1, Text = "Account is geblokkeerd", Date = new DateTime(2012, 9, 9, 13, 24, 48), IsClientResponse = false }; t1.Responses.Add(t1r1); responses.Add(t1r1); TicketResponse t1r2 = new TicketResponse() { Id = responses.Count + 1, Ticket = t1, Text = "Account terug in orde en nieuw paswoord ingesteld", Date = new DateTime(2012, 9, 9, 13, 29, 11), IsClientResponse = false }; t1.Responses.Add(t1r2); responses.Add(t1r2); TicketResponse t1r3 = new TicketResponse() { Id = responses.Count + 1, Ticket = t1, Text = "Aanmelden gelukt en paswoord gewijzigd", Date = new DateTime(2012, 9, 10, 7, 22, 36), IsClientResponse = true }; t1.Responses.Add(t1r3); responses.Add(t1r3); t1.State = TicketState.Closed; //Aanmaken tweede ticket met één response Ticket t2 = new Ticket() { TicketNumber = tickets.Count + 1, AccountId = 1, Text = "Geen internetverbinding", DateOpened = new DateTime(2012, 11, 5, 9, 45, 13), State = TicketState.Open, Responses = new List<TicketResponse>() }; tickets.Add(t2); TicketResponse t2r1 = new TicketResponse() { Id = responses.Count + 1, Ticket = t2, Text = "Controleer of de kabel goed is aangesloten", Date = new DateTime(2012, 11, 5, 11, 25, 42), IsClientResponse = false }; t2.Responses.Add(t2r1); responses.Add(t2r1); t2.State = TicketState.Answered; //Aanmaken eerste HardwareTicket HardwareTicket ht1 = new HardwareTicket() { TicketNumber = tickets.Count + 1, AccountId = 2, Text = "Blue screen!", DateOpened = new DateTime(2012, 12, 14, 19, 15, 32), State = TicketState.Open, //Responses = new List<TicketResponse>(), DeviceName = "PC-123456" }; tickets.Add(ht1); this.CreateTickets(tickets); }
public BL.Domain.Ticket ReadTicket(int ticketNumber) { Ticket ticket = null; string selectStatement = "SELECT TicketNumber, AccountId,[Text], DateOpened, State, DeviceNameFROM Ticket WHERE TicketNumber =@ticketNumber"; using (var connection = this.GetConnection()) { OleDbCommand command = new OleDbCommand(selectStatement, connection); command.Parameters.AddWithValue("@ticketNumber", ticketNumber); connection.Open(); using (OleDbDataReader reader = command.ExecuteReader()) { int ticketNumberOrdinal = reader.GetOrdinal("TicketNumber"); int accountIdOrdinal = reader.GetOrdinal("AccountId"); int textOrdinal = reader.GetOrdinal("Text"); int dateOpenedOrdinal = reader.GetOrdinal("DateOpened"); int stateOrdinal = reader.GetOrdinal("State"); int deviceNameOrdinal = reader.GetOrdinal("DeviceName"); if (reader.Read()) { string deviceName = reader.IsDBNull(deviceNameOrdinal) ? null : reader.GetString(deviceNameOrdinal); if (deviceName == null) { ticket = new Ticket(); } else ticket = new HardwareTicket() { DeviceName = deviceName }; ticket.TicketNumber = reader.GetInt32(ticketNumberOrdinal); ticket.AccountId = reader.GetInt32(accountIdOrdinal); ticket.Text = reader.GetString(textOrdinal); ticket.DateOpened = reader.GetDateTime(dateOpenedOrdinal); ticket.State = (TicketState)reader.GetByte(stateOrdinal); } reader.Close(); } connection.Close(); } return ticket; }
public void Seed() { //Initialize the basic data of the application and/or some dummy data tickets = new List<Ticket>(); responses = new List<TicketResponse>(); // Create first ticket with three responses Ticket t1 = new Ticket() { TicketNumber = tickets.Count + 1, AccountId = 1, Text = "Ik kan mij niet aanmelden op de webmail", DateOpened = new DateTime(2012, 9, 9, 13, 5, 59), State = TicketState.Open, Responses = new List<TicketResponse>() }; tickets.Add(t1); TicketResponse t1r1 = new TicketResponse() { Id = responses.Count + 1, Ticket = t1, Text = "Account was geblokkeerd", Date = new DateTime(2012, 9, 9, 13, 24, 48), IsClientResponse = false }; t1.Responses.Add(t1r1); responses.Add(t1r1); TicketResponse t1r2 = new TicketResponse() { Id = responses.Count + 1, Ticket = t1, Text = "Account terug in orde en nieuw paswoord ingesteld", Date = new DateTime(2012, 9, 9, 13, 29, 11), IsClientResponse = false }; t1.Responses.Add(t1r2); responses.Add(t1r2); TicketResponse t1r3 = new TicketResponse() { Id = responses.Count + 1, Ticket = t1, Text = "Aanmelden gelukt en paswoord gewijzigd", Date = new DateTime(2012, 9, 10, 7, 22, 36), IsClientResponse = true }; t1.Responses.Add(t1r3); responses.Add(t1r3); t1.State = TicketState.Closed; //Second ticket Ticket t2 = new Ticket() { TicketNumber = tickets.Count + 1, AccountId = 1, Text = "Geen internetverbinding", DateOpened = new DateTime(2012, 11, 5, 9, 45, 13), State = TicketState.Open, Responses = new List<TicketResponse>() }; tickets.Add(t2); TicketResponse t2r1 = new TicketResponse() { Id = responses.Count + 1, Ticket = t2, Text = "Controleer of de kabel goed is aangesloten", Date = new DateTime(2012, 11, 5, 11, 25, 42), IsClientResponse = false }; t2.Responses.Add(t2r1); responses.Add(t2r1); t2.State = TicketState.Answered; HardwareTicket ht1 = new HardwareTicket() { TicketNumber = tickets.Count + 1, AccountId = 2, Text = "Blue screen!", DateOpened = new DateTime(2012, 12, 14, 19, 5, 2), State = TicketState.Open, DeviceName = "PC-123456" }; tickets.Add(ht1); }