public List <StoreRawData> GetStoresData(String userID)
{
DataTable dataTable = queries.GetStoresData(userID);
if (dataTable == null)
{
return(null);
}
List <StoreRawData> StoresList = new List <StoreRawData>();
foreach (DataRow row in dataTable.Rows)
{
String[] tpStr = new String[dataTable.Columns.Count];
int i = 0;
foreach (DataColumn col in dataTable.Columns)
{
tpStr[i] = row[col].ToString();
i++;
}
StoreRawData tempData = new StoreRawData();
tempData.Handler(tpStr);
StoresList.Add(tempData);
}
return(StoresList);
}
private void ShowStore_Click(object sender, EventArgs e)
{
if (MyStores.SelectedItem == null)
{
return;
}
String SelectedItem = MyStores.SelectedItem.ToString();
StoreRawData tempData = new StoreRawData();
tempData.RefactorString(SelectedItem);
String StoreID = tempData.ID;
String UserID = controllerSO.storeOwner.Data.ID;
StoreRawData storeRawData = new StoreRawData();
storeRawData.RefactorString(MyStores.SelectedItem.ToString());
Statistics statistics = controllerSO.GetStoreStat(storeRawData.ID);
UserStoreData userStoreData = new UserStoreData(UserID, storeRawData, statistics);
Store store = new Store(userStoreData);
StoreController storeController = new StoreController(store);
StoreProductController storeProductController = new StoreProductController();
StoreLayoutPage storeLayoutPage = new StoreLayoutPage(controllerSO, storeController, storeProductController, false);
storeLayoutPage.Show();
}
private void DeleteStores_Click(object sender, EventArgs e)
{
if (MyStores.SelectedItem == null)
{
return;
}
String SelectedItem = MyStores.SelectedItem.ToString();
StoreRawData tempData = new StoreRawData();
tempData.RefactorString(SelectedItem);
String UserID = controllerSO.storeOwner.Data.ID;
String StoreID = tempData.ID;
bool DONE = this.controllerSO.DeleteStore(UserID, StoreID);
if (DONE)
{
MessageBox.Show("Store Deleted");
}
else
{
MessageBox.Show("Store Deletion failed");
}
this.RefreshStoreList_Click(sender, e);
}
private void OpenStore_Click(object sender, EventArgs e)
{
Products.Items.Clear();
if (Store.SelectedItem == null)
{
return;
}
String selected = Store.SelectedItem.ToString();
StoreRawData storeRawData = new StoreRawData();
storeRawData.RefactorString(selected);
List <StoreProduct> storeProducts = controllerStoreProduct.GetStoreProducts(storeRawData.ID);
if (storeProducts == null)
{
return;
}
foreach (StoreProduct product in storeProducts)
{
Products.Items.Add(product.ToString());
}
}
public void RefreshData()
{
String cmd1 = "select count(UserID) from UserStore where UserID = " + Data.ID + "";
DataTable tp = dataBase.Query(cmd1);
int sz = System.Convert.ToInt32(tp.Rows[0][0].ToString());
storeslist = new Store[sz];
String cmd2 = "select Store.StoreID,StoreName,StoreType,StoreLocation,StoreInfo from Store inner join UserStore on Store.StoreID = UserStore.StoreID and UserStore.UserID = " + Data.ID;
DataTable tpData = dataBase.Query(cmd2);
int i = 0;
foreach (DataRow row in tpData.Rows)
{
String tpStr = "";
foreach (DataColumn col in tpData.Columns)
{
tpStr += row[col].ToString() + ",";
}
StoreRawData tpStoreData = new StoreRawData();
tpStoreData.Handler(tpStr.Split(','));
//storeslist[i] = new Store(tpStoreData);
i++;
}
}
///////////////////////////////////// Store Request /////////////////////////////////////
public List <StoreRequest> GetStoreRequest()
{
DataTable dataTable = queries.GetStoreRequest();
if (dataTable == null)
{
return(null);
}
List <StoreRequest> requestList = new List <StoreRequest>();
foreach (DataRow row in dataTable.Rows)
{
String[] tpStr = new String[dataTable.Columns.Count];
int i = 0;
foreach (DataColumn col in dataTable.Columns)
{
tpStr[i] = row[col].ToString();
i++;
}
String StoreRequestID = tpStr[0];
String UserID = tpStr[1];
String[] storeString = new String[tpStr.Length - 2];
for (int j = 2, k = 0; j < tpStr.Length; j++, k++)
{
storeString[k] = tpStr[j];
}
StoreRawData storeData = new StoreRawData();
storeData.Handler(storeString);
StoreRequest tempData = new StoreRequest(StoreRequestID, UserID, storeData);
requestList.Add(tempData);
}
return(requestList);
}
