protected void get_report(ModuleIdentifier moduleIdentifier, string reportName, bool excel, bool rtl,
bool isPersian, ref Dictionary <string, string> dic, int pageNumber, int pageSize, ref string responseText,
List <ReportParameter> parameters, string password)
{
//Privacy Check: OK
if (!paramsContainer.GBEdit)
{
return;
}
bool isSystemAdmin =
PublicMethods.is_system_admin(paramsContainer.Tenant.Id, paramsContainer.CurrentUserID.Value);
Guid?reportId = ReportUtilities.get_report_id(moduleIdentifier, reportName);
bool hasAccess = reportId.HasValue && (isSystemAdmin ||
AuthorizationManager.has_right(AccessRoleName.Reports, paramsContainer.CurrentUserID));
hasAccess = hasAccess && (isSystemAdmin ||
PrivacyController.check_access(paramsContainer.Tenant.Id, paramsContainer.CurrentUserID,
reportId.Value, PrivacyObjectType.Report, PermissionType.View));
if (!hasAccess)
{
responseText = "{\"ErrorText\":\"" + Messages.AccessDenied + "\"}";
return;
}
DataTable tbl = new DataTable();
string actions = string.Empty;
Dictionary <string, string> columnsDic = new Dictionary <string, string>();
ReportsController.get_report(paramsContainer.Tenant.Id,
moduleIdentifier, reportName, ref tbl, ref actions, ref columnsDic, parameters);
int firstRow = excel ? 0 : (pageSize * (pageNumber - 1));
int lastRow = (excel ? tbl.Rows.Count : Math.Min(firstRow + pageSize, tbl.Rows.Count)) - 1;
for (int c = 0; c < tbl.Columns.Count; ++c)
{
if (tbl.Columns[c].DataType != typeof(string) || tbl.Columns[c].ColumnName.IndexOf("_HTML") < 0)
{
continue;
}
tbl.Columns[c].ColumnName = tbl.Columns[c].ColumnName.Replace("_HTML", string.Empty);
for (int r = firstRow; r <= lastRow; ++r)
{
if (tbl.Rows[r][c] != DBNull.Value && !string.IsNullOrEmpty((string)tbl.Rows[r][c]))
{
//tbl.Rows[r][c] = PublicMethods.markup2plaintext(
//Expressions.replace((string)tbl.Rows[r][c], Expressions.Patterns.HTMLTag, " ")).Trim();
string str = (string)tbl.Rows[r][c];
str = Expressions.replace(str, Expressions.Patterns.HTMLTag, " ");
str = PublicMethods.markup2plaintext(paramsContainer.Tenant.Id, str).Trim();
tbl.Rows[r][c] = str;
}
}
}
if (excel)
{
try
{
Dictionary <string, bool> usedColNames = new Dictionary <string, bool>();
foreach (string n in dic.Values)
{
usedColNames[n] = true;
}
for (int c = 0; c < tbl.Columns.Count; ++c)
{
if (columnsDic.ContainsKey(tbl.Columns[c].ColumnName))
{
string colName = columnsDic[tbl.Columns[c].ColumnName];
int num = 1;
while (true)
{
string tmpName = colName + (num <= 1 ? string.Empty : " (" + num.ToString() + ")");
if (!usedColNames.ContainsKey(tmpName))
{
usedColNames[tmpName] = true;
colName = tmpName;
break;
}
else
{
++num;
}
}
tbl.Columns[c].ColumnName = colName;
}
bool isString = tbl.Columns[c].DataType == typeof(string);
bool isDic = tbl.Columns[c].ColumnName.IndexOf("_Dic") >= 0;
if (isString && isDic)
{
Dictionary <string, string> colDic = _get_dictionary(tbl.Columns[c].ColumnName);
for (int r = 0; r < tbl.Rows.Count; ++r)
{
bool isNull = tbl.Rows[r].ItemArray[c] == DBNull.Value || tbl.Rows[r].ItemArray[c] == null;
if (!isNull && colDic.ContainsKey((string)tbl.Rows[r].ItemArray[c]))
{
tbl.Rows[r][c] = colDic[(string)tbl.Rows[r].ItemArray[c]];
}
}
}
if (isDic)
{
tbl.Columns[c].ColumnName = tbl.Columns[c].ColumnName.Replace("_Dic", string.Empty);
}
}
//meta data for exported file
Privacy p = !reportId.HasValue ? null :
PrivacyController.get_settings(paramsContainer.Tenant.Id, reportId.Value);
string confidentiality = p == null ? null : p.Confidentiality.Title;
User currentUser = !paramsContainer.CurrentUserID.HasValue ? null :
UsersController.get_user(paramsContainer.Tenant.Id, paramsContainer.CurrentUserID.Value);
if (currentUser == null)
{
currentUser = new User();
}
DownloadedFileMeta meta = new DownloadedFileMeta(PublicMethods.get_client_ip(HttpContext.Current),
currentUser.UserName, currentUser.FirstName, currentUser.LastName, confidentiality);
//end of meta data for exported file
string reportFileName = "Reports_" + PublicMethods.get_random_number().ToString();
ExcelUtilities.ExportToExcel(reportFileName, tbl, rtl, dic, password, meta);
}
catch (Exception ex)
{
responseText = "{\"ErrorText\":\"" + Messages.OperationFailed + "\"}";
LogController.save_error_log(paramsContainer.Tenant.Id, paramsContainer.CurrentUserID,
"ExportReportToExcel", ex, ModuleIdentifier.RPT, LogLevel.Fatal);
}
return;
}
Dictionary <string, bool> isFloatDic = new Dictionary <string, bool>();
responseText = "{\"Columns\":[";
for (int i = 0, lnt = tbl.Columns.Count; i < lnt; ++i)
{
object obj = null;
for (int j = firstRow; j <= lastRow; ++j)
{
if (tbl.Rows[j][i] != DBNull.Value && tbl.Rows[j][i] != null && !string.IsNullOrEmpty(tbl.Rows[j][i].ToString()))
{
obj = tbl.Rows[j][i];
break;
}
}
bool isNumber = false;
bool isFloat = false;
if (obj != null)
{
var objType = obj.GetType();
isNumber = objType == typeof(int) || objType == typeof(long) ||
objType == typeof(float) || objType == typeof(double) || objType == typeof(decimal);
isFloat = objType == typeof(float) || objType == typeof(double) || objType == typeof(decimal);
}
isFloatDic.Add(tbl.Columns[i].ColumnName, isFloat);
string colTitle = columnsDic.ContainsKey(tbl.Columns[i].ColumnName) ?
columnsDic[tbl.Columns[i].ColumnName] : tbl.Columns[i].ColumnName;
responseText += (i == 0 ? string.Empty : ",") + "{\"ID\":\"" + tbl.Columns[i].ColumnName +
"\",\"Title\":\"" + Base64.encode(colTitle) + "\",\"Encoded\":true" +
",\"IsNumber\":" + isNumber.ToString().ToLower() + "}";
}
responseText += "],\"Total\":" + tbl.Rows.Count.ToString() + ",\"Rows\":[";
for (int i = firstRow; i <= lastRow; ++i)
{
responseText += (i == firstRow ? string.Empty : ",") + "{";
for (int j = 0, _ln = tbl.Columns.Count; j < _ln; ++j)
{
if (isFloatDic[tbl.Columns[j].ColumnName])
{
tbl.Rows[i].ItemArray[j] =
Math.Round(double.Parse((tbl.Rows[i].ItemArray[j] == DBNull.Value ? 0 : tbl.Rows[i].ItemArray[j]).ToString()), 2);
}
string strVal = tbl.Rows[i].ItemArray[j].GetType() == typeof(DateTime) ?
PublicMethods.get_local_date((DateTime)tbl.Rows[i].ItemArray[j], true) :
(isFloatDic[tbl.Columns[j].ColumnName] ?
Math.Round(double.Parse((tbl.Rows[i].ItemArray[j] == DBNull.Value ? 0 : tbl.Rows[i].ItemArray[j]).ToString()), 2) :
tbl.Rows[i].ItemArray[j]).ToString();
responseText += (j == 0 ? string.Empty : ",") + "\"" + tbl.Columns[j].ColumnName + "\":\"" + Base64.encode(strVal) + "\"";
}
responseText += "}";
}
responseText += "],\"Actions\":" + (string.IsNullOrEmpty(actions) ? "{}" : actions) + "}";
}