private void btBorrow_Click(object sender, EventArgs e)
{
DateTime brDate;
DateTime dueDate;
int brNumber = int.Parse(tbMemberCode.Text.ToString());
int copyNumber = int.Parse(tbCopyNumber.Text.ToString());
try {
//brDate = DateTime.Parse(tbBorrowedDate.Text.ToString());
brDate = Utility.getReturnedDate(tbBorrowedDate.Text);
dueDate = brDate.AddDays(14);
CirculatedCopy c = new CirculatedCopy(copyNumber, brNumber, dueDate);
if (CirculatedCopyBL.insert(c)) {
CopyBL.setTypeOfCopyNumber(copyNumber, 'B');
int bookNumber = CopyBL.getBookNumber(copyNumber);
ReserveBL.setStatusOfReservation(brNumber, bookNumber, 'A');
tbBorrowedDate.Enabled = false;
tbCopyNumber.Enabled = false;
btBorrow.Enabled = false ;
tbMemberCode.Enabled = true;
btCheckMember.Enabled = true;
tbDueDate.Text = dueDate.ToShortDateString();
MessageBox.Show("Borrow successful!");
}
DataSet ds = CirculatedCopyBL.selectDs();
DataView dv = new DataView(ds.Tables[0]);
dv.RowFilter = "returnedDate is NULL and borrowerNumber=" + brNumber;
labelBorrowBorrowedBook.Text = dv.Count.ToString();
dgvBorrowed.DataSource = dv;
}
catch (Exception ex) {
MessageBox.Show(ex.Message);
}
}
public static bool Insert(CirculatedCopy c)
{
try
{
SqlConnection cn = new SqlConnection("Data Source=localhost;Initial Catalog=Library;Integrated Security=True");
string str;
if (c.ReturnedDate < c.BorrowedDate)
{
str = "Insert into CirculatedCopy(copyNumber, borrowerNumber, borrowedDate, dueDate)"
+ "values(@copyNumber, @borrowerNumber, @borrowedDate, @dueDate)";
SqlCommand cmd1 = new SqlCommand(str, cn);
cmd1.Parameters.AddWithValue("@copyNumber", c.CopyNumber);
cmd1.Parameters.AddWithValue("@borrowerNumber", c.BorrowerNumber);
cmd1.Parameters.AddWithValue("@borrowedDate", c.BorrowedDate);
cmd1.Parameters.AddWithValue("@dueDate", c.DueDate);
cn.Open();
cmd1.ExecuteNonQuery();
cn.Close();
return true;
}
else
{
SqlCommand cmd = new SqlCommand("Insert into CirculatedCopy(copyNumber, borrowerNumber, borrowedDate, dueDate, returnedDate, fineAmount)"
+ "values(@copyNumber, @borrowerNumber, @borrowedDate, @dueDate, @returnedDate, @fineAmount)", cn);
cmd.Parameters.AddWithValue("@copyNumber", c.CopyNumber);
cmd.Parameters.AddWithValue("@borrowerNumber", c.BorrowerNumber);
cmd.Parameters.AddWithValue("@borrowedDate", c.BorrowedDate);
cmd.Parameters.AddWithValue("@dueDate", c.DueDate);
cmd.Parameters.AddWithValue("@returnedDate", c.ReturnedDate);
cmd.Parameters.AddWithValue("@fineAmount", c.FineAmount);
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
return true;
}
}
catch (System.Exception ex)
{
MessageBox.Show(ex.Message);
return false;
}
}
public static bool Delete(CirculatedCopy c)
{
try
{
SqlConnection cn = new SqlConnection("Data Source=localhost;Initial Catalog=Library;Integrated Security=True");
SqlCommand cmd = new SqlCommand("Delete CirculatedCopy where copyNumber = @copyNumber", cn);
cmd.Parameters.AddWithValue("@copyNumber", c.CopyNumber);
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
return true;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return false;
}
}
public static bool Update(CirculatedCopy b)
{
return CirculatedCopyDA.Update(b);
}
public static bool Insert(CirculatedCopy b)
{
return CirculatedCopyDA.Insert(b);
}
public static bool Delete(CirculatedCopy b)
{
return CirculatedCopyDA.Delete(b);
}
public static bool insert(CirculatedCopy c)
{
return CirculatedCopyDA.Insert(c);
}
private void buttonConfirmFine_Click(object sender, EventArgs e)
{
if (!isSelectedCopy())
{
MessageBox.Show("Please select a copy to return!");
return ;
}
try
{
DateTime returnedDate = Utility.getReturnedDate(txtReturnedDate.Text);
DateTime borrowDate = (DateTime)dataGridView1.SelectedRows[0].Cells["borrowedDate"].Value;
double d = returnedDate.Subtract(borrowDate).TotalDays;
if (d < 0) throw new Exception("Return before Borrowed Date");
DateTime dueDate = (DateTime)dataGridView1.SelectedRows[0].Cells["dueDate"].Value;
double diff = returnedDate.Subtract(dueDate).TotalDays;
if (diff < 0) diff = 0;
txtFineAmount.Text = diff + "";
int id = (int)dataGridView1.SelectedRows[0].Cells["ID"].Value;
int copyNumber = (int)dataGridView1.SelectedRows[0].Cells["copyNumber"].Value;
int borrowerNumber = (int)dataGridView1.SelectedRows[0].Cells["borrowerNumber"].Value;
DateTime borrowedDate = (DateTime)dataGridView1.SelectedRows[0].Cells["borrowedDate"].Value;
CirculatedCopy c = new CirculatedCopy(copyNumber, borrowerNumber, dueDate);
c.Id = id;
c.BorrowedDate = borrowedDate;
c.ReturnedDate = returnedDate;
c.FineAmount = (float)diff;
ReturnBL.Update(c);
CopyDA.updateStatus(copyNumber);
MessageBox.Show("Book returned successfully!");
DataSet ds = CirculatedCopyDA.SelectDS();
DataView dv = new DataView(ds.Tables[0]);
dv.RowFilter = "returnedDate IS NULL AND borrowerNumber=" + borrowerNumber;
dataGridView1.DataSource = dv;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public static bool Update(CirculatedCopy c)
{
try
{
SqlConnection cn = new SqlConnection("Data Source=localhost;Initial Catalog=Library;Integrated Security=True");
SqlCommand cmd = new SqlCommand("Update CirculatedCopy set borrowerNumber = @borrowerNumber, "
+ "borrowedDate = @borrowedDate, dueDate = @dueDate, returnedDate=@returnedDate, fineAmount=@fineAmount, copyNumber = @copyNumber where id=@id", cn);
cmd.Parameters.AddWithValue("@copyNumber", c.CopyNumber);
cmd.Parameters.AddWithValue("@borrowerNumber", c.BorrowerNumber);
cmd.Parameters.AddWithValue("@borrowedDate", c.BorrowedDate);
cmd.Parameters.AddWithValue("@dueDate", c.DueDate);
cmd.Parameters.AddWithValue("@returnedDate", c.ReturnedDate);
cmd.Parameters.AddWithValue("@fineAmount", c.FineAmount);
cmd.Parameters.AddWithValue("@id", c.Id);
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
return true;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return false;
}
}
