/// <summary> /// Displays EditForm view with TicketData instance as the model /// </summary> /// <param name="td">TicketData instance</param> /// <returns>EditForm View with specified TicketData entry</returns> public async Task <ViewResult> EditForm(TicketData td) { try { Authorize(); } catch (HttpResponseException e) { return(View("Error", Utility.CreateHttpErrorView(e, "You do not have the permissions to view this page"))); } try { RecordRetriever rr = new RecordRetriever(); var tdRes = rr.GetRecordByID(td.EntryId); return(View("EditForm", tdRes)); } catch (HttpResponseException e) { ServerErrorViewModel error = await Utility.CreateServerErrorView(e); return(View("ServerError", error)); } catch (Exception e) { var guid = ExceptionReporter.DumpException(e); ErrorViewModel error = Utility.CreateBasicExceptionView(e, guid); return(View("Error", error)); } }
public Ticket NewTicket(TicketData ticket) { var newTicket = new Ticket() { ProjectId = ticket.ProjectId, TicketNumber = null, AreaId = ticket.AreaId, PriorityId = ticket.PriorityId, CategoryId = ticket.CategoryId, TicketStatusId = (int)TicketStatus.Open, Title = ticket.Title, Details = ticket.Content, IsHtml = true, CreatedBy = ticket.CreatedBy, CreatedDate = DateTime.Now, AssignedTo = ticket.UserId, LastUpdateBy = ticket.CreatedBy, LastUpdateDate = DateTime.Now, OwnerUserId = ticket.CreatedBy, ParentTicketId = null, EditionMarkAsDeleted = false, IsLastDetail = true, IsBillable = ticket.IsBillable, HasFiles = ticket.HasFiles, }; TicketRepository.Add(newTicket); Save(); newTicket.TicketNumber = newTicket.TicketDetailId; Save();// TODO:Use a stored procedure to insert ? return(newTicket); }
/// <summary> /// Lista de tickets /// </summary> /// <returns></returns> public List <object> GetTickets() { List <Object> dataList = new List <object>(); using (tecAirlinesEntities entities = new tecAirlinesEntities()) { try { var ticketsList = entities.Tiquetes.ToList(); int n = ticketsList.Count; if (n == 0) { dataList = null; return(dataList); } else { for (int i = 0; i < ticketsList.Count; ++i) { TicketData data = new TicketData(); data.C_Reserva = ticketsList.ElementAt(i).C_Reserva; data.N_Asiento = ticketsList.ElementAt(i).N_Asiento; dataList.Add(data); } return(dataList); } } catch { dataList = null; return(dataList); } } }
/// <summary> /// Get de un vuelo especifico /// </summary> /// <param name="id"></param> /// <returns></returns> public TicketData GetTicket(int id) { TicketData ticket = new TicketData(); using (tecAirlinesEntities entities = new tecAirlinesEntities()) { try { if (!this.ExistTicket(id)) { ticket = null; return(ticket); } var ticketx = entities.Tiquetes.Find(id); ticket.C_Reserva = ticketx.C_Reserva; ticket.N_Asiento = ticketx.N_Asiento; return(ticket); } catch (Exception) { ticket = null; return(ticket); } } }
public static long Solve2(TicketData input) { var decodedFields = input.YourTicket.Select(_ => new HashSet <Field>(input.Fields)).ToArray(); var validTickets = input.OtherTickets.Where(t => IsValidTicket(t, input.Fields)).ToArray(); foreach (var ticket in validTickets) { decodedFields = decodedFields .Select((fs, i) => fs.Intersect(GetMatchingFields(ticket[i], input.Fields)).ToHashSet()) .ToArray(); } while (decodedFields.Any(f => f.Count > 1)) { foreach (var field in decodedFields.Where(f => f.Count == 1)) { foreach (var other in decodedFields.Where(f => f.Count > 1 && f != field)) { other.Remove(field.First()); } } } return(decodedFields .Select(f => f.First().Name) .Select((f, i) => f.StartsWith("departure") ? input.YourTicket[i] : 1) .Aggregate(1L, (acc, seed) => acc * seed)); }
public static DocumentBuilder Run() { string ticketJsonFile = CheckFile( Path.Combine("Content", "bp-ticket-data.json")); string boardingJsonFile = CheckFile( Path.Combine("Content", "boarding-data.json")); string whatsNextJsonFile = CheckFile( Path.Combine("Content", "whats-next.json")); string ticketJsonContent = File.ReadAllText(ticketJsonFile); string boardingJsonContent = File.ReadAllText(boardingJsonFile); string whatsNextJsonContent = File.ReadAllText(whatsNextJsonFile); TicketData ticketData = JsonConvert.DeserializeObject <TicketData>(ticketJsonContent); BoardingData boardingData = JsonConvert.DeserializeObject <BoardingData>(boardingJsonContent); List <string> whatsNextData = JsonConvert.DeserializeObject <List <string> >(whatsNextJsonContent); BoardingPassBuilder boardingPassBuilder = new BoardingPassBuilder(); boardingPassBuilder.TicketData = ticketData; boardingPassBuilder.BoardingData = boardingData; boardingPassBuilder.WhatsNextData = whatsNextData; return(boardingPassBuilder.Build()); }
public bool Insert(TicketData ticket) { ticket.updatedOn = DateTime.Now.Date; ticket.createdOn = DateTime.Now.Date; try { sqlCommand.Parameters.Clear(); sqlCommand.CommandText = "INSERT INTO Tickets (TicketNumber,Description,Status,Comments,CreatedOn,UpdatedOn)" + "VALUES (@ticketnumber, @description, @status, @comments, @createdon,@updatedon)"; sqlCommand.Parameters.AddWithValue("@ticketnumber", ticket.ticketNumber); sqlCommand.Parameters.AddWithValue("@description", ticket.description); sqlCommand.Parameters.AddWithValue("@status", ticket.status); sqlCommand.Parameters.AddWithValue("@comments", ticket.comments); sqlCommand.Parameters.AddWithValue("@createdon", ticket.createdOn); sqlCommand.Parameters.AddWithValue("@updatedon", ticket.updatedOn); sqlCommand.CommandType = CommandType.Text; sqlDA.InsertCommand = sqlCommand; sqlConnection.Open(); sqlDA.InsertCommand.ExecuteNonQuery(); sqlConnection.Close(); LastError = "Ticket Record created."; return(true); } catch (Exception ex) { LastError = $"Error while creating record.{ex.Message}"; return(false); } }
public TicketData CreateTestData() { using (var context = new TicketingSystemDBContext()) { JobType j = new JobType(); j.JobName = "Miscellaneous"; RecordRetriever rr = new RecordRetriever(); var records = rr.RetrieveRecords(10); Users ticketWorker = context.Users.Where(u => u.FullName == "Test User").FirstOrDefault(); Users entryAuthor = context.Users.Where(w => w.FullName == "Test User").FirstOrDefault(); TicketData td = new TicketData() { TripNum = -1, StageNum = "S01", JobType = j, EntryAuthor = entryAuthor, EntryAuthorId = entryAuthor.UserId, TicketWorker = ticketWorker, TicketWorkerId = ticketWorker.UserId, WorkerName = "Test User", StartTime = "12:00", EndTime = "12:00", StartDate = DateTime.Today, EndDate = DateTime.Today, Comments = "Entry generated by HomeController.PostEntry unit test" }; return(td); } }
/// <summary> /// Posts edited ticket data entry to DataEditor service /// </summary> /// <param name="td">TicketData instance from edit form</param> /// <returns>Index View</returns> public async Task <ViewResult> PostEdit(TicketData td) { try { Authorize(); } catch (HttpResponseException e) { return(View("Error", Utility.CreateHttpErrorView(e, "You do not have the permissions to view this page"))); } try { DataEditor de = new DataEditor(); UserData loggedInUser = Auth0APIClient.GetUserData(User.Claims.First().Value); de.PostEditor(td, loggedInUser); RecordRetriever rr = new RecordRetriever(); var res = rr.RetrieveRecords(1000); return(View("Index", res)); } catch (HttpResponseException e) { ServerErrorViewModel error = await Utility.CreateServerErrorView(e); return(View("ServerError", error)); } catch (Exception e) { var guid = ExceptionReporter.DumpException(e); ErrorViewModel error = Utility.CreateBasicExceptionView(e, guid); return(View("Error", error)); } }
public void AddDemoTicket() { var ticketUnitOfwork = new TicketUnitOfWork(); var userUnitOfwork = new UserUnitOfWork(); var random = new Random(); var projects = ticketUnitOfwork.ProjectRepository.All().ToList(); var defaultProjectId = projects[random.Next(0, projects.Count)].ProjectId; var areas = ticketUnitOfwork.AreaRepository.Where(a => a.ProjectId == defaultProjectId).ToList(); var defaultAreaId = areas[random.Next(0, areas.Count)].AreaId; var categories = ticketUnitOfwork.CategoryRepository.All().ToList(); var defaultCategoryId = categories[random.Next(0, categories.Count)].CategoryId; var priorities = ticketUnitOfwork.PriorityRepository.All().ToList(); var defaultPriorityId = priorities[random.Next(0, priorities.Count)].PriorityId; var normalUsers = userUnitOfwork.GetNormalUsers().ToList(); var projectManagers = userUnitOfwork.GetProjectManagers().ToList(); var statusId = (int)TicketStatus.Open; var defaultUserId = normalUsers[random.Next(0, normalUsers.Count)].Id; var ownerId = projectManagers[random.Next(0, projectManagers.Count)].Id; var data = new TicketData { Title = "FirstIssue", Content = "this is a content", ProjectId = defaultProjectId, CategoryId = defaultCategoryId, PriorityId = defaultPriorityId, UserId = defaultUserId, CreatedBy = ownerId, AreaId = defaultAreaId, IsBillable = false }; ticketUnitOfwork.NewTicket(data); }
public string GetTicketsByTournamentId(string id) { var idGuid = new Guid(id); var x = JsonConvert.SerializeObject(TicketData.GetByTournamentId(CR, idGuid)); return(x); }
public void DeleteEntryTest(TicketData td, UserData ud) { DataEditor dataEditor = new DataEditor(); var result = dataEditor.DeleteEntry(td.EntryId.ToString(), ud); Assert.IsTrue(result); }
//edit ticket public int editTicket(int ParkingPlaceId, TicketData toEdit) { var client = new ServiceReference1.ParkingClient(); return(client.editTicket(ParkingPlaceId, TicketToWebservice(toEdit))); //Todo client close }
private List <TicketData> getAllTicketsInfo(dynamic json) { List <TicketData> list = new List <TicketData>(); for (int i = 0; i < json.items.item.Count; i++) { if (int.Parse(json.items.item[i]["@attributes"].enabled.ToString()) == 1) { string letter = json.items.item[i].letter; string description = cleanTicketDescriptionName(json.items.item[i].desc.ToString()); TicketData ticket = new TicketData(letter, description, true); ticket.Latest = int.Parse(json.items.item[i].latest.ToString()); double averageAtendingTime = (double)int.Parse(json.items.item[i].ast.ToString()) / 60; ticket.AverageAtendingTime = (int)Math.Round(averageAtendingTime, MidpointRounding.AwayFromZero); double averageWaitingTime = (double)int.Parse(json.items.item[i].awt.ToString()) / 60; ticket.AverageWaitingTime = (int)Math.Round(averageWaitingTime, MidpointRounding.AwayFromZero); ticket.ClientsWaiting = int.Parse(json.items.item[i].wc.ToString()); list.Add(ticket); } } return(list); }
/// <summary> /// Posts the ticket entry to be closed to the DataEntry.CloseTicket service /// </summary> /// <param name="td">TicketData entry to close</param> /// <returns>HomePage view with Open records</returns> public async Task <ViewResult> PostEntryClose(TicketData td) { try { Authorize(); } catch (HttpResponseException e) { return(View("Error", Utility.CreateHttpErrorView(e, "You do not have the permissions to view this page"))); } try { DataEntry de = new DataEntry(); RecordRetriever rr = new RecordRetriever(); de.CloseTicket(td); var tdRes = rr.RetrieveRecords(numberOfRecords); return(View("HomePage", tdRes)); } catch (HttpResponseException e) { ServerErrorViewModel error = await Utility.CreateServerErrorView(e); return(View("ServerError", error)); } catch (Exception e) { var guid = ExceptionReporter.DumpException(e); ErrorViewModel error = Utility.CreateBasicExceptionView(e, guid); return(View("Error", error)); } }
public static TicketAnalyser LoadFromFile(string filename) { var lines = File.ReadAllLines(filename); var index = 0; var fieldRanges = new List <FieldRanges>(); while (!string.IsNullOrWhiteSpace(lines[index])) { fieldRanges.Add(new FieldRanges(lines[index])); index += 1; } index += 2; var yourTicket = new TicketData(lines[index]); index += 3; var nearbyTickets = new List <TicketData>(); while (index < lines.Length) { nearbyTickets.Add(new TicketData(lines[index])); index += 1; } return(new TicketAnalyser(fieldRanges, yourTicket, nearbyTickets)); }
public List<TicketModel> GetAll() { TicketData data = new TicketData(_config); var output = data.GetAll(); return output; }
public ValidationStatus Validate(TicketData proj) { _validator = new TicketUnitOfWorkValidator(this); ValidationResult result = _validator.Validate(proj); return(new ValidationStatus { IsValid = result.IsValid, ErrorMessage = _validator.ValidationMessage }); }
private TicketAnalyser( List <FieldRanges> fieldRanges, TicketData yourTicket, List <TicketData> nearbyTickets) { _fieldRanges = fieldRanges; _yourTicket = yourTicket; _nearbyTickets = nearbyTickets; }
private IEnumerable <int> ValuesNotInRange(TicketData ticket) { var invalidValues = ticket .Values .Where(v => !_fieldRanges.Any(fr => fr.InRange(v))) .ToList(); return(invalidValues); }
//convert ticket data from application for webservice private ServiceReference1.ticket TicketToWebservice(TicketData toChange) { ServiceReference1.ticket tmp = new ServiceReference1.ticket(); tmp.ticketnumber = toChange.TicketId; tmp.deleted = toChange.deleted; tmp.entrytime = toChange.EntryTime; tmp.exittime = toChange.ExitTime; return(tmp); }
public void Part2() { TicketData ticketData = TicketDataParser.Parse(StringListRetriever.Retreive("InputList15.txt").ToList()); TicketValidationResult ticketValidationResult = TicketValidator.ValidateNearby(ticketData); FieldOrderResult fieldOrderResult = FieldOrderFinder.FindFieldOrderFor(ticketValidationResult.Tickets, ticketData.ValidationRules); Assert.Equal(1307550234719, fieldOrderResult.FieldOrder.Keys.Where(x => x.StartsWith("departure")) .Select(x => System.Convert.ToInt64(ticketData.Tickets[0].DataItems[fieldOrderResult.FieldOrder[x]])) .Aggregate <long, long>(1, (x, y) => x * y)); }
public async Task PostEntryCloseTest(TicketData td) { ViewResult result = await hc.PostEntryClose(td); ViewResult testView = View("HomePage", "Home"); Assert.IsNotNull(result); Assert.AreEqual(testView.ViewData, result.ViewData); Assert.AreEqual(testView.ViewName, result.ViewName); }
public void Part1Sample() { TicketData ticketData = TicketDataParser.Parse(GetPart1SampleData()); Assert.Equal(3, ticketData.ValidationRules.Count); Assert.Equal(5, ticketData.Tickets.Count); TicketValidationResult ticketValidationResult = TicketValidator.ValidateNearby(ticketData); Assert.Equal(71, ticketValidationResult.InvalidValues.Sum()); }
public void Part2Sample() { TicketData ticketData = TicketDataParser.Parse(GetPart2SampleData()); Assert.Equal(3, ticketData.ValidationRules.Count); Assert.Equal(4, ticketData.Tickets.Count); TicketValidationResult ticketValidationResult = TicketValidator.ValidateNearby(ticketData); Assert.Equal(3, ticketValidationResult.Tickets.Count); FieldOrderResult fieldOrderResult = FieldOrderFinder.FindFieldOrderFor(ticketValidationResult.Tickets, ticketData.ValidationRules); }
public static TicketData GetTestData() { using (var db = new TicketingSystemDBContext()) { Users user = db.Users.Where(u => u.FullName == "Test User").FirstOrDefault(); TicketData td = db.TicketData.Where(t => t.EntryAuthorId == user.UserId).FirstOrDefault(); td.EntryAuthor = user; td.TicketWorker = db.Users.Where(u => u.UserId == td.TicketWorkerId).FirstOrDefault(); td.JobType = db.JobType.Where(jt => jt.JobTypeId == td.JobTypeId).FirstOrDefault(); return(td); } }
internal static TicketValidationResult ValidateNearby(TicketData ticketData) { TicketValidationResult result = new TicketValidationResult(); List <Ticket> nearbyTickets = new List <Ticket>(ticketData.Tickets); nearbyTickets.RemoveAt(0); foreach (Ticket ticket in nearbyTickets) { result.Merge(Validate(ticket, ticketData.ValidationRules)); } return(result); }
/// <summary> /// Posts the new ticket entry to the database /// </summary> /// <param name="td"></param> /// <param name="loggedInUser"></param> /// <returns></returns> public bool PostEntry(TicketData td, UserData loggedInUser) { try { using (var context = new TicketingSystemDBContext()) { IEnumerable<JobType> jobs = context.JobType; int jtypeID = 1; jtypeID = context.JobType.Where(j => j.JobName == td.JobType.JobName).FirstOrDefault().JobTypeId; int authorID = context.Users.Where(a => a.Auth0Uid == loggedInUser.user_id).FirstOrDefault().UserId; var worker = context.Users.Where(w => w.FullName == td.TicketWorker.FullName).FirstOrDefault(); int workerID; if (worker != null) { workerID = worker.UserId; td.TicketWorkerId = workerID; } else { throw new Exception("Error, Employee with name: " + worker.FullName + " not found in System"); } td.JobTypeId = jtypeID; td.TicketClosed = false; td.EntryAuthorId = authorID; td.WorkerName = td.TicketWorker.FullName; td.StartDate = DateTime.Today; //very important null assignment td.JobType = null; td.TicketWorker = null; td.EntryAuthor = null; context.TicketData.Add(td); context.SaveChanges(); int entryID = td.EntryId; TicketDataLogger tdl = new TicketDataLogger(); tdl.LogChange("new entry", "created new entry", entryID, authorID); } } catch (Exception e) { throw new HttpResponseException(Utility.CreateResponseMessage(e)); } return true; }
public async Task PostEditorTest(TicketData td) { using (var db = new TicketingSystemDBContext()) { ViewResult result = await ec.PostEdit(td); RecordRetriever rr = new RecordRetriever(); ViewResult testView = View("Index", rr.RetrieveRecords(10)); Assert.IsNotNull(result); Assert.AreEqual(testView.ViewName, result.ViewName); } }
public void manageDialogueSAC(TicketData ticket, string type) { string phrase = ""; if (ticket.Enabled) { Console.WriteLine("ENABLED"); if (type.Equals("TYPE2")) { phrase = answers.getlastTicketNumber(ticket); Console.WriteLine("GET LAST TICKET NUMBER"); } else if (type.Equals("TYPE3")) { phrase = answers.getTicketAverageWaitingTime(ticket); Console.WriteLine("GET AVERAGE WAITING TICKET NUMBER"); } else if (type.Equals("TYPE4")) { phrase = answers.getTicketPeopleWaiting(ticket); Console.WriteLine("GET PEOPLE WAITING TICKET NUMBER"); } else if (type.Equals("TYPE5")) { phrase = answers.getTicketLineA(ticket); Console.WriteLine("GET INFO ABOUT TICKET A TO PAY FEES"); } } else { if (type.Equals("TYPE5")) { phrase = answers.getTicketLineAClosed(ticket); Console.WriteLine("TICKET A CLOSED - PROPINAS"); } else { phrase = answers.getTicketNotFound(ticket); Console.WriteLine("TICKET NOT FOUND"); } } t.Speak(phrase); Console.WriteLine(phrase); }
public int addTicket(TicketData t) { util = new Util(); param = new List<SqlParameter>(); //to add parameters=> param.Add(new SqlParameter("@gebruikerID", t.gebruikerID)); param.Add(new SqlParameter("@totalePrijs", t.totalePrijs)); param.Add(new SqlParameter("@aankomstdatum", t.aankomstdatum)); param.Add(new SqlParameter("@vertrekdatum", t.vertrekdatum)); param.Add(new SqlParameter("@typeID", t.typeID)); param.Add(new SqlParameter("@treinID", t.treinID)); //SET IDENTITY_INSERT tblGebruikers ON; SqlParameter[] sqlparam = param.ToArray(); strSQL = "INSERT INTO tblTicket (gebruikerID, totalePrijs, aankomstdatum, vertrekDatum, typeID, treinID) VALUES(@gebruikerID, @totalePrijs, @aankomstdatum, @vertrekdatum, @typeID, @treinID);"; return util.updaten(strSQL, sqlparam); }
protected void btnBevestig_Click(object sender, EventArgs e) { TicketAccess tktacc = new TicketAccess(); PersoonAccess persacc = new PersoonAccess(); CapaciteitAccess capacc = new CapaciteitAccess(); GridView grdRitten = (GridView)Session["VPR_grdRitten"]; DataTable rit = (DataTable)Session["VPR_tempRit"]; mail = new StringBuilder(); mail.Append("Beste "+ (String)Session["VPR_fullnaam"]+","); mail.AppendLine("<br/>"); mail.AppendLine("<br/>"); mail.Append("U heeft volgende reis bij VPRtravel geboekt:"); mail.AppendLine("<br/>"); // rij id in het sessionobject met de bestellingstabel int i = 0; foreach (DataRow r in bestelling.Rows) { //mail opstellen mail.Append(r.ItemArray[6].ToString() +" - "+r.ItemArray[7].ToString()); mail.AppendLine("<br/>"); TicketData t = new TicketData(); t.gebruikerID = (int)Session["VPR_id"]; t.totalePrijs = Convert.ToDouble(r.ItemArray[1].ToString()); String s = r.ItemArray[2].ToString(); t.aankomstdatum = DateTime.Parse(r.ItemArray[2].ToString()); t.vertrekdatum = DateTime.Parse(r.ItemArray[3].ToString()); t.typeID = Convert.ToInt32(r.ItemArray[4].ToString()); t.treinID = Convert.ToInt32(r.ItemArray[5].ToString()); tktacc.addTicket(t); int tID = Convert.ToInt32(tktacc.getTicket(t).Rows[0].ItemArray[0]); int tRowID = i; i++; DataTable pers = (DataTable)Session["VPR_personen"]; //mail opstellen mail.Append("met volgende personen als reizigers:"); mail.AppendLine("<br/>"); foreach (DataRow pr in pers.Rows) { if(pr.ItemArray[0].ToString().Equals(tRowID.ToString())) { PersoonData p = new PersoonData(); p.ticketID = tID; p.voornaam = pr.ItemArray[1].ToString(); p.naam = pr.ItemArray[2].ToString(); p.stoelnr = pr.ItemArray[3].ToString(); persacc.addPersoon(p); //mail opstellen mail.Append(p.naam +" "+p.voornaam); mail.AppendLine("<br/>"); } } for (int j = 0; j < rit.Rows.Count; j++) { DateTime datum = DateTime.Parse(grdRitten.Rows[j].Cells[0].Text); DataTable d = new CapaciteitAccess().getCapa(datum, Convert.ToInt32(rit.Rows[j].ItemArray[0].ToString())); CapaciteitData c = new CapaciteitData(); c.datum = datum; c.ritID = Convert.ToInt32(rit.Rows[j].ItemArray[0].ToString()); double extraCapa= specialeDagen(datum, Convert.ToInt32(rit.Rows[j].ItemArray[1].ToString())); if (d.Rows.Count != 0) { c.capaciteit = Convert.ToInt32((extraCapa*Convert.ToInt32(d.Rows[0].ItemArray[0].ToString())) - pers.Rows.Count); capacc.updateCapa(c); } else { DataTable ritTabel = new RitAccess().getRitById(Convert.ToInt32(rit.Rows[j].ItemArray[0].ToString())); c.capaciteit = Convert.ToInt32((extraCapa*Convert.ToInt32(ritTabel.Rows[0].ItemArray[2].ToString())) - pers.Rows.Count); capacc.addCapa(c); } } } //mail opstellen mail.AppendLine("<br/>"); mail.AppendLine("<br/>"); mail.Append("Mvg"); mail.AppendLine("<br/>"); mail.Append("Het VPRtravel team"); String emailAdress = new GebruikersAccess().getMailByID(Convert.ToInt32(Session["VPR_id"].ToString())); Mail.sendMail(mail.ToString(),emailAdress ,Session["VPR_fullnaam"].ToString()); Response.Redirect("BoekSucces.aspx"); }
public DataSet getTicket(TicketData t) { util = new Util(); param = new List<SqlParameter>(); //to add parameters=> param.Add(new SqlParameter("@variabelenaam",variabele)); param.Add(new SqlParameter("@gebruikerID", t.gebruikerID)); param.Add(new SqlParameter("@totalePrijs", t.totalePrijs)); param.Add(new SqlParameter("@aankomstdatum", t.aankomstdatum)); param.Add(new SqlParameter("@vertrekdatum", t.vertrekdatum)); param.Add(new SqlParameter("@typeID", t.typeID)); param.Add(new SqlParameter("@treinID", t.treinID)); SqlParameter[] sqlparam = param.ToArray(); strSQL = "SELECT id FROM tblTicket WHERE( gebruikerID = @gebruikerID AND totalePrijs = @totalePrijs AND aankomstdatum = @aankomstdatum AND vertrekDatum = @vertrekdatum AND typeID = @typeID AND treinID = @treinID);"; return util.ophalen(strSQL, sqlparam); }
public int addTicket(TicketData t) { DAO = new TicketDAO(); return DAO.addTicket(t); }
public DataTable getTicket(TicketData t) { DAO = new TicketDAO(); return DAO.getTicket(t).Tables[0]; }