protected void button2_Click(object sender, EventArgs e) { ReturnDA k = new ReturnDA(); CirculatedCopy c = new CirculatedCopy(); try { c.Id = int.Parse(GridView1.SelectedRow.Cells[1].Text); c.CopyNumber = int.Parse(GridView1.SelectedRow.Cells[2].Text); c.BorrowerNumber = int.Parse(GridView1.SelectedRow.Cells[3].Text); c.DueDate = DateTime.ParseExact(GridView1.SelectedRow.Cells[5].Text, "d/M/yyyy", null); c.BorrowedDate = DateTime.ParseExact(GridView1.SelectedRow.Cells[4].Text, "d/M/yyyy", null); } catch (Exception) { lbError.Text = "You must select a book !"; lbError.Visible = true; return; } try { c.ReturnedDate = DateTime.ParseExact(textBox3.Text, "d/M/yyyy", null); } catch (Exception ex) { lbError.Text = ex.Message; lbError.Visible = true; return; } if (c.ReturnedDate.Date < c.BorrowedDate) { lbError.Text = "BorrowedDate must less than ReturnedDate !"; lbError.Visible = true; //MessageBox.Show("BorrowedDate must less than ReturnedDate !"); return; } TimeSpan dayLater = c.ReturnedDate.Date - c.DueDate; double ngay = dayLater.TotalDays; if (ngay > 0) { c.FineAmount = (int)ngay; } else c.FineAmount = 0; k.returnUpdate(c.CopyNumber); k.cirUpdate(c); button2.Enabled = false; DataSet ds = k.SelectDS(c.CopyNumber); DataView dv = new DataView(ds.Tables[0]); GridView1.DataSource = dv; GridView1.DataBind(); Label4.Text = "" + ds.Tables[0].Rows.Count; lbError.Text = ("Return Successfully !"); lbError.Visible = true; }
public void cirUpdate(CirculatedCopy c) { try { string cm = "Update CirculatedCopy set returnedDate = @returnedDate, fineAmount = @fineAmount " + "where copyNumber = " + c.CopyNumber + "AND ID =" + c.Id; string conn = ConfigurationManager.ConnectionStrings["LibraryConnectionString"].ConnectionString; SqlConnection cn = new SqlConnection(conn); SqlCommand cmd = new SqlCommand(cm, cn); cmd.Parameters.AddWithValue("@returnedDate", c.ReturnedDate); cmd.Parameters.AddWithValue("@fineAmount", c.FineAmount); cn.Open(); cmd.ExecuteNonQuery(); cn.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); return; } }
protected void button3_Click(object sender, EventArgs e) { BorrowBL a = new BorrowBL(); BorrowDA b = new BorrowDA(); //DateTime returnDate = new DateTime(); CirculatedCopy c = new CirculatedCopy(); try { c.Id = int.Parse(GridView1.SelectedRow.Cells[1].Text); c.CopyNumber = int.Parse(GridView1.SelectedRow.Cells[2].Text); c.BorrowerNumber = int.Parse(GridView1.SelectedRow.Cells[3].Text); c.DueDate = DateTime.ParseExact(GridView1.SelectedRow.Cells[5].Text, "d/M/yyyy", null); c.BorrowedDate = DateTime.ParseExact(GridView1.SelectedRow.Cells[4].Text, "d/M/yyyy", null); } catch (Exception) { lbError.Text = "You must select a book !"; lbError.Visible = true; return; } try { c.ReturnedDate = DateTime.ParseExact(textBox3.Text, "d/M/yyyy", null); } catch (Exception ex) { lbError.Text = (ex.Message); lbError.Visible = true; return; } if (c.ReturnedDate.Date < c.BorrowedDate) { lbError.Text = ("BorrowedDate must less than ReturnedDate !"); lbError.Visible = true; return; //MessageBox.Show("BorrowedDate must less than ReturnedDate !"); } TimeSpan dayLater = c.ReturnedDate.Date - c.DueDate; double ngay = dayLater.TotalDays; if (ngay > 0) { textBox4.Text = "" + ngay; } else textBox4.Text = "0"; GridView1.Enabled = false; textBox3.Enabled = false; button3.Enabled = false; button2.Enabled = true; }
protected void button3_Click(object sender, EventArgs e) { BorrowBL a = new BorrowBL(); BorrowDA b = new BorrowDA(); DateTime brDate = new DateTime(); try { brDate = DateTime.ParseExact(textBox4.Text, "d/M/yyyy", null); } catch (Exception ex) { Label1.Text = "Please enter a corect date!"; Label1.Visible = true; return; } DateTime dueDate = brDate.AddDays(14); textBox5.Text = dueDate.ToShortDateString(); int copyNum = int.Parse(textBox3.Text); int brNum = int.Parse(textBox1.Text); CirculatedCopy h = new CirculatedCopy(); a.SetIdMax(); h.Id = ++a.idMax; h.CopyNumber = copyNum; h.BorrowerNumber = brNum; h.BorrowedDate = brDate; h.DueDate = dueDate; b.insertBorrow(h); b.borrowUpdate(copyNum); FillBorrow(brNum); bool test2 = a.checkReserve1(copyNum); bool test3 = a.checkReserve(copyNum, b.getBoNum(copyNum), int.Parse(textBox1.Text)); if (test2 && test3) { b.borrowReUpdate(b.getBoNum(copyNum), int.Parse(textBox1.Text)); } button3.Enabled = false; textBox4.Enabled = false; }
public void insertBorrow(CirculatedCopy a) { try { string conn = ConfigurationManager.ConnectionStrings["LibraryConnectionString"].ConnectionString; SqlConnection cn = new SqlConnection(conn); SqlCommand cmd = new SqlCommand("SET IDENTITY_INSERT [dbo].[CirculatedCopy] ON" + "\n" + "Insert into CirculatedCopy(ID, copyNumber, borrowerNumber, borrowedDate,dueDate,returnedDate,fineAmount) " + "values(@ID, @copyNumber,@borrowerNumber, @borrowedDate,@dueDate,NULL,NULL)", cn); cmd.Parameters.AddWithValue("@ID", a.Id); cmd.Parameters.AddWithValue("@copyNumber", a.CopyNumber); cmd.Parameters.AddWithValue("@borrowerNumber", a.BorrowerNumber); cmd.Parameters.AddWithValue("@borrowedDate", a.BorrowedDate); cmd.Parameters.AddWithValue("@dueDate", a.BorrowedDate.AddDays(14)); //cmd.Parameters.AddWithValue("@returnedDate", null); //cmd.Parameters.AddWithValue("@fineAmount", 0); cn.Open(); cmd.ExecuteNonQuery(); cn.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); return; } }