public void Xoa_Int(DaiLyInternet_InFo Int)
{
SqlCommand cmd = new SqlCommand("Delete DaiLyInternet where MaDaiLyInt = @maInt");
cmd.Parameters.Add("@maInt", SqlDbType.Int).Value = Int.MaDaiLyInt;
ds.Load(cmd);
}
//
public void Them_Int(DaiLyInternet_InFo Int)
{
SqlCommand cmd = new SqlCommand("insert into DaiLyInternet (MaDaiLyInt, TenChuDaiLy, MaXa, DiaChi, SoHieuDaiLy, MaDoanhNghiep) "
+ " values (@maInt, @tendailyInt, @xaInt, @diachiInt, @sohieu, @doanhnghiepInt)");
cmd.Parameters.Add("@maInt", SqlDbType.Int).Value = Int.MaDaiLyInt;
cmd.Parameters.Add("@tendailyInt", SqlDbType.NVarChar, 255).Value = Int.TenDaiLyInt;
cmd.Parameters.Add("@diachiInt", SqlDbType.NVarChar, 50).Value = Int.DiaChiInt;
cmd.Parameters.Add("@sohieu", SqlDbType.VarChar, 5).Value = Int.SoHieu;
//cmd.Parameters.Add("@huyenInt", SqlDbType.Int).Value = Int.huyenInt.MaHuyen;
cmd.Parameters.Add("@xaInt", SqlDbType.Int).Value = Int.xaInt.MaXa;
cmd.Parameters.Add("@doanhnghiepInt", SqlDbType.Int).Value = Int.doanhnghiepInt.MaDoanhNghiep;
ds.Load(cmd);
}
public void Sua_Int(DaiLyInternet_InFo Int)
{
SqlCommand cmd = new SqlCommand("update DaiLyInternet set TenChuDaiLy = @tendailyInt, DiaChi = @diachiInt, SoHieuDaiLy=@sohieu "
+ " MaXa = @xaInt, MaDoanhNghiep = @doanhnghiepInt where MaDaiLyInt = @maInt");
cmd.Parameters.Add("@maInt", SqlDbType.Int).Value = Int.MaDaiLyInt;
cmd.Parameters.Add("@tendailyInt", SqlDbType.NVarChar, 255).Value = Int.TenDaiLyInt;
cmd.Parameters.Add("@diachiInt", SqlDbType.NVarChar, 50).Value = Int.DiaChiInt;
cmd.Parameters.Add("@sohieu", SqlDbType.VarChar, 5).Value = Int.SoHieu;
//cmd.Parameters.Add("@huyenInt", SqlDbType.Int).Value = Int.huyenInt.MaHuyen;
cmd.Parameters.Add("@xaInt", SqlDbType.Int).Value = Int.xaInt.MaXa;
cmd.Parameters.Add("@doanhnghiepInt", SqlDbType.Int).Value = Int.doanhnghiepInt.MaDoanhNghiep;
ds.Load(cmd);
}
public void Sua_Int(DaiLyInternet_InFo Int)
{
data.Sua_Int(Int);
}
public void Them_Int(DaiLyInternet_InFo Int)
{
data.Them_Int(Int);
}
public void Xoa_Int(DaiLyInternet_InFo Int)
{
data.Xoa_Int(Int);
}