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