public Task <bool> AddNewReview(NewReviewDTO data) => Task.Run(() =>
{
if (UserExists(data.customerId) && ShopExists(data.shopId) && RatingIsValid(data.reviewRating) && ReviewCommentIsValid(data.reviewComment))
{
Reviews review = new Reviews
{
reviewId = Guid.NewGuid().ToString(),
customerId = data.customerId,
customerName = data.customerName,
shopId = data.shopId,
reviewRating = data.reviewRating,
reviewComment = data.reviewComment
};
try
{
context.Reviews.Add(review);
context.SaveChanges();
}
catch (DbUpdateException)
{
return(false);
}
return(true);
}
else
{
return(false);
}
});
public IActionResult addReview([FromForm] string username, [FromForm] int rating, [FromForm] string text, string name)
{
if (rating > 0 && rating <= 5)
{
try
{
using SYLContext db = new SYLContext();
var review = new Review
{
Username = username,
Rating = rating,
Text = text,
SellerName = name
};
db.Reviews.Add(review);
db.SaveChanges();
return(Ok());
}catch (SqlException sqlex) {
_logger.LogInformation("SqlException happened. Probably primary key collision: " + sqlex);
return(BadRequest());
}catch (Exception e)
{
_logger.LogInformation("Exception happened: " + e);
return(StatusCode(500));
}
}
return(BadRequest());
}
public Task <bool> AddNewUser(NewUserDTO data) => Task.Run(() =>
{
Users user = new Users
{
userId = Guid.NewGuid().ToString(),
userName = data.userName,
userLastName = data.userLastName,
userEmail = data.userEmail,
userPassword = data.userPassword,
userType = data.userType
};
try
{
context.Users.Add(user);
context.SaveChanges();
}
catch (DbUpdateException)
{
return(false);
}
return(true);
});
public void createSeller([FromForm] string sellerName, [FromForm] string adress, [FromForm] string pass, [FromForm] string email)
{
using SYLContext db = new SYLContext();
var seller = new Seller
{
SellerName = sellerName,
Adress = adress,
Password = pass,
Email = email
};
db.Sellers.Add(seller);
db.SaveChanges();
}
public void addProduct([FromForm] int shopID, [FromForm] double price, [FromForm] string name, [FromForm] int pID)
{
if (price > 0 && shopID >= 0 && pID >= 0)
{
using SYLContext db = new SYLContext();
var product = new Product
{
ShopId = shopID,
Name = name,
Price = price,
ProductTypeId = pID
};
db.Products.Add(product);
db.SaveChanges();
}
}
public void addOrder([FromForm] string name, [FromForm] string time, [FromForm] double quantity, [FromForm] int bID, [FromForm] int sID)
{
if (Regex.IsMatch(time, @"^[0-2]\d:[0-5]\d$") && quantity > 0 && bID >= 0 && sID >= 0)
{
using SYLContext db = new SYLContext();
var order = new Order
{
Name = name,
Time = TimeSpan.Parse(time),
Quantity = quantity,
BuyerId = bID,
SellerId = sID
};
db.Orders.Add(order);
db.SaveChanges();
}
}
private void Seed(SYLContext context)
{
var users = new[]
{
new Users {
userEmail = "*****@*****.**",
userId = "TestUser-1",
userLastName = "Test",
userName = "******",
userPassword = "******",
userType = 1
},
new Users {
userEmail = "*****@*****.**",
userId = "TestUser-2",
userLastName = "Test",
userName = "******",
userPassword = "******",
userType = 0
}
};
context.Users.AddRange(users);
context.SaveChanges();
var shops = new[]
{
new Shops
{
shopAddress = "Test str. 1",
sellerId = "TestUser-2",
shopId = "TestShop-1",
shopName = "Test1"
},
new Shops
{
shopAddress = "Test str. 2",
sellerId = "TestUser-2",
shopId = "TestShop-2",
shopName = "Test2"
}
};
context.Shops.AddRange(shops);
context.SaveChanges();
var reviews = new[]
{
new Reviews
{
reviewComment = "TestComment -1",
reviewId = "Review-1",
reviewRating = 1,
customerId = "TestUser-1",
shopId = "TestShop-1",
customerName = "Test"
},
new Reviews
{
reviewComment = "TestComment -2",
reviewId = "Review-2",
reviewRating = 3,
customerId = "TestUser-1",
shopId = "TestShop-2",
customerName = "Test"
},
new Reviews
{
reviewComment = "TestComment -3",
reviewId = "Review-3",
reviewRating = 5,
customerId = "TestUser-2",
shopId = "TestShop-2",
customerName = "Test"
}
};
context.Reviews.AddRange(reviews);
context.SaveChanges();
}
