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);
}
