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