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