public static int Delete(SQLiteConnection conn, UserDriver vm) { if (vm == null) { return(-2); } if (vm.Id < 0) { return(-3); } using (SQLiteCommand cmd = new SQLiteCommand(delete, conn)) { cmd.Parameters.AddWithValue("@Id", vm.Id); try { cmd.ExecuteNonQuery(); } catch (Exception e) { Trace.WriteLine($"EXCEPTION: UserAdminDbMapper.Delete: {e.Message}"); return(-1); } } return(0); }
public void DidntEnterSystemRemoveItem() { _bridgeGuest2 = UserDriver.getBridge(); MarketAnswer res = _bridgeGuest2.RemoveFromCart("BlahStore2", "doritos", 30); Assert.AreEqual((int)RemoveFromCartStatus.DidntEnterSystem, res.Status); }
private void UserWatchStockInitialize() { _userWatchStock = UserDriver.getBridge(); _userWatchStock.EnterSystem(); _storeBridgeGuest = StoreShoppingDriver.getBridge(); _storeBridgeGuest.GetStoreShoppingService(_userWatchStock.GetUserSession()); }
public static int Insert(SQLiteConnection conn, UserDriver um) { if (um == null) { return(-2); } using (SQLiteCommand cmd = new SQLiteCommand(insert, conn)) { cmd.Parameters.AddWithValue("@FirstName", um.FirstName); cmd.Parameters.AddWithValue("@LastName", um.LastName); cmd.Parameters.AddWithValue("@Email", um.Email); cmd.Parameters.AddWithValue("@Phone", um.Phone); cmd.Parameters.AddWithValue("@Street", um.Street); cmd.Parameters.AddWithValue("@City", um.City); cmd.Parameters.AddWithValue("@Zip", um.Zip); cmd.Parameters.AddWithValue("@Active", um.Active); cmd.Parameters.AddWithValue("@QualificationTo", um.QualificationTo); try { cmd.ExecuteNonQuery(); } catch (Exception e) { Trace.WriteLine($"EXCEPTION: UserAdminDbMapper.Insert: {e.Message}"); return(-1); } } return(0); }
public User Get(int id) { connection.Command.Parameters.Clear(); connection.Command.CommandText = "select * from users where id=@id"; connection.Command.Parameters.AddWithValue("@id", id); User user = null; using (MySqlDataReader reader = connection.Command.ExecuteReader()) { if (reader.HasRows) // если есть данные { while (reader.Read()) { if ((string)reader.GetValue(3) == "D") { user = new UserDriver((int)reader.GetValue(0), (string)reader.GetValue(1), (string)reader.GetValue(2), (string)reader.GetValue(4)); } else if ((string)reader.GetValue(3) == "O") { user = new Operator((int)reader.GetValue(0), (string)reader.GetValue(1), (string)reader.GetValue(2), (string)reader.GetValue(4)); } else if ((string)reader.GetValue(3) == "A") { user = new Admin((int)reader.GetValue(0), (string)reader.GetValue(1), (string)reader.GetValue(2), (string)reader.GetValue(4)); } } } } return(user); }
public void DidntEnterSystemChangeQuantity() { _bridgeGuest2 = UserDriver.getBridge(); MarketAnswer res = _bridgeGuest2.EditCartItem("BlahStore", "bisli", 1, 200); Assert.AreEqual((int)EditCartItemStatus.DidntEnterSystem, res.Status); }
public ActionResult Put([FromBody] UserDriver userDriver) { var userExists = _dbContext.UsersDrivers.AsNoTracking() .Where(u => u.Id == userDriver.Id && u.UserClientId == userDriver.UserClient.Id && u.UserClient.UserId == userDriver.UserClient.User.Id) .FirstOrDefault(); if (userExists == null) { return(NotFound()); } var userUpdate = _dbContext.Attach(userDriver.UserClient.User); userUpdate.State = EntityState.Modified; var userClientUpdate = _dbContext.Attach(userDriver.UserClient); userClientUpdate.State = EntityState.Modified; var userDriverUpdate = _dbContext.Attach(userDriver); userDriverUpdate.State = EntityState.Modified; _dbContext.SaveChanges(); return(Ok()); }
public void LotteryFailGuest() { _buyerGuestBridge = UserDriver.getBridge(); _buyerGuestBridge.EnterSystem(); _orderBridge1 = OrderDriver.getBridge(); _orderBridge1.GetOrderService(_buyerGuestBridge.GetUserSession()); Assert.AreEqual((int)OrderStatus.InvalidUser, _orderBridge1.BuyLotteryTicket("Fanta", storeName, 1, 4).Status); }
private void MakeRegisteredShopper3() { _buyerRegisteredUserBridge3 = UserDriver.getBridge(); _buyerRegisteredUserBridge3.EnterSystem(); _buyerRegisteredUserBridge3.SignUp("Shalom3", "Bye3", "555", "55555555"); _orderBridge3 = OrderDriver.getBridge(); _orderBridge3.GetOrderService(_buyerRegisteredUserBridge3.GetUserSession()); }
public void RegistrationWithATakenName() { _bridge.EnterSystem(); _bridge.SignUp("Pnina", "miahol susia 12", "123456", "12345678"); _bridge2 = UserDriver.getBridge(); _bridge2.EnterSystem(); Assert.AreEqual((int)SignUpStatus.TakenName, _bridge2.SignUp("Pnina", "miahol susia 12", "123456", "12345678").Status); }
// GET: Drivers/Edit/5 public ActionResult Edit(int id) { sqlconn.Open(); UserDriver driver = UserDriverLogic.FindById(sqlconn, id); sqlconn.Close(); return(View(driver)); }
public void MarketBuilder() { MarketDB.Instance.InsertByForce(); SignIn(); CreateStore1AndProducts(); CreateStore2AndProducts(); _bridgeSignUp = UserDriver.getBridge(); _storeBridge3 = null; }
private void AddProductsToCartGuest() { _buyerGuestBridge = UserDriver.getBridge(); _buyerGuestBridge.EnterSystem(); _shoppingBridge2 = StoreShoppingDriver.getBridge(); _shoppingBridge2.GetStoreShoppingService(_buyerGuestBridge.GetUserSession()); _shoppingBridge2.AddProductToCart("Yalla", "Tea", 4); _shoppingBridge2.AddProductToCart("HAHAHA", "Coffee", 3); }
public void SuccessDeleteUserNotSoleOwner() { SignIn(adminName, adminPass); _adminBridge.GetAdminService(_adminSignInBridge.GetUserSession()); Assert.AreEqual((int)RemoveUserStatus.Success, _adminBridge.RemoveUser(userNotSoleStoreOwner).Status); _signInBridge = UserDriver.getBridge(); _signInBridge.EnterSystem(); Assert.AreEqual((int)SignInStatus.NoUserFound, _signInBridge.SignIn(userNotSoleStoreOwner, userNotSoleStoreOwnerPass).Status); }
private void AddProductsToCartRegisteredUser() { _buyerRegisteredUserBridge = UserDriver.getBridge(); _buyerRegisteredUserBridge.EnterSystem(); _buyerRegisteredUserBridge.SignUp("Shalom", "Bye", "555", "55555555"); _shoppingBridge2 = StoreShoppingDriver.getBridge(); _shoppingBridge2.GetStoreShoppingService(_buyerRegisteredUserBridge.GetUserSession()); _shoppingBridge2.AddProductToCart("Yalla", "Tea", 4); _shoppingBridge2.AddProductToCart("HAHAHA", "Coffee", 3); }
public void InvalidUserDidntEnterSystem() { _userWatchStore = UserDriver.getBridge(); _storeBridgeGuest = StoreShoppingDriver.getBridge(); _storeBridgeGuest.GetStoreShoppingService(_userWatchStore.GetUserSession()); MarketAnswer storeDetails = _storeBridgeGuest.ViewStoreInfo("OOF"); Assert.AreEqual((int)ViewStoreStatus.InvalidUser, storeDetails.Status); Assert.AreEqual(null, storeDetails.ReportList); }
public ActionResult Post([FromBody] UserDriver userDriver) { //_dbContext.Add(userClient.User); //_dbContext.Add(userClient); _dbContext.Add(userDriver); _dbContext.SaveChanges(); return(Created("", userDriver)); }
public void MarketBuilder() { MarketDB.Instance.InsertByForce(); _ownerStoreBridge = StoreManagementDriver.getBridge(); _userBridge = UserDriver.getBridge(); _userBridge.EnterSystem(); _userBridge.SignUp("Pnina", "misholSusia", "852852", "77777777"); _storeShopping = StoreShoppingDriver.getBridge(); _storeShopping.GetStoreShoppingService(_userBridge.GetUserSession()); _storeShopping.OpenStore("HistoryShop", "blah"); _ownerStoreBridge.GetStoreManagementService(_userBridge.GetUserSession(), "HistoryShop"); }
public void GuestViewStore() { _userWatchStore = UserDriver.getBridge(); _userWatchStore.EnterSystem(); _storeBridgeGuest = StoreShoppingDriver.getBridge(); _storeBridgeGuest.GetStoreShoppingService(_userWatchStore.GetUserSession()); MarketAnswer storeDetails = _storeBridgeGuest.ViewStoreInfo("OOF"); Assert.AreEqual((int)ViewStoreStatus.Success, storeDetails.Status); string expectedAnswer = "_storeName: OOF StoreAddress: BASA"; string receivedAnswer = "_storeName: " + storeDetails.ReportList[0] + " StoreAddress: " + storeDetails.ReportList[1]; Assert.AreEqual(expectedAnswer, receivedAnswer); }
public void SuccessDeleteUserSoleOwner() { SignIn(adminName, adminPass); _adminBridge.GetAdminService(_adminSignInBridge.GetUserSession()); _signInBridge = UserDriver.getBridge(); _signInBridge.EnterSystem(); Assert.AreEqual((int)RemoveUserStatus.Success, _adminBridge.RemoveUser(userSoleStoreOwner).Status); _managerBridge = StoreManagementDriver.getBridge(); _managerBridge.GetStoreManagementService(_adminSignInBridge.GetUserSession(), "blah"); var res = _managerBridge.CloseStore(); Assert.AreEqual((int)StoreEnum.StoreNotExists, res.Status); Assert.AreEqual((int)SignInStatus.NoUserFound, _signInBridge.SignIn(userSoleStoreOwner, userSoleStoreOwnerPass).Status); }
public void MarketBuilder() { MarketDB.Instance.InsertByForce(); _bridge = UserDriver.getBridge(); _bridge1 = UserDriver.getBridge(); _bridgeGuest = UserDriver.getBridge(); _bridgeGuest.EnterSystem(); _bridge1.EnterSystem(); _bridge1.SignUp("vika", "arad", "6666", "11111111"); CreateStore1AndProducts(); CreateStore2AndProducts(); User1AddToCart(); GuestAddToCart(); _storeGuestBridge = null; }
public void AdminSystemSucceededPromote() { _adminBridge = UserDriver.getBridge(); _adminBridge.EnterSystem(); _adminBridge.SignIn(adminName, adminPass); _storeManager1.GetStoreManagementService(_adminBridge.GetUserSession(), "basush"); MarketAnswer res = _storeManager1.PromoteToStoreManager("eurovision", "StoreOwner"); Assert.AreEqual((int)PromoteStoreStatus.Success, res.Status); //check if eurovision can promote someone himself - if not, he is not an owner SignIn("eurovision", "852963"); _storeManager2 = StoreManagementDriver.getBridge(); _storeManager2.GetStoreManagementService(_signInBridge.GetUserSession(), "basush"); Assert.AreEqual((int)PromoteStoreStatus.Success, _storeManager2.PromoteToStoreManager("blah", "StoreOwner").Status); }
public void MarketBuilder() { MarketDB.Instance.InsertByForce(); SignUp("Pnina", "mishol", "666", "66666666"); OpenStoreAndAddProducts(); _orderBridge = OrderDriver.getBridge(); _userAdminBridge = UserDriver.getBridge(); _userAdminBridge.EnterSystem(); MarketAnswer res = _userAdminBridge.SignIn("Arik1", "123"); _adminBridge = AdminDriver.getBridge(); _adminBridge.GetAdminService(_userAdminBridge.GetUserSession()); _buyerRegisteredUserBridge = null; _buyerGuestBridge = null; PaymentService.Instance.FixExternal(); SupplyService.Instance.FixExternal(); }
public ActionResult Edit(int id, UserDriver driver) { try { sqlconn.Open(); int result = UserDriverLogic.Update(sqlconn, driver); sqlconn.Close(); if (result != 0) { throw new Exception(); } return(RedirectToAction(nameof(Index))); } catch { return(View(driver)); } }
public void MarketBuilder() { MarketYard.SetDateTime(Convert.ToDateTime("14/04/2018")); MarketDB.Instance.InsertByForce(); SignUpStoreOwner("Pnina", "mishol", "666", "66666666"); OpenStoreAndAddProducts(); _userAdminBridge = UserDriver.getBridge(); _userAdminBridge.EnterSystem(); _userAdminBridge.SignIn("Arik1", "123"); _adminBridge = AdminDriver.getBridge(); _adminBridge.GetAdminService(_userAdminBridge.GetUserSession()); _buyerRegisteredUserBridge1 = null; _buyerRegisteredUserBridge2 = null; _buyerRegisteredUserBridge3 = null; _orderBridge1 = null; _orderBridge2 = null; _orderBridge3 = null; _buyerGuestBridge = null; PaymentService.Instance.FixExternal(); SupplyService.Instance.FixExternal(); }
public static List <UserDriver> SelectAll(SQLiteConnection conn) { List <UserDriver> result = new List <UserDriver>(); using (SQLiteCommand cmd = new SQLiteCommand(selectAll, conn)) { SQLiteDataReader reader = null; try { reader = cmd.ExecuteReader(); while (reader.Read()) { UserDriver um = new UserDriver() { Id = Convert.ToInt32(reader["rowid"].ToString()), FirstName = reader["FirstName"].ToString(), LastName = reader["LastName"].ToString(), Email = reader["Email"].ToString(), Phone = reader["Phone"].ToString(), Street = reader["Street"].ToString(), City = reader["City"].ToString(), Zip = reader["Zip"].ToString(), Active = Convert.ToBoolean(reader["Active"]), QualificationTo = Convert.ToDateTime(reader["QualificationTo"]) }; result.Add(um); } } catch (Exception e) { Trace.WriteLine($"EXCEPTION: UserAdminDbMapper.SelectAll: {e.Message}"); } finally { reader?.Close(); } } return(result); }
public static UserDriver SelectById(SQLiteConnection conn, int id) { if (id < 0) { return(null); } using (SQLiteCommand cmd = new SQLiteCommand(selectById, conn)) { cmd.Parameters.AddWithValue("@Id", id); SQLiteDataReader reader = null; try { reader = cmd.ExecuteReader(); while (reader.Read()) { UserDriver um = new UserDriver() { Id = Convert.ToInt32(reader["rowid"].ToString()), FirstName = reader["FirstName"].ToString(), LastName = reader["LastName"].ToString(), Email = reader["Email"].ToString(), Phone = reader["Phone"].ToString(), Street = reader["Street"].ToString(), City = reader["City"].ToString(), Zip = reader["Zip"].ToString(), Active = Convert.ToBoolean(reader["Active"]), QualificationTo = Convert.ToDateTime(reader["QualificationTo"]) }; reader.Close(); return(um); } } catch (Exception e) { reader?.Close(); Trace.WriteLine($"EXCEPTION: UserAdminDbMapper.SelectById: {e.Message}"); } } return(null); }
private void AddProductsToCartGuest() { _buyerGuestBridge = UserDriver.getBridge(); _buyerGuestBridge.EnterSystem(); _shoppingBridge2 = StoreShoppingDriver.getBridge(); _shoppingBridge2.GetStoreShoppingService(_buyerGuestBridge.GetUserSession()); _shoppingBridge2.AddProductToCart("Yalla", "Tea", 4); _shoppingBridge2.AddProductToCart("HAHAHA", "Coffee", 3); MarketAnswer cartDetails = _buyerGuestBridge.ViewCart(); string[] received = cartDetails.ReportList; string[] expected = { "Name : Coffee Store : HAHAHA Quantity : 3 Unit Price : 10 Final Price : 30", "Name : Tea Store : Yalla Quantity : 4 Unit Price : 10 Final Price : 40" }; Assert.AreEqual(expected.Length, cartDetails.ReportList.Length); for (int i = 0; i < received.Length; i++) { Assert.AreEqual(expected[i], received[i]); } }
private void GuestEnter() { _guestBridge = UserDriver.getBridge(); _guestBridge.EnterSystem(); }
private void SignIn(string name, string password) { _signInBridge = UserDriver.getBridge(); _signInBridge.EnterSystem(); _signInBridge.SignIn(name, password); }