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); } } } }