private void btnSave_Click(object sender, EventArgs e) { Double bill_total = 0; try { if (ValidateChildren(ValidationConstraints.Enabled)) { int ret = app.ReferAppointment(patient_id, Int32.Parse(cmbDoctor.SelectedValue.ToString()), Convert.ToDateTime(dtpDate.Text), Int32.Parse(Utils.ProcedureStatus["Scheduled"]), doctor_id, appointment_id); if (ret >= 1) { DataTable dtBill = bill.GetAppointmentBill(appointment_id, patient_id, 3); if (dtBill.Rows.Count == 0) { ConsultationDetails objCD = new ConsultationDetails(); DataTable dtProc = bill.getBillDetails(appointment_id); if (dtProc == null || dtProc.Rows.Count <= 0) //no recs in billing details { Patients pat = new Patients(); DataTable dtPat = pat.getDetailedPatientRecordFromID(patient_id, appointment_id); dtProc = objCD.getProceduresInvoiceFromApptID(appointment_id); bill_total += Convert.ToDouble(dtPat.Rows[0]["doctor_fee"].ToString()); } foreach (DataRow row in dtProc.Rows) { bill_total += Convert.ToDouble(row["fee"].ToString()); } int bill_id = bill.AddBill(appointment_id, patient_id, Convert.ToDecimal(bill_total), 3, LoggedUser.id); } MessageBox.Show("Appointment scheduled successfully!"); } else if (ret == 0) { MessageBox.Show("Appointment already scheduled!"); } else { MessageBox.Show("Error in scheduling appointment!"); } } } catch (Exception ex) { CommonLogger.Info(ex.ToString()); } }
private void btnSave_Click(object sender, EventArgs e) { btnPay.Enabled = true; btnChangeTable.Enabled = true; bool status = false; double totalPrice = Convert.ToDouble(txtToTal.Text); int sale = Convert.ToInt32(cbxSale.SelectedItem); List <Bill> bills = Bill.GetAllBill(tableid); if (!btnAddFood.Enabled) { ArrayList arrayList = new ArrayList() { DateTime.Now, tableid, status, totalPrice, lblStaff.Text, sale }; Bill.AddBill(arrayList); } int billId = Bill.GetAllBill(tableid)[0].Id; if (Bill.GetAllBill(tableid).Count > 0) { BillInfor.DeleteBillInfor(billId); } for (int i = 0; i < dgvOrder.Rows.Count; i++) { ArrayList billInfor = new ArrayList() { billId, foodId[i], dgvOrder.Rows[i].Cells["Số Lượng"].Value, dgvOrder.Rows[i].Cells["Thành Tiền"].Value }; BillInfor.AddBill(billInfor); } ArrayList tableList = new ArrayList() { "Có Người", tableid }; Table.UpdateTableStatus(tableList); LoadTable(); dgvOrder.DataSource = MenuDAL.GetMenuByTableId(tableid); refreshDgvOrder(); }
private void frmOneTimeBill_Load(object sender, EventArgs e) { try { dgvInv.AutoGenerateColumns = false; DataTable dtOpt = opt.GetOptionFromName("CLINIC_NAME"); if (dtOpt.Rows.Count > 0) { lblClinic.Text = dtOpt.Rows[0]["op_value"].ToString(); } bill_total = 0; int k = 1; //displaying data to grid view dgvInv.ColumnHeadersBorderStyle = DataGridViewHeaderBorderStyle.None; //if this appointment has bill details then get records from details table //else for initial loading take from appt procedures dtProc = bill.getBillDetails(appointment_id); if (dtProc == null || dtProc.Rows.Count <= 0) //no recs in billing details { dtProc = objCD.getProceduresInvoiceFromApptID(appointment_id); bill_total += Convert.ToDouble(dtPat.Rows[0]["doctor_fee"].ToString()); k = 2; dgvInv.Rows.Add(new object[] { "1", "Consultation Fees and Charges", Utils.FormatAmount(Convert.ToDouble(dtPat.Rows[0]["doctor_fee"].ToString())) }); } foreach (DataRow row in dtProc.Rows) { dgvInv.Rows.Add(new object[] { k, row["name"].ToString(), Utils.FormatAmount(Convert.ToDouble(row["fee"].ToString())) }); bill_total += Convert.ToDouble(row["fee"].ToString()); k++; } txtTotal.Text = Utils.FormatAmount(bill_total); if (bill_id == 0) { dtBill = bill.GetAppointmentBill(appointment_id, patient_id, 3); if (dtBill.Rows.Count == 0) { if (!(LoggedUser.id > 0)) { LoggedUser.id = 1; } bill_id = bill.AddBill(appointment_id, patient_id, Convert.ToDecimal(bill_total), 3, LoggedUser.id); if (bill_id > 0) { dtBill = bill.GetBill(bill_id); } else { MessageBox.Show("Error in Creating Bill"); } } else { bill_id = Int32.Parse(dtBill.Rows[0]["id"].ToString()); } } if (bill_id > 0) { txtInvNum.Text = dtBill.Rows[0]["bill_number"].ToString(); txtDate.Text = Convert.ToDateTime(dtPat.Rows[0]["meet_date"].ToString()).ToShortDateString(); bill_total = Convert.ToDouble(dtBill.Rows[0]["bill_amount"].ToString()); bill_paid = Convert.ToDouble(dtBill.Rows[0]["bill_paid"].ToString()); bill_paid_load = bill_paid; txtPaid.Text = Utils.FormatAmount(bill_paid); bill_balance = Convert.ToDouble(dtBill.Rows[0]["bill_balance"].ToString()); txtBalance.Text = Utils.FormatAmount(bill_balance); lblTime.Text = dtBill.Rows[0]["bill_date"].ToString(); int creator = Int32.Parse(dtBill.Rows[0]["bill_created_userid"].ToString()); //txtPrevDues.Text = dtBill.Rows[0]["bill_due"].ToString(); if (dtBill.Rows[0]["bill_due"].ToString() != "") { txtPrevDues.Text = Utils.FormatAmount(Convert.ToDouble(dtBill.Rows[0]["bill_due"].ToString())); txtTotal.Text = Utils.FormatAmount(bill_total + Convert.ToDouble(txtPrevDues.Text)); } else { txtPrevDues.Text = "0.000"; txtTotal.Text = Utils.FormatAmount(bill_total); } DataTable dtUser = bill.GetBillCreatedUser(creator); if (dtUser != null) { txtLoggedUser.Text = dtUser.Rows[0]["staff_name"].ToString(); } cmbBillStatus.SelectedValue = dtBill.Rows[0]["bill_status"].ToString(); bill_status = Int32.Parse(dtBill.Rows[0]["bill_status"].ToString()); } editBillDetails(); } catch (Exception ex) { CommonLogger.Info(ex.ToString()); } }
private void frmProceduresBill_Load(object sender, EventArgs e) { try { dgvInv.AutoGenerateColumns = false; DataTable dtOpt = opt.GetOptionFromName("CLINIC_NAME"); if (dtOpt.Rows.Count > 0) { lblClinic.Text = dtOpt.Rows[0]["op_value"].ToString(); } //displaying data to grid view dgvInv.ColumnHeadersBorderStyle = DataGridViewHeaderBorderStyle.None; dtProc = objCD.getProceduresInvoiceFromApptID(appointment_id); int k = 1; foreach (DataRow row in dtProc.Rows) { dgvInv.Rows.Add(new object[] { k, row["name"].ToString(), row["fee"].ToString() }); bill_total += Convert.ToDouble(row["fee"].ToString()); k++; } txtTotal.Text = Utils.FormatAmount(bill_total); if (bill_id == 0) { dtBill = bill.GetAppointmentBill(appointment_id, patient_id, 2); if (dtBill.Rows.Count == 0) { if (!(LoggedUser.id > 0)) { LoggedUser.id = 1; } //sj bill_id = bill.AddBill(appointment_id, patient_id, Convert.ToDecimal(dtPat.Rows[0]["doctor_fee"].ToString()), 1, LoggedUser.id); bill_id = bill.AddBill(appointment_id, patient_id, Convert.ToDecimal(bill_total), 2, LoggedUser.id); if (bill_id > 0) { dtBill = bill.GetBill(bill_id); } else { MessageBox.Show("Error in Creating Bill"); } } else { bill_id = Int32.Parse(dtBill.Rows[0]["id"].ToString()); } } if (bill_id > 0) { txtInvNum.Text = dtBill.Rows[0]["bill_number"].ToString(); txtDate.Text = Convert.ToDateTime(dtPat.Rows[0]["meet_date"].ToString()).ToShortDateString(); bill_total = Convert.ToDouble(dtBill.Rows[0]["bill_amount"].ToString()); bill_paid = Convert.ToDouble(dtBill.Rows[0]["bill_paid"].ToString()); txtPaid.Text = Utils.FormatAmount(bill_paid); bill_balance = Convert.ToDouble(dtBill.Rows[0]["bill_balance"].ToString()); txtBalance.Text = Utils.FormatAmount(bill_balance); lblTime.Text = dtBill.Rows[0]["bill_date"].ToString(); int creator = Int32.Parse(dtBill.Rows[0]["bill_created_userid"].ToString()); txtPrevDues.Text = dtPat.Rows[0]["dues"].ToString(); txtTotal.Text = Utils.FormatAmount(bill_total + Convert.ToDouble(txtPrevDues.Text)); DataTable dtUser = bill.GetBillCreatedUser(creator); if (dtUser != null) { txtLoggedUser.Text = dtUser.Rows[0]["staff_name"].ToString(); } cmbBillStatus.SelectedValue = dtBill.Rows[0]["bill_status"].ToString(); if (dtBill.Rows[0]["bill_status"].ToString() == "4") { txtPaid.ReadOnly = true; dgvInv.ReadOnly = true; btnSave.Enabled = false; } } } catch (Exception ex) { CommonLogger.Info(ex.ToString()); } }
private void frmConsultationBill_Load(object sender, EventArgs e) { try { dgvInv.ColumnHeadersBorderStyle = DataGridViewHeaderBorderStyle.None; dgvInv.AutoGenerateColumns = false; DataTable dtOpt = opt.GetOptionFromName("CLINIC_NAME"); if (dtOpt.Rows.Count > 0) { lblClinic.Text = dtOpt.Rows[0]["op_value"].ToString(); } if (bill_id == 0) { dtBill = bill.GetAppointmentBill(appointment_id, patient_id, 1); if (dtBill.Rows.Count == 0) { bill_id = bill.AddBill(appointment_id, patient_id, Convert.ToDecimal(dtPat.Rows[0]["doctor_fee"].ToString()), 1, LoggedUser.id); if (bill_id > 0) { dtBill = bill.GetBill(bill_id); } else { MessageBox.Show("Error in Creating Bill"); } } else { bill_id = Int32.Parse(dtBill.Rows[0]["id"].ToString()); } } if (bill_id > 0) { txtInvNum.Text = dtBill.Rows[0]["bill_number"].ToString(); txtDate.Text = Convert.ToDateTime(dtPat.Rows[0]["meet_date"].ToString()).ToShortDateString(); bill_total = Convert.ToDouble(dtBill.Rows[0]["bill_amount"].ToString()); dgvInv.Rows.Add(new object[] { "1", "Consultation Fees and Charges", Utils.FormatAmount(bill_total) }); txtTotal.Text = Utils.FormatAmount(bill_total); bill_paid = Convert.ToDouble(dtBill.Rows[0]["bill_paid"].ToString()); txtPaid.Text = Utils.FormatAmount(bill_paid); bill_balance = Convert.ToDouble(dtBill.Rows[0]["bill_balance"].ToString()); txtBalance.Text = Utils.FormatAmount(bill_balance); lblTime.Text = dtBill.Rows[0]["bill_date"].ToString(); int creator = Int32.Parse(dtBill.Rows[0]["bill_created_userid"].ToString()); DataTable dtUser = bill.GetBillCreatedUser(creator); txtLoggedUser.Text = dtUser.Rows[0]["staff_name"].ToString(); cmbBillStatus.SelectedValue = dtBill.Rows[0]["bill_status"].ToString(); if (dtBill.Rows[0]["bill_status"].ToString() == "4") { txtPaid.ReadOnly = true; dgvInv.ReadOnly = true; btnSave.Enabled = false; } } } catch (Exception ex) { CommonLogger.Info(ex.ToString()); } }
private void FormFoodChoices_Load(object sender, EventArgs e) { #region Dymamic Menu TabControl tab = new TabControl(); var listCategory = Category.GetListCategory(); tab.Location = new Point(10, 65); tab.Size = new Size(555, 445); tab.Font = new Font("UTM Bebas", 12, FontStyle.Regular); for (int i = 0; i < listCategory.Count; i++) { TabPage tp = new TabPage(listCategory[i].Name); tp.Location = new Point(10, 58); tp.BackColor = Color.Transparent; var listFood = Food.GetFoodByCategory(listCategory[i].ID); FlowLayoutPanel fl = new FlowLayoutPanel(); fl.Location = new Point(0, 0); fl.BackColor = Color.Transparent; fl.AutoScroll = true; fl.Dock = DockStyle.Fill; for (int j = 0; j < listFood.Count; j++) { Panel pn = new Panel(); pn.Size = new Size(170, 250); pn.BackColor = Color.DarkGray; PictureBox pc = new PictureBox(); pc.Location = new Point(20, 10); pc.Size = new Size(130, 120); // if (listFood[j].Image == null) pc.Image = Image.FromFile(@"C:\Users\Admin\Desktop\Food\bia-tiger-lon-01.jpg"); //else pc.Image = Image.FromFile(listFood[j].Image); pc.SizeMode = PictureBoxSizeMode.StretchImage; Label name = new Label(); Label lbGia = new Label(); Label VND = new Label(); Label sl = new Label(); NumericUpDown numeric = new NumericUpDown(); Button btnChon = new Button(); Button btnBoChon = new Button(); btnChon.Text = "Chọn"; btnBoChon.Text = "Bỏ Chọn"; btnChon.Font = new Font("UTM Bebas", 10, FontStyle.Regular); btnBoChon.Font = new Font("UTM Bebas", 10, FontStyle.Regular); btnChon.Tag = listFood[j].ID; btnBoChon.Tag = listFood[j].ID; btnChon.Click += new EventHandler(this.chon_Click); btnBoChon.Click += new EventHandler(this.bochon_Click); btnBoChon.Size = new Size(55, 30); btnChon.Size = new Size(55, 30); btnChon.Location = new Point(30, pn.Height - 5 - btnChon.Height); btnBoChon.Location = new Point(30 + btnChon.Width, pn.Height - 5 - btnBoChon.Height); btnBoChon.BackColor = Color.Transparent; btnChon.BackColor = Color.Transparent; sl.Text = "Số Lượng"; sl.Location = new Point(btnChon.Location.X, btnChon.Location.Y - 25); sl.Size = new Size(60, 30); numeric.Value = 0; numeric.Name = "SL"; numeric.Font = new Font("UTM Bebas", 10, FontStyle.Regular); numeric.Size = new Size(50, 25); numeric.Location = new Point(sl.Location.X + sl.Width, sl.Location.Y); pn.Controls.Add(btnBoChon); pn.Controls.Add(btnChon); pn.Controls.Add(sl); pn.Controls.Add(numeric); lbGia.Text = String.Format("{0:n0}", listFood[j].Price); lbGia.Location = new Point(sl.Location.X, sl.Location.Y - sl.Height); pn.Controls.Add(lbGia); VND.Text = "VND"; VND.Location = new Point(numeric.Location.X + numeric.Width - 30, sl.Location.Y - sl.Height); pn.Controls.Add(pc); pn.Controls.Add(VND); VND.BringToFront(); name.Text = listFood[j].Name; name.Size = new Size(120, 20); name.Font = new Font("UTM Bebas", 10, FontStyle.Regular); name.Location = new Point(lbGia.Location.X, lbGia.Location.Y - lbGia.Height); name.TextAlign = ContentAlignment.MiddleCenter; pn.Controls.Add(name); fl.Controls.Add(pn); } tab.TabPages.Add(tp); tp.Controls.Add(fl); } this.Controls.Add(tab); tab.BringToFront(); #endregion ID_Bill = Bill.AddBill(EmployeeID); dataGridView1.ReadOnly = true; dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; dataGridView1.AllowUserToAddRows = false; dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect; dataGridView1.BackgroundColor = Color.White; dataGridView1.RowHeadersVisible = false; dataGridView1.DefaultCellStyle.Font = new Font("UTM", 10, FontStyle.Regular); }