// Create and populate a Datatable
// Return the ViewGuide view and pass it a GuideViewModel
public ActionResult ViewGuide(string Type)
{
DataTable table = GetTable(Type);
GuideViewModel model = new GuideViewModel(table, Type);
return(View(model));
}
public GuideViewModel GetResourceAuthorities(int resourceId)
{
var gvm = new GuideViewModel();
var agentSql = Sql.Builder
.Select("linked_agents_rlshp.agent_person_id, linked_agents_rlshp.agent_family_id, linked_agents_rlshp.agent_corporate_entity_id, " +
"linked_agents_rlshp.role_id, linked_agents_rlshp.relator_id, name_person.sort_name AS person_name, " +
"name_family.sort_name AS family_name, name_corporate_entity.sort_name AS corp_name")
.From("linked_agents_rlshp")
.LeftJoin("agent_person").On("agent_person.id = linked_agents_rlshp.agent_person_id")
.LeftJoin("name_person").On("name_person.agent_person_id = linked_agents_rlshp.agent_person_id")
.LeftJoin("agent_family").On("agent_family.id = linked_agents_rlshp.agent_family_id")
.LeftJoin("name_family").On("name_family.agent_family_id = linked_agents_rlshp.agent_family_id")
.LeftJoin("agent_corporate_entity").On("agent_corporate_entity.id = linked_agents_rlshp.agent_corporate_entity_id")
.LeftJoin("name_corporate_entity").On("name_corporate_entity.agent_corporate_entity_id = linked_agents_rlshp.agent_corporate_entity_id")
.Where("resource_id = @0", resourceId)
.OrderBy("person_name, family_name, corp_name");
var subjectSql = Sql.Builder
.Select("subject.id, subject.title AS subject, (select value from archivesspace.enumeration_value where id = (select term_type_id from archivesspace.term WHERE id = (select term_id from archivesspace.subject_term where subject_id = subject.id))) AS type")
.From("subject_rlshp")
.LeftJoin("subject").On("subject.id = subject_rlshp.subject_id")
.Where("resource_id = @0", resourceId);
using (var db = Connection)
{
gvm.AsAgents = db.Fetch <AgentGroup>(agentSql);
gvm.AsSubjects = db.Fetch <SubjectGroup>(subjectSql);
}
return(gvm);
}
private void ButtonSave_Click(object sender, RoutedEventArgs e)
{
try
{
Dictionary <int, string> guideExcursions = new Dictionary <int, string>();
foreach (var exc in ListBoxExcursion.SelectedItems)
{
var excursion = (ExcursionViewModel)exc;
guideExcursions.Add(excursion.ID, excursion.Name);
}
GuideViewModel guide = (GuideViewModel)ComboBoxChoosenGuide.SelectedItem;
guidelogic.CreateOrUpdate(new GuideBindingModel
{
ID = guide.ID,
Name = guide.Name,
Surname = guide.Surname,
WorkPlace = guide.WorkPlace,
PhoneNumber = guide.PhoneNumber,
MainLanguage = guide.MainLanguage,
AdditionalLanguage = guide.AdditionalLanguage,
OperatorID = App.Operator.ID,
GuideExcursions = guideExcursions
});
MessageBox.Show("Привязка прошла успешно", "Сообщение", MessageBoxButton.OK, MessageBoxImage.Information);
DialogResult = true;
Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Ошибка", MessageBoxButton.OK, MessageBoxImage.Error);
logger.Warn("Ошибка при попытке привязки гидов к экскурсии");
}
}
public virtual ActionResult Index()
{
var date = DateTime.Today;
var events = _eventService.GetFullGuide(date);
var channels = _channelService.GetChannels();
var model = new GuideViewModel(events, date, channels);
return(View(model));
}
public virtual PartialViewResult EpgDay(string date)
{
var dateob = date.HasValue() ? date.FromISO8601String() : DateTime.Today;
var events = _eventService.GetFullGuide(dateob);
var channels = _channelService.GetChannels();
var model = new GuideViewModel(events, dateob.Value, channels);
return(PartialView(MVC.Guide.Views._ChannelListing, model));
}
private static GuideViewModel MapUmbracoContentToViewModel(IPublishedContent content)
{
var model = new GuideViewModel()
{
Steps = new List <GuideStepViewModel>(content.Children <IPublishedContent>()
.Where(child => child.ContentType.Alias == "GuideStep")
.Select(MapUmbracoContentToGuideStepViewModel))
};
return(model);
}
private void LoadData()
{
ComboBoxHalts.ItemsSource = Hlogic.Read(new HaltBindingModel {
OperatorID = App.Operator.ID
});
ComboBoxHalts.SelectedItem = null;
var tours = logic.Read(new TourBindingModel {
OperatorID = App.Operator.ID
});
foreach (var tour in tours)
{
if (tour.ID == id)
{
this.tour = tour;
}
}
var listbindmodels = Guidelogic.Read(new GuideBindingModel {
OperatorID = App.Operator.ID
});
foreach (var guide in listbindmodels)
{
ListBoxAvailable.Items.Add(guide);
}
if (tour != null)
{
ListBoxAvailable.Items.Clear();
List <int> array = new List <int>();
var listSelectedGuides = tour.TourGuides.ToList();
foreach (var guide in listSelectedGuides)
{
GuideViewModel current = Guidelogic.Read(new GuideBindingModel
{
ID = guide.Key
})[0];
ListBoxSelected.Items.Add(current);
array.Add(current.ID);
}
foreach (var guide in listbindmodels)
{
if (!array.Contains(guide.ID))
{
ListBoxAvailable.Items.Add(guide);
}
}
NameTextBox.Text = tour.Name;
CountryTextBox.Text = tour.Country;
PriceTextBox.Text = tour.Price.ToString();
ComboBoxHalts.SelectedValue = tour.HaltID;
}
}
public IActionResult ViewGuide([FromQuery] int guideId)
{
IFixitApi ifa = new IFixitApi();
string newSearch = HttpUtility.UrlEncode(guideId.ToString());
IFixitGuide data = ifa.MakeGuideCall("guides/" + guideId + "?pretty");
GuideViewModel ifvm = new GuideViewModel();
ifvm.Guide = data;
return(View("ViewGuide", ifvm));
}
public ActionResult SubjectView(int id)
{
ViewBag.ArchivesSpaceUrl = ConfigurationManager.AppSettings["ArchivesSpaceUrl"] + id;
var gvm = new GuideViewModel();
var resources = AsRepo.GetArchivesSpaceResources();
gvm.Name = SearchNameByAsUri(ConfigurationManager.AppSettings["ArchivesSpaceUrl"] + id);
gvm.Subject = SearchSubjectByAsUri(ConfigurationManager.AppSettings["ArchivesSpaceUrl"] + id);
var match = resources.FirstOrDefault(x => x.id == id);
ViewBag.Guide = match.title + $" ({match.ead_id})";
return(View(gvm));
}
public ActionResult Create(GuideViewModel guideView)
{
if (ModelState.IsValid)
{
var guide = new Guide
{
GuideId = guideView.GuideId,
GuideName = guideView.GuideName,
HeroOptId = guideView.HeroOptId,
};
foreach (var item in guideView.ItemId)
{
guide.ItemG.Add(db.Items.FirstOrDefault(x => x.ItemId == item));
}
db.Guides.Add(guide);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.HeroOptId = new SelectList(db.HeroOpts, "HeroOptId", "Name", guideView.HeroOptId);
return(View(guideView));
}
// GET: Guide
public ActionResult Index1(int id = 0)
{
id = id == 0 ? 1 : id;
var cats = _guideService.Categories.Select(s => new Category
{
Id = s.Id,
Title = s.Title,
SubTitle = s.SubTitle,
CreationDate = s.CreationDate,
RecordState = s.RecordState
});
var articles = _guideService.ArticlesByCategory(id);
var model = new GuideViewModel
{
Categories = cats,
ActiveCategoryId = id,
Articles = articles
};
return(View(model));
}
protected override void OnNavigatedTo(System.Windows.Navigation.NavigationEventArgs e)
{
Debug.WriteLine("A Guide has been navigated to. We are going to make API calls and do SCIENCE");
this.guideID = this.NavigationContext.QueryString["GuideID"];
Debug.WriteLine("\tgot guide id = " + guideID);
if (tapped != null)
tapped.Foreground = App.Current.Resources["PhoneForegroundBrush"] as Brush;
//if the VM is already populated, don't reload it
if (vm != null)
return;
int numCols = -1;
string key = guideID;
//if online, do an api call. The callback will be fired to populate the view
if (DeviceNetworkInformation.IsNetworkAvailable && !this.State.ContainsKey(key))
{
Debug.WriteLine("online. Querying for new guide content");
vm = new GuideViewModel(SourceGuide);
this.DataContext = vm;
new JSONInterface2().populateGuideView(this.guideID, insertGuideIntoDB);
}
//if not online, populate view from DB
else
{
Debug.WriteLine("offline. Using DB for guide content");
using (iFixitDataContext db = new iFixitDataContext(App.DBConnectionString))
{
//get the guide, if it already exists
//SourceGuide = db.GuidesTable.SingleOrDefault(g => g.GuideID == this.guideID);
SourceGuide = DBHelpers.GetCompleteGuide(this.guideID, db);
vm = new GuideViewModel(SourceGuide);
//force view model to update
//vm.UpdateContentFromGuide(SourceGuide);
this.DataContext = vm;
//hide the loading bar
LoadingBarInfo.Visibility = System.Windows.Visibility.Collapsed;
}
}
if (SourceGuide != null)
{
numCols = SourceGuide.Steps.Count + 1;
}
// if there is a saved index, re-navigate to it
if (key != null && this.State.ContainsKey(key))
{
int selectedTabIndex = (int)this.State[key];
if (0 <= selectedTabIndex && selectedTabIndex < numCols)
{
GuidePivot.SelectedIndex = selectedTabIndex;
}
}
}
