public void Insert(LichSuBanSP ls) { try { dp.Connect(); string sql = "Insert Into LichSuBanSP Values(@MaSP,@NgayBan,@TenSP,@SoLuong,@DonGia,@TongTien)"; SqlCommand cmd = new SqlCommand(sql, dp.CN); cmd.Parameters.Add("@MaSP", ls.MaSP); cmd.Parameters.Add("@NgayBan", ls.NgayBan); cmd.Parameters.Add("@TenSP", ls.TenSP); cmd.Parameters.Add("@SoLuong", ls.SoLuong); cmd.Parameters.Add("@DonGia", ls.DonGia); cmd.Parameters.Add("@TongTien", ls.TongTien); dp.ExecuteQuery(cmd); } catch (SqlException ex) { throw ex; } finally { dp.Disconnect(); } }
private void btIn_Click(object sender, EventArgs e) { int i = 0; DateTime ngayDat = new TamBUS().GetDate(_maPhong); int songuoi = new TamBUS().GetSoNguoi(_maPhong); LichSuThuePhong ls = new LichSuThuePhong(_maPhong, LBCMND.Text, ngayDat, DateTime.Now, user, songuoi, Convert.ToDouble(tongtienphong), CapNhatTongDonGiaSP(), tongtien); new LichSuThuePhongBUS().Insert(ls); new TamBUS().Delete(_maPhong); frmTraTien frmtratien = new frmTraTien(tongtien); frmtratien.ShowDialog(); while (i < Convert.ToInt32(ListSP.Rows.Count)) { string masp = new SanPhamPhuThuBUS().getcode(ListSP.Rows[i].Cells[0].Value.ToString()); LichSuBanSP ls1 = new LichSuBanSP(masp, DateTime.Now, ListSP.Rows[i].Cells[0].Value.ToString(), Convert.ToInt32(ListSP.Rows[i].Cells[2].Value), Convert.ToDouble(ListSP.Rows[i].Cells[1].Value), Convert.ToDouble(ListSP.Rows[i].Cells[3].Value)); new LichSuBanSPBUS().Insert(ls1); i++; } // string masp = new SanPhamPhuThuBUS().getcode(SPPhuThu.SelectedItem.ToString()); // LichSuBanSP ls1 = new LichSuBanSP(masp,DateTime.Now,SPPhuThu.SelectedItem.ToString()) this.Close(); }
public void Insert(LichSuBanSP ls) { new LichSuBanSPDAO().Insert(ls); }