public void ClosedTicketInsert(ClosedTicketInfo cinfo) { ClosedTicket closed; using (OTMDataContext db = new OTMDataContext()) { closed = new ClosedTicket(); Guid ID = Guid.NewGuid(); closed.ClosedTicketID = ID.ToString(); closed.TicketID = ID.ToString(); closed.Solution = cinfo.Solution; closed.CreatedDate = cinfo.CreatedDate; closed.UpdatedDate = cinfo.UpdatedDate; db.ClosedTickets.InsertOnSubmit(closed); db.SubmitChanges(); } }
public List <ClosedTicketInfo> SelectAllClosedTicketInfo() { List <ClosedTicketInfo> lstclosedinfo = new List <ClosedTicketInfo>(); ClosedTicketInfo closedinfo; using (OTMDataContext db = new OTMDataContext()) { var data = (from a in db.ClosedTickets select a).ToList();// db.GETALLClosedTicket(); lamda expression foreach (var obj in data) { closedinfo = new ClosedTicketInfo(); closedinfo.ClosedTicketID = obj.ClosedTicketID; closedinfo.TicketID = obj.TicketID; closedinfo.Solution = obj.Solution; closedinfo.CreatedDate = obj.CreatedDate; closedinfo.UpdatedDate = obj.UpdatedDate; lstclosedinfo.Add(closedinfo); } return(lstclosedinfo); } }