public bool checkReserve1(int copyNum)
{
BorrowDA a = new BorrowDA();
int bN = a.getBoNum(copyNum);
string conn = ConfigurationManager.ConnectionStrings["LibraryConnectionString"].ConnectionString;
SqlDataAdapter da = new SqlDataAdapter("select * from Reservation where bookNumber =" + bN + "AND status = 'R'", conn);
DataSet ds = new DataSet();
da.Fill(ds);
if (ds.Tables[0].Rows.Count < 1)
{
return false;
}
return true;
}
protected void button2_Click(object sender, EventArgs e)
{
BorrowBL a = new BorrowBL();
BorrowDA b = new BorrowDA();
int code = 0;
try
{
code = int.Parse(textBox3.Text);
}
catch (Exception ex)
{
Label1.Text = "Please enter a corect copy number!";
Label1.Visible = true;
return;
}
bool test = a.checkCopy(code);
if (!test)
{
Label1.Text = "You can't borrow this copy!";
Label1.Visible = true;
return;
}
bool test1 = a.checkFive(int.Parse(textBox1.Text));
if (!test1)
{
Label1.Text = "You have borrowed 5 copies!";
Label1.Visible = true;
return;
}
bool test2 = a.checkReserve1(code);
if (!test2)
{
textBox4.Text = DateTime.Now.ToString("d/M/yyyy");
textBox3.Enabled = false;
button2.Enabled = false;
button3.Enabled = true;
textBox4.Enabled = true;
Label1.Visible = false;
}
else
{
bool test3 = a.checkReserve(code, b.getBoNum(code), int.Parse(textBox1.Text));
if (!test3)
{
Label1.Text = "This book have resserved by other person!";
Label1.Visible = true;
return;
}
else
{
textBox3.Enabled = false;
textBox4.Text = DateTime.Now.ToString("d/M/yyyy");
button2.Enabled = false;
textBox4.Enabled = true;
button3.Enabled = true;
Label1.Visible = false;
}
}
}
protected void button3_Click(object sender, EventArgs e)
{
BorrowBL a = new BorrowBL();
BorrowDA b = new BorrowDA();
DateTime brDate = new DateTime();
try
{
brDate = DateTime.ParseExact(textBox4.Text, "d/M/yyyy", null);
}
catch (Exception ex)
{
Label1.Text = "Please enter a corect date!";
Label1.Visible = true;
return;
}
DateTime dueDate = brDate.AddDays(14);
textBox5.Text = dueDate.ToShortDateString();
int copyNum = int.Parse(textBox3.Text);
int brNum = int.Parse(textBox1.Text);
CirculatedCopy h = new CirculatedCopy();
a.SetIdMax();
h.Id = ++a.idMax;
h.CopyNumber = copyNum;
h.BorrowerNumber = brNum;
h.BorrowedDate = brDate;
h.DueDate = dueDate;
b.insertBorrow(h);
b.borrowUpdate(copyNum);
FillBorrow(brNum);
bool test2 = a.checkReserve1(copyNum);
bool test3 = a.checkReserve(copyNum, b.getBoNum(copyNum), int.Parse(textBox1.Text));
if (test2 && test3)
{
b.borrowReUpdate(b.getBoNum(copyNum), int.Parse(textBox1.Text));
}
button3.Enabled = false;
textBox4.Enabled = false;
}