public List <User> listUsers()
{
List <StoreOwner> StoreOwners = new List <StoreOwner>();
bool wasOpen = true;
if (conn != null && conn.State == ConnectionState.Closed)
{
conn.Open();
wasOpen = false;
}
string strSelect = "Select * From StoreOwner ";
SqlCommand cmd = new SqlCommand(strSelect, conn);
SqlDataReader myReader = cmd.ExecuteReader();
while (myReader.Read())
{
string email = myReader["email"].ToString();
string userName = myReader["userName"].ToString();
string password = myReader["password"].ToString();
List <StoreController> stores = new RegisteredStoresController().listStoresOfOwner(email);
StoreOwner storeOwner = new StoreOwner(email, userName, password, stores);
StoreOwners.Add(storeOwner);
}
myReader.Close();
if (!wasOpen)
{
conn.Close();
}
return(new List <User>(StoreOwners));
}
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);
}
