public errorCompositeType UpdateExchangeAutorization(ExchangeAutorizationCompositeType eact)
{
var lstError = new errorCompositeType();
try
{
param = new SqlParameter[5];
param[0] = new SqlParameter("@fiid_Exchange", SqlDbType.Int)
{
Value = eact.iIdExchange
};
param[1] = new SqlParameter("@fiid_review_type_eng", SqlDbType.Int)
{
Value = eact.iIdReviewTypeEng
};
param[2] = new SqlParameter("@fvEngObservation", SqlDbType.VarChar)
{
Value = eact.sEngObsevations
};
param[3] = new SqlParameter("@fiid_review_type_adm", SqlDbType.Int)
{
Value = eact.iIdReviewTypeAdm
};
param[4] = new SqlParameter("@fvobservation", SqlDbType.VarChar)
{
Value = eact.sObsevations
};
objDB.ExecStoredIUD("sp_updateExchangeAutorization", param);
lstError.bError = true;
return(lstError);
}
catch (Exception ex)
{
lstError.bError = false;
lstError.sError = ex.Message;
return(lstError);
}
}
public ExchangeAutorizationCompositeType GetExchangeAutorizationById(int idExchange)
{
try
{
var et = new ExchangeAutorizationCompositeType();
param = new SqlParameter[1];
param[0] = new SqlParameter("@fiid_Exchange", SqlDbType.Int)
{
Value = idExchange
};
DataTable dt = objDB.ExecStore("sp_selectExchangeAutorizationByIdExchange", param);
if (dt.Rows.Count > 0)
{
et.iIdExchangeAutorization = int.Parse(dt.Rows[0].ItemArray[0].ToString());
et.iIdExchange = int.Parse(dt.Rows[0].ItemArray[1].ToString());
et.iIdReviewTypeAdm = int.Parse(dt.Rows[0].ItemArray[3].ToString());
et.iIdReviewTypeEng = int.Parse(dt.Rows[0].ItemArray[2].ToString());
et.bStatus = bool.Parse(dt.Rows[0].ItemArray[4].ToString());
et.sIdReviewTypeEng = dt.Rows[0].ItemArray[5].ToString();
et.sEngObsevations = dt.Rows[0].ItemArray[6].ToString();
et.sIdReviewTypeAdm = dt.Rows[0].ItemArray[7].ToString();
et.sObsevations = dt.Rows[0].ItemArray[8].ToString();
et.iIngeniero = int.Parse(dt.Rows[0].ItemArray[9].ToString());
et.iIngenieroSup = int.Parse(dt.Rows[0].ItemArray[10].ToString());
et.iGerente = int.Parse(dt.Rows[0].ItemArray[11].ToString());
return(et);
}
else
{
return(null);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
