public void Delete() { using (SIREntities context = new SIREntities()) { var incident = context.Incident.First(i => i.ServiceDeskTicketNumber.Contains("888")); context.DeleteObject(incident); context.SaveChanges(); } }
public void Change() { using (SIREntities context = new SIREntities()) { var incident = context.Incident.First(i => i.ServiceDeskTicketNumber.Contains("888")); if (incident != null) { incident.TechnicianName = "Pong Lee"; } context.SaveChanges(); } }
public void Insert() { using (SIREntities context = new SIREntities()) { context.AddToIncident(new Incident() { IncidentID = System.Guid.NewGuid(), CreatedBy = "pxlee", CreatedDate = DateTime.Now, HeatTicketNumber = "", ChangeRequestNumber = "", ImpactID = 1, IncidentNumber = "SD-888", IssueChronology = "Chrono", IssueDescription = "Description", IssueDeviceID = "", IssueLocation = "", IssueSummary = "Summary", IssueRootCause = "root", IssueResolutionDate = DateTime.Now, IssueStartDate = DateTime.Now, OtherSystemsAffected = false, OtherSystemsAffectedValue = "", ProcessImprovements = "Improvement", TravelRequired = false, ServiceDeskTicketNumber = "888", ServiceGroupID = 1, SeverityID = 1, Status = "Pending", TechnicianEmail = "*****@*****.**", TechnicianName = "pxlee", TechnicianPhone = "333-333-3333", VisibilityID = 1, LastModifiedBy = "pxlee", LastModifiedDate = DateTime.Now }); context.SaveChanges(); } }