public List <TakeABook> GetAll() { List <TakeABook> result = new List <TakeABook>(); IDbConnection connection = new SqlConnection(connectionString); using (connection) { connection.Open(); IDbCommand command = connection.CreateCommand(); command.Connection = connection; command.CommandText = @"SELECT * FROM TakeABooks"; IDataReader reader = command.ExecuteReader(); using (reader) { while (reader.Read()) { TakeABook takeABook = new TakeABook(); takeABook.Id = (int)reader["Id"]; takeABook.book = (Book)reader["Book"]; takeABook.reader = (Reader)reader["Reader"]; takeABook.dateTaken = (DateTime)reader["Date Taken"]; takeABook.dateForReturn = (DateTime)reader["Date For Return"]; takeABook.dateReturn = (DateTime)reader["dateReturn"]; result.Add(takeABook); } } } return(result); }
public ActionResult Create(TakeABookCreateViewModel model) { if (!ModelState.IsValid) { return(View(model)); } TakeABook takeABook = new TakeABook(); takeABook.BookId = model.BookId; if (UserLogin.IsAdmin()) { takeABook.UserId = model.UserId; } else { takeABook.UserId = UserLogin.GetUserId(); } //takeABook.dateTaken = model.dateTaken.Date; takeABook.DateTaken = System.DateTime.Now; // takeABook.dateForReturn = model.dateForReturn.Date; takeABook.DateForReturn = takeABook.DateTaken.AddMonths(3); //takeABook.dateReturn = model.dateReturn.Date; DateTime now = DateTime.Now; takeABook.DateReturn = new DateTime(2000, 1, 1, 0, 0, 0); var repository = new TakeABookRepository(); repository.Insert(takeABook); return(RedirectToAction("Index")); }
public ActionResult Delete(int id) { TakeABookRepository repository = new TakeABookRepository(); TakeABook takeABook = repository.GetById(id); TakeABookDeleteViewModel model = new TakeABookDeleteViewModel(); // model.Id = takeABook.Id; model.BookId = takeABook.BookId; model.UserId = takeABook.UserId; model.dateTaken = takeABook.DateTaken; model.dateForReturn = takeABook.DateForReturn; model.dateReturn = takeABook.DateReturn; return(View(model)); }
public ActionResult Edit(int?id) { TakeABookRepository repository = new TakeABookRepository(); TakeABookEditViewModel model = new TakeABookEditViewModel(); if (id.HasValue) { TakeABook takeABook = repository.GetById(id.Value); model.Id = takeABook.Id; model.Books = PopuateBooksList(); model.Users = PopuateUsersList(); model.dateTaken = takeABook.DateTaken.Date; model.dateForReturn = takeABook.DateForReturn.Date; model.dateReturn = takeABook.DateReturn.Date; } return(View(model)); }
public void Insert(TakeABook takeABook) { IDbConnection connection = new SqlConnection(connectionString); using (connection) { connection.Open(); IDbCommand command = connection.CreateCommand(); command.CommandText = @"INSERT INTO TakeABooks (book, reader, dateTaken, dateForReturn, dateReturn) VALUES (@book, @reader, @dateTaken, @dateForReturn, @dateReturn) "; IDataParameter parameter = command.CreateParameter(); parameter.ParameterName = "@book"; parameter.Value = takeABook.book; command.Parameters.Add(parameter); parameter = command.CreateParameter(); parameter.ParameterName = "@reader"; parameter.Value = takeABook.reader; command.Parameters.Add(parameter); parameter = command.CreateParameter(); parameter.ParameterName = "@dateTaken"; parameter.Value = takeABook.dateTaken; command.Parameters.Add(parameter); parameter = command.CreateParameter(); parameter.ParameterName = "@dateForReturn"; parameter.Value = takeABook.dateForReturn; command.Parameters.Add(parameter); parameter = command.CreateParameter(); parameter.ParameterName = "@dateReturn"; parameter.Value = takeABook.dateReturn; command.Parameters.Add(parameter); command.ExecuteNonQuery(); } }
public ActionResult Create(TakeABookCreateViewModel model) { if (!ModelState.IsValid) { return(View(model)); } TakeABook takeABook = new TakeABook(); takeABook.BookId = model.BookId; takeABook.ReaderId = model.ReaderId; takeABook.dateTaken = model.dateTaken.Date; takeABook.dateForReturn = model.dateForReturn.Date; takeABook.dateReturn = model.dateReturn.Date; var repository = new TakeABookRepository(); repository.Insert(takeABook); return(RedirectToAction("Index")); }
public ActionResult Edit(TakeABookEditViewModel model) { if (!ModelState.IsValid) { return(View(model)); } TakeABookRepository repository = new TakeABookRepository(); TakeABook takeABook = new TakeABook(); takeABook.Id = model.Id; takeABook.BookId = model.BookId; takeABook.UserId = model.UserId; takeABook.DateTaken = model.dateTaken.Date; takeABook.DateForReturn = model.dateForReturn.Date; takeABook.DateReturn = model.dateReturn.Date; repository.Save(takeABook); return(RedirectToAction("Index")); }