//Kiểm tra nếu có cthd đó rồi thì báo trùng
public bool KTTrung(ChiTietHopDong cthd)
{
SqlParameter parMahd = new SqlParameter("@mahd", SqlDbType.VarChar);
parMahd.Value = cthd.MaHopDong;
SqlParameter parCMND = new SqlParameter("@cm", SqlDbType.VarChar);
parCMND.Value = cthd.CMND;
bool kq = WriteData("select * from ChiTietHopDong where MaHopDong = @mahd and CMND = @cm", new[] { parMahd, parCMND });
return(kq);
}
//dùng để thêm cthd
public bool ThemCTHD(ChiTietHopDong cthd)
{
string sql = "insert into ChiTietHopDong values(@mahd,@cmnd)";
SqlParameter parMahd = new SqlParameter("@mahd", System.Data.SqlDbType.VarChar);
parMahd.Value = cthd.MaHopDong;
SqlParameter parCMND = new SqlParameter("@cmnd", System.Data.SqlDbType.VarChar);
parCMND.Value = cthd.CMND;
bool kq = WriteData(sql, new[] { parMahd, parCMND });
return(kq);
}
public bool SuaCTHD(ChiTietHopDong cthd)
{
string sql = "update ChiTietHopDong set MaHopDong = @mahd, CMND = @cmnd";
SqlParameter parMahd = new SqlParameter("@mahd", System.Data.SqlDbType.VarChar);
parMahd.Value = cthd.MaHopDong;
SqlParameter parCMND = new SqlParameter("@cmnd", System.Data.SqlDbType.VarChar);
parCMND.Value = cthd.CMND;
bool kq = WriteData(sql, new[] { parMahd, parCMND });
return(kq);
}
public ChiTietHopDong TimHopDongTheoMaHopDong(string mahd)
{
string sql = "select * from ChiTietHopDong where MaHopDong=@mahd";
ChiTietHopDong cthd = new ChiTietHopDong();
SqlParameter parMaHopDong = new SqlParameter("@mahd", SqlDbType.VarChar);
parMaHopDong.Value = mahd;
SqlDataReader reader = ReadDataPars(sql, new[] { parMaHopDong });
if (reader.Read())
{
cthd.CMND = reader.GetString(0);
}
return(cthd);
}
public ChiTietHopDong TimHopDongTheoCMND(string cmnd)
{
string sql = "select * from ChiTietHopDong where CMND=@cm";
ChiTietHopDong cthd = new ChiTietHopDong();
SqlParameter parCMND = new SqlParameter("@cm", SqlDbType.VarChar);
parCMND.Value = cmnd;
SqlDataReader reader = ReadDataPars(sql, new[] { parCMND });
if (reader.Read())
{
cthd.MaHopDong = reader.GetString(1);
}
return(cthd);
}
//kiểm tra hợp đồng có cthd hay không, không có mới cho xóa, nếu có thì phải xóa cthd trước
public bool KTcoCTHD(string mahd)
{
string sql = "select * from ChiTietHopDong where MaHopDong=@mahd";
ChiTietHopDong cthd = new ChiTietHopDong();
SqlParameter parMaHopDong = new SqlParameter("@mahd", SqlDbType.VarChar);
parMaHopDong.Value = mahd;
SqlDataReader reader = ReadDataPars(sql, new[] { parMaHopDong });
if (reader.Read())
{
reader.Close();
return(true);
}
reader.Close();
return(false);
}
public List <ChiTietHopDong> dsChiTietHopDong(string mahd)
{
SqlParameter parHD = new SqlParameter("@mahd", SqlDbType.VarChar);
parHD.Value = mahd;
SqlDataReader reader = ReadDataPars("select * from ChiTietHopDong where MaHopDong = @mahd", new[] { parHD });
List <ChiTietHopDong> dsCTHD = new List <ChiTietHopDong>();
while (reader.Read())
{
string cmnd = reader.GetString(0);
string mahopdong = reader.GetString(1);
ChiTietHopDong cthd = new ChiTietHopDong();
cthd.MaHopDong = mahopdong;
cthd.CMND = cmnd;
dsCTHD.Add(cthd);
}
reader.Close();
return(dsCTHD);
}
