//public virtual string GetNumOfActiveCustomers()
//{
// try
// {
// return DalOrder.NumOfActiveCustomers("");
// }
// catch
// {
// return "";
// }
//}
public virtual string GetNumOfCustomers()
{
try
{
return(DalOrder.NumOfCustomers("WHERE(((Users.UserType) = 4)) Group By Users.FirstName,Users.Email,Users.PhoneNumber"));
}
catch
{
return("");
}
}
/// <summary>
/// Get Num Of Active Customers
/// </summary>
/// <returns></returns>
public override string GetNumOfCustomers()
{
try
{
return(DalOrder.NumOfCustomers($" INNER JOIN Orders ON(Users.ID = Orders.CustomerID) WHERE(((Users.UserType)= 4) AND([Orders].[ShopID]= {GetShopId()})) "));
}
catch (Exception e)
{
return(e.Message);
}
}