static void DisplaySkateboard(Skateboard skateboard)
{
Console.WriteLine($"Skateboard id: {skateboard.SkateboardId}");
Console.WriteLine($"Skateboard brand: {skateboard.Brand}");
Console.WriteLine($"Skateboard price: {skateboard.Price}");
Console.WriteLine($"Skateboard date listed: {skateboard.DateListed}");
}
public List <Skateboard> GetBoardsForLikeList()
{
List <Skateboard> completeSkateboards = new List <Skateboard>();
using (var conn = new NpgsqlConnection(_conn))
{
conn.Open();
using (var cmd = new NpgsqlCommand("select * from skateboards WHERE deck_id != 0 AND wheels_id != 0 AND trucks_id != 0", conn))
{
var reader = cmd.ExecuteReader();
while (reader.Read())
{
int skateboardId = int.Parse(reader["skateboard_id"].ToString());
int userId = int.Parse(reader["user_id"].ToString());
int deckId = int.Parse(reader["deck_id"].ToString());
int wheelsId = int.Parse(reader["wheels_id"].ToString());
int truckId = int.Parse(reader["trucks_id"].ToString());
Deck deck = GetDeckById(deckId);
Truck truck = GetTruckById(truckId);
Wheels wheels = GetWheelsById(wheelsId);
Skateboard skateboard = new Skateboard(skateboardId, userId, deck, wheels, truck);
completeSkateboards.Add(skateboard);
}
reader.Close();
}
conn.Close();
}
return(completeSkateboards);
}
public List <Skateboard> GetUserSkateboards(int userId)
{
List <Skateboard> userSkateboards = new List <Skateboard>();
using (var conn = new NpgsqlConnection(_conn))
{
conn.Open();
using (var cmd = new NpgsqlCommand("SELECT * FROM skateboards WHERE user_id = (@userId);", conn))
{
cmd.Parameters.AddWithValue("@userId", userId);
var reader = cmd.ExecuteReader();
while (reader.Read())
{
int skateboardId = int.Parse(reader["skateboard_id"].ToString());
int deckId = int.Parse(reader["deck_id"].ToString());
int wheelsId = int.Parse(reader["wheels_id"].ToString());
int truckId = int.Parse(reader["trucks_id"].ToString());
Deck deck = GetDeckById(deckId);
Truck truck = GetTruckById(truckId);
Wheels wheels = GetWheelsById(wheelsId);
Skateboard skateboard = new Skateboard(skateboardId, userId, deck, wheels, truck);
userSkateboards.Add(skateboard);
}
reader.Close();
}
conn.Close();
}
return(userSkateboards);
}
public ActionResult Create(Skateboard skateboard)
{
context.Skateboards.Add(skateboard);
context.SaveChanges();
return(RedirectToAction("Index"));
}
public int AddSkateboard(Skateboard skateboard)
{
skateboard.DateListed = DateTime.Now;
_executor.Insert(skateboard);
return skateboard.SkateboardId;
}
static void MarkSkateboardAsDeleted()
{
Skateboard skateboard = GetSkateboardById();
_skateboardRepo.MarkSkateboardAsDeleted(skateboard);
Console.WriteLine("skateboard has been marked as deleted");
}
static Skateboard GetSkateboardById()
{
Console.WriteLine("Enter skateboard id");
int skateboardId = int.Parse(Console.ReadLine());
Skateboard skateboard = _skateboardRepo.GetSkateboardById(skateboardId);
return(skateboard);
}
public ActionResult Delete(int id)
{
Skateboard std = context.Skateboards.Where(s => s.SkateboardId == id).FirstOrDefault();
context.Skateboards.Remove(std);
context.SaveChanges();
return(RedirectToAction("Index"));
}
/// <summary>
/// Checks if a board is eligible for a competition .
/// Returns true if the competitor skateboard's length is more than 32 and the wheel's hardness is either medium or soft.
/// </summary>
/// <param name="competitor"></param>
/// <returns></returns>
public override bool EligibleForCompetition(Skateboard competitor)
{
if (competitor.deck.length < 32 && competitor.wheel.hardness.Equals("medium") || competitor.wheel.hardness.Equals("soft"))
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// Checks if a board is eligible for a competition .
/// Returns true if the competitor skateboard has an "Almost" branded deck and a wheel with a "hard" hardness.
/// </summary>
/// <param name="competitor"></param>
/// <returns></returns>
public override bool EligibleForCompetition(Skateboard competitor)
{
if (competitor.deck.brand.Equals("Almost") && competitor.wheel.hardness.Equals("hard"))
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// Checks if a board is eligible for a competition .
/// Returns true if the competitor skateboard's bearing type is one of these: "reds", "super reds", "g2", "big balls reds"
/// and the wheel's size must be atleast 56.
/// </summary>
/// <param name="competitor"></param>
/// <returns></returns>
public override bool EligibleForCompetition(Skateboard competitor)
{
List<string> eligibleBearings = new List<string>() { "reds", "super reds", "g2", "big balls reds" };
if (eligibleBearings.Contains(competitor.bearings.type.ToLower()) && competitor.wheel.size>=56)
{
return true;
}
else
{
return false;
}
}
public ActionResult Edit(Skateboard skateboards)
{
Skateboard skateboard = context.Skateboards.Where(s => s.SkateboardId == skateboards.SkateboardId).FirstOrDefault();
skateboard.SkateboardBrand = skateboards.SkateboardBrand;
skateboard.SkateboardCurve = skateboards.SkateboardCurve;
skateboard.SkateboardWidth = skateboards.SkateboardWidth;
context.SaveChanges();
return(RedirectToAction("Index"));
}
static void AddNewSkateBoard()
{
Skateboard skateboard = new Skateboard();
Console.WriteLine("Please enter brand name");
skateboard.Brand = Console.ReadLine();
Console.WriteLine("Please enter price");
skateboard.Price = decimal.Parse(Console.ReadLine());
_skateboardRepo.AddSkateboard(skateboard);
}
static void UpdateSkateboardPrice()
{
Skateboard skateboard = GetSkateboardById();
DisplaySkateboard(skateboard);
Console.WriteLine("Enter new price for skateboard");
decimal newPrice = decimal.Parse(Console.ReadLine());
_skateboardRepo.UpdateSkateboardPrice(skateboard, newPrice);
Console.WriteLine("skateboard price has been updated");
}
/// <summary>
/// Checks if a board is eligible for a competition .
/// Asks the user their gender, if they answer female it returns true.
/// </summary>
/// <param name="competitor"></param>
/// <returns></returns>
public override bool EligibleForCompetition(Skateboard competitor)
{
UI.Printer("Are you a male or a female? (m/f)");
string gender = UI.Scanner();
if (gender.ToLower().Equals("f"))
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// Simulates a competition where the competitor is against 14 other skaters.
/// </summary>
/// <param name="storage"></param>
/// <param name="competitor"></param>
/// <returns></returns>
public override bool Race(Storage storage,Skateboard competitor)
{
var rand = new Random();
TimeSpan ts = new TimeSpan(0, 0, 3);
Console.Clear();
UI.Printer("Competing against 14 other skaters...");
Thread.Sleep(ts);
Console.Clear();
if (rand.Next(0,16) == 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// Simulates a competition where the competitor is against 3 other skaters. There is a 25% chance of their board breaking at the end.
/// </summary>
/// <param name="storage"></param>
/// <param name="competitor"></param>
/// <returns></returns>
public override bool Race(Storage storage, Skateboard competitor)
{
var rand = new Random();
TimeSpan ts = new TimeSpan(0, 0, 3);
Console.Clear();
UI.Printer("Competing against 3 other skaters on the halfpipe...");
Thread.Sleep(ts);
Console.Clear();
if (rand.Next(0, 4) == 0)
{
storage.BrokeBoard(competitor);
return(true);
}
else
{
storage.BrokeBoard(competitor);
return(false);
}
}
/// <summary>
/// Simulates a 3 round competition where every round the competitor is against 1 other competitor.
/// </summary>
/// <param name="storage"></param>
/// <param name="competitor"></param>
/// <returns></returns>
public override bool Race(Storage storage, Skateboard competitor)
{
TimeSpan ts = new TimeSpan(0, 0, 3);
var rand = new Random();
int wonRounds = 0;
for (int i = 0; i < 3; i++)
{
Console.Clear();
UI.Printer("Competing...");
Thread.Sleep(ts);
Console.Clear();
if (rand.Next(0, 2) == 0)
{
UI.Printer($"You won the {i + 1}. round! ");
wonRounds++;
Thread.Sleep(ts);
Console.Clear();
}
else
{
UI.Printer("You lost this round, and you're out of the competition.");
Thread.Sleep(ts);
Console.Clear();
break;
}
}
if (wonRounds == 3)
{
return(true);
}
else
{
return(false);
}
}
public ActionResult Delete(int?Id)
{
Skateboard std = context.Skateboards.Where(s => s.SkateboardId == Id).FirstOrDefault();
return(View(std));
}
public List <LikeList> GetLikeListForBoards()
{
var likes = new List <LikeList>();
bool foundBoard;
using (var conn = new NpgsqlConnection(_conn))
{
conn.Open();
using (var cmd = new NpgsqlCommand("SELECT l.user_id as likedUserId, s.skateboard_id as skateboardId,u.nickname as userNickname,s.user_id as skateboardUserId, s.deck_id as deckId, s.wheels_id as wheelsId, s.trucks_id as trucksId FROM liked AS l INNER JOIN skateboards AS s on s.skateboard_id = l.skateboard_id INNER JOIN users AS u on u.user_id = s.user_id", conn))
{
var reader = cmd.ExecuteReader();
while (reader.Read())
{
foundBoard = false;
int likedUserId = int.Parse(reader["likedUserId"].ToString());
int skateboardId = int.Parse(reader["skateboardId"].ToString());
string userNickname = reader["userNickname"].ToString();
int skateboardUserId = int.Parse(reader["skateboardUserId"].ToString());
int deckId = int.Parse(reader["deckId"].ToString());
int wheelsId = int.Parse(reader["wheelsId"].ToString());
int truckId = int.Parse(reader["trucksId"].ToString());
Deck deck = GetDeckById(deckId);
Truck truck = GetTruckById(truckId);
Wheels wheels = GetWheelsById(wheelsId);
Skateboard skateboard = new Skateboard(skateboardId, skateboardUserId, deck, wheels, truck);
foreach (LikeList like in likes)
{
if (like.LikeSkateboard.SkateboardId.Equals(skateboard.SkateboardId))
{
like.LikeUsers.Add(likedUserId);
foundBoard = true;
break;
}
}
if (foundBoard == false)
{
LikeList like_list = new LikeList(new List <int>(), skateboard, userNickname);
like_list.LikeUsers.Add(likedUserId);
likes.Add(like_list);
}
}
reader.Close();
}
conn.Close();
List <Skateboard> completeSkateboards = GetBoardsForLikeList();
foreach (Skateboard board in completeSkateboards)
{
foundBoard = false;
foreach (LikeList like in likes)
{
if (like.LikeSkateboard.SkateboardId.Equals(board.SkateboardId))
{
foundBoard = true;
break;
}
}
if (foundBoard == false)
{
LikeList like_list = new LikeList(new List <int>(), board, GetUserFromSkateboardId(board.SkateboardId).UserNickname);
likes.Add(like_list);
}
}
}
return(likes);
}
public InternBuilder()
{
skateboard = new Skateboard();
}
public void SaveChildEntities()
{
Executor executor = Executor.GetInstance();
executor.CreateTable <Order>();
executor.CreateTable <Skateboard>();
executor.CreateTable <Wheel>();
Order order = new Order
{
OrderDate = new DateTime(2021, 12, 5),
Address = "123 abc street"
};
var w = new Wheel {
Name = "1"
};
var w2 = new Wheel {
Name = "2"
};
var w3 = new Wheel {
Name = "3"
};
var w4 = new Wheel {
Name = "4"
};
var sk = new Skateboard
{
Brand = "Hotsauce",
DateCreated = new DateTime(2020, 5, 5),
IsColor = true,
Price = 45.99m,
Wheels = new List <Wheel> {
w, w2
}
};
var sk2 = new Skateboard
{
Brand = "Water",
DateCreated = new DateTime(2021, 2, 28),
IsColor = false,
Price = 48.99m,
Wheels = new List <Wheel> {
w3, w4
}
};
List <Skateboard> skateboards = new List <Skateboard>
{
sk,
sk2
};
order.Items = skateboards;
executor.Insert(order);
Assert.AreEqual(1L, order.Items[0].BoardId);
Assert.AreEqual(2L, order.Items[1].BoardId);
Assert.AreEqual("1", order.Items[0].Wheels[0].Name);
Assert.AreEqual("2", order.Items[0].Wheels[1].Name);
Assert.AreEqual("3", order.Items[1].Wheels[0].Name);
Assert.AreEqual("4", order.Items[1].Wheels[1].Name);
}
public void UpdateSkateboardPrice(Skateboard skateboard, decimal price)
{
skateboard.Price = price;
_executor.Update(skateboard);
}
public void MarkSkateboardAsDeleted(Skateboard skateboard)
{
skateboard.Deleted = true;
_executor.Update(skateboard);
}
