private void btn_submit_Click(object sender, EventArgs e)
{
if (int.Parse(this.lb_cus_cash.Text.ToString().Replace(",", "").Trim()) >= int.Parse(this.lb_total_price.Text.ToString().Replace(",", "").Trim()))
{
try
{
bool success = false;
DTO_Bill bill = new DTO_Bill(this.billID, this.currentUserLogin.MaNV, DateTime.Now, int.Parse(this.lb_total_price.Text.ToString().Replace(",", "").Trim()));
success = new BUS_Bill().insertBill(bill);
foreach (DataRow row in this.tableProduct.Rows)
{
DTO_BillDetail billDetail = new DTO_BillDetail(this.billID, row["MSMH"].ToString(), int.Parse(row["SOLUONG"].ToString()), int.Parse(row["THANHTIEN"].ToString()));
new BUS_BillDetail().insertBillDetail(billDetail);
}
DTO_Money.Sales = DTO_Money.Sales + int.Parse(this.lb_total_price.Text.ToString().Replace(",", "").Trim());
new frm_InHoaDon(this.billID).ShowDialog();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
else
{
MessageBox.Show("Nhận thiếu tiền", "Không thể thanh toán", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public DTO_Bill GetIdBill()
{
DTO_Bill dt = new DTO_Bill();
dt = db.GetIdBill();
return(dt);
}
public void dropItem(DTO_Bill info)
{
string[] value =
{
info.Id.ToString()
};
dataBill.Delete(value);
}
public DataTable GetBill(string id)
{
DataTable dt = new DataTable();
DTO_Bill k = new DTO_Bill();
sqlCm.Connection = connectionBill.OpenConnection();
sqlCm.CommandText = "SELECT * FROM PAYMENT WHERE maHD='" + id + "'";
sqlCm.CommandType = CommandType.Text;
SqlDataAdapter adapter = new SqlDataAdapter(sqlCm);
adapter.Fill(dt);
connectionBill.CloseConnection();
return(dt);
}
public void Insert(DTO_Bill ex)
{
sqlCm.Connection = connectionBill.OpenConnection();
sqlCm.CommandText = "INSERTDATABILL";
sqlCm.CommandType = CommandType.StoredProcedure;
sqlCm.Parameters.AddWithValue("@NVLap", ex.NVLap);
sqlCm.Parameters.AddWithValue("@thongTinKH", ex.ThongTinKH);
sqlCm.Parameters.AddWithValue("@ngayLap", ex.NgayLap);
sqlCm.Parameters.AddWithValue("@tongTien", ex.TongTien);
sqlCm.Parameters.AddWithValue("@daThanhToan", ex.DaThanhToan);
sqlCm.Parameters.AddWithValue("@soTienTra", ex.SoTienTra);
sqlCm.Parameters.AddWithValue("@soTienThua", ex.SoTienThua);
sqlCm.ExecuteNonQuery();
sqlCm.Parameters.Clear();
}
public bool insertBill(DTO_Bill bill)
{
bool success = false;
String query = "INSERT INTO HOADON VALUES(@billID, @userID, @dateCreated, @totalPrice)";
SqlCommand command = new SqlCommand(query, DAL_CDBConnect.myconn);
command.Parameters.Add("@billID", SqlDbType.VarChar).Value = bill.BillID;
command.Parameters.Add("@userID", SqlDbType.VarChar).Value = bill.UserID;
command.Parameters.Add("@dateCreated", SqlDbType.VarChar).Value = bill.DateCreated;
command.Parameters.Add("@totalPrice", SqlDbType.VarChar).Value = bill.TotalPrice;
success = command.ExecuteNonQuery() >= 0;
command.Dispose();
return(success);
}
private void btnPayment_Click(object sender, EventArgs e)
{
// thêm hóa đơn
bilDTO.NVLap = Convert.ToInt32(cmbAddbyStaff.SelectedValue);
cusDTO = blCus.GetIdCus(txtNameCustomer.Text);
bilDTO.ThongTinKH = cusDTO.MaKH;
bilDTO.NgayLap = DateTime.Now;
bilDTO.TongTien = Convert.ToDecimal(txtTotalBill.Text);
bilDTO.DaThanhToan = true;
decimal val;
bool result = decimal.TryParse(txtPayAmout.Text, out val);
if (!result)
{
return;
}
bilDTO.SoTienTra = Convert.ToDecimal(val);
bilDTO.SoTienThua = Convert.ToDecimal(txtReturnPay.Text);
Bldtb.InsertBill(bilDTO);
// thêm chi tiết hóa đơn
try
{
for (int i = 0; i < Bill.Rows.Count; i++)
{
masp = blProd.GetIDProductBill(Convert.ToString(Bill.Rows[i][0].ToString()));
billDTO.MaSP = masp;
billDTO.SoLuong = Convert.ToInt32(Bill.Rows[i][1].ToString());
billDTO.GiaBan = decimal.Parse(Bill.Rows[i][2].ToString());
billDTO.ThanhTien = decimal.Parse(Bill.Rows[i][3].ToString());
billDTO.KhuyenMai = int.Parse(txtSaleProduct.Text);
bilDTO = Bldtb.GetIdBill();
billDTO.MaHD = bilDTO.MaHD;
blProd.DecreaseProd(billDTO.MaSP, billDTO.SoLuong);
bldldt.InsertBillDetail(billDTO);
}
MessageBox.Show("Thanh toán thành công");
ReportB rp = new ReportB(Convert.ToString(billDTO.MaHD));
rp.Show();
clearform();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnDrop_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Bạn có chắc là muốn xóa hóa đơn này không?", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == System.Windows.Forms.DialogResult.Yes)
{
foreach (DataGridViewRow row in dataGridView.SelectedRows)
{
this.index = row.Index;
}
if (this.index >= 0)
{
int id = Convert.ToInt32(dataGridView.Rows[this.index].Cells["colId"].Value);
DTO_Bill info = new DTO_Bill();
info.Id = id;
bus.dropItem(info);
GUI_Bill_Load(sender, e);
}
}
}
public DTO_Bill GetIdBill()
{
DataTable dataTable = new DataTable();
DTO_Bill k = new DTO_Bill();
sqlCm.Connection = connectionBill.OpenConnection();
sqlCm.CommandText = "SELECT MAX(maHD) as maHD FROM HOADON";
sqlCm.CommandType = CommandType.Text;
SqlDataAdapter adapter = new SqlDataAdapter(sqlCm);
adapter.Fill(dataTable);
if (dataTable.Rows.Count > 0)
{
k.MaHD = int.Parse(dataTable.Rows[0]["maHD"].ToString());
}
connectionBill.CloseConnection();
return(k);
}
public void InsertBill(DTO_Bill bil)
{
db.Insert(bil);
}
public bool insertBill(DTO_Bill bill)
{
return(new DAL_Bill().insertBill(bill));
}
