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"));
}
