public ActionResult Create([Bind(Include = "Band,Song,ShowDate,Description,Link")] SingleUserViewModel userVm)
{
if (ModelState.IsValid)
{
var band = (from b in db.Bands
where b.Name == userVm.Band
select b).FirstOrDefault <Band>();
var song = (from s in db.Songs
where s.Title == userVm.Song
select s).FirstOrDefault <Song>();
var user = (from u in db.Users
where u.UserID == 1 // eventually, UserId will be passed in as a parameter
select u).FirstOrDefault <User>();
Note note = new Note();
note.UserID = user.UserID;
note.BandID = band.BandID;
note.SongID = song.SongID;
note.ShowDate = userVm.ShowDate;
note.Description = userVm.Description;
note.Link = userVm.Link;
db.Notes.Add(note);
db.SaveChanges();
return(RedirectToAction("MyNotes"));
}
return(View(userVm));
}
public IActionResult SingleUser(int Id)
{
var userOut = new SingleUserViewModel()
{
SingleUser = _UserRepository.GetUserById(Id)
};
return(View(userOut));
}
// GET: MyNotes
public ActionResult MyNotes()
{
var user = (from u in db.Users
where u.UserID == 1 // later, UserId will be passed in as a parameter
select u).FirstOrDefault <User>();
var userNotes = from n in db.Notes
where n.UserID == user.UserID
select n;
var model = new SingleUserViewModel()
{
UserName = user.UserName,
Notes = userNotes.ToList()
};
return(View(model));
}
public ActionResult SingleUser(string userName)
{
if (String.IsNullOrWhiteSpace(userName))
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
var viewModel = new SingleUserViewModel();
viewModel.User = _userRepository.GetUserByName(userName);
viewModel.Room = _roomRepository.GetRoomByName(userName);
if ((viewModel.User == null) || (viewModel.Room == null))
{
return(HttpNotFound());
}
return(View("SingleUser", viewModel));
}
