public ActionResult Create(FormCollection collection)
{
var newRentalLog = new RentalLog
{
CustomerId = int.Parse(collection["CustomerId"]),
MovieId = int.Parse(collection["MovieId"]),
DateCheckedOut = DateTime.Parse(collection["DateCheckedOut"]),
DueDate = DateTime.Parse(collection["DueDate"]),
};
new RentalLogServices().AddRentalLog(newRentalLog);
return(RedirectToAction("Index"));
}
public ActionResult Create(int id, FormCollection collection)
{
var rentalLog = new RentalLog
{
MovieId = int.Parse(collection["MovieId"]),
CustomerId = int.Parse(collection["CustomerId"]),
CheckOutDate = DateTime.Parse(collection["CheckOutDate"]),
DueBackDate = DateTime.Parse(collection["DueBackDate"])
};
rentalLogService.Create(rentalLog);
return(RedirectToAction("Index"));
}
public ActionResult Edit(int id, FormCollection collection)
{
var updatedRentalLog = new RentalLog
{
CustomerId = int.Parse(collection["CustomerId"]),
MovieId = int.Parse(collection["MovieId"]),
DateCheckedOut = DateTime.Parse(collection["DateCheckedOut"]),
DueDate = DateTime.Parse(collection["DueDate"]),
Id = id
};
//save to database
//display correct page.
new RentalLogServices().EditRentalLog(updatedRentalLog, id);
return(RedirectToAction("Index"));
}
//add new rental log method
public void AddRentalLog(RentalLog newRentalLog)
{
using (var connection = new SqlConnection(ConnectionString))
{
var query = "INSERT INTO RentalLog ([CustomerId], [MovieId], [DateCheckedOut], " +
"[DueDate]) VALUES(@CustomerId, @MovieId, @DateCheckedOut, @DueDate)";
var cmd = new SqlCommand(query, connection);
connection.Open();
cmd.Parameters.AddWithValue("@CustomerId", newRentalLog.CustomerId);
cmd.Parameters.AddWithValue("@MovieId", newRentalLog.MovieId);
cmd.Parameters.AddWithValue("@DateCheckedOut", newRentalLog.DateCheckedOut);
cmd.Parameters.AddWithValue("@DueDate", newRentalLog.DueDate);
cmd.ExecuteNonQuery();
connection.Close();
}
}
//get single rental log
public RentalLog GetRentalLog(int id)
{
var rentalLog = new RentalLog();
using (var connection = new SqlConnection(ConnectionString))
{
var query = "SELECT * FROM RentalLog WHERE ID = @id";
var cmd = new SqlCommand(query, connection);
cmd.Parameters.AddWithValue("@Id", id);
connection.Open();
var reader = cmd.ExecuteReader();
while (reader.Read())
{
rentalLog = new RentalLog(reader);
}
connection.Close();
}
return(rentalLog);
}
//edit rental log method
public void EditRentalLog(RentalLog rentalLog, int id)
{
using (var connection = new SqlConnection(ConnectionString))
{
var query = @"UPDATE RentalLog SET
[CustomerId] = @CustomerId
,[MovieId] = @MovieId
,[DateCheckedOut] = @DateCheckedOut
,[DueDate] = @DueDate
WHERE Id = @Id";
var cmd = new SqlCommand(query, connection);
connection.Open();
cmd.Parameters.AddWithValue("@CustomerId", rentalLog.CustomerId);
cmd.Parameters.AddWithValue("@MovieId", rentalLog.MovieId);
cmd.Parameters.AddWithValue("@DateCheckedOut", rentalLog.DateCheckedOut);
cmd.Parameters.AddWithValue("@DueDate", rentalLog.DueDate);
cmd.ExecuteNonQuery();
connection.Close();
}
}
public RentalLog Create(RentalLog RentalLog)
{
using (var connection = new SqlConnection(_ConnectionString))
{
var query = @"INSERT INTO RentalLog
([MovieId]
,[CustomerId]
,[CheckOutDate]
,[DueBackDate])
VALUES(@MovieId, @CustomerId, @CheckOutDate, @DueBackDate)";
var cmd = new SqlCommand(query, connection);
cmd.Parameters.AddWithValue("@MovieId", RentalLog.MovieId);
cmd.Parameters.AddWithValue("@CustomerId", RentalLog.CustomerId);
cmd.Parameters.AddWithValue("@CheckOutDate", RentalLog.CheckOutDate);
cmd.Parameters.AddWithValue("@DueBackDate", RentalLog.DueBackDate);
connection.Open();
cmd.ExecuteNonQuery();
connection.Close();
}
return(RentalLog);
}
