public Ticket checkTicket(Ticket p_ti) { var result = (from t in dc.Tickets where t.Code == p_ti.Code select t).Single(); return (Ticket)result; }
public ActionResult Create(FormCollection f) { string fname = f["firstname"]; string lname = f["lastname"]; string twitname = f["twittername"]; TicketModel ticketModel = new TicketModel(); User u = new User(); u.Firstname = fname; u.Lastname = lname; u.Twitterpic = twitname; int userID = ticketModel.insertUser(u); //generate random int Random random = new Random(); var i = random.Next(1000, 10000); string code = twitname.Substring(0, 2) + i.ToString(); Ticket t = new Ticket(); t.FK_Status = 1; t.FK_User = userID; t.Code = code; ticketModel.insertTicket(t); ViewBag.status = "posted"; ViewBag.ticket = code; return View(); //skills per user model aanroepen //wegschrijven in skills per user }
public bool changeTicketStatus(Ticket p_ti) { var ticket = (from t in dc.Tickets where t.Code == p_ti.Code select t).Single(); // Execute the query, and change the column values ticket.FK_Status = 2; // Submit the changes to the database. try { dc.SubmitChanges(); } catch (Exception e) { Console.WriteLine(e); return false; } return true; }
// INSERT public void insertTicket(Ticket p_ti) { dc.Tickets.InsertOnSubmit(p_ti); dc.SubmitChanges(); }
partial void DeleteTicket(Ticket instance);
partial void UpdateTicket(Ticket instance);
partial void InsertTicket(Ticket instance);
private void detach_Tickets(Ticket entity) { this.SendPropertyChanging(); entity.User = null; }
private void attach_Tickets(Ticket entity) { this.SendPropertyChanging(); entity.User = this; }