public FullTicket(Data.SQL.Ticket tick) : base(tick)
{
Notes = new List <Note>();
foreach (Data.SQL.Note n in tick.Notes)
{
Notes.Add(new Note(n));
}
}
public Ticket(Data.SQL.Ticket tick)
{
Id = tick.Id;
Subject = tick.Title;
Priority = tick.Priority;
Status = tick.Status;
Date = tick.Notes[0].DateTime;
try
{
User = ADUtils.FindUserInfos(tick.Notes[0].Username)[0].DisplayName;
}
catch { User = "******"; }
}
protected void Migrate(string archive, XmlDocument doc, Data.SQL.sql2linqDataContext sql)
{
foreach (XmlNode node in doc.SelectNodes("/Tickets/Ticket"))
{
FullTicket ticket = new FullTicket(node);
Data.SQL.Ticket tick = new Data.SQL.Ticket {
Archive = archive, Faq = ticket.FAQ, Status = ticket.Status, AssignedTo = ticket.AssignedTo, ShowTo = ticket.ShowTo, ReadBy = ticket.ReadBy, Title = ticket.Subject, Priority = ticket.Priority
};
foreach (Note n in ticket.Notes)
{
tick.Notes.Add(new Data.SQL.Note {
DateTime = DateTime.Parse(n.Date), Hide = n.Hide, Username = n.Username, Content = n.NoteText
});
}
sql.Tickets.InsertOnSubmit(tick);
}
sql.SubmitChanges();
}
public Ticket(Data.SQL.Ticket tick)
{
Id = tick.Id;
Subject = tick.Title;
Priority = tick.Priority;
Status = tick.Status;
AssignedTo = (tick.AssignedTo == null) ? "" : tick.AssignedTo;
Date = tick.Notes[0].DateTime.ToString("dd/MM/yy HH:mm");
try
{
Username = ADUtils.FindUserInfos(tick.Notes[0].Username)[0].UserName;
}
catch { Username = "******"; }
ShowTo = tick.ShowTo == null ? "" : tick.ShowTo;
try
{
DisplayName = ADUtils.FindUserInfos(tick.Notes[0].Username)[0].DisplayName;
}
catch { DisplayName = "UNKNOWN"; }
FAQ = tick.Faq;
ReadBy = tick.ReadBy;
}
