public void ControllerEditMethodWithIdAndTicketAsParameter_CallsMgrUpdateTicket() { Ticket t = new HardwareTicket(); _controller.Edit(15, t); mgr.Received(1).ChangeTicket(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(); }
private HardwareTicket HardwareTicketAndTicketResponseImplemention(HardwareTicket ticket, TicketResponse response) { if (ticket.Responses == null) { ticket.Responses = new List <TicketResponse>(); } ticket.Responses.Add(response); return(ticket); }
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(AddTicket(t)); }
public Ticket CreateTicket(int accountId, string device, string problem) { HardwareTicket hwTicketToAdd = new HardwareTicket() { AccountId = accountId, DateOpened = System.DateTime.Now, DeviceName = device, State = TicketState.Open, Text = problem }; return(repo.CreateTicket(hwTicketToAdd)); }
public Ticket AddTicket(int accountId, string device, string problem) { Ticket ticket = new HardwareTicket() { AccountID = accountId, Text = problem, DeviceName = device, State = TicketState.Open, DateOpened = DateTime.Now }; return(repo.CreateTicket(ticket)); }
public IEnumerable <Ticket> ReadTickets() { List <Ticket> tickets = new List <Ticket>(); string selectStatement = "SELECT TicketNumber, AccountId, [Text], DateOpened" + ", State, DeviceName FROM Ticket"; using (var connection = GetConnection()) { SqlCommand command = new SqlCommand(selectStatement, connection); connection.Open(); using (SqlDataReader reader = command.ExecuteReader()) { int ticketNumberOrdinal = reader.GetOrdinal("TicketNumber"); //gaat index van kolom Ticketnumber uit ons teruggegeven resultaat van select geven int accountIdOrdinal = reader.GetOrdinal("AccountId"); int textOrdinal = reader.GetOrdinal("Text"); int dateOpenedOrdinal = reader.GetOrdinal("DateOpened"); int stateOrdinal = reader.GetOrdinal("State"); int deviceOrdinal = reader.GetOrdinal("DeviceName"); while (reader.Read()) { Ticket ticket; string deviceName = reader.IsDBNull(deviceOrdinal) ? null : reader.GetString(deviceOrdinal); //controle of de waarde in DB null is if (deviceName == null) //als devicename null is dan is het een normaal ticket { ticket = new Ticket(); } else //anders een hardware ticket { 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); //ticketstate is een byte, kunnen casten naar TicketState tickets.Add(ticket); } reader.Close(); } connection.Close(); } return(tickets); }
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); }
public Ticket AddTicket(int accountId, string device, string problem) { Ticket t = new HardwareTicket() { AccountId = accountId, Text = problem, DateOpened = DateTime.Now, State = TicketState.Open, //Responses = new List<TicketResponse>(), DeviceName = device }; return(this.AddTicket(t)); }
public Ticket ReadTicket(int ticketNumber) { Ticket requestedTicket = null; string selectStatement = "SELECT TicketNumber, AccountId, [Text], DateOpened, State, DeviceName FROM Ticket" + " WHERE TicketNumber = @ticketNumber"; using (var connection = this.GetConnection()) { SqlCommand command = new SqlCommand(selectStatement, connection); command.Parameters.AddWithValue("@ticketNumber", ticketNumber); 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"); if (reader.Read()) { string deviceName = reader.IsDBNull(deviceNameOrdinal) ? null : reader.GetString(deviceNameOrdinal); if (deviceName == null) { requestedTicket = new Ticket(); } else { requestedTicket = new HardwareTicket() { DeviceName = deviceName } }; requestedTicket.TicketNumber = reader.GetInt32(ticketNumberOrdinal); requestedTicket.AccountId = reader.GetInt32(accountIdOrdinal); requestedTicket.Text = reader.GetString(textOrdinal); requestedTicket.DateOpened = reader.GetDateTime(dateOpenedOrdinal); requestedTicket.State = (TicketState)reader.GetByte(stateOrdinal); } reader.Close(); // good practice! } connection.Close(); // good practice! } return(requestedTicket); }
static void Main(string[] args) { Ticket ticket = new HardwareTicket { TicketNumber = 2, AccountID = 1, Text = "", DateOpened = DateTime.Now, State = TicketState.Open, DeviceName = "PC-4387" }; TicketResponse response = new TicketResponse { Id = 1, Text = "response", IsClientResponse = true, Date = new DateTime(2019, 1, 1), Ticket = ticket }; var errors = new List <ValidationResult>(); Validator.ValidateObject(ticket, new ValidationContext(ticket), true); }
public Ticket ReadTicket(int ticketNumber) { Ticket requestedTicket = null; string statement = "SELECT TicketNumber, AccountId, [Text], DateOpened" + ", State, DeviceName FROM Ticket" + " WHERE TicketNumber = @ticketNumber"; using (var connection = GetConnection()) { SqlCommand command = new SqlCommand(statement, connection); command.Parameters.AddWithValue("@ticketNumber", ticketNumber); //parameter in statement invullen 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"); if (reader.Read()) { string deviceName = reader.IsDBNull(deviceNameOrdinal) ? null : reader.GetString(deviceNameOrdinal); if (deviceName == null) { requestedTicket = new Ticket(); } else { requestedTicket = new HardwareTicket() { DeviceName = deviceName } }; } reader.Close(); } connection.Close(); } return(requestedTicket); }
private static void Seed(SupportCenterDbContext context) { // Create first ticket with three responses Ticket t1 = new Ticket() { AccountId = 1, Text = "Ik kan mij niet aanmelden op de webmail", DateOpened = new DateTime(2017, 9, 9, 13, 5, 59), State = TicketState.Open, Responses = new List <TicketResponse>() }; context.Tickets.Add(t1); TicketResponse t1r1 = new TicketResponse() { Ticket = t1, Text = "Account was geblokkeerd", Date = new DateTime(2017, 9, 9, 13, 24, 48), IsClientResponse = false }; t1.Responses.Add(t1r1); TicketResponse t1r2 = new TicketResponse() { Ticket = t1, Text = "Account terug in orde en nieuw paswoord ingesteld", Date = new DateTime(2017, 9, 9, 13, 29, 11), IsClientResponse = false }; t1.Responses.Add(t1r2); TicketResponse t1r3 = new TicketResponse() { Ticket = t1, Text = "Aanmelden gelukt en paswoord gewijzigd", Date = new DateTime(2017, 9, 10, 7, 22, 36), IsClientResponse = true }; t1.Responses.Add(t1r3); t1.State = TicketState.Closed; // Create second ticket with one response Ticket t2 = new Ticket() { AccountId = 1, Text = "Geen internetverbinding", DateOpened = new DateTime(2017, 11, 5, 9, 45, 13), State = TicketState.Open, Responses = new List <TicketResponse>() }; context.Tickets.Add(t2); TicketResponse t2r1 = new TicketResponse() { Ticket = t2, Text = "Controleer of de kabel goed is aangesloten", Date = new DateTime(2017, 11, 5, 11, 25, 42), IsClientResponse = false }; t2.Responses.Add(t2r1); t2.State = TicketState.Answered; // Create hardware ticket without response HardwareTicket ht1 = new HardwareTicket() { AccountId = 2, Text = "Blue screen!", DateOpened = new DateTime(2017, 12, 14, 19, 5, 2), State = TicketState.Open, DeviceName = "PC-123456" }; context.Tickets.Add(ht1); // Save the changes in the context to the database context.SaveChanges(); // Detach all entities from the context, // else this data stays attached to context and should be read from the db when needed! foreach (EntityEntry entry in context.ChangeTracker.Entries().ToList()) { entry.State = EntityState.Detached; } }
static void Main(string[] args) { Ticket t1 = new Ticket() { TicketNumber = 1, AccountId = 1, Text = "a", State = TicketState.Open, DateOpened = DateTime.Now }; var errors = new List <ValidationResult>(); bool isValid = Validator.TryValidateObject(t1, new ValidationContext(t1), errors, validateAllProperties: true); if (!isValid) { foreach (var item in errors) { Console.WriteLine(item.ErrorMessage); } } else { Console.WriteLine("Ticket1 is valid"); } Ticket t2 = new HardwareTicket() { TicketNumber = 2, AccountId = 1, DeviceName = "PC-9876", Text = "text", State = TicketState.Open, DateOpened = DateTime.Now }; var errors2 = new List <ValidationResult>(); isValid = Validator.TryValidateObject(t2, new ValidationContext(t2), errors2, validateAllProperties: true); if (!isValid) { foreach (var item in errors2) { Console.WriteLine(item.ErrorMessage); } } else { Console.WriteLine("Ticket2 is valid"); } 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) } }; var errors3 = new List <ValidationResult>(); isValid = Validator.TryValidateObject(tr, new ValidationContext(tr), errors3, true); if (!isValid) { foreach (var item in errors3) { Console.WriteLine(item.ErrorMessage); } } else { Console.WriteLine("TicketResponse OK"); } Console.ReadLine(); }
protected override void Seed(SupportCenterDbContext context) { #region Ticket 1 var t1 = new Ticket() { AccountId = 1, Text = "Help, kan niet meer aanmelden", DateOpened = DateTime.Now.AddHours(-3194), State = TicketState.Open, Responses = new List <TicketResponse>() }; context.Tickets.Add(t1); var t1r1 = new TicketResponse() { Ticket = t1, Text = "Ai, je account was geblokkeerd", Date = DateTime.Now.AddHours(-3192), IsClientResponse = false }; t1.Responses.Add(t1r1); var t1r2 = new TicketResponse() { Ticket = t1, Text = "Account terug in orde en nieuw paswoord ingesteld", Date = DateTime.Now.AddHours(-3191), IsClientResponse = false }; t1.Responses.Add(t1r2); var t1r3 = new TicketResponse() { Ticket = t1, Text = "Yihaa, alles werkt terug", Date = DateTime.Now.AddHours(-3188), IsClientResponse = true }; t1.Responses.Add(t1r3); t1.State = TicketState.Closed; #endregion #region Ticket 2 // Create second ticket with one response var t2 = new Ticket() { AccountId = 1, Text = "Kan niet meer surfen", DateOpened = DateTime.Now.AddHours(-50), State = TicketState.Open, Responses = new List <TicketResponse>() }; context.Tickets.Add(t2); var t2r1 = new TicketResponse() { Ticket = t2, Text = "Ga naar zee, daar is er genoeg water en zijn er golven", Date = DateTime.Now.AddHours(-48), IsClientResponse = false }; t2.Responses.Add(t2r1); t2.State = TicketState.Answered; #endregion #region Ticket 3 var ht1 = new HardwareTicket() { AccountId = 2, Text = "Oeps, blue screen bij het aankoppelen aan een beamer", DateOpened = DateTime.Now.AddHours(-24.6), State = TicketState.Open, DeviceName = "PC-123456" }; context.Tickets.Add(ht1); #endregion context.SaveChanges(); }
private void Seed() { tickets = new List <Ticket>(); responses = new List <TicketResponse>(); // Aanmaken eerste ticket met drie responses var 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); var 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); var 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); var 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 var 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); var 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 var 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); }
protected override void Seed(SC.DAL.EF.SupportCenterDbContext context) { // Create first ticket with three responses Ticket t1 = new Ticket() { 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>() }; context.Tickets.Add(t1); TicketResponse t1r1 = new TicketResponse() { Ticket = t1, Text = "Account was geblokkeerd", Date = new DateTime(2012, 9, 9, 13, 24, 48), IsClientResponse = false }; t1.Responses.Add(t1r1); TicketResponse t1r2 = new TicketResponse() { 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); TicketResponse t1r3 = new TicketResponse() { Ticket = t1, Text = "Aanmelden gelukt en paswoord gewijzigd", Date = new DateTime(2012, 9, 10, 7, 22, 36), IsClientResponse = true }; t1.Responses.Add(t1r3); t1.State = TicketState.Closed; // Create second ticket with one response Ticket t2 = new Ticket() { AccountId = 1, Text = "Geen internetverbinding", DateOpened = new DateTime(2012, 11, 5, 9, 45, 13), State = TicketState.Open, Responses = new List <TicketResponse>() }; context.Tickets.Add(t2); TicketResponse t2r1 = new TicketResponse() { 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); t2.State = TicketState.Answered; // Create hardware ticket without response HardwareTicket ht1 = new HardwareTicket() { AccountId = 2, Text = "Blue screen!", DateOpened = new DateTime(2012, 12, 14, 19, 5, 2), State = TicketState.Open, DeviceName = "PC-123456" }; context.Tickets.Add(ht1); // Save the changes in the context (all added entities) to the database context.SaveChanges(); }
protected void Seed() { // Create first ticket with three responses var t1 = new Ticket { TicketNumber = 0, 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); var t1r1 = new TicketResponse { Id = 0, Ticket = t1, Text = "Account was geblokkeerd", Date = new DateTime(2012, 9, 9, 13, 24, 48), IsClientResponse = false }; t1.Responses.Add(t1r1); var t1r2 = new TicketResponse { Id = 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); var t1r3 = new TicketResponse { Id = 2, Ticket = t1, Text = "Aanmelden gelukt en paswoord gewijzigd", Date = new DateTime(2012, 9, 10, 7, 22, 36), IsClientResponse = true }; t1.Responses.Add(t1r3); t1.State = TicketState.Closed; // Create second ticket with one response var t2 = new Ticket { TicketNumber = 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); var t2r1 = new TicketResponse { Id = 0, 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); t2.State = TicketState.Answered; // Create hardware ticket without response var ht1 = new HardwareTicket { TicketNumber = 2, AccountId = 2, Text = "Blue screen!", DateOpened = new DateTime(2012, 12, 14, 19, 5, 2), State = TicketState.Open, DeviceName = "PC-123456" }; this.Tickets.Add(ht1); }
public void Initialize() { #region create dummy data Ticket t1 = new Ticket() { TicketNumber = 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>() }; TicketResponse t1r1 = new TicketResponse() { Id = 1, Ticket = t1, Text = "Account is geblokkeerd", Date = new DateTime(2012, 9, 9, 13, 24, 48), IsClientResponse = false }; t1.Responses.Add(t1r1); TicketResponse t1r2 = new TicketResponse() { Id = 2, 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); TicketResponse t1r3 = new TicketResponse() { Id = 3, Ticket = t1, Text = "Aanmelden gelukt en paswoord gewijzigd", Date = new DateTime(2012, 9, 10, 7, 22, 36), IsClientResponse = true }; t1.Responses.Add(t1r3); Ticket t2 = new Ticket() { TicketNumber = 2, AccountId = 1, Text = "Geen internetverbinding", DateOpened = new DateTime(2012, 11, 5, 9, 45, 13), State = TicketState.Answered, Responses = new List <TicketResponse>() }; TicketResponse t2r1 = new TicketResponse() { Id = 4, 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); HardwareTicket ht1 = new HardwareTicket() { TicketNumber = 3, AccountId = 2, Text = "Blue screen!", DateOpened = new DateTime(2012, 12, 14, 19, 15, 32), State = TicketState.Open, DeviceName = "PC-123456" }; #endregion #region initialize fakes tickets = new List <Ticket> { //add data t1, t2 }.AsQueryable(); hardwareTickets = new List <HardwareTicket> { //add data ht1 }.AsQueryable(); ticketResponses = new List <TicketResponse> { //add data t1r1, t1r2, t1r3, t2r1 }.AsQueryable(); #endregion }