public List <ComputerComponentModel> GetUserOptions(int UserId) { string query = @"select cc.Id, Name, URL, cc.SKU, Price, Type, q.Quantity, q.UserId from ComputerComponent as cc join UserCart uc on uc.ProcessorSku = cc.SKU or uc.MainboarSku = cc.SKU join Quantity as q on q.SKU = cc.SKU where q.UserId = @UserId and uc.UserId = @UserId" ; List <SqlParameter> parameters = new List <SqlParameter> { new SqlParameter("@UserId", UserId) }; List <ComputerComponentModel> computerComponents = new List <ComputerComponentModel>(); try { SqlDataReader reader = SqlHelper.ExecuteReader(Startup.ConnectionString, CommandType.Text, query, parameters.ToArray()); if (reader.HasRows) { while (reader.Read()) { ComputerComponentModel computerComponent = new ComputerComponentModel { Id = reader.GetInt32(0), Name = reader.GetString(1), URL = reader.GetString(2), SKU = reader.GetString(3), Price = reader.GetString(4), Type = reader.GetInt32(5), Quantity = reader.GetInt32(6), UserId = reader.GetInt32(7) }; computerComponents.Add(computerComponent); } } else { Console.WriteLine("No rows found."); } reader.Close(); } catch (Exception ex) { Console.WriteLine(ex.Message); } return(computerComponents); }
public List <ComputerComponentModel> GetComputerComponents() { string query = "select Id, Name, URL, SKU, Price, Type from ComputerComponent"; List <ComputerComponentModel> computerComponents = new List <ComputerComponentModel>(); try { SqlDataReader reader = SqlHelper.ExecuteReader(Startup.ConnectionString, CommandType.Text, query); if (reader.HasRows) { while (reader.Read()) { ComputerComponentModel computerComponent = new ComputerComponentModel { Id = reader.GetInt32(0), Name = reader.GetString(1), URL = reader.GetString(2), SKU = reader.GetString(3), Price = reader.GetString(4), Type = reader.GetInt32(5), }; computerComponents.Add(computerComponent); } } else { Console.WriteLine("No rows found."); } reader.Close(); } catch (Exception ex) { Console.WriteLine(ex.Message); } return(computerComponents); }