protected void btnSave_Click(object sender, EventArgs e) { int add = (int)Session["add"]; Copy c = new Copy(); c.BookNumber = int.Parse(txtBookNumber.Text); c.SequenceNumber = CopyDAO.GetSequenceNumberMax(c.BookNumber) + 1; c.Type = txtType.Text[0]; if (txtPrice.Text == "") { c.Price = 0; } else { c.Price = int.Parse(txtPrice.Text); } if (add == 1) { c.CopyNumber = CopyDAO.GetCopyNumberMax() + 1; CopyDAO.Insert(c); } else { c.CopyNumber = (int)Session["copyNumber"]; CopyDAO.Update(c); } ObjectDataSource1.Select(); GridView1.DataBind(); displayButtons(1); }
private void btnCopyEdit_Click(object sender, EventArgs e) { Button btn = (Button)sender; if (btn.Text == "Edit") { if (!isCopySelected()) { return; } if (txtType.Text[0] == 'B') { MessageBox.Show("Can't edit borrwed copy!"); return; } displayCopyButtons(3); } else { c = new Copy(int.Parse(txtCopyBookNumber.Text), int.Parse(txtCopyNumber.Text) , int.Parse(txtSequenceNumber.Text), txtType.Text[0], double.Parse(txtPrice.Text)); CopyDAO.Update(c); ViewCopies(); displayCopyButtons(1); } }
private void borrow(CirculatedCopy cc, Copy c, Reservation r) { // Insert borrow record if (cc == null) { return; } if (CirculatedCopyDAO.Insert(cc)) { txtDueDate.Text = Calendar1.SelectedDate.AddDays(14).ToString("dd/MM/yyyy"); // update type = 'B' at Copy c = (Copy)Session["copy"]; if (c == null) { return; } c.Type = 'B'; CopyDAO.Update(c); // update status = 'A' at Reservation r = (Reservation)Session["reser"]; if (r == null) { return; } r.Status = 'A'; ReserveDAO.Update(r); } else { lblError.Text = cc.BorrowedDate.ToString("yyyy-MM-dd hh:mm:ss"); lblError.Text = "Borrow Fail :< "; } }
private void borrow(CirculatedCopy cc, Copy c, Reservation r) { // Insert borrow record if (cc == null) { return; } CirculatedCopyDAO.Insert(cc); // update type = 'B' at Copy if (c == null) { return; } c.Type = 'B'; CopyDAO.Update(c); // update status = 'A' at Reservation if (r == null) { return; } r.Status = 'A'; ReserveDAO.Update(r); }
private void Return(CirculatedCopy cc) { CirculatedCopyDAO.Update(cc); Copy c = CopyDAO.GetCopy(cc.CopyNumber); // update type = 'A' in copy c.Type = 'A'; CopyDAO.Update(c); }
protected void btnSave_Click(object sender, EventArgs e) { Copy c = new Copy(); c.BookNumber = int.Parse(txtBookNum.Text); c.SequenceNumber = CopyDAO.GetSeqNumMaxOfBook(c.BookNumber) + 1; ///Set Type if (!(txtType.Text[0].Equals('A'))) { if (!(txtType.Text[0].Equals('R'))) { lblError.Text = "Type must be A or R"; lblError.Visible = true; return; } } c.Type = txtType.Text[0]; //Set Price if (txtPrice.Text == "") { c.Price = 0; } else { if (DAO.checkFloat(txtPrice.Text)) { c.Price = float.Parse(txtPrice.Text); } else { lblError.Text = "Price must in range 0-999.999.999"; lblError.Visible = true; return; } } if (check == 1) { CopyDAO.Insert(c); clear(); displayButtons(1); } if (check == 2) { c.CopyNumber = (int)Session["copyNumber"]; CopyDAO.Update(c); clear(); displayButtons(1); } ObjectDataSource1.Select(); GridView1.DataBind(); }
private void Return(CirculatedCopy cc) { CirculatedCopyDAO.Update(cc); Copy c = CopyDAO.GetCopy(cc.CopyNumber); // if copy is reference if (c.Type == 'R') { return; } // update type = 'A' in copy c.Type = 'A'; CopyDAO.Update(c); }
private void Return(CirculatedCopy cc) { if (CirculatedCopyDAO.Update(cc)) { showMessageError("Return completed <3"); Copy c = CopyDAO.GetCopy(cc.CopyNumber); // update type = 'A' in copy c.Type = 'A'; CopyDAO.Update(c); } else { showMessageError("Return Fail :<"); } }
private void borrow(CirculatedCopy cc, Copy c, Reservation r) { // Insert borrow record if (cc == null) { return; } CirculatedCopyDAO.Insert(cc); // update type = 'B' at Copy c = CopyDAO.GetCopy(Int32.Parse(txtCopyNumber.Text)); c.Type = 'B'; CopyDAO.Update(c); // update status = 'A' at Reservation if (r == null) { return; } r.Status = 'A'; ReserveDAO.Update(r); }
//button save protected void Button5_Click(object sender, EventArgs e) { //edit if (checkEditBook == true) { //book if (copyExist == false) { if (txtTitle.Text.Trim().Length == 0) { lbErrorTitleAdd.Text = "Please input title"; lbErrorTitleAdd.Visible = true; return; } bo.Title = txtTitle.Text; bo.Authors = txtAuthor.Text; bo.Publisher = txtPublisher.Text; if (!BookDAO.Update(bo)) { return; } btSaveBook.Enabled = false; btCancelBook.Enabled = false; } else { //copy if (txtTypecopy.Text.Trim().Length == 0) { lbErrorCopies.Text = "Please iput type A/F"; lbErrorCopies.Visible = true; return; } co.Type = char.Parse(txtTypecopy.Text.ToUpper()); if (co.Type != 'A' && co.Type != 'F') { lbErrorCopies.Text = "Please iput type A/F"; lbErrorCopies.Visible = true; return; } co.Price = double.Parse(txtPrice.Text); co.BookNumber = int.Parse(GridView2.SelectedRow.Cells[3].Text); co.CopyNumber = int.Parse(GridView2.SelectedRow.Cells[2].Text); if (!CopyDAO.Update(co)) { return; } btSaveCopies.Enabled = false; btCancelCopies.Enabled = false; txtTypecopy.ReadOnly = true; txtPrice.ReadOnly = true; } } //add if (checkAddBook == true) { if (copyExist == false) { if (txtTitle.Text.Trim().Length == 0) { lbErrorTitleAdd.Text = "Please input title"; lbErrorTitleAdd.Visible = true; return; } bo = new Book(); bo.BookNumber = BookDAO.GetBookNumberMax() + 1; bo.Title = txtTitle.Text; bo.Authors = txtAuthor.Text; bo.Publisher = txtPublisher.Text; if (!BookDAO.Insert(bo)) { return; } foreach (TextBox tb in GetTextBoxes()) { tb.ReadOnly = true; } btSaveBook.Enabled = false; btCancelBook.Enabled = false; } else { if (txtTypecopy.Text.Trim().Length == 0) { lbErrorCopies.Text = "Please iput type A/F"; lbErrorCopies.Visible = true; return; } String type = txtTypecopy.Text.Trim().ToUpper(); if (!type.Equals("A") && !type.Equals("F")) { lbErrorCopies.Text = "Please iput type A/F"; lbErrorCopies.Visible = true; return; } co = new Copy(); co.CopyNumber = CopyDAO.GetCopyNumberMax() + 1; co.BookNumber = Int32.Parse(txtBookNumberCopies.Text); co.SequenceNumber = CopyDAO.GetSequenceNumberMax(co.BookNumber) + 1; co.Type = char.Parse(type); if (co.Type != 'A' && co.Type != 'F') { co.Price = double.Parse(txtPrice.Text.Trim().Length == 0 ? "0" : txtPrice.Text.Trim()); } if (!CopyDAO.Insert(co)) { return; } } btSaveCopies.Enabled = false; // save btCancelCopies.Enabled = false; // cancel } foreach (TextBox tb in GetTextBoxes()) { if (!checkEditBook) { tb.Text = ""; } tb.ReadOnly = true; } checkAddBook = false; checkEditBook = false; reload(); }