// GET: /List public ActionResult List(int?page, string csu, int id, string sortField, int?sortOrder, string filter) { //Set Access Rights ViewData["Access"] = ""; RolesRepository rolesRepository = new RolesRepository(); if (rolesRepository.HasWriteAccessToClientSubUnit(csu) && hierarchyRepository.AdminHasDomainWriteAccess(groupName)) { ViewData["Access"] = "WriteAccess"; } //Sorting if (sortField == null || sortField == "UsageTypeDescription") { sortField = "UsageTypeDescription"; } ViewData["CurrentSortField"] = sortField; //Ordering if (sortOrder == 1) { ViewData["NewSortOrder"] = 0; ViewData["CurrentSortOrder"] = 1; } else { ViewData["NewSortOrder"] = 1; ViewData["CurrentSortOrder"] = 0; sortOrder = 0; }; AdditionalBookingCommentsVM additionalBookingCommentsVM = new AdditionalBookingCommentsVM(); additionalBookingCommentsVM.AdditionalBookingComments = additionalBookingCommentRepository.PageAdditionalBookingComments(page ?? 1, id, sortField, sortOrder, filter ?? ""); ClientSubUnit clientSubUnit = new ClientSubUnit(); clientSubUnit = clientSubUnitRepository.GetClientSubUnit(csu); //Check clientSubUnit if (clientSubUnit == null) { ViewData["ActionMethod"] = "List"; return(View("RecordDoesNotExistError")); } additionalBookingCommentsVM.ClientSubUnit = clientSubUnit; //Get BookingChannel BookingChannel BookingChannel = new BookingChannel(); BookingChannel = BookingChannelRepository.BookingChannel(id); additionalBookingCommentsVM.BookingChannel = BookingChannel; //return items return(View(additionalBookingCommentsVM)); }
public AdditionalBookingCommentsVM( ClientSubUnit clientSubUnit, CWTPaginatedList <spDesktopDataAdmin_SelectAdditionalBookingComments_v1Result> additionalBookingComments, BookingChannel bookingChannel ) { ClientSubUnit = clientSubUnit; AdditionalBookingComments = additionalBookingComments; BookingChannel = bookingChannel; }
public BookingChannelVM( BookingChannel bookingChannel, ClientSubUnit clientSubUnit, IEnumerable <SelectListItem> bookingTypes ) { BookingChannel = bookingChannel; ClientSubUnit = clientSubUnit; UsageTypes = bookingTypes; }
//Delete From DB public void Delete(BookingChannel BookingChannel) { string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0]; db.spDesktopDataAdmin_DeleteClientSubUnitBookingChannel_v1( BookingChannel.BookingChannelId, BookingChannel.VersionNumber, adminUserGuid ); }
public ActionResult Delete(BookingChannelVM bookingChannelVM) { //Get BookingChannel BookingChannel bookingChannel = new BookingChannel(); bookingChannel = bookingChannelRepository.BookingChannel( bookingChannelVM.BookingChannel.BookingChannelId ); //Check Exists if (bookingChannel == null) { ViewData["ActionMethod"] = "DeletePost"; return(View("RecordDoesNotExistError")); } //Access Rights RolesRepository rolesRepository = new RolesRepository(); if (!rolesRepository.HasWriteAccessToClientSubUnit(bookingChannel.ClientSubUnitGuid) || !hierarchyRepository.AdminHasDomainWriteAccess(groupName)) { ViewData["Message"] = "You do not have access to this item"; return(View("Error")); } //Delete Item try { bookingChannelRepository.Delete(bookingChannelVM.BookingChannel); } catch (SqlException ex) { //Versioning Error - go to standard versionError page if (ex.Message == "SQLVersioningError") { ViewData["ReturnURL"] = String.Format("/BookingChannel.mvc/Delete/id={0}", bookingChannelVM.BookingChannel.BookingChannelId); return(View("VersionError")); } //Generic Error ViewData["Message"] = "There was a problem with your request, please see the log file or contact an administrator for details"; return(View("Error")); } //Return return(RedirectToAction("List", new { id = bookingChannel.ClientSubUnitGuid })); }
// GET: /Create public ActionResult Create(string id) { //Get ClientSubUnit ClientSubUnit clientSubUnit = new ClientSubUnit(); clientSubUnit = clientSubUnitRepository.GetClientSubUnit(id); //Check Exists if (clientSubUnit == null) { ViewData["ActionMethod"] = "CreateGet"; return(View("RecordDoesNotExistError")); } //Access Rights RolesRepository rolesRepository = new RolesRepository(); if (!rolesRepository.HasWriteAccessToClientSubUnit(id) || !hierarchyRepository.AdminHasDomainWriteAccess(groupName)) { ViewData["Message"] = "You do not have access to this item"; return(View("Error")); } BookingChannelVM bookingChannelVM = new BookingChannelVM(); bookingChannelVM.ClientSubUnit = clientSubUnit; BookingChannel bookingChannel = new BookingChannel(); bookingChannel.ClientSubUnit = clientSubUnit; bookingChannel.ClientSubUnitGuid = clientSubUnit.ClientSubUnitGuid; bookingChannelVM.BookingChannel = bookingChannel; //Usage Types UsageTypeRepository usageTypeRepository = new UsageTypeRepository(); bookingChannelVM.UsageTypes = new SelectList(usageTypeRepository.GetAvailableUsageTypes(id).ToList(), "UsageTypeId", "UsageTypeDescription"); //Booking Channel Types BookingChannelTypeRepository bookingChannelTypeRepository = new BookingChannelTypeRepository(); bookingChannelVM.BookingChannelTypes = new SelectList(bookingChannelTypeRepository.GetAllBookingChannelTypes().ToList(), "BookingChannelTypeId", "BookingChannelTypeDescription"); //Channel Products ProductChannelTypeRepository productChannelTypeRepository = new ProductChannelTypeRepository(); bookingChannelVM.ProductChannelTypes = new SelectList(productChannelTypeRepository.GetAllProductChannelTypes().ToList(), "ProductChannelTypeId", "ProductChannelTypeDescription"); //Desktop Used Types DesktopUsedTypeRepository desktopUsedTypeRepository = new DesktopUsedTypeRepository(); bookingChannelVM.DesktopUsedTypes = new SelectList(desktopUsedTypeRepository.GetAllDesktopUsedTypes().ToList(), "DesktopUsedTypeId", "DesktopUsedTypeDescription"); //Content Booked Items ProductRepository productRepository = new ProductRepository(); bookingChannelVM.Products = new SelectList(productRepository.GetAllProducts().ToList(), "ProductId", "ProductName"); GDSRepository GDSRepository = new GDSRepository(); bookingChannelVM.GDSList = new SelectList(GDSRepository.GetAllGDSsExceptALL().OrderBy(x => x.GDSName).ToList(), "GDSCode", "GDSName"); //Show Create Form return(View(bookingChannelVM)); }
public ActionResult Delete(int id) { //Get BookingChannel BookingChannel bookingChannel = new BookingChannel(); bookingChannel = bookingChannelRepository.BookingChannel(id); //Check Exists if (bookingChannel == null) { ViewData["ActionMethod"] = "DeleteGet"; return(View("RecordDoesNotExistError")); } //Access Rights RolesRepository rolesRepository = new RolesRepository(); if (!rolesRepository.HasWriteAccessToClientSubUnit(bookingChannel.ClientSubUnitGuid) || !hierarchyRepository.AdminHasDomainWriteAccess(groupName)) { ViewData["Message"] = "You do not have access to this item"; return(View("Error")); } BookingChannelVM bookingChannelVM = new BookingChannelVM(); bookingChannelVM.BookingChannel = bookingChannel; //Get ClientSubUnit ClientSubUnit clientSubUnit = new ClientSubUnit(); clientSubUnit = clientSubUnitRepository.GetClientSubUnit(bookingChannel.ClientSubUnitGuid); bookingChannelVM.ClientSubUnit = clientSubUnit; //Get GDS GDSRepository gdsRepository = new GDSRepository(); GDS gds = gdsRepository.GetGDS(bookingChannel.GDSCode); bookingChannelVM.GDS = gds; //Channel Products if (bookingChannel.ProductChannelTypeId != null) { ProductChannelTypeRepository productChannelTypeRepository = new ProductChannelTypeRepository(); ProductChannelType productChannelType = productChannelTypeRepository.GetProductChannelType((int)bookingChannel.ProductChannelTypeId); if (productChannelType != null) { bookingChannelVM.BookingChannel.ProductChannelType = productChannelType; } } //Desktop Used Types if (bookingChannel.DesktopUsedTypeId != null) { DesktopUsedTypeRepository desktopUsedTypeRepository = new DesktopUsedTypeRepository(); DesktopUsedType desktopUsedType = desktopUsedTypeRepository.GetDesktopUsedType((int)bookingChannel.DesktopUsedTypeId); if (desktopUsedType != null) { bookingChannelVM.BookingChannel.DesktopUsedType = desktopUsedType; } } //Content Booked Items ContentBookedItemRepository contentBookedItemRepository = new ContentBookedItemRepository(); List <ContentBookedItem> contentBookedItems = contentBookedItemRepository.GetBookingChannelContentBookedItems(bookingChannel.BookingChannelId).ToList(); if (contentBookedItems != null) { bookingChannelVM.ContentBookedItemsList = String.Join(", ", contentBookedItems.Select(x => x.Product.ProductName.ToString()).ToArray()); } //Show Form return(View(bookingChannelVM)); }
// GET: /View public ActionResult View(int id) { //Get BookingChannel BookingChannel bookingChannel = new BookingChannel(); bookingChannel = bookingChannelRepository.BookingChannel(id); //Check Exists if (bookingChannel == null) { ViewData["ActionMethod"] = "DeleteGet"; return(View("RecordDoesNotExistError")); } BookingChannelVM bookingChannelVM = new BookingChannelVM(); bookingChannelVM.BookingChannel = bookingChannel; //Get ClientSubUnit ClientSubUnit clientSubUnit = new ClientSubUnit(); clientSubUnit = clientSubUnitRepository.GetClientSubUnit(bookingChannel.ClientSubUnitGuid); bookingChannelVM.ClientSubUnit = clientSubUnit; //Get GDS GDSRepository gdsRepository = new GDSRepository(); GDS gds = gdsRepository.GetGDS(bookingChannel.GDSCode); bookingChannelVM.GDS = gds; //Channel Products if (bookingChannel.ProductChannelTypeId != null) { ProductChannelTypeRepository productChannelTypeRepository = new ProductChannelTypeRepository(); ProductChannelType productChannelType = productChannelTypeRepository.GetProductChannelType((int)bookingChannel.ProductChannelTypeId); if (productChannelType != null) { bookingChannelVM.BookingChannel.ProductChannelType = productChannelType; } } //Desktop Used Types if (bookingChannel.DesktopUsedTypeId != null) { DesktopUsedTypeRepository desktopUsedTypeRepository = new DesktopUsedTypeRepository(); DesktopUsedType desktopUsedType = desktopUsedTypeRepository.GetDesktopUsedType((int)bookingChannel.DesktopUsedTypeId); if (desktopUsedType != null) { bookingChannelVM.BookingChannel.DesktopUsedType = desktopUsedType; } } //Content Booked Items ContentBookedItemRepository contentBookedItemRepository = new ContentBookedItemRepository(); List <ContentBookedItem> contentBookedItems = contentBookedItemRepository.GetBookingChannelContentBookedItems(bookingChannel.BookingChannelId).ToList(); if (contentBookedItems != null) { bookingChannelVM.ContentBookedItemsList = String.Join(", ", contentBookedItems.Select(x => x.Product.ProductName.ToString()).ToArray()); } //Show Form return(View(bookingChannelVM)); }
public ActionResult Edit(BookingChannelVM bookingChannelVM) { //Get BookingChannel BookingChannel bookingChannel = new BookingChannel(); bookingChannel = bookingChannelRepository.BookingChannel( bookingChannelVM.BookingChannel.BookingChannelId ); //Check Exists if (bookingChannel == null) { ViewData["ActionMethod"] = "EditPost"; return(View("RecordDoesNotExistError")); } string clientSubUnitGuid = bookingChannelVM.BookingChannel.ClientSubUnitGuid; ClientSubUnit clientSubUnit = new ClientSubUnit(); clientSubUnit = clientSubUnitRepository.GetClientSubUnit(clientSubUnitGuid); //Check Exists if (clientSubUnit == null) { ViewData["ActionMethod"] = "CreatePost"; return(View("RecordDoesNotExistError")); } //Access Rights RolesRepository rolesRepository = new RolesRepository(); if (!rolesRepository.HasWriteAccessToClientSubUnit(clientSubUnitGuid) || !hierarchyRepository.AdminHasDomainWriteAccess(groupName)) { ViewData["Message"] = "You do not have access to this item"; return(View("Error")); } //Update Model from Form try { TryUpdateModel <BookingChannel>(bookingChannel, "BookingChannel"); } catch { string n = ""; foreach (ModelState modelState in ViewData.ModelState.Values) { foreach (ModelError error in modelState.Errors) { n += error.ErrorMessage; } } ViewData["Message"] = "ValidationError : " + n; return(View("Error")); } try { bookingChannelRepository.Update(bookingChannelVM); } catch (SqlException ex) { LogRepository logRepository = new LogRepository(); logRepository.LogError(ex.Message); ViewData["Message"] = "There was a problem with your request, please see the log file or contact an administrator for details"; return(View("Error")); } return(RedirectToAction("List", new { id = clientSubUnitGuid })); }
// GET: /Edit public ActionResult Edit(int id) { //Get BookingChannel BookingChannel bookingChannel = new BookingChannel(); bookingChannel = bookingChannelRepository.BookingChannel(id); //Check Exists if (bookingChannel == null) { ViewData["ActionMethod"] = "EditGet"; return(View("RecordDoesNotExistError")); } //Access Rights RolesRepository rolesRepository = new RolesRepository(); if (!rolesRepository.HasWriteAccessToClientSubUnit(bookingChannel.ClientSubUnitGuid) || !hierarchyRepository.AdminHasDomainWriteAccess(groupName)) { ViewData["Message"] = "You do not have access to this item"; return(View("Error")); } BookingChannelVM bookingChannelVM = new BookingChannelVM(); bookingChannelVM.BookingChannel = bookingChannel; //Get ClientSubUnit ClientSubUnit clientSubUnit = new ClientSubUnit(); clientSubUnit = clientSubUnitRepository.GetClientSubUnit(bookingChannel.ClientSubUnitGuid); bookingChannelVM.ClientSubUnit = clientSubUnit; //Booking Channel Types BookingChannelTypeRepository bookingChannelTypeRepository = new BookingChannelTypeRepository(); if (bookingChannelVM.BookingChannel.BookingChannelTypeId != null) { bookingChannelVM.BookingChannelTypes = new SelectList( bookingChannelTypeRepository.GetAllBookingChannelTypes().ToList(), "BookingChannelTypeId", "BookingChannelTypeDescription", bookingChannelVM.BookingChannel.BookingChannelTypeId ); } else { bookingChannelVM.BookingChannelTypes = new SelectList( bookingChannelTypeRepository.GetAllBookingChannelTypes().ToList(), "BookingChannelTypeId", "BookingChannelTypeDescription" ); } //Channel Products ProductChannelTypeRepository productChannelTypeRepository = new ProductChannelTypeRepository(); int bookingChannelTypeId = (bookingChannelVM.BookingChannel.BookingChannelTypeId != null) ? bookingChannelVM.BookingChannel.BookingChannelTypeId.Value : 1; bookingChannelVM.ProductChannelTypes = new SelectList( productChannelTypeRepository.GetProductChannelTypesForBookingChannel(bookingChannelTypeId).ToList(), "ProductChannelTypeId", "ProductChannelTypeDescription", bookingChannelVM.BookingChannel.ProductChannelTypeId ); //Desktop Used Types DesktopUsedTypeRepository desktopUsedTypeRepository = new DesktopUsedTypeRepository(); if (bookingChannelVM.BookingChannel.DesktopUsedTypeId != null) { bookingChannelVM.DesktopUsedTypes = new SelectList( desktopUsedTypeRepository.GetAllDesktopUsedTypes().ToList(), "DesktopUsedTypeId", "DesktopUsedTypeDescription", bookingChannelVM.BookingChannel.DesktopUsedTypeId ); } else { bookingChannelVM.DesktopUsedTypes = new SelectList( desktopUsedTypeRepository.GetAllDesktopUsedTypes().ToList(), "DesktopUsedTypeId", "DesktopUsedTypeDescription" ); } //Content Booked Items ContentBookedItemRepository contentBookedItemRepository = new ContentBookedItemRepository(); List <ContentBookedItem> contentBookedItems = contentBookedItemRepository.GetBookingChannelContentBookedItems(bookingChannelVM.BookingChannel.BookingChannelId).ToList(); ProductRepository productRepository = new ProductRepository(); IEnumerable <SelectListItem> defaultProducts = new SelectList(productRepository.GetAllProducts().ToList(), "ProductId", "ProductName"); List <SelectListItem> contentBookedItemsSelected = new List <SelectListItem>(); foreach (SelectListItem item in defaultProducts) { bool selected = false; foreach (ContentBookedItem contentBookedItem in contentBookedItems) { if (item.Value == contentBookedItem.Product.ProductId.ToString()) { selected = true; } } contentBookedItemsSelected.Add( new SelectListItem() { Text = item.Text, Value = item.Value, Selected = selected } ); } bookingChannelVM.ContentBookedItemsSelected = contentBookedItemsSelected; //GDS GDSRepository GDSRepository = new GDSRepository(); bookingChannelVM.GDSList = new SelectList(GDSRepository.GetAllGDSsExceptALL().OrderBy(x => x.GDSName).ToList(), "GDSCode", "GDSName"); //Show Edit Form return(View(bookingChannelVM)); }