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(); }