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();
}
}
