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