public static bool Insert(Reservation re)
{
try
{
string strConn = ConfigurationManager.ConnectionStrings["LibraryConnectionString"].ConnectionString;
SqlConnection cn = new SqlConnection(strConn);
SqlCommand cmd = new SqlCommand("Insert into Reservation( borrowerNumber, bookNumber, date, status) " +
"values( @borrowerNumber, @bookNumber, @date, @status)", cn);
//cmd.Parameters.AddWithValue("@ID", re.Id);
cmd.Parameters.AddWithValue("@borrowerNumber", re.BorrowerNumber);
cmd.Parameters.AddWithValue("@bookNumber", re.BookNumber);
cmd.Parameters.AddWithValue("@date", re.Date);
cmd.Parameters.AddWithValue("@status", re.Status);
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
return true;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return false;
}
}
//RESERVE
protected void btServe_Click(object sender, EventArgs e)
{
int x = int.Parse(tbBorrowerNumber.Text);
Reservation re = new Reservation();
//re.Id = ReservationBL.idMax + 1;
re.BorrowerNumber = int.Parse(tbBorrowerNumber.Text);
re.BookNumber = int.Parse(tbBookNumber.Text);
re.Date = DateTime.Today;
re.Status = 'R';
ReservationBL.Insert(re);
lbReservedBook.Text = "The number of Reserved Book : " + countReservedBook(x);
GridView1.DataBind();
btReserve.Enabled = false;
}
public static bool Delete(Reservation re)
{
try
{
string strConn = ConfigurationManager.ConnectionStrings["LibraryConnectionString"].ConnectionString;
SqlConnection cn = new SqlConnection(strConn);
SqlCommand cmd = new SqlCommand("Delete Reservation where ID = @ID", cn);
cmd.Parameters.AddWithValue("@ID", re.Id);
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
return true;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return false;
}
}
public static bool Update(Reservation re)
{
return ReservationDA.Update(re);
}
public static bool Insert(Reservation re)
{
return ReservationDA.Insert(re);
}
public static bool Delete(Reservation re)
{
return ReservationDA.Delete(re);
}
public static bool Update(Reservation re)
{
try
{
string strConn = ConfigurationManager.ConnectionStrings["LibraryConnectionString"].ConnectionString;
SqlConnection cn = new SqlConnection(strConn);
SqlCommand cmd = new SqlCommand("Update Reservation set borrowerNumber = @borrowerNumber, "
+ "bookNumber = @bookNumber, date = @date, price= @price where ID = @ID", cn);
cmd.Parameters.AddWithValue("@ID", re.Id);
cmd.Parameters.AddWithValue("@borrowerNumber", re.BorrowerNumber);
cmd.Parameters.AddWithValue("@bookNumber", re.BookNumber);
cmd.Parameters.AddWithValue("@date", re.Date);
cmd.Parameters.AddWithValue("@status", re.Status);
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
return true;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return false;
}
}