/// <summary> /// The request to display search results. /// </summary> /// <param name="request">A request model that contains the search parameters.</param> /// <returns></returns> public IActionResult SearchResult(Actor actor) { /* Call the DAL and pass the values as a model back to the View */ ActorDAL actorDAL = new ActorDAL(@"Data Source=.\SQLEXPRESS;Initial Catalog=dvdstore;Integrated Security=True"); IList <Actor> actorList = actorDAL.FindActors(actor.LastName); return(View(actorList)); }
/// <summary> /// The request to display search results. /// </summary> /// <param name="request"></param> /// <returns></returns> public IActionResult SearchResult(ActorSearch request) { IActorDAL dal = new ActorDAL(@"Data Source=.\SQLEXPRESS;Initial Catalog=DVDStore;Integrated Security=True"); IList <Actor> actors = dal.FindActors(request.LastName); request.Results = actors; return(View("Index", request)); }
//Sparar skådespelare om det inte finns något id, annars så sker en uppdatering av en befintlig skådespelare public static void SaveActor(Actor actor) { ICollection <ValidationResult> validationresults; if (!actor.Validate(out validationresults)) { var ex = new ValidationException("Objektet kunde inte valideras"); ex.Data.Add("ValidationResults", validationresults); throw ex; } if (actor.ActorID == 0) { ActorDAL.InsertActor(actor); } else { ActorDAL.UpdateActor(actor); } }
//Hämtar ut alla skådespelare från databasen och räknar rader så att man kan få dem på flera sidor i applikationen public static IEnumerable <Actor> GetActorsPageWise(int maximumRows, int startRowIndex, out int totalRowCount) { return(ActorDAL.GetActorsPageWise(maximumRows, startRowIndex, out totalRowCount)); }
//Hämtar ut alla skådespelare från databasen som en lista public static IEnumerable <Actor> GetActors() { return(ActorDAL.GetActors()); }
public static void DeleteActor(int actorId) { ActorDAL.DeleteActor(actorId); }
//Hämtar ut en specifik skådespelare public static Actor GetActor(int actorId) { return(ActorDAL.GetActorById(actorId)); }