/// <summary>
/// Gets opened documents data as a csv string
/// </summary>
public static string GetOpenedDocumentsData(string documentTitle, int userId, int clientId, int sellerId, string note,
DateTime dateFrom, DateTime dateTo, string orderby, string orderdir, int currentSellerId, int productId)
{
var data = DB.GetOpenedDocuments(documentTitle, userId, clientId, sellerId, note, dateFrom, dateTo, 0, int.MaxValue, orderby, orderdir, currentSellerId, productId);
return(DBUtil.ConstructCSVStringFromData(data));
}
/// <summary>
/// Gets users data as a csv string
/// </summary>
public static string GetUsersData(string searchText, string sortBy, string sortDir, int userTypeId, int sellerId, string note,
int minLoginCount, int maxLoginCount, int originId, int currentSellerId)
{
var data = DB.GetUsersStat(searchText, 0, int.MaxValue, sortBy, sortDir, userTypeId, sellerId, note, minLoginCount, maxLoginCount, originId, currentSellerId);
return(DBUtil.ConstructCSVStringFromData(data));
}
/// <summary>
/// Gets last logins data as a csv string
/// </summary>
public static string GetLastLoginsData(DateTime dateFrom, DateTime dateTo, int userId, int sellerId, int clientId, bool showOnlyNulls, string note, string orderby, string orderdir, int currentSellerId)
{
var data = new List <IDataRecord>();
if (showOnlyNulls)
{
data = DB.GetLastLoginsNulls(userId, sellerId, clientId, dateFrom, dateTo, 0, int.MaxValue, orderby, orderdir, note, currentSellerId) as List <IDataRecord>;
}
else
{
data = DB.GetLastLogins(userId, sellerId, clientId, dateFrom, dateTo, 0, int.MaxValue, orderby, orderdir, note, currentSellerId) as List <IDataRecord>;
}
return(DBUtil.ConstructCSVStringFromData(data));
}
/// <summary>
/// Gets searches data as a csv string
/// </summary>
public static string GetSearchesData(string searchText)
{
var data = DB.GetStatSearches(searchText, int.MaxValue);
return(DBUtil.ConstructCSVStringFromData(data));
}
/// <summary>
/// Gets logins data as a csv string
/// </summary>
public static string GetLoginsData(int browserId, DateTime dateFrom, DateTime dateTo, string orderby, string orderdir, string searchText, int currentSellerId)
{
var data = DB.GetLogins(browserId, dateFrom, dateTo, 0, int.MaxValue, orderby, orderdir, searchText, currentSellerId);
return(DBUtil.ConstructCSVStringFromData(data));
}
/// <summary>
/// Gets clients data as a csv string
/// </summary>
public static string GetClientsData(string searchText, string sortBy, string sortDir, int sellerId, int currentSellerId, int originId)
{
var data = DB.GetClientsStats(searchText, 0, int.MaxValue, sortBy, sortDir, sellerId, currentSellerId, originId);
return(DBUtil.ConstructCSVStringFromData(data));
}
