public NV_QuyTrinhDinhNghia_ChiTiet GetByLoaiActive(int id)
{
using (SqlConnection myConnection = new SqlConnection(ConnectionString))
{
using (SqlCommand myCommand = new SqlCommand("NV_QuyTrinhDinhNghia_getByLoaiActive", myConnection))
{
myCommand.CommandType = CommandType.StoredProcedure;
SqlParameter pID = new SqlParameter("@LoaiQuyTrinh", SqlDbType.Int);
pID.Value = id;
myCommand.Parameters.Add(pID);
DataTable dt;
NV_QuyTrinhDinhNghia_ChiTiet model = new NV_QuyTrinhDinhNghia_ChiTiet();
myConnection.Open();
using (SqlDataAdapter mData = new SqlDataAdapter(myCommand))
{
dt = new DataTable();
mData.Fill(dt);
}
if (dt != null && dt.Rows.Count > 0)
{
model = new NV_QuyTrinhDinhNghia_ChiTiet(dt.Rows[0]);
}
return(model);
}
}
}
public bool update(NV_QuyTrinhDinhNghia_ChiTiet model)
{
using (SqlConnection myConnection = new SqlConnection(ConnectionString))
{
using (SqlCommand myCommand = new SqlCommand("NV_QuyTrinhDinhNghia_update", myConnection))
{
myCommand.CommandType = CommandType.StoredProcedure;
SqlParameter pID = new SqlParameter("@ID", SqlDbType.Int);
pID.Value = model.ID;
myCommand.Parameters.Add(pID);
SqlParameter pTen = new SqlParameter("@Ten", SqlDbType.NVarChar, 1000);
pTen.Value = model.Ten;
myCommand.Parameters.Add(pTen);
SqlParameter pLoaiQuyTrinh = new SqlParameter("@LoaiQuyTrinh", SqlDbType.Int);
pLoaiQuyTrinh.Value = model.LoaiQuyTrinh;
myCommand.Parameters.Add(pLoaiQuyTrinh);
SqlParameter pTrangThai = new SqlParameter("@TrangThai", SqlDbType.Bit);
pTrangThai.Value = model.TrangThai;
myCommand.Parameters.Add(pTrangThai);
SqlParameter pNgayHieuLuc = new SqlParameter("@NgayHieuLuc", SqlDbType.DateTime);
pNgayHieuLuc.Value = model.NgayHieuLuc;
myCommand.Parameters.Add(pNgayHieuLuc);
SqlParameter pNgayTao = new SqlParameter("@NgayTao", SqlDbType.DateTime);
pNgayTao.Value = model.NgayTao;
myCommand.Parameters.Add(pNgayTao);
SqlParameter pNguoiTao = new SqlParameter("@NguoiTao", SqlDbType.Int);
pNguoiTao.Value = model.NguoiTao;
myCommand.Parameters.Add(pNguoiTao);
SqlParameter pChuanBi = new SqlParameter("@ChuanBi", SqlDbType.NVarChar, 4000);
pChuanBi.Value = model.ChuanBi;
myCommand.Parameters.Add(pChuanBi);
SqlParameter pCachThuc = new SqlParameter("@CachThuc", SqlDbType.NVarChar, 200);
pCachThuc.Value = model.CachThuc;
myCommand.Parameters.Add(pCachThuc);
SqlParameter pThoiHan = new SqlParameter("@ThoiHan", SqlDbType.NVarChar, 200);
pThoiHan.Value = model.ThoiHan;
myCommand.Parameters.Add(pThoiHan);
SqlParameter pDoiTuong = new SqlParameter("@DoiTuong", SqlDbType.NVarChar, 200);
pDoiTuong.Value = model.DoiTuong;
myCommand.Parameters.Add(pDoiTuong);
SqlParameter pCoQuan = new SqlParameter("@CoQuan", SqlDbType.Int);
pCoQuan.Value = model.CoQuanID;
myCommand.Parameters.Add(pCoQuan);
SqlParameter pKetQua = new SqlParameter("@KetQua", SqlDbType.NVarChar, 200);
pKetQua.Value = model.KetQua;
myCommand.Parameters.Add(pKetQua);
SqlParameter pYeuCau = new SqlParameter("@YeuCau", SqlDbType.NText);
pYeuCau.Value = model.YeuCau;
myCommand.Parameters.Add(pYeuCau);
SqlParameter pLePhi = new SqlParameter("@LePhi", SqlDbType.NVarChar, 200);
pLePhi.Value = model.LePhi;
myCommand.Parameters.Add(pLePhi);
SqlParameter pMauDon = new SqlParameter("@MauDon", SqlDbType.NText);
pMauDon.Value = model.MauDon;
myCommand.Parameters.Add(pMauDon);
SqlParameter pPhapLy = new SqlParameter("@PhapLy", SqlDbType.NText);
pPhapLy.Value = model.PhapLy;
myCommand.Parameters.Add(pPhapLy);
SqlParameter pTrinhTu = new SqlParameter("@TrinhTu", SqlDbType.NText);
pTrinhTu.Value = model.TrinhTu;
myCommand.Parameters.Add(pTrinhTu);
try
{
myConnection.Open();
myCommand.ExecuteNonQuery();
return(true);
}
catch
{
return(false);
}
}
}
}
