示例#1
0
        public void Bills()
        {
            try
            {
                AllBilling b = new AllBilling();

                for (int i = 0; i < dataGridView1.Rows.Count - 1; i++)
                {
                    b.Name                 = dataGridView1.Rows[i].Cells[0].Value.ToString();
                    b.Type                 = dataGridView1.Rows[i].Cells[3].Value.ToString();
                    b.Price                = double.Parse(dataGridView1.Rows[i].Cells[1].Value.ToString());
                    b.Quantity             = int.Parse(dataGridView1.Rows[i].Cells[2].Value.ToString());
                    b.AddedDate            = DateTime.Now;
                    b.AddedBy              = LoggedInUser.UserName;
                    b.PatientInformationId = billId;
                    db.Bills.Add(b);
                    db.SaveChanges();
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("error\n" + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }