public errorCompositeType UpdateTaskGroup(int iIdTaskGroup, int iIdArea, int iIdGroup) { errorCompositeType lstError = new errorCompositeType(); try { param = new SqlParameter[3]; param[0] = new SqlParameter("@fiid_task_group", SqlDbType.Int); param[0].Value = iIdTaskGroup; param[1] = new SqlParameter("@fiid_task", SqlDbType.Int); param[1].Value = iIdArea; param[2] = new SqlParameter("@fiid_group", SqlDbType.Int); param[2].Value = iIdGroup; objDB.ExecStore("sp_updateTaskGroup", param); lstError.bError = true; return(lstError); } catch (Exception ex) { lstError.bError = false; lstError.sError = ex.Message; return(lstError); } }
public errorCompositeType UpdateArea(int iIdArea, String sDescription, int iNumber, int iResponsable) { var lstError = new errorCompositeType(); try { param = new SqlParameter[4]; param[0] = new SqlParameter("@fiid_area", SqlDbType.Int) { Value = iIdArea }; param[1] = new SqlParameter("@fvdescription_area", SqlDbType.VarChar) { Value = sDescription }; param[2] = new SqlParameter("@finumber_area", SqlDbType.Int) { Value = iNumber }; param[3] = new SqlParameter("@fiManager", SqlDbType.Int) { Value = iResponsable }; objDB.ExecStore("sp_updateArea", param); lstError.bError = true; return(lstError); } catch (Exception ex) { lstError.bError = false; lstError.sError = ex.Message; return(lstError); } }
public errorCompositeType UpdateReason(int iIdReason, int iNumber, String sDescription) { errorCompositeType lstError = new errorCompositeType(); try { param = new SqlParameter[3]; param[0] = new SqlParameter("@fiid_reason", SqlDbType.Int); param[0].Value = iIdReason; param[1] = new SqlParameter("@finumber_reason", SqlDbType.Int); param[1].Value = iNumber; param[2] = new SqlParameter("@fvdescription_reason", SqlDbType.VarChar); param[2].Value = sDescription; objDB.ExecStore("sp_updateReason", param); lstError.bError = true; return(lstError); } catch (Exception ex) { lstError.bError = false; lstError.sError = ex.Message; return(lstError); } }
/// <summary> /// Inserta un Tipo de Cambio(ExchangeType) en la base de datos /// </summary> /// <param name="sDescription">La descripción</param> public errorCompositeType InsertExchangeType(String sDescription, String sInitial) { errorCompositeType lstError = new errorCompositeType(); try { bool bStatus = true; param = new SqlParameter[3]; param[0] = new SqlParameter("@fvdescription_Exchange_type", SqlDbType.VarChar); param[0].Value = sDescription; param[1] = new SqlParameter("@fbstatus_Exchange_type", SqlDbType.Bit); param[1].Value = bStatus; param[2] = new SqlParameter("@fcinitial", SqlDbType.VarChar); param[2].Value = sInitial; objDB.ExecStoredIUD("sp_insertExchangeType", param); lstError.bError = true; return(lstError); } catch (Exception ex) { lstError.bError = false; lstError.sError = ex.Message; return(lstError); } }
public errorCompositeType UpdateExchangeReview(ExchangeReviewCompositeType erct) { var lstError = new errorCompositeType(); try { bool bStatus = true; param = new SqlParameter[3]; param[0] = new SqlParameter("@fvobservation_review_Exchange", SqlDbType.VarChar) { Value = erct.sDescription }; param[1] = new SqlParameter("@fiid_review_type", SqlDbType.Int) { Value = erct.iIdReviewType }; param[2] = new SqlParameter("@fiid_review_exchange", SqlDbType.Int) { Value = erct.iIdReviewExchange }; objDB.ExecStoredIUD("sp_updateReviewExchange", param); lstError.bError = true; return(lstError); } catch (Exception ex) { lstError.bError = false; lstError.sError = ex.Message; return(lstError); } }
public void InsertUser(int iIdEmployed, String sUserName, String sPassword, int iUserRol) { var lstError = new errorCompositeType(); try { param = new SqlParameter[4]; param[0] = new SqlParameter("@fiid_employed", SqlDbType.Int) { Value = iIdEmployed }; param[1] = new SqlParameter("@fvuser_name", SqlDbType.VarChar) { Value = sUserName }; param[2] = new SqlParameter("@fvpassword", SqlDbType.VarChar) { Value = sPassword }; param[3] = new SqlParameter("@fiRol", SqlDbType.Int) { Value = iUserRol }; objDB.ExecStoredIUD("sp_insertUser", param); } catch (Exception ex) { throw new Exception(); } }
public errorCompositeType DeletePartListExchange(int iIdExchange, int iIdPartList) { var lstError = new errorCompositeType(); try { param = new SqlParameter[2]; param[0] = new SqlParameter("@fiid_exchange", SqlDbType.Int) { Value = iIdExchange }; param[1] = new SqlParameter("@fiid_part_list", SqlDbType.Int) { Value = iIdPartList }; objDB.ExecStoredIUD("sp_deletePartListExchange", param); lstError.bError = true; return(lstError); } catch (Exception ex) { lstError.bError = false; lstError.sError = ex.Message; return(lstError); } }
public errorCompositeType InsertLockingType(String sDescription) { errorCompositeType lstError = new errorCompositeType(); try { bool bStatus = true; param = new SqlParameter[2]; param[0] = new SqlParameter("@fvdescription_locking", SqlDbType.VarChar) { Value = sDescription }; param[1] = new SqlParameter("@fbstatus_locking", SqlDbType.Bit) { Value = bStatus }; objDB.ExecStoredIUD("sp_insertLockingType", param); lstError.bError = true; return(lstError); } catch (Exception ex) { lstError.bError = false; lstError.sError = ex.Message; return(lstError); } }
public errorCompositeType UpdatePlant(int iIdPlant, String sDescription) { errorCompositeType lstError = new errorCompositeType(); try { param = new SqlParameter[2]; param[0] = new SqlParameter("@fiid_plant", SqlDbType.Int); param[0].Value = iIdPlant; param[1] = new SqlParameter("@fvdescription_plant", SqlDbType.VarChar); param[1].Value = sDescription; objDB.ExecStore("sp_updatePlant", param); lstError.bError = true; return(lstError); } catch (Exception ex) { lstError.bError = false; lstError.sError = ex.Message; return(lstError); } }
public errorCompositeType UpdatePartListExchange(int iIdListPartExchange, int iIdPartList, int iIdAffectation, int iIdExchange) { var lstError = new errorCompositeType(); try { param = new SqlParameter[4]; param[0] = new SqlParameter("@fiid_Exchange_part_list", SqlDbType.Int) { Value = iIdListPartExchange }; param[1] = new SqlParameter("@fiid_part_list", SqlDbType.Int) { Value = iIdPartList }; param[2] = new SqlParameter("@fiid_Exchange", SqlDbType.Int) { Value = iIdExchange }; param[3] = new SqlParameter("@fiid_affectation_type", SqlDbType.Int) { Value = iIdAffectation }; objDB.ExecStore("sp_updatePartListExchange", param); lstError.bError = true; return(lstError); } catch (Exception ex) { lstError.bError = false; lstError.sError = ex.Message; return(lstError); } }
public errorCompositeType InsertTask(String sDescription, int iIdArea) { errorCompositeType lstError = new errorCompositeType(); try { bool bStatus = true; param = new SqlParameter[3]; param[0] = new SqlParameter("@fvdescription_task", SqlDbType.VarChar) { Value = sDescription }; param[1] = new SqlParameter("@fbstatus_task", SqlDbType.Bit) { Value = bStatus }; param[2] = new SqlParameter("@fiidarea", SqlDbType.Int) { Value = iIdArea }; objDB.ExecStoredIUD("sp_insertTask", param); lstError.bError = true; return(lstError); } catch (Exception ex) { lstError.bError = false; lstError.sError = ex.Message; return(lstError); } }
/// <summary> /// Inserta un Tipo de Cambio(area) en la base de datos /// </summary> /// <param name="sDescription">La descripción</param> public errorCompositeType InsertArea(String sDescription, int iNumber, int iResponsable) { errorCompositeType lstError = new errorCompositeType(); try { bool bStatus = true; param = new SqlParameter[3]; param[0] = new SqlParameter("@fvdescription_area", SqlDbType.VarChar) { Value = sDescription }; param[1] = new SqlParameter("@finumber_area", SqlDbType.Int) { Value = iNumber }; param[2] = new SqlParameter("@fiManager", SqlDbType.Int) { Value = iResponsable }; objDB.ExecStoredIUD("sp_insertArea", param); lstError.bError = true; return(lstError); } catch (Exception ex) { lstError.bError = false; lstError.sError = ex.Message; return(lstError); } }
public errorCompositeType UpdateAffectationType(int iIdAffectationType, String sDescription) { var lstError = new errorCompositeType(); try { param = new SqlParameter[2]; param[0] = new SqlParameter("@fiid_affectation_type", SqlDbType.Int) { Value = iIdAffectationType }; param[1] = new SqlParameter("@fvdescription_affectation_type", SqlDbType.VarChar) { Value = sDescription }; objDB.ExecStore("sp_updateAffectationType", param); lstError.bError = true; return(lstError); } catch (Exception ex) { lstError.bError = false; lstError.sError = ex.Message; return(lstError); } }
public errorCompositeType InsertTaskGroup(int iIdGroup, int iIdTask) { errorCompositeType lstError = new errorCompositeType(); try { bool bStatus = true; param = new SqlParameter[3]; param[0] = new SqlParameter("@fiid_task", SqlDbType.Int); param[0].Value = iIdTask; param[1] = new SqlParameter("@fbstatus_task_group", SqlDbType.Bit); param[1].Value = bStatus; param[2] = new SqlParameter("@fiid_group", SqlDbType.Int); param[2].Value = iIdGroup; objDB.ExecStoredIUD("sp_insertTaskGroup", param); lstError.bError = true; return(lstError); } catch (Exception ex) { lstError.bError = false; lstError.sError = ex.Message; return(lstError); } }
public errorCompositeType InsertAffectationType(String sDescription) { var lstError = new errorCompositeType(); try { param = new SqlParameter[2]; param[0] = new SqlParameter("@fvdescription_affectation_type", SqlDbType.VarChar) { Value = sDescription }; param[1] = new SqlParameter("@fbstatus_affectation_type", SqlDbType.Bit) { Value = true }; objDB.ExecStoredIUD("sp_insertAffectationType", param); lstError.bError = true; return(lstError); } catch (Exception ex) { lstError.bError = false; lstError.sError = ex.Message; return(lstError); } }
public errorCompositeType UpdateExchangeType(int iIdExchangeType, String sDescription, String sInitial) { errorCompositeType lstError = new errorCompositeType(); try { param = new SqlParameter[3]; param[0] = new SqlParameter("@fiid_Exchange_type", SqlDbType.Int); param[0].Value = iIdExchangeType; param[1] = new SqlParameter("@fvdescription_Exchange_type", SqlDbType.VarChar); param[1].Value = sDescription; param[2] = new SqlParameter("@fcinitial", SqlDbType.VarChar); param[2].Value = sInitial; objDB.ExecStore("sp_updateExchangeType", param); lstError.bError = true; return(lstError); } catch (Exception ex) { lstError.bError = false; lstError.sError = ex.Message; return(lstError); } }
/// <summary> /// Inserta un Motivo(PartListType) en la base de datos /// </summary> /// <param name="sDescription">La descripción</param> public errorCompositeType InsertPartList(String iNumber, String sDescription, String iNumberClient) { var lstError = new errorCompositeType(); try { param = new SqlParameter[4]; param[0] = new SqlParameter("@finumber_part_list", SqlDbType.VarChar) { Value = iNumber }; param[1] = new SqlParameter("@fvdescription_part_list", SqlDbType.VarChar) { Value = sDescription }; param[2] = new SqlParameter("@fbstatus_part_list", SqlDbType.Bit) { Value = true }; param[3] = new SqlParameter("@finumber_client", SqlDbType.VarChar) { Value = iNumberClient }; objDB.ExecStoredIUD("sp_insertPartList", param); lstError.bError = true; return(lstError); } catch (Exception ex) { lstError.bError = false; lstError.sError = ex.Message; return(lstError); } }
public errorCompositeType UpdatePartList(int iIdPartList, String iNumber, String sDescription, String iPartListClient) { var lstError = new errorCompositeType(); try { param = new SqlParameter[4]; param[0] = new SqlParameter("@fiid_part_list", SqlDbType.Int) { Value = iIdPartList }; param[1] = new SqlParameter("@fvnumber_part_DS", SqlDbType.VarChar) { Value = iNumber }; param[2] = new SqlParameter("@fvaffectation_part", SqlDbType.VarChar) { Value = sDescription }; param[3] = new SqlParameter("@finumber_part_client", SqlDbType.VarChar) { Value = iPartListClient }; objDB.ExecStore("sp_updatePartList", param); lstError.bError = true; return(lstError); } catch (Exception ex) { lstError.bError = false; lstError.sError = ex.Message; return(lstError); } }
public errorCompositeType UpdateTaskData(int iIdTaskData, int iIdArea, int iIdGroup, String sDescription) { errorCompositeType lstError = new errorCompositeType(); try { param = new SqlParameter[4]; param[0] = new SqlParameter("@fiid_task_data", SqlDbType.Int) { Value = iIdTaskData }; param[1] = new SqlParameter("@fiid_task", SqlDbType.Int) { Value = iIdArea }; param[2] = new SqlParameter("@fiid_data", SqlDbType.Int) { Value = iIdGroup }; param[3] = new SqlParameter("@fvdescription", SqlDbType.VarChar) { Value = sDescription }; objDB.ExecStore("sp_updateTaskData", param); lstError.bError = true; return(lstError); } catch (Exception ex) { lstError.bError = false; lstError.sError = ex.Message; return(lstError); } }
public errorCompositeType InsertTaskData(int iIdGroup, int iIdTask, String sDescription) { errorCompositeType lstError = new errorCompositeType(); try { bool bStatus = true; param = new SqlParameter[4]; param[0] = new SqlParameter("@fiid_task", SqlDbType.Int); param[0].Value = iIdTask; param[1] = new SqlParameter("@fbstatus_task", SqlDbType.Bit); param[1].Value = bStatus; param[2] = new SqlParameter("@fiid_data", SqlDbType.Int); param[2].Value = iIdGroup; param[3] = new SqlParameter("@fvdescription", SqlDbType.VarChar); param[3].Value = sDescription; objDB.ExecStoredIUD("sp_insertTaskData", param); lstError.bError = true; return(lstError); } catch (Exception ex) { lstError.bError = false; lstError.sError = ex.Message; return(lstError); } }
public errorCompositeType InsertTaskExchange(ExchangeFileCompositeType etct) { var lstError = new errorCompositeType(); try { var param = new SqlParameter[4]; param[0] = new SqlParameter("@fvlabel_file", SqlDbType.VarChar) { Value = etct.sLabel }; param[1] = new SqlParameter("@fvaddress_file", SqlDbType.VarChar) { Value = etct.sURL }; param[2] = new SqlParameter("@fiid_file_type", SqlDbType.Int) { Value = etct.iTiype }; param[3] = new SqlParameter("@fiid_Exchange", SqlDbType.Int) { Value = etct.iExchange }; objDB.ExecStoredIUD("sp_insertFileExchange", param); lstError.bError = true; return(lstError); } catch (Exception ex) { lstError.bError = false; lstError.sError = ex.Message; return(lstError); } }
/// <summary> /// Inserta un Motivo(reasonType) en la base de datos /// </summary> /// <param name="sDescription">La descripción</param> public errorCompositeType InsertReason(int iNumber, String sDescription) { errorCompositeType lstError = new errorCompositeType(); try { bool bStatus = true; param = new SqlParameter[3]; param[0] = new SqlParameter("@finumber_reason", SqlDbType.Int); param[0].Value = iNumber; param[1] = new SqlParameter("@fvdescription_reason", SqlDbType.VarChar); param[1].Value = sDescription; param[2] = new SqlParameter("@fbstatus_reason", SqlDbType.Bit); param[2].Value = bStatus; objDB.ExecStoredIUD("sp_insertReason", param); lstError.bError = true; return(lstError); } catch (Exception ex) { lstError.bError = false; lstError.sError = ex.Message; return(lstError); } }
public errorCompositeType UpdateTaskExchange(TaskExchangeCompositeType tect, string sDesencadenante) { var lstError = new errorCompositeType(); try { param = new SqlParameter[9]; param[0] = new SqlParameter("@fvtiming_task_exchange", SqlDbType.Int) { Value = tect.iTiming }; param[1] = new SqlParameter("@finext_task", SqlDbType.Int) { Value = tect.iNextTask }; param[2] = new SqlParameter("@fiid_task", SqlDbType.Int) { Value = tect.iTask }; param[3] = new SqlParameter("@fiid_exchange", SqlDbType.Int) { Value = tect.iExchange }; param[4] = new SqlParameter("@fiid_employed", SqlDbType.Int) { Value = tect.iEmployed }; param[5] = new SqlParameter("@fi_timing_total", SqlDbType.Int) { Value = tect.iTimingTotal }; param[6] = new SqlParameter("@fvtiming_task_exchange_Date", SqlDbType.DateTime) { Value = tect.dTiming }; param[7] = new SqlParameter("@fiid_task_exchange", SqlDbType.Int) { Value = tect.iIdTaskExchange }; param[8] = new SqlParameter("@fvDesencadenante", SqlDbType.VarChar) { Value = sDesencadenante }; objDB.ExecStoredIUD("[sp_updateTaskExchange]", param); lstError.bError = true; return(lstError); } catch (Exception ex) { lstError.bError = false; lstError.sError = ex.Message; return(lstError); } }
public errorCompositeType InsertTaskExchange(TaskExchangeCompositeType tect) { var lstError = new errorCompositeType(); try { param = new SqlParameter[8]; param[0] = new SqlParameter("@fvtiming_task_exchange", SqlDbType.Int) { Value = tect.iTiming }; param[1] = new SqlParameter("@finext_task", SqlDbType.Int) { Value = tect.iNextTask }; param[2] = new SqlParameter("@fiid_task", SqlDbType.Int) { Value = tect.iTask }; param[3] = new SqlParameter("@fiid_exchange", SqlDbType.Int) { Value = tect.iExchange }; param[4] = new SqlParameter("@fiid_employed", SqlDbType.Int) { Value = tect.iEmployed }; param[5] = new SqlParameter("@fi_timing_total", SqlDbType.Int) { Value = tect.iTimingTotal }; param[6] = new SqlParameter("@fvtiming_task_exchange_Date", SqlDbType.DateTime) { Value = tect.dTiming }; param[7] = new SqlParameter("@fiGroup", SqlDbType.Int) { Value = tect.iGroup }; objDB.ExecStoredIUD("sp_insertTaskExchange", param); lstError.bError = true; return(lstError); } catch (Exception ex) { lstError.bError = false; lstError.sError = ex.Message; return(lstError); } }
//#region Insert public errorCompositeType InsertExchangeFlA(ExchangeFlACompositeType ect) { errorCompositeType lstError = new errorCompositeType(); try { bool bStatus = true; param = new SqlParameter[12]; param[0] = new SqlParameter("@fdDateIn", SqlDbType.DateTime); param[0].Value = ect.dDateIn; param[1] = new SqlParameter("@fdDatePromese", SqlDbType.DateTime); param[1].Value = ect.dDatePromise; param[2] = new SqlParameter("@fdDateOut", SqlDbType.DateTime); param[2].Value = ect.dDateOut; param[3] = new SqlParameter("@fvSOP", SqlDbType.VarChar); param[3].Value = ect.SOECliente; param[4] = new SqlParameter("@fiMold", SqlDbType.Int); param[4].Value = ect.iMold; param[5] = new SqlParameter("@fiMoldProt", SqlDbType.Int); param[5].Value = ect.iMoldProt; param[6] = new SqlParameter("@fiCostMa", SqlDbType.Int); param[6].Value = ect.iCost; param[7] = new SqlParameter("@fiDateStart", SqlDbType.Int); param[7].Value = ect.iDateStart; param[8] = new SqlParameter("@fiTotal", SqlDbType.Int); param[8].Value = ect.iTotalInv; param[9] = new SqlParameter("@fiTotalP", SqlDbType.Int); param[9].Value = ect.iTotalP; param[10] = new SqlParameter("@fbStatus", SqlDbType.Bit); param[10].Value = ect.bStatus; param[11] = new SqlParameter("@fiidEPL", SqlDbType.Int); param[11].Value = ect.iIdPlEA; objDB.ExecStoredIUD("sp_insertTAAfectationExchangePartList", param); lstError.bError = true; return(lstError); } catch (Exception ex) { lstError.bError = false; lstError.sError = ex.Message; return(lstError); } }
public errorCompositeType InsertEmployed(int iNumber, String sName, String sMotherLastName, String sFatherLasteName, String sEMail, int iIdArea, int iIdPlant, int iBoss, int iSubstitute) { errorCompositeType lstError = new errorCompositeType(); try { param = new SqlParameter[11]; param[0] = new SqlParameter("@finumber_employed", SqlDbType.Int); param[0].Value = iNumber; param[1] = new SqlParameter("@fvname_employed", SqlDbType.VarChar); param[1].Value = sName; param[2] = new SqlParameter("@fvmother_last_name", SqlDbType.VarChar); param[2].Value = sMotherLastName; param[3] = new SqlParameter("@fvfather_last_name", SqlDbType.VarChar); param[3].Value = sFatherLasteName; param[4] = new SqlParameter("@fvemail_employed", SqlDbType.VarChar); param[4].Value = sEMail; param[5] = new SqlParameter("@fistatus_employed", SqlDbType.Int); param[5].Value = 1; param[6] = new SqlParameter("@fiid_area", SqlDbType.Int); param[6].Value = iIdArea; param[7] = new SqlParameter("@fiid_plant", SqlDbType.Int); param[7].Value = iIdPlant; param[8] = new SqlParameter("@fdregistry_date", SqlDbType.DateTime); param[8].Value = DateTime.Now; param[9] = new SqlParameter("@fiid_boss", SqlDbType.Int); param[9].Value = iBoss; param[10] = new SqlParameter("@fiid_substitute", SqlDbType.Int); param[10].Value = iSubstitute; objDB.ExecStoredIUD("sp_insertEmployed", param); lstError.bError = true; return(lstError); } catch (Exception ex) { lstError.bError = false; lstError.sError = ex.Message; return(lstError); } }
/// <summary> /// Hace el borrado logico de un area a cero. /// </summary> /// <param name="iIdArea">id del area a eliminar</param> /// <returns></returns> public errorCompositeType DeleteArea(int iIdArea) { errorCompositeType lstError = new errorCompositeType(); try { param = new SqlParameter[1]; param[0] = new SqlParameter("@fiid_area", SqlDbType.Int); param[0].Value = iIdArea; objDB.ExecStoredIUD("sp_deleteArea", param); lstError.bError = true; return(lstError); } catch (Exception ex) { lstError.bError = false; lstError.sError = ex.Message; return(lstError); } }
public errorCompositeType InsertActionRol(int iIdAction, int iIdRol, Boolean bStatus) { var lstError = new errorCompositeType(); try { param = new SqlParameter[3]; param[0] = new SqlParameter("@fiIdAction", SqlDbType.TinyInt) { Value = iIdAction }; param[1] = new SqlParameter("@fiRol", SqlDbType.SmallInt) { Value = iIdRol }; param[2] = new SqlParameter("@fiStatus", SqlDbType.Bit) { Value = bStatus }; objDB.ExecStoredIUD("sp_insertActionsxRol", param); lstError.bError = true; return lstError; } catch (Exception ex) { lstError.bError = false; lstError.sError = ex.Message; return lstError; } }
public errorCompositeType DeleteAffectationType(int iIdAffectationType) { var lstError = new errorCompositeType(); try { param = new SqlParameter[1]; param[0] = new SqlParameter("@fiid_affectation_type", SqlDbType.Int) { Value = iIdAffectationType }; objDB.ExecStoredIUD("sp_deleteAffectationType", param); lstError.bError = true; return(lstError); } catch (Exception ex) { lstError.bError = false; lstError.sError = ex.Message; return(lstError); } }
public void UpdateUser(int iIdUser, int iIdEmployed, String sUserName, String sPassword, Boolean bStatus, int iUserRol) { var lstError = new errorCompositeType(); try { param = new SqlParameter[6]; param[0] = new SqlParameter("@fiid_user", SqlDbType.Int) { Value = iIdUser }; param[1] = new SqlParameter("@fiid_employed", SqlDbType.Int) { Value = iIdEmployed }; param[2] = new SqlParameter("@fvuser_name", SqlDbType.VarChar) { Value = sUserName }; param[3] = new SqlParameter("@fvpassword", SqlDbType.VarChar) { Value = sPassword }; param[4] = new SqlParameter("@fbLock", SqlDbType.Bit) { Value = bStatus }; param[5] = new SqlParameter("@fiRol", SqlDbType.Int) { Value = iUserRol }; objDB.ExecStoredIUD("sp_updateUser", param); } catch (Exception ex) { throw new Exception(); } }