public void Query(out string pageHtml)
{
pageHtml = string.Empty;
var request = new TicketsRequest();
if ((request.state == TicketsState.All))
{
request.state = null;
}
request.Bdate = Data.Start;
request.Edate = Data.End;
if (request.pageIndex == null || request.pageIndex <= 0)
{
request.pageIndex = 1;
}
if (request.pageSize == null || request.pageSize <= 0)
{
request.pageSize = 10;
}
var query = TicketsService.GetList(request);
if (query != null)
{
List = query.ModelList.ToList(this, u => new ListTickets(u));
pageHtml = MvcPage.AjaxPager((int)request.pageIndex, (int)request.pageSize, query.TotalCount);
}
}
public List <ListTickets> AjaxGet(TicketsRequest request, out string pageHtml)
{
List <ListTickets> data = null;
pageHtml = string.Empty;
if ((request.state == TicketsState.All))
{
request.state = null;
}
if (request.pageIndex == null || request.pageIndex <= 0)
{
request.pageIndex = 1;
}
if (request.pageSize == null || request.pageSize <= 0)
{
request.pageSize = 10;
}
var query = TicketsService.GetList(request);
if (query != null)
{
data = query.ModelList.Select(u => new ListTickets(u)).ToList();
pageHtml = MvcPage.AjaxPager((int)request.pageIndex, (int)request.pageSize, query.TotalCount);
}
return(data);
}
public ActionResult ListPost(TicketsRequest request)
{
var createRole = _unityContainer.Resolve <Models.Ticketss.ListTicketss>();
string pageHtml = string.Empty;
var datas = createRole.AjaxGet(request, out pageHtml);
return(Json(new { tables = datas, html = pageHtml }));
}
public HttpResponseMessage Get([FromUri] TicketsRequest model)
{
return(Request.CreateResponse(HttpStatusCode.OK, new TicketsResponse
{
DepartureStation = new Station
{
Id = "22200001",
Name = "КИЕВ-ПАССАЖИРСКИЙ"
},
ArrivalStation = new Station
{
Id = "22204001",
Name = "ХАРЬКОВ-ПАСС"
},
DepartureDate = model.DepartureDate,
ReturnDate = model.ReturnDate,
Variants = new TicketsVariant
{
Id = "c1912161-a121-7d0d-00cb-00373736cf00",
DepartureDate = model.DepartureDate,
ArrivalDate = model.DepartureDate.AddDays(1),
Duration = new TimeSpan(0, 10, 15, 0),
Trip = new Trip
{
Id = "776П",
DepartureStation = new Station
{
Id = "22200001",
Name = "КИЕВ-ПАССАЖИРСКИЙ"
},
ArrivalStation = new Station
{
Id = "22204001",
Name = "ХАРЬКОВ-ПАСС"
}
},
Cars = new List <Car>
{
new Car
{
Type = CarType.RailwayPlats,
Number = 6,
Price = 305,
Seats = new List <Seat>
{
new Seat
{
Type = SeatsType.RailwayBottom,
FreeSeats = new List <string> {
"4", "9", "40"
}
}
}
}
}
}
}));
}
public DataTables <Ticketss> GetList(TicketsRequest request)
{
SqlParameter[] param =
{
new SqlParameter("@Bdate", request.Bdate),
new SqlParameter("@code", request.code),
new SqlParameter("@Edate", request.Edate),
new SqlParameter("@mobile", request.mobile),
new SqlParameter("@orderNo", request.orderNo),
new SqlParameter("@state", request.state),
new SqlParameter("@ticketName", request.ticketName),
new SqlParameter("@useScope", request.useScope),
new SqlParameter("@pageIndex", request.pageIndex),
new SqlParameter("@pageSize", request.pageSize)
};
StoreProcedure sp = new StoreProcedure("P_getTicketss", param);
return(_databaseInstance.GetTables <Ticketss>(sp));
}