public static int[] GetNumbersOfPlaces(this HtmlHelper helper, int routeId) //Метод, расширяющий хелпер @Html
{
List <int> freetickets = new List <int>();
List <int> busytickets = new List <int>();
using (WorkWithDatabase db = new WorkWithDatabase())
{
int RouteId = routeId;
var countst = db.GetEntityById <Route, int>(RouteId).MaxNumberOfPlace;
if (countst > 0)
{
int countOfPlace = Convert.ToInt32(countst);
int[] masplace = new int[countOfPlace];
busytickets = db.GetEntityList <Ticket>().Where(x => x.Route.Id.Equals(RouteId)).Select(x => x.NumberOfPlace).ToList();
for (int i = 1; i <= countOfPlace; i++)
{
if (!busytickets.Contains(i))
{
freetickets.Add(i);
}
}
}
}
return(freetickets.ToArray());
}
public ActionResult ReturnTicket(int ticketId)
{
using (WorkWithDatabase db = new WorkWithDatabase())
{
Ticket tic = db.GetEntityById <Ticket, int>(ticketId);
tic.IsDeleted = true;
db.Commit();
}
return(RedirectToAction("TicketInformation"));
}
public ActionResult BuyBookTicket(int tickId)
{
using (WorkWithDatabase db = new WorkWithDatabase())
{
Ticket tick = db.GetEntityById <Ticket, int>(tickId);
tick.Condition = TypeOfTicketEnum.Bought;
db.Commit();
}
return(RedirectToAction("TicketInformation"));
}
public ActionResult Buy()
{
Ticket ticket = new Ticket();
using (WorkWithDatabase db = new WorkWithDatabase())
{
string s = Session[BookTickets.Properties.Resources.RouteID].ToString();
if (s != null)
{
int r = Convert.ToInt32(s);
var rout = db.GetEntityById<Route, int>(r);
ticket.Route = rout;
}
}
return View("Buy", ticket);
}
public ActionResult Buy()
{
Ticket ticket = new Ticket();
using (WorkWithDatabase db = new WorkWithDatabase())
{
string s = Session[BookTickets.Properties.Resources.RouteID].ToString();
if (s != null)
{
int r = Convert.ToInt32(s);
var rout = db.GetEntityById <Route, int>(r);
ticket.Route = rout;
}
}
return(View("Buy", ticket));
}
public ActionResult Buy(Ticket tick)
{
if (tick.NumberOfPlace != 0)
{
using (WorkWithDatabase db = new WorkWithDatabase())
{
tick.Condition = TypeOfTicketEnum.Bought;
string s1 = Session[BookTickets.Properties.Resources.LogInUserName].ToString();
string s2 = Session[BookTickets.Properties.Resources.LogInUserPassword].ToString();
var per = db.GetEntityList <Person>().Where(x => x.LogName.Equals(s1) && x.Password.Equals(s2)).FirstOrDefault();
var route = db.GetEntityById <Route, int>(tick.Route.RouteID);
tick.Person = per;
tick.Route = route;
db.Insert <Ticket>(tick);
db.Commit();
}
return(RedirectToAction("TicketInformation"));
}
else
{
return(View());
}
}
public ActionResult Buy(Ticket tick)
{
if (tick.NumberOfPlace != 0)
{
using (WorkWithDatabase db = new WorkWithDatabase())
{
tick.Condition = TypeOfTicketEnum.Bought;
string s1 = Session[BookTickets.Properties.Resources.LogInUserName].ToString();
string s2 = Session[BookTickets.Properties.Resources.LogInUserPassword].ToString();
var per = db.GetEntityList<Person>().Where(x => x.LogName.Equals(s1) && x.Password.Equals(s2)).FirstOrDefault();
var route = db.GetEntityById<Route, int>(tick.Route.RouteID);
tick.Person = per;
tick.Route = route;
db.Insert<Ticket>(tick);
db.Commit();
}
return RedirectToAction("TicketInformation");
}
else
{
return View();
}
}
public static int[] GetNumbersOfPlaces(this HtmlHelper helper, int routeId)//Метод, расширяющий хелпер @Html
{
List<int> freetickets = new List<int>();
List<int> busytickets = new List<int>();
using (WorkWithDatabase db = new WorkWithDatabase())
{
int RouteId = routeId;
var countst = db.GetEntityById<Route, int>(RouteId).MaxNumberOfPlace;
if (countst > 0)
{
int countOfPlace = Convert.ToInt32(countst);
int[] masplace = new int[countOfPlace];
busytickets = db.GetEntityList<Ticket>().Where(x => x.Route.Id.Equals(RouteId)).Select(x => x.NumberOfPlace).ToList();
for (int i = 1; i <= countOfPlace; i++)
{
if (!busytickets.Contains(i)) { freetickets.Add(i); }
}
}
}
return freetickets.ToArray();
}
public ActionResult ReturnTicket(int ticketId)
{
using (WorkWithDatabase db = new WorkWithDatabase())
{
Ticket tic = db.GetEntityById<Ticket, int>(ticketId);
tic.IsDeleted = true;
db.Commit();
}
return RedirectToAction("TicketInformation");
}
public ActionResult BuyBookTicket(int tickId)
{
using (WorkWithDatabase db = new WorkWithDatabase())
{
Ticket tick = db.GetEntityById<Ticket, int>(tickId);
tick.Condition = TypeOfTicketEnum.Bought;
db.Commit();
}
return RedirectToAction("TicketInformation");
}