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();
}
}
public void Relation()
{
using (SIREntities context = new SIREntities())
{
var ia = context.IncidentAuditItem.Include("AuditITem").First(a => a.CreatedBy == "pxlee");
if (ia != null)
Console.WriteLine(ia.AuditItem.Description);
}
}
public void SendReminder()
{
using (SIREntities context = new SIREntities())
{
var incidents = new List<Incident>();
foreach (Incident i in context.Incident)
{
if (DateTime.Now.Subtract(i.LastModifiedDate).Days > 13)
{
incidents.Add(i);
}
}
foreach (Incident i in incidents)
Console.WriteLine(i.IncidentID + "," + i.LastModifiedDate);
}
}
