public static bool InsertRoomBill(RoomBillDTO bill) { try { if (connection.State != ConnectionState.Open) { connection.Open(); } var command = new SqlCommand("ThemHoaDon", connection); command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(new SqlParameter("@TenKhach", bill.CustomerName)); command.Parameters.Add(new SqlParameter("@DiaChi", bill.CustomerAddress)); command.Parameters.Add(new SqlParameter("@NgayHoaDon", bill.BillDate)); command.Parameters.Add(new SqlParameter("@TriGia", bill.BillCost)); command.ExecuteNonQuery(); return(true); } catch { return(false); } finally { connection.Close(); } }
public RoomBillDTO GetBillPayer() { var bill = new RoomBillDTO(); bill.CustomerName = this.tbBillCustomerName.Text; bill.CustomerAddress = this.rtbBillCustomerAddress.Text; bill.BillDate = DateTime.ParseExact(this.deBillDate.Text, "d/M/yyyy", CultureInfo.InvariantCulture).ToString("M/d/yyyy"); return(bill); }
private void BtnCreate_Click(object sender, EventArgs e) { if (this.tbChange.Text[0] == '-') { MessageBox.Show( "Số tiền nhận chưa đủ tiền thanh toán", "THANH TOÁN HOÁ ĐƠN THẤT BẠI", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { var BillDate = DateTime.ParseExact(this.tbBillDate.Text, "d/M/yyyy", CultureInfo.InvariantCulture); var bill = new RoomBillDTO(); bill.BillDate = DateTime.ParseExact(this.tbBillDate.Text, "d/M/yyyy", CultureInfo.InvariantCulture).ToString("d"); bill.CustomerName = this.tbBillCustomer.Text; bill.CustomerAddress = this.tbBillAddress.Text; bill.BillCost = Convert.ToInt64(this.tbBillPrice.Text.Replace(",", "")); RoomBillBUS.InsertBill(bill); foreach (DataGridViewRow row in this.dgvBillData.Rows) { var roomID = row.Cells["PaidRoomID"].Value.ToString(); var price = Convert.ToInt64(row.Cells["PaidRoomTotalPrice"].Value.ToString().Replace(",", "")); RoomLeaseBUS.InsertRoomLeasePayment(roomID, price); } MainForm mainForm = (MainForm)Owner; mainForm.ReLoadRoomData(); mainForm.ReLoadAvailableRoom(); mainForm.ReCreateBill(); MessageBox.Show( "Thanh toán hoá đơn thành công", "THANH TOÁN HOÁ ĐƠN THÀNH CÔNG", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } }
public static bool InsertBill(RoomBillDTO bill) { return(RoomBillDAO.InsertRoomBill(bill)); }