public bool CongtacAnNinhMoi(CongTacAnNinhDTO ct)
{
string sql = "sp_CongTacAnNinhMoi";
List <SqlParameter> ds = new List <SqlParameter>();
SqlParameter id = new SqlParameter("@id", SqlDbType.Int);
id.Value = ct.Id;
ds.Add(id);
SqlParameter lapdathtbt = new SqlParameter("@lapdathtbt", SqlDbType.NVarChar);
lapdathtbt.Value = ct.LapDatHTBT;
ds.Add(lapdathtbt);
SqlParameter hoatdonggiamsat = new SqlParameter("@hoatdonggiamsat", SqlDbType.NVarChar);
hoatdonggiamsat.Value = ct.HoatDongGiamSat;
ds.Add(hoatdonggiamsat);
SqlParameter cameraanninh = new SqlParameter("@cameraaninh", SqlDbType.NVarChar);
cameraanninh.Value = ct.CameraAnNinh;
ds.Add(cameraanninh);
SqlParameter hopdongBT = new SqlParameter("@hopdongbaotri", SqlDbType.NVarChar);
hopdongBT.Value = ct.HopDongBaoTri;
ds.Add(hopdongBT);
SqlParameter khoachim = new SqlParameter("@khoachim", SqlDbType.NVarChar);
khoachim.Value = ct.KhoaChim;
ds.Add(khoachim);
SqlParameter thietkekhoacuaso = new SqlParameter("@thietkekhoacuaso", SqlDbType.NVarChar);
thietkekhoacuaso.Value = ct.ThietKeKhoaCuaSo;
ds.Add(thietkekhoacuaso);
SqlParameter baove = new SqlParameter("@baove", SqlDbType.NVarChar);
baove.Value = ct.BaoVe;
ds.Add(baove);
SqlParameter nguonthuoctruc = new SqlParameter("@nguonthuongtruc", SqlDbType.NVarChar);
nguonthuoctruc.Value = ct.NguoiThuongTruc;
ds.Add(nguonthuoctruc);
bool kq = SqlDataAcessHelper.exNonStoreParas(sql, ds);
return(kq);
}
public bool CongtacAnNinhMoi(CongTacAnNinhDTO ct)
{
string sql= "sp_CongTacAnNinhMoi";
List<SqlParameter> ds= new List<SqlParameter>();
SqlParameter id = new SqlParameter("@id", SqlDbType.Int);
id.Value = ct.Id;
ds.Add(id);
SqlParameter lapdathtbt = new SqlParameter("@lapdathtbt", SqlDbType.NVarChar);
lapdathtbt.Value = ct.LapDatHTBT;
ds.Add(lapdathtbt);
SqlParameter hoatdonggiamsat = new SqlParameter("@hoatdonggiamsat", SqlDbType.NVarChar);
hoatdonggiamsat.Value = ct.HoatDongGiamSat;
ds.Add(hoatdonggiamsat);
SqlParameter cameraanninh = new SqlParameter("@cameraaninh",SqlDbType.NVarChar);
cameraanninh.Value = ct.CameraAnNinh;
ds.Add(cameraanninh);
SqlParameter hopdongBT = new SqlParameter("@hopdongbaotri", SqlDbType.NVarChar);
hopdongBT.Value = ct.HopDongBaoTri;
ds.Add(hopdongBT);
SqlParameter khoachim = new SqlParameter("@khoachim",SqlDbType.NVarChar);
khoachim.Value = ct.KhoaChim;
ds.Add(khoachim);
SqlParameter thietkekhoacuaso = new SqlParameter("@thietkekhoacuaso", SqlDbType.NVarChar);
thietkekhoacuaso.Value = ct.ThietKeKhoaCuaSo;
ds.Add(thietkekhoacuaso);
SqlParameter baove = new SqlParameter("@baove",SqlDbType.NVarChar);
baove.Value = ct.BaoVe;
ds.Add(baove);
SqlParameter nguonthuoctruc = new SqlParameter("@nguonthuongtruc",SqlDbType.NVarChar);
nguonthuoctruc.Value = ct.NguoiThuongTruc;
ds.Add(nguonthuoctruc);
bool kq = SqlDataAcessHelper.exNonStoreParas(sql, ds);
return kq;
}
