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