public string GetCustomersByCountry(object context, string path)
{
IDictionary <string, object> contextDictionary = (IDictionary <string, object>)context;
string country = ((string)contextDictionary["Value"]);
DataTable customers = ToolTipWebService.DB_GetCustomersByCountry(country);
if (customers.Rows.Count > 0)
{
return(ViewManager.RenderView(path + "Customers.ascx", customers));
}
else
{
return(ViewManager.RenderView(path + "NoCustomers.ascx", null));
}
}
public static DataTable DB_GetOrdersByCustomer(string customerID)
{
return(ToolTipWebService.DB_GetDataTable("SELECT * FROM [Orders] WHERE CustomerID=@id", customerID));
}
public static DataTable DB_GetCustomersByCountry(string Country)
{
return(ToolTipWebService.DB_GetDataTable("SELECT * FROM [Customers] WHERE Country=@id", Country));
}
