public UserController searchByEmail(string email)
{
bool wasOpen = true;
if (conn != null && conn.State == ConnectionState.Closed)
{
conn.Open();
wasOpen = false;
}
string strSelect = "Select * From StoreOwner where email=@email";
SqlCommand cmd = new SqlCommand(strSelect, conn);
cmd.Parameters.Add("@email", email);
SqlDataReader myReader = cmd.ExecuteReader();
if (myReader.Read())
{
string Nemail = myReader["email"].ToString();
string userName = myReader["userName"].ToString();
string password = myReader["password"].ToString();
List <StoreController> stores = new RegisteredStoresController().listStoresOfOwner(email);
StoreOwnerController storeOwner = new StoreOwnerController(email, userName, password, stores); conn.Close();
return(storeOwner);
}
if (!wasOpen)
{
conn.Close();
}
return(null);
}
public UserController registerStoreOwnerForOnSiteStore(string email, string userName, string password, string storeName, string storeAddress, [FromBody] string value)
{
UserController user = userFinder.findUser(email);
if (user != null)
{
return(null);
}
Store store = onsiteStoreSearcher.searchStoreByName(storeName);
if (store != null)
{
return(null);
}
StoreOwnerController storeOwnerUser = new StoreOwnerController(email, userName, password);
OnSiteStore onSiteStore = new OnSiteStore(storeName, storeAddress, storeOwnerUser.getStoreOwner());
onsiteStoreAdder.addStore(onSiteStore);
storeOwnerUser.addStore(onSiteStore);
storeOwnerRepo.addUser(storeOwnerUser.getStoreOwner());
return(storeOwnerUser);
}