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