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