public IActionResult SaveScore(Score input)
{
using (var context = new MetronomeContext())
{
Boolean isUpdate = input.id == null;
var score = new Score();
if (!isUpdate)
{
Guid id = new Guid();
score.id = id;
score.create_date = DateTime.Now;
}
score.creator = input.creator;
score.composer = input.composer;
score.title = input.title;
if (isUpdate)
{
context.Score.Update(score);
}
else
{
context.Score.Add(score);
}
context.SaveChanges();
return(Ok("Score Created"));
}
}
public IActionResult SaveUser(User inputData)
{
string result = "Data was saved";
using (var context = new MetronomeContext())
{
Guid id = new Guid();
User user = new User();
var exists = context.User.Where(u => u.handle == inputData.handle).Count();
if (exists > 0)
{
Response.StatusCode = 500;
result = "Already a user with that handle";
}
else
{
user.id = id;
user.first_name = inputData.first_name;
user.last_name = inputData.last_name;
user.create_date = DateTime.Now;
user.handle = inputData.handle;
context.User.Add(user);
context.SaveChanges();
}
}
return(Ok(result));
}
public IActionResult GetMeasures(string score)
{
using (var context = new MetronomeContext()) {
var measures = context.Measure.Where(s => s.score.ToString() == score).ToList().OrderBy(measure => measure.measureNumber);
return(Json(measures));
}
}
public IActionResult SaveComposer(Composer inputData)
{
using (var context = new MetronomeContext())
{
if (inputData.id == null)
{
var id = new Guid();
var composer = new Composer();
composer.id = id;
composer.first_name = inputData.first_name;
composer.last_name = inputData.last_name;
composer.birth_date = inputData.birth_date;
context.Composer.Add(composer);
context.SaveChanges();
}
else
{
context.Composer.Update(inputData);
context.SaveChanges();
}
return(Ok("Done"));
}
}
public IActionResult UpdateMeasure([FromBody] Measure measure)
{
using (var context = new MetronomeContext())
{
context.Measure.Update(measure);
context.SaveChanges();
return(Ok(measure));
}
}
public IActionResult GetUserByHandle(User input)
{
using (var context = new MetronomeContext()) {
IQueryable <User> result = context.User.Where(u => u.handle == input.handle);
if (result.Count() > 0)
{
return(Ok(result.First()));
}
else
{
Response.StatusCode = 500;
return(Ok("No handles found"));
}
}
}
public IActionResult GetScore(string id)
{
using (var context = new MetronomeContext()) {
var scoreCollection = context.Score.Where(s => s.id.ToString() == id);
var score = scoreCollection.Count() != 0 ? scoreCollection.First() : null;
if (score != null)
{
return(Json(score));
}
else
{
return(Json(new { error = "Nothing is here" }));
}
}
}
public IActionResult UpdateMeasures([FromBody] List <Measure> measures)
{
using (var context = new MetronomeContext())
{
foreach (Measure measure in measures)
{
if (measure.id == null)
{
measure.id = new Guid();
}
}
context.Measure.UpdateRange(measures);
context.SaveChanges();
return(Ok(measures));
}
}
