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 bool Exists(FullTicket entity)
{
try
{
int intCount = 0;
if (entity.TicketId > 0)
{
intCount = fullticketlist().Where(w => w.TicketId != entity.TicketId && (w.Subject == entity.Subject)).Count();
}
else
{
intCount = fullticketlist().Where(w => w.Subject == entity.Subject).Count();
}
return(intCount > 0 ? true : false);
}
catch (Exception ex)
{
throw ex;
}
}
