public Boolean ThemGioHang(SanPhamHoaDon sphd) { try { return(sphdd.ThemGioHang(sphd)); } catch (Exception e) { MessageBox.Show(e.Message); } return(false); }
private void button2_Click(object sender, EventArgs e) { string masanpham = spDuocChon.MaSanPham; if (masanpham == null) { MessageBox.Show("Xin mời lựa chọn sản phẩm"); return; } int sl; try { sl = Int32.Parse(txtSoLuongMua.Text); } catch (Exception ex) { Console.WriteLine(ex.Message); txtSoLuongMua.Text = ""; return; } if (sl > spDuocChon.SoLuong) { MessageBox.Show("Số lượng trong kho không đủ"); txtSoLuongMua.Text = ""; return; } if (spb.CapNhatSoLuong(masanpham, sl)) { soHangTrongGio++; lblGioHang.Text = Convert.ToString(soHangTrongGio); lblSLCon.Text = (spDuocChon.SoLuong - sl).ToString(); SanPhamHoaDon sphd = new SanPhamHoaDon(); sphd.TenSanPham = spDuocChon.TenSanPham; sphd.DungTich = spDuocChon.DungTich; sphd.NongDo = spDuocChon.NongDo; sphd.SoLuongMua = Int32.Parse(txtSoLuongMua.Text); sphd.DonGia = spDuocChon.DonGia; sphdBUL.ThemGioHang(sphd); } //dgvListSanPham.DataSource = spb.LaySanPham(); txtSoLuongMua.Text = ""; }
public Boolean ThemGioHang(SanPhamHoaDon sphd) { OpenConn(); string sql = "insert into SanPhamHoaDon values(@tensanpham,@dungtich,@nongdo,@soluongmua,@dongia)"; SqlCommand sqlComm = new SqlCommand(sql, conn); sqlComm.Parameters.Add(new SqlParameter("@tensanpham", SqlDbType.NVarChar)).Value = sphd.TenSanPham; sqlComm.Parameters.Add(new SqlParameter("@dungtich", SqlDbType.Int)).Value = sphd.DungTich; sqlComm.Parameters.Add(new SqlParameter("@nongdo", SqlDbType.Int)).Value = sphd.NongDo; sqlComm.Parameters.Add(new SqlParameter("@soluongmua", SqlDbType.Int)).Value = sphd.SoLuongMua; sqlComm.Parameters.Add(new SqlParameter("@dongia", SqlDbType.Int)).Value = sphd.DonGia; int kq = sqlComm.ExecuteNonQuery(); CloseConn(); if (kq != 0) { return(true); } return(false); }
public List <SanPhamHoaDon> LayGioHang() { List <SanPhamHoaDon> list = new List <SanPhamHoaDon>(); OpenConn(); string sql = "select * from SanPhamHoaDon"; SqlCommand sqlComm = new SqlCommand(sql, conn); SqlDataReader sqlDr = sqlComm.ExecuteReader(); while (sqlDr.Read()) { SanPhamHoaDon sphd = new SanPhamHoaDon(); sphd.TenSanPham = sqlDr.GetString(0); sphd.DungTich = sqlDr.GetInt32(1); sphd.NongDo = sqlDr.GetInt32(2); sphd.SoLuongMua = sqlDr.GetInt32(3); sphd.DonGia = sqlDr.GetInt32(4); list.Add(sphd); } sqlDr.Close(); CloseConn(); return(list); }