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