public ResponseStoreList GetStoresForCDC(string aCDCID) { ResponseStoreList theResponse = new ResponseStoreList(); if (aCDCID == null || aCDCID.Equals("")) { theResponse.statusCode = 1; theResponse.statusDescription = "CDC ID is missing"; } else { openDataConnection(); SqlCommand cmdGet = new SqlCommand("GetStoresForCDC", theConnection); cmdGet.Parameters.AddWithValue("@cdcID", aCDCID); cmdGet.CommandType = System.Data.CommandType.StoredProcedure; try { theReader = cmdGet.ExecuteReader(); if (theReader.HasRows) { theResponse.stores = new List<Store>(); while (theReader.Read()) { Store thisStore = new Store(); thisStore.storeID = (int)theReader["StoreID"]; thisStore.storeName = theReader["StoreName"].ToString(); thisStore.storeAddress = theReader["StoreAddress"].ToString(); thisStore.storeCity = theReader["StoreCity"].ToString(); thisStore.storeZip = theReader["StoreZip"].ToString(); thisStore.storeState = theReader["StoreState"].ToString(); thisStore.storePhone = theReader["StorePhone"].ToString(); thisStore.storeManagerName = theReader["StoreManagerName"].ToString(); thisStore.storeEmailAddress = theReader["StoreEmail"].ToString(); thisStore.storeNumber = theReader["StoreNumber"].ToString(); thisStore.storeOwnershipType = theReader["StoreOwnershipType"].ToString(); theResponse.stores.Add(thisStore); } theResponse.statusCode = 0; theResponse.statusDescription = ""; } else { theResponse.statusCode = 4; theResponse.statusDescription = "There are no stores for CDC ID " + aCDCID; } theReader.Close(); } catch (Exception _exception) { theResponse.statusCode = 6; theResponse.statusDescription = _exception.Message; } closeDataConnection(); } return theResponse; }
public ResponseStoreList GetAllStoresWithRange(string startingIndex, string endingIndex) { ResponseStoreList theResponse = new ResponseStoreList(); openDataConnection(); SqlCommand cmdGetAllUsers = new SqlCommand("SELECT * FROM Store", theConnection); theReader = cmdGetAllUsers.ExecuteReader(); if (theReader.HasRows) { List<Store> listOfStores = new List<Store>(); int numRecords = 0; while (theReader.Read()) { Store thisStore = new Store(); thisStore.storeID = (int)theReader["StoreID"]; thisStore.storeName = theReader["StoreName"].ToString(); thisStore.storeAddress = theReader["StoreAddress"].ToString(); thisStore.storeCity = theReader["StoreCity"].ToString(); thisStore.storeZip = theReader["StoreZip"].ToString(); thisStore.storeState = theReader["StoreState"].ToString(); thisStore.storePhone = theReader["StorePhone"].ToString(); thisStore.storeManagerName = theReader["StoreManagerName"].ToString(); thisStore.storeEmailAddress = theReader["StoreEmail"].ToString(); thisStore.storeNumber = theReader["StoreNumber"].ToString(); thisStore.storeOwnershipType = theReader["StoreOwnershipType"].ToString(); listOfStores.Add(thisStore); numRecords++; } theResponse.stores = new List<Store>(); int startIndex = Int32.Parse(startingIndex); int endIndex = Int32.Parse(endingIndex); endIndex = startIndex + endIndex; if (startIndex <= 0) { startIndex = 1; } if (startIndex > 0 && endIndex >= startIndex) { if (endIndex > numRecords) { endIndex = numRecords; } for (int i = startIndex; i <= endIndex; i++) { theResponse.stores.Add(listOfStores[i - 1]); } theResponse.numberOfRecords = numRecords; theResponse.statusCode = 0; theResponse.statusDescription = ""; } else { theResponse.statusCode = 6; theResponse.statusDescription = "The starting or ending index did not fall within the data range"; } } else { theResponse.statusCode = 4; theResponse.statusDescription = "There are no stores in the database"; } theReader.Close(); closeDataConnection(); return theResponse; }
public ResponseStoreList GetStoreDetail(string aStoreID) { ResponseStoreList theResponse = new ResponseStoreList(); if (aStoreID.Equals("")) { theResponse.statusCode = 1; theResponse.statusDescription = "Store ID not provided"; return theResponse; } openDataConnection(); SqlCommand cmdUserDetail = new SqlCommand("SELECT * FROM Store WHERE StoreID = " + aStoreID + " OR StoreName = '" + aStoreID + "'", theConnection); theReader = cmdUserDetail.ExecuteReader(); if (theReader.HasRows) { theResponse.stores = new List<Store>(); while (theReader.Read()) { Store thisStore = new Store(); thisStore.storeID = (int)theReader["StoreID"]; thisStore.storeName = theReader["StoreName"].ToString(); thisStore.storeAddress = theReader["StoreAddress"].ToString(); thisStore.storeCity = theReader["StoreCity"].ToString(); thisStore.storeZip = theReader["StoreZip"].ToString(); thisStore.storeState = theReader["StoreState"].ToString(); thisStore.storePhone = theReader["StorePhone"].ToString(); thisStore.storeManagerName = theReader["StoreManagerName"].ToString(); thisStore.storeEmailAddress = theReader["StoreEmail"].ToString(); thisStore.storeNumber = theReader["StoreNumber"].ToString(); thisStore.storeOwnershipType = theReader["StoreOwnershipType"].ToString(); theResponse.stores.Add(thisStore); } theResponse.statusCode = 0; } else { theResponse.statusCode = 4; theResponse.statusDescription = "The store " + aStoreID + " could not be found"; } theReader.Close(); closeDataConnection(); return theResponse; }
public ResponseStoreList GetAllStores() { ResponseStoreList theResponse = new ResponseStoreList(); openDataConnection(); SqlCommand cmdGetAllUsers = new SqlCommand("SELECT * FROM Store", theConnection); theReader = cmdGetAllUsers.ExecuteReader(); if (theReader.HasRows) { List<Store> listOfStores = new List<Store>(); int numRecords = 0; while (theReader.Read()) { Store thisStore = new Store(); thisStore.storeID = (int)theReader["StoreID"]; thisStore.storeName = theReader["StoreName"].ToString(); thisStore.storeAddress = theReader["StoreAddress"].ToString(); thisStore.storeCity = theReader["StoreCity"].ToString(); thisStore.storeZip = theReader["StoreZip"].ToString(); thisStore.storeState = theReader["StoreState"].ToString(); thisStore.storePhone = theReader["StorePhone"].ToString(); thisStore.storeManagerName = theReader["StoreManagerName"].ToString(); thisStore.storeEmailAddress = theReader["StoreEmail"].ToString(); thisStore.storeNumber = theReader["StoreNumber"].ToString(); thisStore.storeOwnershipType = theReader["StoreOwnershipType"].ToString(); listOfStores.Add(thisStore); numRecords++; } theResponse.stores = listOfStores; theResponse.numberOfRecords = numRecords; theResponse.statusCode = 0; theResponse.statusDescription = ""; } else { theResponse.statusCode = 4; theResponse.statusDescription = "There are no stores in the database"; } theReader.Close(); closeDataConnection(); return theResponse; }