Coder Social home page Coder Social logo

ispindelmvc's Introduction

iSpindelMvc

iSpindel Server C# Core Mvc

This is a basic service for recording information from an iSpindel written using asp.net core and entity framework. It takes input from iSpindel set to use HTTP.

This was written primarily as an exercise in learning some new languages and frameworks. I've always found having a practicle application to write helps with the learning. There were certainly some challenges with complex entity framework joins and with adding a chart. This is basic asp.net, but I'll get this rewritten using Angular and React for the front end.

It allows the use of SQLServer/LocalDb or Sqlite. The database is created automatically and there are just three basic tables to store the information: Device, Batch and Log. Change ServerType to 1 in the appsettings to use Sqlite instead of SQL Server/LocalDb

Devices are created by the first log sent by an iSpindel. It matches the name field set up on the device, so this must be unique if you are using more than one device. Once created you can only change the description and the token fields. A future development could be to use the token to ensure that log calls are valid, but as I expect this to be run on a private network I've not felt it necessary to add that code.

For each device you can create a Batch which will have a start date of when you created it. Description can be changed for a batch and a batch can be manually ended. A batch will automatically be ended if a new batch is created on the same device.

Batch Detail Image

Batch Detail Image

Home Page Image

ispindelmvc's People

Contributors

jwealthall avatar

Watchers

 avatar  avatar

ispindelmvc's Issues

Firstrun query error

I'm using sqlite database. After i run project getting multiple errors on Index > SummaryData > BatchSummaryList

AggregateException: One or more errors occurred. (The LINQ expression '(GroupByShaperExpression: KeySelector: (l.BatchId), ElementSelector:(EntityShaperExpression: EntityType: Log ValueBufferExpression: (ProjectionBindingExpression: EmptyProjectionMember) IsNullable: False ) ) .Max(x => x.Gravity)' could not be translated. Either rewrite the query in a form that can be translated, or switch to client evaluation explicitly by inserting a call to either AsEnumerable(), AsAsyncEnumerable(), ToList(), or ToListAsync().

InvalidOperationException: The LINQ expression '(GroupByShaperExpression: KeySelector: (l.BatchId), ElementSelector:(EntityShaperExpression: EntityType: Log ValueBufferExpression: (ProjectionBindingExpression: EmptyProjectionMember) IsNullable: False ) ) .Max(x => x.Gravity)' could not be translated. Either rewrite the query in a form that can be translated, or switch to client evaluation explicitly by inserting a call to either AsEnumerable(), AsAsyncEnumerable(), ToList(), or ToListAsync().

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.