protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
tbBookNum.Enabled = false;
tbCopyNum.Enabled = false;
tbSequence.Enabled = false;
tbCopyNum.Text = (CopyBL.GetCopyNumberMax() + 1).ToString();
string s = (string)Session["bookNumber"];
Book b = new Book();
b = BookBL.SelectByID(s);
tbBookNum.Text = b.BookNumber.ToString();
int Seq;
try
{
Seq = CopyBL.getSequenceMax(tbBookNum.Text) + 1;
}
catch (Exception)
{
Seq = 1;
}
tbSequence.Text = Seq.ToString();
}
}
protected void btSave_Click(object sender, EventArgs e)
{
if (tbTitle.Text != "")
{
Book b = new Book(int.Parse(tbBookNum.Text), tbTitle.Text, tbAuthor.Text, tbPulisher.Text);
BookBL.Insert(b);
Response.Redirect("~/GUI/BookUI.aspx");
}
else
{
lbTitle.Visible = true;
}
}
//public static void DeleteAllCopy(Book b) {
// try {
// SqlConnection cn = new SqlConnection("Data Source=TRUNGND\\SQL;Initial Catalog=Library;Integrated Security=True");
// SqlCommand cmd=new SqlCommand("Delete Copy where bookNumber = @bookNumber",cn);
// cmd.Parameters.AddWithValue("@bookNumber",b.BookNumber);
// cn.Open();
// cmd.ExecuteNonQuery();
// cn.Close();
// } catch(Exception ex) {
// MessageBox.Show(ex.Message);
// }
//}
public static bool DeleteAllCopy(Book b)
{
try
{
string conn = ConfigurationManager.ConnectionStrings["LibraryConnectionString"].ConnectionString;
SqlConnection cn = new SqlConnection(conn);
SqlCommand cmd = new SqlCommand("Delete Copy where bookNumber = @bookNumber", cn);
cmd.Parameters.AddWithValue("@bookNumber", b.BookNumber);
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
return true;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return false;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack && Session["bookNumber"] != null)
{
tbBookNum.Enabled = false;
string s = (string)Session["bookNumber"];
Book b = new Book();
b = BookBL.SelectByID(s);
tbBookNum.Text = b.BookNumber.ToString();
tbAuthor.Text = b.Authors;
tbPulisher.Text = b.Publisher;
tbTitle.Text = b.Title;
//GridViewRow row = (GridViewRow)Session["book"];
//tbBookNum.Text = row.Cells[1].Text;
//tbTitle.Text = row.Cells[2].Text;
//tbAuthor.Text = row.Cells[3].Text;
//tbPulisher.Text = row.Cells[4].Text;
}
}
private void FillCopyBook()
{
if (Session["bookNumber"] != null)
{
tbBookNum.Enabled = false;
tbTittle.Enabled = false;
string s = (string)Session["bookNumber"];
Book b = new Book();
b = BookBL.SelectByID(s);
tbBookNum.Text = b.BookNumber.ToString();
tbTittle.Text = b.Title;
string filter = "bookNumber =" + s;
DataSet ds = new DataSet();
ds = CopyBL.SelectDS();
DataView dv = new DataView(ds.Tables[0]);
dv.RowFilter = filter;
string sortDirection = "", sortExpression = "";
if (ViewState["SortDirection"] != null)
sortDirection = ViewState["SortDirection"].ToString();
if (ViewState["SortExpression"] != null)
{
sortExpression = ViewState["SortExpression"].ToString();
dv.Sort = sortExpression + " " + sortDirection;
}
gvCopyBook.DataSource = dv;
gvCopyBook.DataBind();
lbNum.Text = gvCopyBook.Rows.Count.ToString();
}
}
protected void gvBook_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
GridViewRow row = gvBook.SelectedRow;
if (row != null)
{
{
string s = gvBook.Rows[e.RowIndex].Cells[1].Text;
Book b = new Book();
b.BookNumber = int.Parse(s);
BookBL.DeleteAllCopy(b);
BookBL.Delete(b);
FillBook();
}
}
else
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "wtf", "alert('Please select a book!');", true);
}
}
public static bool Update(Book b)
{
return BookDA.Update(b);
}
public static bool Insert(Book b)
{
return BookDA.Insert(b);
}
public static bool DeleteAllCopy(Book b)
{
return BookDA.DeleteAllCopy(b);
}
public static bool Delete(Book b)
{
return BookDA.Delete(b);
}
public static bool Update(Book b)
{
try
{
string conn = ConfigurationManager.ConnectionStrings["LibraryConnectionString"].ConnectionString;
SqlConnection cn = new SqlConnection(conn);
SqlCommand cmd = new SqlCommand("Update Book set title = @title, "
+ "authors = @authors, publisher = @publisher where bookNumber = @bookNumber", cn);
cmd.Parameters.AddWithValue("@bookNumber", b.BookNumber);
cmd.Parameters.AddWithValue("@title", b.Title);
cmd.Parameters.AddWithValue("@authors", b.Authors);
cmd.Parameters.AddWithValue("@publisher", b.Publisher);
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
return true;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return false;
}
}
public static Book SelectByID(string s)
{
try
{
string conn = ConfigurationManager.ConnectionStrings["LibraryConnectionString"].ConnectionString;
string sql = "SELECT * FROM Book where bookNumber = " + s;
SqlDataAdapter da = new SqlDataAdapter(sql, conn);
DataSet ds = new DataSet();
da.Fill(ds);
Book b = new Book();
b.BookNumber = int.Parse(ds.Tables[0].Rows[0][0].ToString());
b.Title = ds.Tables[0].Rows[0][1].ToString();
b.Authors = ds.Tables[0].Rows[0][2].ToString();
b.Publisher = ds.Tables[0].Rows[0][3].ToString();
return b;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return new Book();
}
}
public static bool Insert(Book b)
{
try
{
string conn = ConfigurationManager.ConnectionStrings["LibraryConnectionString"].ConnectionString;
SqlConnection cn = new SqlConnection(conn);
SqlCommand cmd = new SqlCommand("Insert into Book(bookNumber, title, authors, publisher) " +
"values(@bookNumber, @title, @authors, @publisher)", cn);
cmd.Parameters.AddWithValue("@bookNumber", b.BookNumber);
cmd.Parameters.AddWithValue("@title", b.Title);
cmd.Parameters.AddWithValue("@authors", b.Authors);
cmd.Parameters.AddWithValue("@publisher", b.Publisher);
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
return true;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return false;
}
}
