//======================================
public static bool Insert(CirculatedCopy cir)
{
try
{
string strConn = ConfigurationManager.ConnectionStrings["LibraryConnectionString"].ConnectionString;
SqlConnection cn = new SqlConnection(strConn);
SqlCommand cmd = new SqlCommand("Insert into CirculatedCopy(copyNumber,borrowerNumber,borrowedDate,dueDate) " +
"values(@copyNumber,@borrowerNumber,@borrowedDate,@dueDate)", cn);
//cmd.Parameters.AddWithValue("@ID", cir.Id);
cmd.Parameters.AddWithValue("@copyNumber", cir.CopyNumber);
cmd.Parameters.AddWithValue("@borrowerNumber", cir.BorrowerNumber);
cmd.Parameters.AddWithValue("@borrowedDate", cir.BorrowedDate);
cmd.Parameters.AddWithValue("@dueDate", cir.DueDate);
//cmd.Parameters.AddWithValue("@returnDate", cir.ReturnedDate);
//cmd.Parameters.AddWithValue("@fineAmount", cir.FineAmount);
//,returnedDate,fineAmount ,@returnedDate,@fineAmount
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
return true;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return false;
}
}
//==============================
public static bool Delete(CirculatedCopy c)
{
try
{
string strConn = ConfigurationManager.ConnectionStrings["LibraryConnectionString"].ConnectionString;
SqlConnection cn = new SqlConnection(strConn);
SqlCommand cmd = new SqlCommand("Delete CirculatedCopy where ID = @ID", cn);
cmd.Parameters.AddWithValue("@ID", c.Id);
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
return true;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return false;
}
}
public static bool Update(CirculatedCopy cir)
{
return CirculatedCopyDA.Update(cir);
}
public static bool Insert(CirculatedCopy cir)
{
return CirculatedCopyDA.Insert(cir);
}
public static bool Delete(CirculatedCopy cir)
{
return CirculatedCopyDA.Delete(cir);
}
//Borrow a Copies
protected void Button3_Click(object sender, EventArgs e)
{
try
{
CirculatedCopy cir = new CirculatedCopy();
CirculatedCopyBL.SetIDNumberMax();
//cir.Id = CirculatedCopyBL.IDMax + 1;
cir.CopyNumber = int.Parse(tbCopyNumber.Text);
cir.BorrowerNumber = int.Parse(tbBorrowerNumber.Text);
cir.BorrowedDate = DateTime.Today;
cir.DueDate = DateTime.Today.AddDays(14);
CirculatedCopyBL.Insert(cir);
CopyBL.UpdateType(int.Parse(tbCopyNumber.Text), 'B');
GridView1.DataBind();
//viewBorrowedBook(cir.BorrowerNumber);
lbBorrowedBook.Text = "The number of borrowed Book : " + getNumberOf_BorroweredBook(int.Parse(tbBorrowerNumber.Text));
updateReservationStatus();
Button3.Enabled = false;
}
catch (Exception ex)
{
lbConditionError.Text = ex.Message;
}
}
//==========================
public static bool Update(CirculatedCopy cir)
{
try
{
string strConn = ConfigurationManager.ConnectionStrings["LibraryConnectionString"].ConnectionString;
SqlConnection cn = new SqlConnection(strConn);
SqlCommand cmd = new SqlCommand("Update CirculatedCopy set copyNumber = @copyNumber, borrowerNumber = @borrowerNumber, borrowedDate = @borrowedDate "
+ "dueDate = @dueDate, returnDate = @returnDate, fineAmount = @fineAmount where ID = @ID", cn);
cmd.Parameters.AddWithValue("@ID", cir.Id);
cmd.Parameters.AddWithValue("@copyNumber", cir.CopyNumber);
cmd.Parameters.AddWithValue("@borrowerNumber", cir.BorrowerNumber);
cmd.Parameters.AddWithValue("@borrowedDate", cir.BorrowedDate);
cmd.Parameters.AddWithValue("@dueDate", cir.DueDate);
cmd.Parameters.AddWithValue("@returnDate", cir.ReturnedDate);
cmd.Parameters.AddWithValue("@fineAmount", cir.FineAmount);
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
return true;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return false;
}
}