public DataTable SearchCountWithPagination(Listado_NutrientesPorAlimentosEntityPaged EntityPaged, Listado_NutrientesPorAlimentosEntityFilter EntityFilter) { try { return(this.CreateDataAccess().SearchCountWithPagination(EntityPaged, EntityFilter)); } catch (Exception ex) { Helpers.Logger.Logger.LogExceptionStatic(ex); throw ex; } }
public DataTable SearchCountWithPagination(Listado_NutrientesPorAlimentosEntityPaged EntityPaged, Listado_NutrientesPorAlimentosEntityFilter EntityFilter) { DbCommand storedProcCommand = this.DataBase.GetStoredProcCommand("Listado_NutrientesPorAlimentos_SearchCountWithPagination"); try { using (storedProcCommand) { this.DataBase.AddInParameter(storedProcCommand, "PageSize", DbType.Int32, (object)EntityPaged.pageSize); this.DataBase.AddInParameter(storedProcCommand, "PageReturn", DbType.Int32, (object)EntityPaged.pageReturn); this.DataBase.AddInParameter(storedProcCommand, "WhereExtendido", DbType.String, (object)EntityFilter.WhereExtendido); this.DataBase.AddInParameter(storedProcCommand, "OrdenDeRegistros", DbType.String, (object)EntityFilter.OrderBy); this.DataBase.AddInParameter(storedProcCommand, "OpeEncuestaNro", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeEncuestaNro)); this.DataBase.AddInParameter(storedProcCommand, "EncuestaNro", DbType.Int32, (object)EntityFilter.EncuestaNro); this.DataBase.AddInParameter(storedProcCommand, "OpeHistoriaClinica", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeHistoriaClinica)); this.DataBase.AddInParameter(storedProcCommand, "HistoriaClinica", DbType.AnsiString, (object)EntityFilter.HistoriaClinica); this.DataBase.AddInParameter(storedProcCommand, "OpeFecha", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeFecha)); if (EntityFilter.FechaDesde.HasValue) { DateTime dateTime = DateTime.Parse(EntityFilter.FechaDesde.ToString()); this.DataBase.AddInParameter(storedProcCommand, "FechaDesde", DbType.String, (object)dateTime.ToString("yyyyMMdd' 'HH':'mm':'ss")); } else { this.DataBase.AddInParameter(storedProcCommand, "FechaDesde", DbType.String, (object)DBNull.Value); } if (EntityFilter.FechaHasta.HasValue) { DateTime dateTime = DateTime.Parse(EntityFilter.FechaHasta.ToString()); this.DataBase.AddInParameter(storedProcCommand, "FechaHasta", DbType.String, (object)dateTime.ToString("yyyyMMdd' 'HH':'mm':'ss")); } else { this.DataBase.AddInParameter(storedProcCommand, "FechaHasta", DbType.String, (object)DBNull.Value); } this.DataBase.AddInParameter(storedProcCommand, "OpeSexo", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeSexo)); this.DataBase.AddInParameter(storedProcCommand, "Sexo", DbType.AnsiString, (object)EntityFilter.Sexo); this.DataBase.AddInParameter(storedProcCommand, "OpeEdad", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeEdad)); this.DataBase.AddInParameter(storedProcCommand, "Edad", DbType.Int16, (object)EntityFilter.Edad); this.DataBase.AddInParameter(storedProcCommand, "OpePeso", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpePeso)); this.DataBase.AddInParameter(storedProcCommand, "Peso", DbType.Decimal, (object)EntityFilter.Peso); this.DataBase.AddInParameter(storedProcCommand, "OpeTalla", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeTalla)); this.DataBase.AddInParameter(storedProcCommand, "Talla", DbType.Decimal, (object)EntityFilter.Talla); this.DataBase.AddInParameter(storedProcCommand, "OpeIMC", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeIMC)); this.DataBase.AddInParameter(storedProcCommand, "IMC", DbType.Decimal, (object)EntityFilter.IMC); this.DataBase.AddInParameter(storedProcCommand, "OpeTipoDeDieta", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeTipoDeDieta)); this.DataBase.AddInParameter(storedProcCommand, "TipoDeDieta", DbType.AnsiString, (object)EntityFilter.TipoDeDieta); this.DataBase.AddInParameter(storedProcCommand, "OpeAlimento", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeAlimento)); this.DataBase.AddInParameter(storedProcCommand, "Alimento", DbType.AnsiString, (object)EntityFilter.Alimento); this.DataBase.AddInParameter(storedProcCommand, "OpeCantidadAlimento", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeCantidadAlimento)); this.DataBase.AddInParameter(storedProcCommand, "CantidadAlimento", DbType.Decimal, (object)EntityFilter.CantidadAlimento); this.DataBase.AddInParameter(storedProcCommand, "OpeNutriente", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeNutriente)); this.DataBase.AddInParameter(storedProcCommand, "Nutriente", DbType.AnsiString, (object)EntityFilter.Nutriente); this.DataBase.AddInParameter(storedProcCommand, "OpeCantidadNutriente", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeCantidadNutriente)); this.DataBase.AddInParameter(storedProcCommand, "CantidadNutriente", DbType.Decimal, (object)EntityFilter.CantidadNutriente); this.DataBase.AddInParameter(storedProcCommand, "OpeUserId", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeUserId)); this.DataBase.AddInParameter(storedProcCommand, "UserId", DbType.Guid, (object)EntityFilter.UserId); return(this.DataBase.ExecuteDataSet(storedProcCommand).Tables[0]); } } catch (SqlException ex) { throw ex; } catch (Exception ex) { throw ex; } }