public List <StoreController> listOwnerStores(string email)
{
bool wasOpen = true;
if (conn != null && conn.State == ConnectionState.Closed)
{
conn.Open();
wasOpen = false;
}
string strSelect = "Select * From OnlineStore where storeOwner=@email";
SqlCommand cmd = new SqlCommand(strSelect, conn);
cmd.Parameters.Add("@email", email);
SqlDataReader myReader = cmd.ExecuteReader();
List <StoreController> stores = new List <StoreController>();
while (myReader.Read())
{
string storename = myReader["storeName"].ToString();
string storeaddress = myReader["storeAddress"].ToString();
string storeowner = myReader["storeOwner"].ToString();
StoreOwnerDataBase sodb = new StoreOwnerDataBase();
StoreOwnerController storeOwner = (StoreOwnerController)sodb.searchByEmail(storeowner);
StoreController store = new OnlineStoreController(storename, storeaddress, storeOwner);
stores.Add(store);
}
if (!wasOpen)
{
conn.Close();
}
return(stores);
}
public StoreController searchStoreByName(string name)
{
conn.Open();
string strSelect = "Select * From OnlineStore where storeName=@name";
SqlCommand cmd = new SqlCommand(strSelect, conn);
cmd.Parameters.Add("@name", name);
SqlDataReader myReader = cmd.ExecuteReader();
if (myReader.Read())
{
string storename = myReader["storeName"].ToString();
string storeaddress = myReader["storeAddress"].ToString();
string storeowner = myReader["storeOwner"].ToString();
StoreOwnerDataBase sodb = new StoreOwnerDataBase();
StoreOwnerController storeOwner = (StoreOwnerController)sodb.searchByEmail(storeowner);
StoreController store = new OnlineStoreController(storename, storeaddress, storeOwner);
conn.Close();
return(store);
}
conn.Close();
return(null);
}
