コード例 #1
0
        // GET: Home/Details/5
        public ActionResult Details(int id)
        {
            SamplesEntities db   = new SamplesEntities();
            Books           book = db.Books.Single(x => x.book_id == id);

            return(View(book));
        }
コード例 #2
0
        // GET: Home
        public ActionResult Index()
        {
            SamplesEntities     db    = new SamplesEntities();
            IEnumerable <Books> books = db.Books.ToList();

            return(View(books));
        }
コード例 #3
0
ファイル: MainWindowViewModel.cs プロジェクト: xela30/Samples
        public MainWindowViewModel()
        {
            this.context = new SamplesEntities();            //"Data Source=IronPythonSample.sdf");

            this.ShowSpeakersCommand = new GenericCommand(
                x => this.WindowContent == WindowContent.Sessions,
                x => this.WindowContent = WindowContent.Speakers,
                this);

            this.ShowSessionsCommand = new GenericCommand(
                x => this.WindowContent == WindowContent.Speakers,
                x => this.WindowContent = WindowContent.Sessions,
                this);

            this.RunScriptCommand = new GenericCommand(
                x => true,
                x =>
            {
                OpenFileDialog dlg = new OpenFileDialog();
                dlg.DefaultExt     = ".py";
                dlg.Filter         = "Python script (.py)|*.py";
                var result         = dlg.ShowDialog();
                if (result.HasValue && result.Value)
                {
                    Task.Factory.StartNew(() => this.RunScript(dlg.FileName));
                }
            });

            this.EraseOutputCommand = new GenericCommand(
                x => true,
                x =>
            {
                lock (this.scriptOutput)
                {
                    this.scriptOutput = new StringBuilder();
                }

                this.OnPropertyChanged("ScriptOutput");
            });

            this.ApproveSessionCommand = new GenericCommand(
                x => this.SelectedSession != null,
                x =>
            {
                var engine = Python.CreateEngine();
                var scope  = engine.CreateScope();
                scope.SetVariable("viewModel", this);
                engine.CreateScriptSourceFromString(@"
viewModel.SelectedSession.Approved = True
viewModel.SaveChanges()
").Execute(scope);
            },
                this);

            this.SpeakerExportCommand = new GenericCommand(
                x => true,
                x =>
            {
                var engine       = Python.CreateEngine();
                var scope        = engine.CreateScope();
                var scriptSource = @"
import clr
clr.AddReferenceByName('Microsoft.Office.Interop.Excel, Version=11.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c')
clr.AddReference(""System.Core"")
from Microsoft.Office.Interop import *
from Microsoft.Office.Interop.Excel import *
from System import *

def export(speakers):
  ex = Excel.ApplicationClass()   
  ex.Visible = True
  ex.DisplayAlerts = False   
  workbook = ex.Workbooks.Add()
  ws = workbook.Worksheets[1]
  rowIndex = 1
  for speaker in speakers:
    ws.Cells[rowIndex, 1].Value2 = speaker.FirstName
    ws.Cells[rowIndex, 2].Value2 = speaker.LastName
    ws.Cells[rowIndex, 3].Value2 = speaker.FullName
    ws.Cells[rowIndex, 4].Value2 = speaker.NumberOfApprovedSessions
    rowIndex = rowIndex + 1";
                engine.CreateScriptSourceFromString(scriptSource).Execute(scope);
                object exportFunc = scope.GetVariable("export");
                engine.Operations.Invoke(exportFunc, this.Speakers);
            });

            this.PropertyChanged += (s, e) =>
            {
                if (e.PropertyName == "WindowContent")
                {
                    OnWindowContentChanged();
                }
            };

            this.WindowContent = WindowContent.Speakers;
        }