public static bool Insert(Reservation b)
{
try
{
SqlConnection cn=new SqlConnection("Data Source=localhost;Initial Catalog=Library;Integrated Security=True");
SqlCommand cmd = new SqlCommand("Insert into Reservation(borrowerNumber,bookNumber,date,status) " +
"values(@borrowerNumber,@bookNumber,@date,@status)", cn);
cmd.Parameters.AddWithValue("@borrowerNumber", b.BorrowerNumber);
cmd.Parameters.AddWithValue("@bookNumber", b.BookNumber);
cmd.Parameters.AddWithValue("@date", b.Date);
cmd.Parameters.AddWithValue("@status", b.Status);
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
return true;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return false;
}
}
private void button3_Click(object sender, EventArgs e)
{
DateTime reserveDate = new DateTime();
try
{
reserveDate = GetDate(textBox4.Text.Trim());
}
catch (Exception)
{
Console.WriteLine("Invalid Date ! Please try again !");
}
Reservation re = new Reservation(memcode, bookcode, reserveDate);
re.Id = ReserveBL.IDMax() + 1;
ReserveDA.Insert(re);
DataSet ds = ReserveBL.selectTableReservation(memcode);
DataView dv = new DataView(ds.Tables[0]);
dataGridView1.DataSource = dv;
label6.Text = "" + ds.Tables[0].Rows.Count;
}
