private void button2_Click(object sender, EventArgs e) { ReturnDA k = new ReturnDA(); if (MessageBox.Show("Are you sure?", "Question", MessageBoxButtons.YesNo) == DialogResult.Yes) { CirculatedCopy c = new CirculatedCopy(); try { c.Id = int.Parse(dataGridView1.SelectedRows[0].Cells["ID"].Value.ToString()); c.CopyNumber = int.Parse(dataGridView1.SelectedRows[0].Cells["copyNumber"].Value.ToString()); c.BorrowerNumber = int.Parse(dataGridView1.SelectedRows[0].Cells["borrowerNumber"].Value.ToString()); c.DueDate = Convert.ToDateTime(dataGridView1.SelectedRows[0].Cells["dueDate"].Value.ToString()); c.BorrowedDate = Convert.ToDateTime(dataGridView1.SelectedRows[0].Cells["borrowedDate"].Value.ToString()); } catch (Exception) { MessageBox.Show("You must select a book !"); return; } try { c.ReturnedDate = DateTime.ParseExact(textBox3.Text, "d/M/yyyy", null); } catch (Exception ex) { MessageBox.Show(ex.Message); return; } if (c.ReturnedDate.Date < c.BorrowedDate) { 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]); dataGridView1.DataSource = dv; label5.Text = "" + ds.Tables[0].Rows.Count; //MessageBox.Show("Return Successfully !"); } else { return; //MessageBox.Show("No clicked"); } }
private void button1_Click(object sender, EventArgs e) { ReturnDA b = new ReturnDA(); ReturnBL a = new ReturnBL(); int code = 0; try { code = int.Parse(textBox1.Text); } catch (Exception ex) { MessageBox.Show(ex.Message); return; } bool test = a.checkMember(code); if (!test) { MessageBox.Show("Don't have this member in Database"); return; } else { DataSet ds = b.SelectDS(code); DataView dv = new DataView(ds.Tables[0]); dataGridView1.DataSource = dv; label5.Text = "" + ds.Tables[0].Rows.Count; textBox2.Text = b.getName(code); textBox3.Enabled = true; textBox3.Text = DateTime.Now.ToString("dd/M/yyyy"); button3.Enabled = true; textBox1.Enabled = false; button1.Enabled = false; } }