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