// GET: Author/Edit/5 public ActionResult Edit(int id) { using (BLLContext ctx = new BLLContext()) { AuthorBO author = ctx.GetAuthor(id); return(View(author)); } }
// GET: Series/Details/5 public ActionResult Details(int id) { using (BLLContext ctx = new BLLContext()) { SeriesBO series = ctx.GetSeries(id); AuthorBO author = ctx.GetAuthor(series.AuthorID_FK); SeriesAuthor m = new SeriesAuthor(); m.SeriesID = series.SeriesID; m.SeriesTitle = series.SeriesTitle; m.AuthorName = author.Name; return(View(m)); } }
public ActionResult Edit(int id) { AuthorBO authors = DependencyResolver.Current.GetService <AuthorBO>(); AuthorViewModel model = null; if (id != 0) { ViewBag.Message = "Edit"; model = mapper.Map <AuthorViewModel>(authors.GetListAuthorsById(id)); } else { ViewBag.Message = "Create"; } return(View(model)); }
public ActionResult Edit(int id, AuthorBO author) { try { // TODO: Add update logic here using (BLLContext ctx = new BLLContext()) { ctx.UpdateAuthor(author); return(RedirectToAction("Index")); } } catch (Exception ex) { Logger.Log(ex); return(View("Error", ex)); } }
// GET: Author public ActionResult Index() { AuthorBO authors = DependencyResolver.Current.GetService <AuthorBO>(); List <AuthorViewModel> authorsTop = new List <AuthorViewModel>(); //BookBO books = DependencyResolver.Current.GetService<BookBO>(); //var expensiveBooks = books.GetListBooks().Select(item => mapper.Map<BookViewModel>(item)) // .OrderByDescending(b => b.Price).ToList(); ////expensiveBooks.ForEach(x => authorsTop.Add(db.Authors.Where(a => a.Id == x).FirstOrDefault())); //foreach (var item in expensiveBooks) //{ // authorsTop.Add(authors.GetListAuthors().Select(a => mapper.Map<AuthorViewModel>(a)) // .Where(a => a.Id == item.AuthorId).FirstOrDefault()); //} ViewBag.Authors = authors.GetListAuthors().Select(item => mapper.Map <AuthorViewModel>(item)).ToList(); ViewBag.AuthorsTop = authorsTop.Distinct().Take(5); return(View()); }
public ActionResult Create(AuthorBO author) { try { if (ModelState.IsValid) { using (BLLContext ctx = new BLLContext()) { ctx.NewAuthor(author.Name); return(RedirectToAction("Index")); } } return(View(author)); } catch (Exception ex) { Logger.Log(ex); return(View("Error", ex)); } }
static void Main(string[] args) { // using (DataAccessLayer.ContextDAL ctx = new DataAccessLayer.ContextDAL()) using (BusinessLayer.BLLContext ctx = new BusinessLayer.BLLContext()) { // Define the connection string for using (DataAccessLayer...Context // ConnectionStringSettings cs = ConfigurationManager.ConnectionStrings["CharStubsConnection"]; // ctx.ConnectionString = cs.ConnectionString; #region Select By ID Test BLL //// Get an Author object by AuthorID //AuthorBO r = ctx.GetAuthor(1); //Console.WriteLine($"{r.AuthorID} {r.Name}"); //Console.ReadLine(); //// Get a Book object by BookID //BookBO r = ctx.GetBook(1); //Console.WriteLine($"{r.BookID} {r.Title} {r.SeriesID_FK}"); //Console.ReadLine(); //// Get a Character object by CharacterID //CharacterBO r = ctx.GetCharacter(1); //Console.WriteLine($"{r.CharacterID} {r.Name} {r.Class} {r.AC} {r.Strength} {r.Dexterity} {r.Constitution} {r. Intelligence} {r.Wisdom} {r.Charisma} {r.Description} {r.SeriesID_FK} {r.ClassID_FK}"); //Console.ReadLine(); //// Get a Class object by ClassID //ClassBO r = ctx.GetClass(1); //Console.WriteLine($"{r.ClassID} {r.ClassName} {r.ClassDiceValue}"); //Console.ReadLine(); //// Get a Class object by ClassName //ClassBO r = ctx.GetClassByClassName("bard"); //if (r != null) //{ // Console.WriteLine($"{r.ClassID} {r.ClassName} {r.ClassDiceValue}"); // Console.ReadLine(); //} //// Get a Suggested Character object by SuggestedCharacterID //SuggestedCharacterBO r = ctx.GetSuggested(1); //Console.WriteLine($"{r.SuggestedCharacterID} {r.SuggestedCharacterName} {r.SuggestedCharacterSeries}"); //Console.ReadLine(); //// Get a Role object by RoleID //RoleBO r = ctx.GetRoleByID(1); //Console.WriteLine($"{r.RoleID} {r.Role}"); //Console.ReadLine(); //// Get a User object by UserID //UserBO r = ctx.GetUser(2); //Console.WriteLine($"{r.UserID} {r.FirstName} {r.LastName} {r.UserName} {r.Password} {r.EmailAddress} {r.RoleID_FK}"); //Console.ReadLine(); //// get a User Character object by UserCharacterID //UserCharacterBO r = ctx.GetUserCharacter(2); //Console.WriteLine($"{r.UserCharacterID} {r.Name} {r.Class} {r.ClassLevel} {r.HitPoints} {r.AC} {r.Strength} {r.Dexterity} {r.Constitution} {r.Intelligence} {r.Wisdom} {r.Charisma} {r.Description} {r.SeriesID_FK} {r.ClassID_FK} {r.UserID_FK}"); //Console.ReadLine(); #endregion #region Select By Name BLL //// Get a Series object by SeriesTitle //SeriesBO r = ctx.GetSeriesBySeriesTitle("The Chronicles of Thomas Covenant"); //if (r != null) //{ // Console.WriteLine($"{r.SeriesID} {r.SeriesTitle} {r.AuthorID_FK}"); // Console.ReadLine(); //} // Get an Author object by Name AuthorBO r = ctx.GetAuthorByName("Robert Jordan"); if (r != null) { Console.WriteLine($"{r.AuthorID} {r.Name}"); Console.ReadLine(); } #endregion #region Select "All" By BLL //// Get a list of all UserCharacter Objects by UserName BLL //foreach (UserCharacterBO r in ctx.GetAllUserCharactersByUserName("parkerjerry")) //{ // Console.WriteLine($"{r.UserCharacterID} {r.Name} {r.Class} {r.ClassLevel} {r.HitPoints} {r.AC} {r.Strength} {r.Dexterity} {r.Constitution} {r.Intelligence} {r.Wisdom} {r.Charisma} {r.Description} {r.SeriesID_FK} {r.ClassID_FK} {r.UserID_FK}"); //} //Console.ReadLine(); //// Get a list of all UserCharacter Objects by UserName DAL //foreach (UserCharacterBO r in ctx.GetAllUserCharactersByUserID(26)) //{ // Console.WriteLine($"{r.UserCharacterID} {r.Name} {r.Class} {r.ClassLevel} {r.HitPoints} {r.AC} {r.Strength} {r.Dexterity} {r.Constitution} {r.Intelligence} {r.Wisdom} {r.Charisma} {r.Description} {r.SeriesID_FK} {r.ClassID_FK} {r.UserID_FK}"); //} //Console.ReadLine(); #endregion #region Select All //// Get a list of all UserCharacter Objects //foreach (BusinessLayer.UserCharacterBO r in ctx.GetAllUserCharacters()) //{ // Console.WriteLine($"{r.UserCharacterID} {r.Name} {r.Class} {r.ClassLevel} {r.HitPoints} {r.AC} {r.Strength} {r.Dexterity} {r.Constitution} {r.Intelligence} {r.Wisdom} {r.Charisma} {r.Description} {r.SeriesID_FK} {r.ClassID_FK} {r.UserID_FK}"); //} //Console.ReadLine(); #endregion #region Create Test BLL //// Create a new Wheel of Time Book //Console.WriteLine("Enter a Wheel of Time book Title"); //string title = Console.ReadLine(); //BookBO rv = ctx.NewBook(title, 1); //Console.WriteLine($"{rv.BookID} {rv.Title} {rv.SeriesID_FK}"); //Console.ReadLine(); //// Create a new Character entry //Console.WriteLine("Enter a Description"); //string description = Console.ReadLine(); //string n = "Reinhold"; //string c = "Fighter"; //ctx.NewCharacter(n, c, 17, 15, 14, 15, 14, 15, 14, description, 1, 1); //// Create a new Class //ClassBO rv = ctx.NewClass("Ranger", 8); //Console.WriteLine($"{rv.ClassID} {rv.ClassName} {rv.ClassDiceValue}"); //Console.ReadLine(); //// Create a new Series //// SeriesBO rv = ctx.NewSeries("Ranger", 8); //Console.WriteLine($"{rv.SeriesID} {rv.SeriesTitle} {rv.AuthorID_FK}"); //Console.ReadLine(); //// Create a new User //UserBO rv = ctx.NewUser("Mark", "Anthony", "markanthony", "hellomark", "*****@*****.**", 1); //Console.WriteLine($"{rv.FirstName} {rv.LastName} {rv.UserName} {rv.Password} {rv.EmailAddress} {rv.RoleID_FK}"); //Console.ReadLine(); //// Create a new UserCharacter entry //Console.WriteLine("Enter a Description"); //string description = Console.ReadLine(); //string n = "Reinhold"; //string c = "Fighter"; //ctx.NewUserCharacter(n, c, 11, 110,17, 15, 14, 15, 14, 15, 14, description, 1, 1, 9); #endregion #region Create Methods Test code //// Create a new UserCharacter entry and retrieve the newly created ID //Console.WriteLine("Enter a Description"); //string description = Console.ReadLine(); //string n = "Timmy"; //string c = "Fighter"; //int x = ctx.AddUserCharacter(n, c,8,80,17, 15, 14, 15, 14, 15, 14, description, 1, 1,9); //Console.WriteLine(x); //Console.ReadLine(); //// Create a new Character entry and retrieve the newly created ID //Console.WriteLine("Enter a Description"); //string description = Console.ReadLine(); //string n = "Reinhold"; //string c = "Fighter"; //int x = ctx.AddCharacter(n, c, 17, 15, 14, 15, 14, 15, 14, description, 1, 1); //Console.WriteLine(x); //Console.ReadLine(); //// Create a new Wheel of Time Book //Console.WriteLine("Enter a Wheel of Time book Title"); //string title = Console.ReadLine(); //int rv = ctx.AddBook(title, 1); //Console.WriteLine(rv); //Console.ReadLine(); //// Create a new Class //Console.WriteLine("Enter a new Class"); //string className = Console.ReadLine(); //int rv = ctx.AddClass(className, 8); //Console.WriteLine(rv); //Console.ReadLine(); //// Create a new Series authored by Terry Brooks //Console.WriteLine("Enter a new Series Title"); //string seriesTitle = Console.ReadLine(); //int rv = ctx.AddSeries(seriesTitle, 3); //Console.WriteLine(rv); //Console.ReadLine(); //// Create a new Suggested Character //Console.WriteLine("Enter a new Character Name"); //string charName = Console.ReadLine(); //Console.WriteLine("Enter the series the character appears in"); //string seriesTitle = Console.ReadLine(); //int rv = ctx.AddSuggestedCharacter(charName, seriesTitle); //Console.WriteLine(rv); //Console.ReadLine(); //// Create a new User //Console.WriteLine("Enter your First Name"); //string firstName = Console.ReadLine(); //Console.WriteLine("Enter your Last Name"); //string lastName = Console.ReadLine(); //Console.WriteLine("Enter a username"); //string userName = Console.ReadLine(); //Console.WriteLine("Enter a password"); //string password = Console.ReadLine(); //Console.WriteLine("Enter your email address"); //string emailAddress = Console.ReadLine(); //int rv = ctx.AddUser(firstName, lastName, userName, password, emailAddress, 1); //Console.WriteLine(rv); //Console.ReadLine(); //ctx.AddAuthor(_name); #endregion #region Select Methods Test code //// Get a list of all Author objects //foreach (DataAccessLayer.AuthorDO r in ctx.GetAuthorDOs()) //{ // Console.WriteLine($"{r.AuthorID} {r.Name} "); //} //// Get a list of all Character Objects //foreach (DataAccessLayer.CharacterDO r in ctx.GetCharacterDOs()) //{ // Console.WriteLine($"{r.CharacterID} {r.Name} {r.Class} {r.AC} {r.Strength} {r.Dexterity} {r.Constitution} {r.Intelligence} {r.Wisdom} {r.Charisma} {r.Description} {r.SeriesID_FK} {r.ClassID_FK}"); //} //// Get a list of all UserCharacter Objects //foreach (DataAccessLayer.UserCharacterDO r in ctx.GetUserCharacterDOs()) //{ // Console.WriteLine($"{r.UserCharacterID} {r.Name} {r.Class} {r.ClassLevel} {r.HitPoints} {r.AC} {r.Strength} {r.Dexterity} {r.Constitution} {r.Intelligence} {r.Wisdom} {r.Charisma} {r.Description} {r.SeriesID_FK} {r.ClassID_FK} {r.UserID_FK}"); //} //Console.ReadLine(); //// Get a list of all UserCharacter Objects by UserID //foreach (DataAccessLayer.UserCharacterDO r in ctx.GetUserCharacterDOsByUserID(9)) //{ // Console.WriteLine($"{r.UserCharacterID} {r.Name} {r.Class} {r.ClassLevel} {r.HitPoints} {r.AC} {r.Strength} {r.Dexterity} {r.Constitution} {r.Intelligence} {r.Wisdom} {r.Charisma} {r.Description} {r.SeriesID_FK} {r.ClassID_FK} {r.UserID_FK}"); //} //Console.ReadLine(); //// Get a list of all UserCharacter Objects by UserName DAL //foreach (DataAccessLayer.UserCharacterDO r in ctx.GetUserCharacterDOsByUserName("jerryparker")) //{ // Console.WriteLine($"{r.UserCharacterID} {r.Name} {r.Class} {r.ClassLevel} {r.HitPoints} {r.AC} {r.Strength} {r.Dexterity} {r.Constitution} {r.Intelligence} {r.Wisdom} {r.Charisma} {r.Description} {r.SeriesID_FK} {r.ClassID_FK} {r.UserID_FK}"); //} //Console.ReadLine(); //// Get a UserCharacter object by UserCharacterID //DataAccessLayer.UserCharacterDO r = ctx.GetUserCharacterDOByID(19); // Console.WriteLine($"{r.UserCharacterID} {r.Name} {r.Class} {r.ClassLevel} {r.HitPoints} {r.AC} {r.Strength} {r.Dexterity} {r.Constitution} {r.Intelligence} {r.Wisdom} {r.Charisma} {r.Description} {r.SeriesID_FK} {r.ClassID_FK} {r.UserID_FK}"); //Console.ReadLine(); //// Get a list of all Book objects //foreach (DataAccessLayer.BookDO r in ctx.GetBookDOs()) //{ // Console.WriteLine($"{r.BookID} {r.Title} {r.SeriesID_FK}"); //} //Console.ReadLine(); //// Get a Book object by BookID //DataAccessLayer.BookDO r = ctx.GetBookDOByID(3); //Console.WriteLine($"{r.BookID} {r.Title} {r.SeriesID_FK}"); //Console.ReadLine(); //// Get a list of all Book objects by SeriesID //foreach (DataAccessLayer.BookDO r in ctx.GetBookDOsBySeriesID(3)) //{ // Console.WriteLine($"{r.BookID} {r.Title} {r.SeriesID_FK}"); //} //Console.ReadLine(); //// Get a list of all Class objects //foreach (DataAccessLayer.ClassDO r in ctx.GetClassDOs()) //{ // Console.WriteLine($"{r.ClassID} {r.ClassName} {r.ClassDiceValue}"); //} //Console.ReadLine(); //// Get a list of all Series objects //foreach (DataAccessLayer.SeriesDO r in ctx.GetSeriesDOs()) //{ // Console.WriteLine($"{r.SeriesID} {r.SeriesTitle} {r.AuthorID_FK }"); //} //Console.ReadLine(); //// Get a list of all SuggestedCharacter objects //foreach (DataAccessLayer.SuggestedCharacterDO r in ctx.GetSuggestedCharacterDOs()) //{ // Console.WriteLine($"{r.SuggestedCharacterID} {r.SuggestedCharacterName} {r.SuggestedCharacterSeries }"); //} //Console.ReadLine(); //// Get a list of all User objects //foreach (DataAccessLayer.UserDO r in ctx.GetUserDOs()) //{ // Console.WriteLine($"{r.UserID} {r.FirstName} {r.LastName } {r.UserName} {r.Password} {r.EmailAddress} {r.RoleID_FK}"); //} //Console.ReadLine(); //// Get a list of all User objects //DataAccessLayer.UserDO r = ctx.GetUserDOByID(2); //Console.WriteLine($"{r.UserID} {r.FirstName} {r.LastName } {r.UserName} {r.Password} {r.EmailAddress} {r.RoleID_FK}"); //Console.ReadLine(); //// Get a User object by username //DataAccessLayer.UserDO r = ctx.GetUserDOByUsername("jerryparker"); //if (r != null) //{ // Console.WriteLine($"{r.UserID} {r.FirstName} {r.LastName } {r.UserName} {r.Password} {r.EmailAddress} {r.RoleID_FK}"); //} //else //{ // Console.WriteLine("Username entered doesn't exist in the database"); //} //Console.ReadLine(); //// Get a Class object by ClassName //DataAccessLayer.ClassDO r = ctx.GetClassDOByClassName("Sorcerer"); //if (r != null) //{ // Console.WriteLine($"{r.ClassID} {r.ClassName} {r.ClassDiceValue }"); //} //else //{ // Console.WriteLine("Class name entered doesn't exist in the database"); //} //Console.ReadLine(); //// Get a Series object by SeriesID //DataAccessLayer.SeriesDO r = ctx.GetSeriesDOByID(6); //Console.WriteLine($"{r.SeriesID} {r.SeriesTitle} {r.AuthorID_FK }"); //Console.ReadLine(); //// Get a Character object by CharacterID //DataAccessLayer.CharacterDO r = ctx.GetCharacterDOByID(2); //Console.WriteLine($"{r.CharacterID} {r.Name} {r.Class} {r.Strength} {r.Dexterity} {r.Constitution} {r.Intelligence} {r.Wisdom} {r.Charisma} {r.Description} {r.SeriesID_FK} {r.ClassID_FK}"); //Console.ReadLine(); //// Get an Author object by AuthorID //DataAccessLayer.AuthorDO r = ctx.GetAuthorDOByID(1); //Console.WriteLine($"{r.AuthorID} {r.Name}"); //Console.ReadLine(); //// Get an Author object by AuthorID //DataAccessLayer.ClassDO r = ctx.GetClassDOByID(2); //Console.WriteLine($"{r.ClassID} {r.ClassName} {r.ClassDiceValue}"); //Console.ReadLine(); #endregion #region Delete Methods Test Code // ctx.DeleteCharacter(12); #endregion #region Update Methods Test Code // ctx.UpdateAuthor(1, "Robert Rockstar Jordan"); // ctx.UpdateBook(1, "The Eye of the World", 1); // ctx.UpdateCharacter(12,"Tammy", "Fighter", 21, 10, 14, 15, 14, 15, 10, "Test", 1, 1); // ctx.UpdateClass(5, "Druid", 8); // ctx.UpdateSeries(1, "The Wheel of Time", 1); // ctx.UpdateUser(10, "Matt", "Mercer", "matty", "himatt", "*****@*****.**", 1); // ctx.UpdateUserCharacter(19, "Tammy", "Fighter",10,100,18, 10, 14, 15, 14, 15, 10, "Check", 1, 1, 8); #endregion } }