//DELETE : TicketType
public ActionResult DeleteTicketType(int Id)
{
if (TicketTypeUtils.DeleteTicketType(Id))
{
return(RedirectToAction("ListTicketTypes"));
}
return(RedirectToAction("ListTicketTypes"));
}
public ActionResult CreateTicketType(TicketType Type)
{
if (ModelState.IsValid)
{
if (TicketTypeUtils.InsertTicketType(Mappings.MappingDtos.ModelTicketTypeToEntityTicketType(Type)))
{
return(RedirectToAction("ListTicketTypes"));
}
}
return(View(Type));
}
//GET : Ticket Types
public ActionResult ListTicketTypes(int?page, string seachString)
{
List <DataAccessLayer.Entities.TicketType> typesContextList = TicketTypeUtils.GetAllTicketTypes();
List <TicketType> typeList = Mappings.MappingDtos.EntityTicketLIstToModelTicketTypeAsList(typesContextList);
if (!String.IsNullOrEmpty(seachString))
{
typeList = typeList.Where(s => s.Name.ToLower().Contains(seachString.ToLower())).ToList();
}
return(View(typeList.ToPagedList(page ?? 1, pageSize: 20)));
}
public ActionResult TicketsList(Client client)
{
if (Session["TicType"] != null)
{
List <TicketType> SelectType = new List <TicketType>();
SelectType.Add(MappingDtos.EntityTicketTypeToModelTicketType(TicketTypeUtils.GetTicketById(Int32.Parse(Session["TicType"].ToString()))));
Session["TicType"] = null;
var data = MappingDtos.EntityTicketLIstToModelTicketAsList(TicketUtils.GetListOfTicketByClientId(client.Id));
return(View(new TicketsClient {
Client = client, Tickets = data, Types = SelectType
}));
}
else
{
var data = MappingDtos.EntityTicketLIstToModelTicketAsList(TicketUtils.GetListOfTicketByClientId(client.Id));
return(View(new TicketsClient {
Client = client, Tickets = data, Types = MappingDtos.EntityTicketLIstToModelTicketTypeAsList(TicketTypeUtils.GetAllTicketTypes())
}));
}
}
public static TicketType getTicketTypeByTypeName(string whatName)
{
return(Mappings.MappingDtos.EntityTicketTypeToModelTicketType(TicketTypeUtils.GetTicketTypeByTypeName(whatName)));
}
public ActionResult SaveToXls(string what)
{
DataTable dt = null;
bool result = false;
switch (what)
{
case "Client":
List <DataAccessLayer.Entities.Client> layerClientList = ClientUtils.GetAllClients();
List <Client> clientList = Mappings.MappingDtos.EntityClientToModelClientAsList(layerClientList);
dt = DataToExcel.ConvertToDataTable(clientList);
result = DataToExcel.FlushToExcel <Client>(dt);
break;
case "Employee":
List <DataAccessLayer.Entities.Employee> layerEmplyeeList = EmployeeUtils.GetAllEmplyees();
List <Employee> employeeList = Mappings.MappingDtos.EntityEmployeeToModelEmployeeAsList(layerEmplyeeList);
dt = DataToExcel.ConvertToDataTable(employeeList);
result = DataToExcel.FlushToExcel <Employee>(dt);
break;
case "Event":
List <DataAccessLayer.Entities.Event> layerEventList = EventUtils.GetAllEvents();
List <Event> eventList = Mappings.MappingDtos.EntityEventToModelEventList(layerEventList);
dt = DataToExcel.ConvertToDataTable(eventList);
result = DataToExcel.FlushToExcel <Event>(dt);
break;
case "Room":
List <DataAccessLayer.Entities.Room> layerRoomList = RoomUtils.GetAllRooms();
List <Room> roomList = Mappings.MappingDtos.EntityRoomToModelRoomAsList(layerRoomList);
dt = DataToExcel.ConvertToDataTable(roomList);
result = DataToExcel.FlushToExcel <Room>(dt);
break;
case "Ticket":
List <DataAccessLayer.Entities.Ticket> layerTicketList = TicketUtils.GetAllTickets();
List <Ticket> ticketList = Mappings.MappingDtos.EntityTicketLIstToModelTicketAsList(layerTicketList);
dt = DataToExcel.ConvertToDataTable(ticketList);
result = DataToExcel.FlushToExcel <Ticket>(dt);
break;
case "Type":
List <DataAccessLayer.Entities.TicketType> layerTypeList = TicketTypeUtils.GetAllTicketTypes();
List <TicketType> typeList = Mappings.MappingDtos.EntityTicketLIstToModelTicketTypeAsList(layerTypeList);
dt = DataToExcel.ConvertToDataTable(typeList);
result = DataToExcel.FlushToExcel <TicketType>(dt);
break;
default:
break;
}
if (result)
{
return(RedirectToAction("ListEmployees"));
}
else
{
return(RedirectToAction("Index"));
}
}
//GET : Events
public ActionResult ListEvents(int?page, string searchString, string category = "", string usedate = "")
{
int cid = 0;
List <DataAccessLayer.Entities.Event> eventContextList = EventUtils.GetAllEvents();
List <Event> eventList = Mappings.MappingDtos.EntityEventToModelEventList(eventContextList);
List <TicketType> type = Mappings.MappingDtos.EntityTicketLIstToModelTicketTypeAsList(TicketTypeUtils.GetAllTicketTypes());
ViewBag.tklist = type;
if (!String.IsNullOrEmpty(searchString))
{
if (Int32.TryParse(searchString, out cid))
{
var c = ClientUtils.GetClientById(cid);
eventList = eventList.Where(s => s.ClientName == (c.FirstName + " " + c.LastName)).ToList();
}
else
{
eventList = eventList.Where(s => s.ClientName.ToLower().Contains(searchString.ToLower())).ToList();
}
}
if (!String.IsNullOrEmpty(category))
{
eventList = eventList.Where(s => s.TicketId == Int32.Parse(category)).ToList();
}
if (!String.IsNullOrEmpty(usedate))
{
eventList = eventList.Where(s => s.Date.ToString("yyyy'-'MM'-'dd").Contains(usedate)).ToList();
}
return(View(eventList.ToPagedList(page ?? 1, pageSize: 20)));
}
//GET : Tickets
public ActionResult ListTickets(int?page, string searchString, bool active = false, bool inactive = false, string category = "")
{
List <DataAccessLayer.Entities.Ticket> ticketContextList = TicketUtils.GetAllTickets();
List <Ticket> ticketList = Mappings.MappingDtos.EntityTicketLIstToModelTicketAsList(ticketContextList);
List <TicketType> type = Mappings.MappingDtos.EntityTicketLIstToModelTicketTypeAsList(TicketTypeUtils.GetAllTicketTypes());
ViewBag.tklist = type;
if (active && inactive && String.IsNullOrEmpty(category))
{
if (!String.IsNullOrEmpty(searchString))
{
ticketList = ticketList.Where(s => s.TicketName.ToLower().Contains(searchString.ToLower())).ToList();
}
}
else
{
if (!String.IsNullOrEmpty(searchString))
{
ticketList = ticketList.Where(s => s.TicketName.ToLower().Contains(searchString.ToLower())).ToList();
}
if (!String.IsNullOrEmpty(category))
{
ticketList = ticketList.Where(s => s.TicketName == category).ToList();
}
if (active)
{
List <Ticket> tic = new List <Ticket>();
foreach (var ticket in ticketList)
{
var ticketType = TicketTypeUtils.GetTicketTypeByTypeName(ticket.TicketName);
var date = ticket.StartDate;
if (ticketType.DayNum != 0 && ticketType.OccasionNum != 0)
{
if (ticketType.DayNum - ticket.LoginsNum > 0)
{
tic.Add(ticket);
}
}
if (ticketType.DayNum != 0 && date.AddDays(ticketType.DayNum) > DateTime.Now)
{
if (ticketType.DayNum - ticket.LoginsNum > 0)
{
tic.Add(ticket);
}
}
if (ticketType.OccasionNum != 0)
{
if (ticketType.OccasionNum - ticket.LoginsNum > 0)
{
tic.Add(ticket);
}
}
}
ticketList = tic;
}
if (inactive)
{
List <Ticket> tic = new List <Ticket>();
foreach (var ticket in ticketList)
{
var ticketType = TicketTypeUtils.GetTicketTypeByTypeName(ticket.TicketName);
var date = ticket.StartDate;
if (ticketType.DayNum != 0 && ticketType.OccasionNum != 0)
{
if (ticketType.DayNum - ticket.LoginsNum < 0)
{
tic.Add(ticket);
}
}
if (ticketType.DayNum != 0 && date.AddDays(ticketType.DayNum) < DateTime.Now)
{
if (ticketType.DayNum - ticket.LoginsNum < 0)
{
tic.Add(ticket);
}
}
if (ticketType.OccasionNum != 0)
{
if (ticketType.OccasionNum - ticket.LoginsNum < 0)
{
tic.Add(ticket);
}
}
}
ticketList = tic;
}
}
return(View(ticketList.ToPagedList(page ?? 1, pageSize: 20)));
}
// GET: Employee/TicketTypeLists
public ActionResult TicketTypesList()
{
var data = MappingDtos.EntityTicketLIstToModelTicketTypeAsList(TicketTypeUtils.GetAllTicketTypes());
return(View(data));
}
