public void getAllStoreDetails(string clientID, string categoryIDs,string storeType)
{
try
{
MySQLBusinessLogic bl = new MySQLBusinessLogic();
DataTable dt = new DataTable();
if (categoryIDs == "" && storeType=="")
dt = bl.GetAllStores();
else
{
//get list of Store ID's from category id
List<string> lst = new List<string>();
string storeIDS = "";
if (categoryIDs != "")
{
lst = bl.GetStoresbyCategoryID(categoryIDs);
storeIDS = String.Join(",", lst);
}
//return all stores
//if (lst.Count > 0)
dt = bl.GetStoresByStoreID(storeIDS, storeType);
//else
// Clients.Client(clientID).gotStores("0");
}
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
DataTable temp = new DataTable();
for (int c = 0; c < dt.Columns.Count; c++)
{
DataColumn dc = new DataColumn();
dc.ColumnName = dt.Columns[c].ToString();
if (dc.ColumnName == "StoreImage")
{
dc.DataType = typeof(string);
}
else
dc.DataType = dt.Columns[c].DataType;
temp.Columns.Add(dc);
}
//temp.Rows[i].ItemArray = dt.Rows[i].ItemArray;
temp.ImportRow(dt.Rows[i]);
string ImageUrl = "NoImage";
if (dt.Rows[i]["StoreImage"].GetType().Name != "DBNull")
{
byte[] bytes = (Byte[])dt.Rows[i]["StoreImage"];
string base64String = Convert.ToBase64String(bytes, 0, bytes.Length);
ImageUrl = "data:image/png;base64," + base64String;
}
temp.Rows[0]["StoreImage"] = ImageUrl;
string json = ConvertDataTabletoString(temp);
Clients.Client(clientID).gotStores("1", json);
}
}
else
{
Clients.Client(clientID).gotStores("0");
}
}
catch (Exception ex)
{
}
}