public DataSet SelectAll()
{
List<DbParameter> lstParametros = new List<DbParameter>();
SQLConexion conProxy = new SQLConexion();
return conProxy.EjecutarConsulta(lstParametros, "dbo.sp_tblFamilies_SelectAll");
}
public DataSet TraerTodos()
{
List<DbParameter> lstParametros = new List<DbParameter>();
SQLConexion conProxy = new SQLConexion();
return conProxy.EjecutarConsulta(lstParametros, "dbo.sp_tblSubAreas_SelectStatus");
}
public DataSet SelectAll()
{
List<DbParameter> lstParametros = new List<DbParameter>();
SQLConexion conProxy = new SQLConexion();
return conProxy.EjecutarConsulta(lstParametros, "dbo.SelCostCenter");
}
public DataSet SelectByName(string iFamily_name)
{
List<DbParameter> lstParametros = new List<DbParameter>();
DbParameter prmiFamily_id = new SqlParameter();
prmiFamily_id.DbType = DbType.String;
prmiFamily_id.ParameterName = "@iFamily_name";
prmiFamily_id.Value = iFamily_name;
prmiFamily_id.Direction = ParameterDirection.Input;
lstParametros.Add(prmiFamily_id);
SQLConexion conProxy = new SQLConexion();
return conProxy.EjecutarConsulta(lstParametros, "dbo.sp_tblFamilies_SelectByName");
}
public DataSet SelectRow(int isubarea)
{
List<DbParameter> lstParametros = new List<DbParameter>();
DbParameter prmA = new SqlParameter();
prmA.DbType = DbType.Int32;
prmA.ParameterName = "@iSubArea_id";
prmA.Value = isubarea;
prmA.Direction = ParameterDirection.Input;
lstParametros.Add(prmA);
SQLConexion conProxy = new SQLConexion();
return conProxy.EjecutarConsulta(lstParametros, "dbo.sp_tblSubAreas_SelectRow");
}
public DataSet SelectRow(int iRol_id)
{
List<DbParameter> lstParametros = new List<DbParameter>();
DbParameter prmiRol_id = new SqlParameter();
prmiRol_id.DbType = DbType.Int32;
prmiRol_id.ParameterName = "@iRol_id";
prmiRol_id.Value = iRol_id;
prmiRol_id.Direction = ParameterDirection.Input;
lstParametros.Add(prmiRol_id);
SQLConexion conProxy = new SQLConexion();
return conProxy.EjecutarConsulta(lstParametros, "dbo.sp_tblRols_SelectRow");
}
public DataSet TraerFacturaXId(int codigo)
{
List<DbParameter> lstParametros = new List<DbParameter>();
DbParameter prmA = new SqlParameter();
prmA.DbType = DbType.Int32;
prmA.ParameterName = "@codigo";
prmA.Value = codigo;
prmA.Direction = ParameterDirection.Input;
lstParametros.Add(prmA);
SQLConexion conProxy = new SQLConexion();
return conProxy.EjecutarConsulta(lstParametros, "dbo.TraerFactura");
}
public DataSet selectRow(
int iResponsible_id,
int iCostCenter_id)
{
List<DbParameter> lstParametros = new List<DbParameter>();
DbParameter prmiResponsible_id = new SqlParameter();
prmiResponsible_id.DbType = DbType.Int32;
prmiResponsible_id.ParameterName = "@iResponsible_id";
prmiResponsible_id.Value = Convert.ToInt32(iResponsible_id);
prmiResponsible_id.Direction = ParameterDirection.Input;
lstParametros.Add(prmiResponsible_id);
DbParameter prmiCostCenter_id = new SqlParameter();
prmiCostCenter_id.DbType = DbType.Int32;
prmiCostCenter_id.ParameterName = "@iCostCenter_id";
prmiCostCenter_id.Value = Convert.ToInt32(iCostCenter_id);
prmiCostCenter_id.Direction = ParameterDirection.Input;
lstParametros.Add(prmiCostCenter_id);
SQLConexion conProxy = new SQLConexion();
return conProxy.EjecutarConsulta(lstParametros, "dbo.sp_tblPeopleCostCenters_SelectRow");
}
public DataSet selectRow(int codigo)
{
List<DbParameter> lstParametros = new List<DbParameter>();
DbParameter prmId = new SqlParameter();
prmId.DbType = DbType.Int32;
prmId.ParameterName = "@iSubFamily_id";
prmId.Value = codigo;
prmId.Direction = ParameterDirection.Input;
lstParametros.Add(prmId);
SQLConexion conProxy = new SQLConexion();
return conProxy.EjecutarConsulta(lstParametros, "dbo.sp_tblSubFamilies_SelectRow");
}
public DataSet TraerCentrodeCostosXId(int iCostCenter_id)
{
List<DbParameter> lstParametros = new List<DbParameter>();
DbParameter prmA = new SqlParameter();
prmA.DbType = DbType.Int32;
prmA.ParameterName = "@iCostCenter_id";
prmA.Value = iCostCenter_id;
prmA.Direction = ParameterDirection.Input;
lstParametros.Add(prmA);
DbParameter prmD = new SqlParameter();
prmD.DbType = DbType.Int32;
prmD.ParameterName = "@iEvento";
prmD.Value = 5;
prmD.Direction = ParameterDirection.Input;
lstParametros.Add(prmD);
SQLConexion conProxy = new SQLConexion();
return conProxy.EjecutarConsulta(lstParametros, "dbo.TraerCostCenterXId");
}
public DataSet selectRow(int iPerson_id, int iActive_id)
{
List<DbParameter> lstParametros = new List<DbParameter>();
DbParameter prmiPerson_id = new SqlParameter();
prmiPerson_id.DbType = DbType.Int32;
prmiPerson_id.ParameterName = "@iPerson_id";
prmiPerson_id.Value = iPerson_id;
prmiPerson_id.Direction = ParameterDirection.Input;
lstParametros.Add(prmiPerson_id);
DbParameter prmiActive_id = new SqlParameter();
prmiActive_id.DbType = DbType.Int32;
prmiActive_id.ParameterName = "@iActive_id";
prmiActive_id.Value = iActive_id;
prmiActive_id.Direction = ParameterDirection.Input;
lstParametros.Add(prmiActive_id);
SQLConexion conProxy = new SQLConexion();
return conProxy.EjecutarConsulta(lstParametros, "dbo.sp_AsigResponsibleActive_SelectRow");
}
public DataSet selectAll()
{
SQLConexion conProxy = new SQLConexion();
return conProxy.EjecutarConsulta(null, "dbo.sp_AsigResponsibleActive_SelectAll");
}
public DataSet selectByUsername(string usrnm)
{
List<DbParameter> lstParametros = new List<DbParameter>();
DbParameter prmId = new SqlParameter();
prmId.DbType = DbType.String;
prmId.ParameterName = "@sUsername";
prmId.Value = usrnm;
prmId.Direction = ParameterDirection.Input;
lstParametros.Add(prmId);
SQLConexion conProxy = new SQLConexion();
return conProxy.EjecutarConsulta(lstParametros, "dbo.sp_tblResponsibles_SelectByUsername");
}
/// <summary>
/// falta completar el metodo
/// </summary>
/// <param name="nombre"></param>
/// <returns></returns>
public DataSet TraerLocalidadxNombre(string nombre)
{
List<DbParameter> lstParametros = new List<DbParameter>();
DbParameter prmA = new SqlParameter();
prmA.DbType = DbType.String;
prmA.ParameterName = "@sLocation_name";
prmA.Value = nombre;
prmA.Direction = ParameterDirection.Input;
lstParametros.Add(prmA);
SQLConexion conProxy = new SQLConexion();
return conProxy.EjecutarConsulta(lstParametros, "dbo.TraerEmpleadoXNombre");
}
public DataSet selectByName(string name)
{
List<DbParameter> lstParametros = new List<DbParameter>();
DbParameter prmName = new SqlParameter();
prmName.DbType = DbType.String;
prmName.ParameterName = "@sActive_name";
prmName.Value = name;
prmName.Direction = ParameterDirection.Input;
lstParametros.Add(prmName);
SQLConexion conProxy = new SQLConexion();
return conProxy.EjecutarConsulta(lstParametros, "dbo.sp_tblActives_SelectByName");
}
public DataSet TraerEmpleado()
{
List<DbParameter> lstParametros = new List<DbParameter>();
SQLConexion conProxy = new SQLConexion();
return conProxy.EjecutarConsulta(lstParametros, "dbo.TraerEmpleado");
}