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