private static RecordsStats GetRecordsStatsFromDataRow(DataRow dr) { var stats = new RecordsStats(); stats.RecordFirst = dr["RecordFirst"].ToInt(); stats.RecordLast = dr["RecordLast"].ToInt(); stats.RecordsTotal = dr["RecordsTotal"].ToInt(); stats.RecordCount = dr["recordCount"].ToInt(); return(stats); }
public LoggingModel GetApplicationLogs(String appName, String logLevel, int top, int skip, String search = "") { var result = new LoggingModel(); // Create a SQL command to execute the sproc using (SqlCommand command = (SqlCommand)StoreDbContext.Database.Connection.CreateCommand()) { command.CommandTimeout = StoreConstants.StoreProcedureCommandTimeOut; command.CommandType = CommandType.StoredProcedure; command.CommandText = "log_GetApplicationLogs"; if (!String.IsNullOrEmpty(appName.Trim())) { command.Parameters.Add("AppName", SqlDbType.NVarChar).Value = appName; } else { command.Parameters.Add("AppName", SqlDbType.NVarChar).Value = DBNull.Value; } if (!String.IsNullOrEmpty(search.Trim())) { command.Parameters.Add("search", SqlDbType.NVarChar).Value = search; } else { command.Parameters.Add("search", SqlDbType.NVarChar).Value = DBNull.Value; } if (!String.IsNullOrEmpty(logLevel.Trim())) { command.Parameters.Add("logLevel", SqlDbType.NVarChar).Value = logLevel; } else { command.Parameters.Add("logLevel", SqlDbType.NVarChar).Value = DBNull.Value; } command.Parameters.Add("top", SqlDbType.Int).Value = top; command.Parameters.Add("skip", SqlDbType.Int).Value = skip; using (SqlDataAdapter adapter = new SqlDataAdapter()) { adapter.SelectCommand = command; using (DataSet dataset = new DataSet()) { adapter.Fill(dataset); var systemLoggingList = new List <system_logging>(); using (DataTable dt = dataset.Tables[0]) { foreach (DataRow dr in dt.Rows) { var systemLogging = new system_logging(); systemLogging.entered_date = dr["entered_date"].ToDateTime(); systemLogging.log_application = dr["log_application"].ToStr(); systemLogging.log_date = dr["log_date"].ToStr(); systemLogging.log_level = dr["log_level"].ToStr(); systemLogging.log_logger = dr["log_logger"].ToStr(); systemLogging.log_message = dr["log_message"].ToStr(); systemLogging.log_call_site = dr["log_call_site"].ToStr(); systemLogging.log_exception = dr["log_exception"].ToStr(); systemLogging.log_stacktrace = dr["log_stacktrace"].ToStr(); systemLoggingList.Add(systemLogging); } } result.SystemLoggingList = systemLoggingList; RecordsStats stats = new RecordsStats(); using (DataTable dt = dataset.Tables[1]) { foreach (DataRow dr in dt.Rows) { stats.RecordFirst = dr["RecordFirst"].ToInt(); stats.RecordLast = dr["RecordLast"].ToInt(); stats.RecordsTotal = dr["RecordsTotal"].ToInt(); stats.RecordCount = dr["recordCount"].ToInt(); } } result.RecordsStats = stats; } // dataset } //dataAdapter } //command return(result); }
private ProductsSearchResult GetProductsSearchResult( int storeId, string search, List <Filter> filters, int top, int skip, Boolean isAdmin = false, string categoryApiId = "women") { var searchResult = new ProductsSearchResult(); String commandText = @"SearchProducts"; var commandType = CommandType.StoredProcedure; var parameterList = new List <SqlParameter>(); var dtFilters = new DataTable("med_tpt_Filter"); dtFilters.Columns.Add("FieldName"); dtFilters.Columns.Add("ValueFirst"); dtFilters.Columns.Add("ValueLast"); if (filters != null && filters.Any()) { foreach (var filter in filters) { DataRow dr = dtFilters.NewRow(); dr["FieldName"] = filter.FieldName; dr["ValueFirst"] = filter.ValueFirst; dr["ValueLast"] = filter.ValueLast; dtFilters.Rows.Add(dr); } } parameterList.Add(DatabaseUtility.GetSqlParameter("IsAdmin", isAdmin, SqlDbType.Bit)); parameterList.Add(DatabaseUtility.GetSqlParameter("storeId", storeId, SqlDbType.Int)); parameterList.Add(DatabaseUtility.GetSqlParameter("search", search.ToStr(), SqlDbType.NVarChar)); parameterList.Add(DatabaseUtility.GetSqlParameter("ApiCategoryId", categoryApiId.ToStr(), SqlDbType.NVarChar)); parameterList.Add(DatabaseUtility.GetSqlParameter("filter", dtFilters, SqlDbType.Structured)); parameterList.Add(DatabaseUtility.GetSqlParameter("top", top, SqlDbType.Int)); parameterList.Add(DatabaseUtility.GetSqlParameter("skip", skip, SqlDbType.Int)); DatabaseUtility.SqlCommandTimeout = StoreConstants.StoreProcedureCommandTimeOut; DataSet dataSet = DatabaseUtility.ExecuteDataSet((SqlConnection)StoreDbContext.Database.Connection, commandText, commandType, parameterList.ToArray()); if (dataSet.Tables.Count > 0) { var productCategories = new List <ProductCategory>(); using (DataTable dt = dataSet.Tables[0]) { foreach (DataRow dr in dt.Rows) { var item = GetProductCategoriesFromDataRow(dr); productCategories.Add(item); } ; } searchResult.ProductCategories = productCategories; var fileManagerList = new List <FileManager>(); using (DataTable dt = dataSet.Tables[3]) { foreach (DataRow dr in dt.Rows) { var item = GetFileManagerFromDataRow(dr); fileManagerList.Add(item); } ; } var productFiles = new List <ProductFile>(); using (DataTable dt = dataSet.Tables[2]) { foreach (DataRow dr in dt.Rows) { var item = GetProductFilesFromDataRow(dr); productFiles.Add(item); item.FileManager = fileManagerList.FirstOrDefault(r => r.Id == item.FileManagerId); } ; } var products = new List <Product>(); using (DataTable dt = dataSet.Tables[1]) { foreach (DataRow dr in dt.Rows) { var item = GetProductsFromDataRow(dr); products.Add(item); item.ProductFiles = productFiles.Where(r => r.ProductId == item.Id).ToList(); } ; } searchResult.Products = products; using (DataTable dt = dataSet.Tables[4]) { var m = new List <Filter>(); foreach (DataRow dr in dt.Rows) { var item = GetFilterFromDataRow(dr); item.OwnerType = ProductsItem; m.Add(item); } searchResult.Filters = m; } using (DataTable dt = dataSet.Tables[5]) { var stats = new RecordsStats(); foreach (DataRow dr in dt.Rows) { stats = GetRecordsStatsFromDataRow(dr); stats.OwnerType = ProductsItem; } searchResult.Stats = stats; } } searchResult.PageSize = top; return(searchResult); }