public JsonResult getTicketDetails([FromBody] TKTInputModel inputModel)
{
try
{
if (inputModel != null)
{
TicketDetails ticketDetails = new TicketDetails();
ticketDetails = db.getTicketDetail(inputModel.qrCode);
object response = new object();
if (ticketDetails == null)
{
response = new { Status = "false", Message = "Authentication failed" };
}
else
{
response = new { status = "true", ticket_details = ticketDetails };
}
var json = new JavaScriptSerializer().Serialize(response);
var result = new JsonResult
{
Data = JsonConvert.DeserializeObject(json)
};
return(result);
}
return(new JsonResult());
}
catch (Exception)
{
throw;
}
}
public async Task <IActionResult> GetTrainTicketDetails(
[FromRoute] int id,
[FromServices] ScheduleApiProxy proxy
)
{
var trainTicket = await _context.Tickets
.SingleOrDefaultAsync(m => m.Id == id);
if (trainTicket == null)
{
return(NotFound());
}
var trainSchedule = await proxy.GetDetailsAsync(trainTicket.TrainScheduleId);
if (trainSchedule == null)
{
return(NotFound());
}
var details = new TicketDetails()
{
Id = trainTicket.Id,
PassengerName = trainTicket.PassengerName,
Destination = trainSchedule.Destination,
DepartureTime = trainSchedule.DepartureTime,
Price = trainSchedule.DistanceKm * 0.6M
};
return(Ok(details));
}
public TicketDetails GetDetails(int id)
{
var ticket = GetById(id);
var flight = _flightService.GetById(ticket.FlightId);
return(TicketDetails.Create(ticket, flight));
}
public TicketDetails getTicketDetail(string qrcode)
{
TicketDetails ticketDetails = new TicketDetails();
try
{
SqlCommand cmd = new SqlCommand("getTicketDetail", con);
cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("", "");
con.Open();
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
if (ds != null && ds.Tables.Count > 0)
{
foreach (DataRow dRow in ds.Tables[0].Rows)
{
}
}
return(ticketDetails);
}
catch (Exception ex)
{
return(ticketDetails);
}
finally
{
con.Close();
}
}
public IHttpActionResult PutEmployee(int id, TicketDetails t)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != t.ReqID)
{
return(BadRequest());
}
//db.Entry(t).State = EntityState.Modified;
db.TicketAction(id, t.managerApproval);
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!TicketDetailExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
private static Export extractData(SQLiteDataReader reader)
{
Export ticket = new Export();
ticket.Id = reader.GetInt32(0);
ticket.Staff = StaffDAL.GetById(reader.GetInt32(1));
ticket.Date = reader.GetString(2);
ticket.Receipt = ReceiptDAL.GetById(reader.GetInt32(3));
string detailsQuery = $"SELECT * FROM {subTable} WHERE ticketId = @ticketId";
SQLiteCommand detailsCommand = new SQLiteCommand(detailsQuery, DAL.Conn);
detailsCommand.Parameters.AddWithValue("@ticketId", ticket.Id);
SQLiteDataReader detailsReader = detailsCommand.ExecuteReader();
while (detailsReader.HasRows)
{
while (detailsReader.Read())
{
TicketDetails details = new TicketDetails();
details.Ticket = ticket;
details.Product = ProductDAL.GetById(detailsReader.GetInt32(1));
details.Amount = detailsReader.GetInt32(2);
ticket.Details.Add(details);
}
detailsReader.NextResult();
}
return(ticket);
}
public void MockInsert()
{
for (int i = 0; i < 100000; i++)
{
var generate = new GenerateTicketNo();
var applicationNo =
generate.ApplicationNo(_category.GetCategoryCodeByCategoryId(1));
var tickets = new Tickets();
tickets.TicketId = 0;
tickets.CreatedDate = DateTime.Now;
tickets.TrackingId = applicationNo;
tickets.StatusAssigned = false;
tickets.Contact = "9999999999";
tickets.Email = "*****@*****.**";
tickets.PriorityId = 3;
tickets.CategoryId = 1;
tickets.Name = "Joejoe";
tickets.UserId = Convert.ToInt32(_sessionHandler.UserId);
var message = @"<p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p>
Thanks & Regards,
IT Analyst
";
var ticketDetails = new TicketDetails()
{
Subject = "Lorem Ipsum is simply dummy text of the printing and typesetting indus",
Message = message,
TicketDetailsId = 0
};
var ticketId = _tickets.AddTickets(Convert.ToInt64(_sessionHandler.UserId), tickets, ticketDetails, null, null);
}
}
public ActionResult Test()
{
TicketDetails details = new TicketDetails();
var g = details.GetTicketDetails;
return(View(g));
}
public async Task <ServiceResponse <GetTicketDetailsDTO> > UpdateTicketDetails(UpdateTicketDetailsDTO updatedTicketDetails)
{
ServiceResponse <GetTicketDetailsDTO> serviceResponse = new ServiceResponse <GetTicketDetailsDTO>();
try
{
TicketDetails td = await _context.TicketDetails.Where(td => td.IsDeleted == false)
.FirstOrDefaultAsync(td => td.Id == updatedTicketDetails.Id);
td.DateAdded = updatedTicketDetails.DateAdded;
td.Price = updatedTicketDetails.Price;
if (updatedTicketDetails.Event != null)
{
td.Event = updatedTicketDetails.Event;
}
_context.TicketDetails.Update(td);
await _context.SaveChangesAsync();
serviceResponse.Data = _mapper.Map <GetTicketDetailsDTO>(td);
}
catch (Exception exc)
{
serviceResponse.Success = false;
serviceResponse.Message = exc.Message;
}
return(serviceResponse);
}
public async Task GetsCorrectTrack()
{
//лучше создать и добавить новый тикет
var expected = await _context.Tickets.Select(t => new
{
t.Id,
t.Track
})
.FirstAsync();
var query = new TicketDetails()
{
Id = expected.Id
};
var handler = new TicketDetailsHandler(_context, GetMapper());
var result = (await handler.Handle(query, new System.Threading.CancellationToken()))
.Ticket
.Entries;
CollectionAssert.IsNotEmpty(result);
Assert.AreEqual(expected.Track.Count(), result.Count());
CollectionAssert.AreEqual(expected.Track, result, new TrackComparer());
}
public IActionResult Create([FromBody] TicketDetails ticket)
{
CreateTicketEvent @event = new CreateTicketEvent(ticket);
TicketCreatedEvent outputEvt = ticketService.Create(@event);
Ticket output = Ticket.FromTicketDetails(outputEvt.Object);
return(CreatedAtRoute("Get", new { code = outputEvt.Object.Code }, output));
}
private void DispenseChange(TicketDetails ticket, Action onPayChangeToMobilePhone)
{
if (_cashAccepted > ticket.Price &&
!TryToDispense(_cashAccepted - ticket.Price))
{
onPayChangeToMobilePhone?.Invoke();
}
}
public async Task <ServiceResponse <GetTicketDetailsDTO> > GetTicketDetailsById(int id)
{
ServiceResponse <GetTicketDetailsDTO> serviceResponse = new ServiceResponse <GetTicketDetailsDTO>();
TicketDetails dbDetails = await _context.TicketDetails.Where(td => td.IsDeleted == false)
.FirstOrDefaultAsync(td => td.Id == id);
serviceResponse.Data = _mapper.Map <GetTicketDetailsDTO>(dbDetails);
return(serviceResponse);
}
/**
* Translate the ticket to the domain model
*
* @param ticketDetails
* @return model
*/
public static Ticket FromTicketDetails(TicketDetails ticketDetails)
{
Ticket domain = new Ticket();
domain.Code = ticketDetails.Code;
domain.Creation = ticketDetails.Creation;
domain.Priority = ticketDetails.Priority;
return(domain);
}
private TicketDetails TicketDetailsFrom(string counterName)
{
if (!_dictionary.TryGetValue(counterName, out var ticketDetails))
{
ticketDetails = new TicketDetails();
_dictionary[counterName] = ticketDetails;
}
return(ticketDetails);
}
// Get tickets from the PostgreSQL database and return the tickets as a JSON string
public string GetTicketsList()
{
this.ticketStatus.TicketsDetailsList = new List <TicketDetails>();
using (NpgsqlCommand sqlCmd = new NpgsqlCommand())
{
sqlCmd.CommandType = System.Data.CommandType.Text;
sqlCmd.CommandText = "SELECT TICKETID,CREATED, DATEASSIGNED,TITLE,DESCRIPTION,coalesce(PRIORITY,'') AS PRIORITY ," +
"coalesce(ASSIGNEDTO,'') AS ASSIGNEDTO," +
" TICKETSTATUS FROM TICKETS";
NpgsqlConnection conn = new NpgsqlConnection(GetConnectionString());
conn.Open();
// SELECT records from changed table...
// Query tickets.
sqlCmd.Connection = conn;
using (NpgsqlDataReader reader = sqlCmd.ExecuteReader())
{
string DateAssignedstr = "";
while (reader.Read())
// conn.Wait();
{
// check if DateTime field DateAssigned is null
if (!reader.IsDBNull(2))
{
DateAssignedstr = reader.GetDateTime(2).ToString();
}
else
{
DateAssignedstr = String.Empty;
}
TicketDetails ticket = new TicketDetails();
ticket.TicketId = reader.GetInt32(0);
ticket.Created = reader.GetDateTime(1).ToString();
ticket.DateAssigned = DateAssignedstr; //
ticket.Title = reader.GetString(3);
ticket.Description = reader.GetString(4);
ticket.Priority = reader.GetString(5);
ticket.AssignedTo = reader.GetString(6);
ticket.TicketStatus = reader.GetString(7);
// Add this ticket to the TicketsDetailsList list object
ticketStatus.TicketsDetailsList.Add(ticket);
}
reader.Close();
conn.Close();
}
}
HttpRuntime.Cache["Tickets"] = SerializeObjectToJson(ticketStatus);
return(HttpRuntime.Cache["Tickets"] as string);
}
public override void CreateTicketDetails()
{
TicketDetailInfo = new TicketDetails
{
ValidTime = monthTicketDetailsFactory.GetValidTime(),
From = monthTicketDetailsFactory.SetFromStation(),
Price = monthTicketDetailsFactory.SetPrice(),
To = monthTicketDetailsFactory.SetToStation(),
Category = monthTicketDetailsFactory.SetCategory()
};
}
public IHttpActionResult GetTicketDetail(int id)
{
TicketDetails ticketDetail = db.TicketDetails.Find(id);
if (ticketDetail == null)
{
return(NotFound());
}
return(Ok(ticketDetail));
}
public JsonResult AddTicketDetail(TicketDetails detail)
{
var listTicketDetail = new List<TicketDetails>();
if (SessionUtilities.Exist(Constant.SESSION_TicketDetails))
{
listTicketDetail = (List<TicketDetails>)SessionUtilities.Get(Constant.SESSION_TicketDetails);
}
listTicketDetail.Add(detail);
SessionUtilities.Set(Constant.SESSION_TicketDetails, listTicketDetail);
return Json(new { }, JsonRequestBehavior.AllowGet);
}
public async Task <IActionResult> TicketDetails(int extraPrice, string description, float ticketPrice, string user)
{
TicketDetails details = new TicketDetails();
details.Description = description;
details.price = ticketPrice;
details.extraPrice = extraPrice;
details.username = user;
details.totalPrice = ticketPrice + extraPrice;
return(View(details));
}
public TicketDetails GetDetails(int id)
{
var ticket = _unitOfWork.Set <Ticket>()
.Details(x => x.Id == id).FirstOrDefault();
if (ticket == null)
{
throw new NotFoundException("Ticket with such id was not found");
}
return(TicketDetails.Create(ticket));
}
public IList <TicketDetails> GetAllDetails()
{
var tickets = GetAll();
var flights = _flightService.GetAll();
var joined = from ticket in tickets
join flight in flights
on ticket.FlightId equals flight.Id
select TicketDetails.Create(ticket, flight);
return(joined.ToList());
}
public void BuyTicket(TicketDetails ticket,
PaymentDetails payment, Action onPayChangeToMobilePhone)
{
if (payment.Method == PaymentMethod.CreditCard)
{
ChargeCard(ticket, payment);
}
else
{
AcceptCash(ticket);
DispenseChange(ticket, onPayChangeToMobilePhone);
}
}
public async Task CanGetTicket()
{
var ticket = await _context.Tickets.FirstAsync();
var query = new TicketDetails()
{
Id = ticket.Id
};
var handler = new TicketDetailsHandler(_context, GetMapper());
var result = await handler.Handle(query, new System.Threading.CancellationToken());
Assert.IsNotNull(result as TicketDetailsVm);
}
public void Throws_onWrongIdn()
{
const int InvalidId = -1;
string errorMsg = $"Entity \"Ticket\" ({InvalidId}) was not found.";
var query = new TicketDetails()
{
Id = InvalidId
};
var handler = new TicketDetailsHandler(_context, GetMapper());
var act = Assert.ThrowsAsync <NotFoundException>(async() =>
await handler.Handle(query, new System.Threading.CancellationToken()));
StringAssert.AreEqualIgnoringCase(errorMsg, act.Message);
}
public IActionResult Post([FromBody] TicketDetails value)
{
try
{
var GenerateTicket = ticketRepository.BookTicket(value);
if (GenerateTicket == null)
{
return(NotFound("Error"));
}
return(Ok(GenerateTicket));
}
catch (Exception)
{
return(BadRequest("Link Failure"));
}
}
/**
* Translate the domain model to the API
*
* @return the transfer object
*/
public TicketDetails ToTicketDetails()
{
TicketDetails transferObject = new TicketDetails();
transferObject.Code = this.Code;
transferObject.Creation = this.Creation;
transferObject.Priority = this.Priority;
Account account = this.Account;
if (account != null)
{
// Loading other domain model dependencies
transferObject.Account = account.Login;
}
return(transferObject);
}
private async void btnAdd_Click(object sender, EventArgs e)
{
List <Product> rows_product = new List <Product>();
var x = dataGridViewProduct.Rows.Count;
for (int rows = 0; rows < dataGridViewProduct.Rows.Count - 1; rows++)
{
Product product = new Product()
{
Id = Int32.Parse(dataGridViewProduct.Rows[rows].Cells[0].Value.ToString()),
Name = dataGridViewProduct.Rows[rows].Cells[1].Value.ToString(),
Amount = Int32.Parse(dataGridViewProduct.Rows[rows].Cells[2].Value.ToString())
};
rows_product.Add(product);
}
List <TicketDetails> listTicketDetails = new List <TicketDetails>();
foreach (var item in rows_product)
{
TicketDetails ticketDetails = new TicketDetails()
{
Product = new Product()
{
Id = item.Id
},
Amount = item.Amount
};
listTicketDetails.Add(ticketDetails);
}
Import import = new Import()
{
Date = dateDate.Text,
//TotalAmount = Int32.Parse(textTotalAmount.Text),
//TotalCost = Double.Parse(textTotalCost.Text),
Staff = new Staff()
{
Id = 1
},
Details = listTicketDetails
};
await ApiHandler.client.PostAsJsonAsync("Import", import);
LoadDataImport();
}
public void TestCreateTicket()
{
TicketDetails ticket = new TicketDetails();
ticket.Account = "root";
ticket.Priority = 5;
CreateTicketEvent @event = new CreateTicketEvent(ticket);
TicketCreatedEvent evtOutput = ticketService.Create(@event);
Assert.Equal(ResponseCode.OK, evtOutput.Code);
TicketDetails output = evtOutput.Object;
Assert.Equal(5, output.Priority);
Assert.True(output.Code > 0);
}
public ActionResult PurchaseDetails(TicketDetails td)
{
if (ModelState.IsValid)
{
return(View("PurchaseSummary", td));
}
else
{
return(RedirectToAction("PurchaseDetails", new
{
OriginLoc = td.Passenger.OriginLocID,
DestiLoc = td.Passenger.DestiLocID,
WayLoc = td.Passenger.WayLocID,
Citizen = td.Passenger.CitizenID,
Quantity = td.Passenger.Quantity
}));
}
}
public async Task <ServiceResponse <List <GetTicketDetailsDTO> > > AddTicketDetails(AddTicketDetailsDTO newTicketDetails)
{
ServiceResponse <List <GetTicketDetailsDTO> > serviceResponse = new ServiceResponse <List <GetTicketDetailsDTO> >();
TicketDetails td = _mapper.Map <TicketDetails>(newTicketDetails);
td.IsDeleted = false;
td.DateAdded = DateTime.Now;
if (td.Event == null)
{
serviceResponse.Success = false;
serviceResponse.Message = "Please enter sufficient data. Event is missing.";
return(serviceResponse);
}
await _context.TicketDetails.AddAsync(td);
await _context.SaveChangesAsync();
serviceResponse.Data = (_context.TicketDetails.Select(e => _mapper.Map <GetTicketDetailsDTO>(td))).ToList();
return(serviceResponse);
}
