public void AddCopy(Copy selectedCopy)
{
int isAvailable = selectedCopy.GetAvailable();
if (isAvailable == 1)
{
SqlConnection conn = DB.Connection();
conn.Open();
SqlCommand cmd = new SqlCommand("INSERT INTO checkout (patron_id, copy_id, current_checkout, due_date) VALUES (@PatronId, @CopyId, @CurrentCheckout, @DueDate); UPDATE copy SET available = @Available WHERE id = @CopyId;", conn);
cmd.Parameters.Add(new SqlParameter("@PatronId", this.GetId().ToString()));
cmd.Parameters.Add(new SqlParameter("@CopyId", selectedCopy.GetId().ToString()));
cmd.Parameters.Add(new SqlParameter("@CurrentCheckout", "1"));
//TODO Later on, lets figure out a way to get the current date to plug into duedate.
cmd.Parameters.Add(new SqlParameter("@DueDate", "2017-03-02"));
cmd.Parameters.Add(new SqlParameter("@Available", "0"));
cmd.ExecuteNonQuery();
if (conn != null)
{
conn.Close();
}
selectedCopy.SetAvailable(0);
}
}
public void CheckIn(Copy selectedCopy)
{
SqlConnection conn = DB.Connection();
conn.Open();
SqlCommand cmd = new SqlCommand("UPDATE copy SET available = @Available WHERE id = @CopyId; UPDATE checkout SET current_checkout = @CurrentCheckout WHERE copy_id = @CopyId AND patron_id = @PatronId;", conn);
cmd.Parameters.Add(new SqlParameter("@Available", "1"));
cmd.Parameters.Add(new SqlParameter("@CopyId", selectedCopy.GetId().ToString()));
cmd.Parameters.Add(new SqlParameter("@CurrentCheckout", "0"));
cmd.Parameters.Add(new SqlParameter("@PatronId", this.GetId().ToString()));
cmd.ExecuteNonQuery();
if (conn != null)
{
conn.Close();
}
selectedCopy.SetAvailable(1);
}
