private void btThemCTT_Click(object sender, EventArgs e)
{
string s = "false";
if (txtKiemTraGhiChu.Text == s.ToString())
{
MessageBox.Show("Phòng Đang Sửa , chưa sử dụng được!");
}
else
{
loadTinhTrangPhongThue();
string map, makh;
DateTime nt, ndk, ntr;
map = cbbMaP.Text.Trim();
makh = cbbMaKH.Text.Trim();
nt = Convert.ToDateTime(dtpNgayThue.Text);
ndk = Convert.ToDateTime(dtpNgayThue.Text);
ntr = Convert.ToDateTime(dtpNgayThue.Text);
DTOChiTietThue ctt = new DTOChiTietThue(map, makh, nt, ndk, ntr);
try
{
int i = new BUSChiTietThue().Add(ctt);
dgvChiTietThue.DataSource = GetCTT();
load();
loadChiTietGiaThem();
kiemtraghichu();
}
catch (SqlException ex)
{
MessageBox.Show("Bị Trùng!!" + ex.Message);
}
}
}
public List <DTOChiTietThue> GetCTT(string sql)
{
dp.connect();
List <DTOChiTietThue> list = new List <DTOChiTietThue>();
{
string map, makh;
DateTime nt, ndk, ntr;
try
{
SqlDataReader dr = dp.ExecuteReader(sql);
while (dr.Read())
{
map = dr.GetString(0);
makh = dr.GetString(1);
nt = dr.GetDateTime(2);
ndk = dr.GetDateTime(3);
ntr = dr.GetDateTime(4);
DTOChiTietThue ctt = new DTOChiTietThue(map, makh, nt, ndk, ntr);
list.Add(ctt);
}
dr.Close();
return(list);
}
catch (SqlException ex)
{
throw ex;
}
}
}
public int Add(DTOChiTietThue ctt)
{
List <SqlParameter> paras = new List <SqlParameter>();
paras.Add(new SqlParameter("@map", ctt.MaP));
paras.Add(new SqlParameter("@makh", ctt.MaKH));
paras.Add(new SqlParameter("@nt", ctt.NgayThue));
paras.Add(new SqlParameter("@ndk", ctt.NgayTraDuKien));
paras.Add(new SqlParameter("@ntr", ctt.NgayTra));
try
{
return(dp.ExcuteNonQuery("ThemCTT", System.Data.CommandType.StoredProcedure, paras));
}
catch (SqlException ex)
{
throw ex;
}
}
private void btThemCTT_Click(object sender, EventArgs e)
{
string map, makh;
DateTime nt, ndk, ntr;
map = cbbMaPhong.Text.Trim();
makh = cbbMaKH.Text.Trim();
nt = Convert.ToDateTime(dtpNgayThue.Text);
ndk = Convert.ToDateTime(dtpNgayThue.Text);
ntr = Convert.ToDateTime(dtpNgayThue.Text);
DTOChiTietThue ctt = new DTOChiTietThue(map, makh, nt, ndk, ntr);
try
{
int i = new BUSChiTietThue().Add(ctt);
dgvChiTietThue.DataSource = GetCTT();
load();
xoaCTT();
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message);
}
}
public int Add(DTOChiTietThue ctt)
{
return(new DAOChiTietThue().Add(ctt));
}
