public SqlParameter[] GetListParameters(string SP_NAME, object[] parameter)
{
try
{
IConsultantReader <DataTable, DataTable> consultor = new ConsultantReader <DataTable, DataTable>();
DataTable paramsSp = consultor.GetParametersSP(SP_NAME.Substring(SP_NAME.IndexOf(".") + 1), Conexion);
SqlParameter[] listParameter = new SqlParameter[paramsSp.Rows.Count];
Int32 i = 0;
ValidateParameters(parameter, listParameter, SP_NAME);
foreach (DataRow itemRow in paramsSp.Rows)
{
SqlParameter parameterSQL = new SqlParameter();;
var nameParameterSp = itemRow["name"].ToString();
parameterSQL.ParameterName = nameParameterSp;
parameterSQL.Value = parameter[i];
parameterSQL.Direction = ParameterDirection.Input;
listParameter[i] = parameterSQL;
i += 1;
}
return(listParameter);
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet GetDetails(string sp, object[] filter)
{
try
{
IConsultantReader <object, object> consultor = new ConsultantReader <object, object>();
DataSet response =
consultor.ConsultarDatos(sp, ConnectionString,
CommandType.StoredProcedure, filter);
return(response);
}
catch (Exception ex)
{
throw ex;
}
}
public List <string> GetAxis(string sp, object[] filter)
{
try
{
IConsultantReader <object, string> consultor = new ConsultantReader <object, string>();
MapperManager <object, string> mapper = FactoryTransformer.Create <object, string>();
List <string> response =
consultor.ConsultarProcedimientoListObjArray(sp,
ConnectionString,
CommandType.StoredProcedure, filter, mapper);
return(response);
}
catch (Exception ex)
{
throw ex;
}
}
public List <ParametersBO> GetParameters(object[] filter)
{
try
{
IConsultantReader <object, ParametersBO> consultor = new ConsultantReader <object, ParametersBO>();
MapperManager <object, ParametersBO> mapper = FactoryTransformer.Create <object, ParametersBO>();
List <ParametersBO> response =
consultor.ConsultarProcedimientoListObjArray(ParametersSP,
ConnectionString,
CommandType.StoredProcedure, filter, mapper);
return(response);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Metodo que permite crear la lista de parametros para un SP
/// </summary>
/// <param name="parameter"></param>
/// <returns></returns>
public SqlParameter[] GetListParameters <Parameters>(string SP_NAME, Parameters parameter)
{
try
{
List <PropertyInfo> properties = typeof(Parameters).GetProperties().ToList();
IConsultantReader <DataTable, DataTable> consultor = new ConsultantReader <DataTable, DataTable>();
DataTable paramsSp = consultor.GetParametersSP(SP_NAME.Substring(SP_NAME.IndexOf(".") + 1), Conexion);
SqlParameter[] listParameter = new SqlParameter[paramsSp.Rows.Count];
Int32 i = 0;
foreach (DataRow itemRow in paramsSp.Rows)
{
SqlParameter parameterSQL;
var nameParameterSp = itemRow["name"].ToString();
var queryProperty =
(from prop in properties
where prop.Name.Equals(nameParameterSp.Replace("@", string.Empty))
select prop).ToList();
if (queryProperty.Count > 0)
{
parameterSQL = new SqlParameter();
parameterSQL.ParameterName = nameParameterSp;
parameterSQL.Value = queryProperty[0].GetValue(parameter);
parameterSQL.Direction = ParameterDirection.Input;
listParameter[i] = parameterSQL;
i += 1;
}
}
if (listParameter.Contains(null))
{
throw new Exception(string.Format(DALMessage.Error_Parametros, parameter.GetType(), SP_NAME));
}
return(listParameter);
}
catch (Exception)
{
throw;
}
}
