private void button2_Click(object sender, EventArgs e)
{
try
{
if (int.Parse(textBox4.Text) > 0)
{
String query = "INSERT INTO Book (IDBook,Title,Author,Category,Publisher,Amount) VALUES('" + textBox6.Text.Trim() + "',N'" + textBox1.Text.Trim() + "',N'" + textBox2.Text.Trim() + "',N'" + textBox3.Text.Trim() + "',N'" + textBox5.Text.Trim() + "','" + textBox4.Text.Trim() + "')";
bool kq = QueryData.ExecuteNonQueryBook(connect, query); // thuc thi luu du lieu
if (kq)
{
MessageBox.Show("Inserted successfully !!!");
textBox1.Text = null;
textBox2.Text = null;
textBox3.Text = null;
textBox4.Text = null;
textBox5.Text = null;
textBox6.Text = null;
}
this.View();
}
else
{
MessageBox.Show("Amount is invalid");
}
}
catch
{
MessageBox.Show("Amount is invalid");
}
}
public void borrowBook(Book a) // thoi gian muon trong 2 tuan
{
DateTime date = DateTime.Now;
if (setBook.Count <= 2) // moi lan muon toi da 3 cuon sach
{
SqlConnection connect = QueryData.Connect_Server();
String query = "INSERT INTO Bookitem (IDBook,IDUser,Title,Borrowed,Duedate,Bkstatus) VALUES('" + a.IDBook.ToString().Trim() + "','" + idUser.ToString().Trim() + "',N'" + a.Titletext.Trim() + "',CONVERT(datetime, '" + date.ToShortDateString().ToString() + "', 103) , CONVERT(datetime, '" + date.AddDays(14).ToShortDateString().ToString() + "',103),'" + "Being borrowed" + "')";
bool kq = QueryData.ExecuteNonQueryBook(connect, query); // thuc thi luu du lieu
if (kq)
{
setBook.Add(new Bookitem {
IDBook = a.IDBook, IDUser = idUser, Titletext = a.Titletext, Borrowtime = date, DueTime = date.AddDays(14), Statusbool = "Booked"
});
MessageBox.Show("Borrowed successfully !!!!");
}
}
else
{
MessageBox.Show("Only borrow max three book");
}
}
