示例#1
0
        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");
            }
        }