public void Insert(LichSuThuePhong ls) { try { dp.Connect(); string sql = "Insert Into LichSuThuePhong Values(@MaPhong,@CMND,@NgayDat,@NgayTra,@MaNV,@SoNguoi,@TienPhong,@PhuThu,@TongTien)"; SqlCommand cmd = new SqlCommand(sql, dp.CN); cmd.Parameters.Add("@MaPhong", ls.MaPhong); cmd.Parameters.Add("@CMND", ls.CMND); cmd.Parameters.Add("@NgayDat", ls.NgayDat); cmd.Parameters.Add("@NgayTra", ls.NgayTra); cmd.Parameters.Add("@MaNV", ls.MaNV); cmd.Parameters.Add("@SoNguoi", ls.SoNguoi); cmd.Parameters.Add("@TienPhong", ls.TienPhong); cmd.Parameters.Add("@PhuThu", ls.PhuThu); cmd.Parameters.Add("@TongTien", ls.TongTien); dp.ExecuteQuery(cmd); } catch (SqlException ex) { throw ex; } finally { dp.Disconnect(); } }
public List <LichSuThuePhong> LoadData() { try { dp.Connect(); string sql = "Select * From LichSuThuePhong"; SqlDataReader dr = dp.ExecuteReader(sql); List <LichSuThuePhong> list = new List <LichSuThuePhong>(); while (dr.Read()) { string maPhong = dr.GetValue(0).ToString(); string cmnd = dr.GetValue(1).ToString(); DateTime ngayDat = Convert.ToDateTime(dr.GetValue(2)); DateTime ngayTra = Convert.ToDateTime(dr.GetValue(3)); string maNV = dr.GetValue(4).ToString(); int soNguoi = Convert.ToInt16(dr.GetValue(5)); double tienPhong = Convert.ToDouble(dr.GetValue(6)); double phuThu = Convert.ToDouble(dr.GetValue(7)); double tongTien = Convert.ToDouble(dr.GetValue(8)); LichSuThuePhong ls = new LichSuThuePhong(maPhong, cmnd, ngayDat, ngayTra, maNV, soNguoi, tienPhong, phuThu, tongTien); list.Add(ls); } dr.Close(); return(list); } 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(LichSuThuePhong ls) { new LichSuThuePhongDAO().Insert(ls); }