// This reads from a data row
public static NoteItem FromDataRow(DataTableRow r)
{
NoteItem i = new NoteItem();
i.id = r.GetLong("id");
i.note = r.GetString("note");
return i;
}
public ValueTable(ТаблицаЗначений value)
{
if (value == null)
{
throw new System.ArgumentNullException("value");
}
this.Column = new DataTableColumn[value.Колонки.Count];
for (int i = 0; i < value.Колонки.Count; i++)
{
DataTableColumn columnSOAP = new DataTableColumn();
columnSOAP.Name = value.Колонки[i].Имя;
this.Column[i] = columnSOAP;
}
this.Row = new DataTableRow[value.Count];
for (int i = 0; i < value.Count; i++)
{
DataTableRow rowSOAP = new DataTableRow();
rowSOAP.Property = new ValueBase[value.Колонки.Count];
for (int j = 0; j < value.Колонки.Count; j++)
{
КолонкаКоллекцииЗначений column = value.Колонки[j];
ValueBase property = ValueBase.From(((dynamic)value[i]).GetByColumn(column));
property.Name = column.Имя;
rowSOAP.Property[j] = property;
}
this.Row[i] = rowSOAP;
}
}
// This reads from a data row
public static GroceriesItem FromDataRow(DataTableRow r)
{
GroceriesItem i = new GroceriesItem();
i.name = r.GetString("name");
i.count = r.GetLong("count");
i.list = r.GetInt("list");
return i;
}
// This reads from a data row
public static AgendaItem FromDataRow(DataTableRow r)
{
AgendaItem i = new AgendaItem();
i.id = r.GetLong("id");
i.color = (ColorIndex)r.GetInt("color");
i.description = r.GetString("description");
i.startdate = new DateTime(r.GetLong("startdate"));
i.originstartdate = i.startdate;
i.duration = new TimeSpan(r.GetLong("duration"));
i.alarm = r.GetBool("alarm");
i.alarmdate = new DateTime(r.GetLong("alarmdate"));
i.recur = (AgendaItemRecur)r.GetInt("recur");
i.recursions = 0;
return i;
}
/// <summary>
/// Generates the data table row collection.
/// </summary>
/// <param name="table">The data table.</param>
/// <param name="className">Name of the class.</param>
/// <param name="rowInfos">The list of DataTableRow.</param>
/// <returns>The data collection of data table row.</returns>
private static List <DataTableRow> GenerateDataTableRowCollection(DataTable table, string namespaceString, string className, List <DataTableRowInfo> rowInfos)
{
List <DataTableRow> dataCollection = new List <DataTableRow>();
string classFullName = className;
if (!string.IsNullOrEmpty(namespaceString))
{
classFullName = string.Format("{0}.{1}", namespaceString, classFullName);
}
DataTablePreferences preferencesData = DataTablePreferencesWindow.LoadPreferencesData();
if (preferencesData)
{
int rowCount = table.Rows.Count;
for (int i = preferencesData.DataRowsStartRow - 1; i < rowCount; ++i)
{
DataTableRow rowData = (DataTableRow)UnityReflectionUtil.CreateInstance(classFullName);
for (int j = 0, propertiesCount = rowInfos.Count; j < propertiesCount; ++j)
{
string cellValue = table.Rows[i][j].ToString().Trim();
if (!string.IsNullOrEmpty(cellValue))
{
DataTableRowInfo rowInfo = rowInfos[j];
ITypeParser typeParser = GetTypeParser(rowInfo.Type);
if (typeParser != null)
{
object value = typeParser.Parse(cellValue);
ReflectionUtil.SetObjectPropertyValue(rowData, rowInfo.PropertyName, value);
}
else
{
Debug.LogWarningFormat("Type '{0}' is not supported!", rowInfo.Type);
}
}
}
dataCollection.Add(rowData);
}
}
return(dataCollection);
}
public IEnumerable <DataTableRow> OnExecute(string query)
{
var tableMapping = DBAccess.GetMapping(typeof(Country));
foreach (var entity in DBAccess.Connection.Query(tableMapping, query))
{
var row = new DataTableRow();
foreach (var column in tableMapping.Columns)
{
var value = column.GetValue(entity);
if (column.IsPK)
{
row.ID = (int)value;
}
row.Cells.Add(value == null ? "NULL" : value.ToString());
}
yield return(row);
}
}
private void AddRowsSOAP(ДеревоЗначений tree, DataTableRow[] rowsSOAP, КоллекцияСтрокДереваЗначений rows)
{
for (int i = 0; i < rows.Count; i++)
{
СтрокаДереваЗначений currentRow = rows[i];
DataTableRow rowSOAP = new DataTableRow();
rowSOAP.Property = new ValueBase[tree.Колонки.Count];
for (int j = 0; j < tree.Колонки.Count; j++)
{
string columnName = tree.Колонки[j].Имя;
ValueBase property = ValueBase.From(((dynamic)currentRow)[columnName]);
property.Name = columnName;
rowSOAP.Property[j] = property;
}
rowsSOAP[i] = rowSOAP;
if (currentRow.Строки().Count > 0)
{
rowSOAP.Row = new DataTableRow[currentRow.Строки().Count];
this.AddRowsSOAP(tree, rowSOAP.Row, currentRow.Строки());
}
}
}
public async Task <JsonResult> HistoryList(DataTableRequest request, int ID)
{
var _query = db.AdministratorSessions.Where(a => a.AdministratorID == ID).Select(a => new
{
a.StartTime,
a.EndTime,
a.IPAddress,
a.UserAgent,
a.ID,
a.AdministratorID
});
if (!string.IsNullOrEmpty(request.sSearch))
{
_query = _query.Where(a => a.IPAddress.Contains(request.sSearch) || a.UserAgent.Contains(request.sSearch) || a.StartTime.ToString().Contains(request.sSearch) || a.EndTime.ToString().Contains(request.sSearch));
}
switch (request.iSortCol_0)
{
case 0:
_query = request.sSortDir_0 == "asc" ? _query.OrderBy(a => a.IPAddress) : _query.OrderByDescending(a => a.IPAddress);
break;
case 1:
_query = request.sSortDir_0 == "asc" ? _query.OrderBy(a => a.UserAgent) : _query.OrderByDescending(a => a.UserAgent);
break;
case 2:
_query = request.sSortDir_0 == "asc" ? _query.OrderBy(a => a.StartTime) : _query.OrderByDescending(a => a.StartTime);
break;
case 3:
_query = request.sSortDir_0 == "asc" ? _query.OrderBy(a => a.EndTime) : _query.OrderByDescending(a => a.EndTime);
break;
default:
_query = _query.OrderByDescending(a => a.ID);
break;
}
int _count = await _query.CountAsync();
var data = await _query.Skip(request.iDisplayStart).Take(request.iDisplayLength).ToListAsync();
List <DataTableRow> _rows = new List <DataTableRow>();
foreach (var _rowData in data)
{
DataTableRow _row = new DataTableRow();
if (_rowData.IPAddress != null)
{
_row.Add(_rowData.IPAddress);
}
else
{
_row.Add("-");
}
if (_rowData.UserAgent != null)
{
_row.Add(@"<span data-toggle='popover' data-trigger='hover' data-content='" + _rowData.UserAgent + "' data-placement='top' data-container='body' data-animation='true'>" + _rowData.UserAgent.Remove(20) + "...</span>");
}
else
{
_row.Add("-");
}
_row.Add(_rowData.StartTime.ToString("dd MMMM, yyyy hh:mm:ss tt"));
_row.Add(_rowData.EndTime == null ? _rowData.StartTime.AddMinutes(20).ToString("dd MMMM, yyyy hh:mm:ss tt") : _rowData.EndTime.Value.ToString("dd MMMM, yyyy hh:mm:ss tt"));
_row.Add(AppManager.FormattedDuration(_rowData.EndTime != null ? _rowData.EndTime.Value.Subtract(_rowData.StartTime) : _rowData.StartTime.AddMinutes(20).Subtract(_rowData.StartTime)));
_rows.Add(_row);
}
return(Json(new DataTableResponse
{
sEcho = request.sEcho,
iDisplayLength = request.iDisplayLength,
iTotalRecords = _count,
iDisplayStart = request.iDisplayStart,
iTotalDisplayRecords = _count,
aaData = _rows
}, JsonRequestBehavior.AllowGet));
}
public async Task <JsonResult> List(DataTableRequest request, string daterange)
{
var _query = from a in db.Administrators
where a.IsDataActive
select new
{
a.ID,
a.IsSuperAdmin,
a.Email,
a.AuthString,
a.Name,
a.Phone,
a.IsActive,
a.LastUpdatedOn,
};
if (!string.IsNullOrEmpty(daterange))
{
string[] _daterange = daterange.Split(new string[] { " " }, StringSplitOptions.RemoveEmptyEntries);
DateTime?_start = Convert.ToDateTime(_daterange[0], new CultureInfo("en-CA"));
DateTime?_end = Convert.ToDateTime(_daterange[2], new CultureInfo("en-CA"));
_end = _end.Value.AddDays(1);
_query = _query.Where(a => a.LastUpdatedOn >= _start.Value && a.LastUpdatedOn < _end.Value);
}
if (!AppManager.Administrator.IsSuperAdmin)
{
_query = _query.Where(a => a.ID == AppManager.Administrator.ID);
}
if (!string.IsNullOrEmpty(request.sSearch))
{
_query = _query.Where(a => a.Name.Contains(request.sSearch) || a.Email.Contains(request.sSearch) || a.Phone.Contains(request.sSearch) || (a.IsActive ? "Yes" : "No").Contains(request.sSearch) || (a.IsSuperAdmin ? "Yes" : "No").Contains(request.sSearch) || a.LastUpdatedOn.ToString().Contains(request.sSearch));
}
switch (request.iSortCol_0)
{
case 0:
_query = request.sSortDir_0 == "asc" ? _query.OrderBy(a => a.Name) : _query.OrderByDescending(a => a.Name);
break;
case 1:
_query = request.sSortDir_0 == "asc" ? _query.OrderBy(a => a.Email) : _query.OrderByDescending(a => a.Email);
break;
case 2:
_query = request.sSortDir_0 == "asc" ? _query.OrderBy(a => a.Phone) : _query.OrderByDescending(a => a.Phone);
break;
case 3:
_query = request.sSortDir_0 == "asc" ? _query.OrderBy(a => a.IsSuperAdmin) : _query.OrderByDescending(a => a.IsSuperAdmin);
break;
case 4:
_query = request.sSortDir_0 == "asc" ? _query.OrderBy(a => a.IsActive) : _query.OrderByDescending(a => a.IsActive);
break;
case 5:
_query = request.sSortDir_0 == "asc" ? _query.OrderBy(a => a.LastUpdatedOn) : _query.OrderByDescending(a => a.LastUpdatedOn);
break;
default:
_query = _query.OrderByDescending(a => a.ID);
break;
}
int _count = await _query.CountAsync();
var _data = await _query.Skip(request.iDisplayStart).Take(request.iDisplayLength).ToListAsync();
List <DataTableRow> _rows = new List <DataTableRow>();
foreach (var _rowData in _data)
{
DataTableRow _row = new DataTableRow();
_row.Add(@"<a href='/L0C5A3E8915871B710C2CC98073748424/administrators/details/" + _rowData.ID + "'> " + _rowData.Name + " </a> ");
_row.Add(_rowData.Email);
_row.Add(!string.IsNullOrEmpty(_rowData.Phone) ? _rowData.Phone : "-");
_row.Add(_rowData.IsSuperAdmin ? "<span class='label label-success'>Yes</span>" : "<span class='label label-warning'>No</span>");
_row.Add(_rowData.IsActive ? "<span class='label label-success'>Yes</span>" : "<span class='label label-warning'>No</span>");
_row.Add(_rowData.LastUpdatedOn.ToString("dd/MM/yyyy hh:mm tt"));
if (AppManager.Administrator.ID == _rowData.ID)
{
_row.Add(@"<a href='/L0C5A3E8915871B710C2CC98073748424/administrators/edit/" + _rowData.ID + "' title='Edit' class='mr5'><i class='icon-pencil7'></i></a>");
}
else
{
_row.Add(@"<a href='/L0C5A3E8915871B710C2CC98073748424/administrators/edit/" + _rowData.ID + "' title='Edit' class='mr5'><i class='icon-pencil7'></i></a> <a class='confirm' data-confirm='Are you sure you want to cancel this Administator?' href='/L0C5A3E8915871B710C2CC98073748424/administrators/delete/" + _rowData.ID + "' title='Cancel'><i class='icon-cancel-square'></i></a>");
}
_rows.Add(_row);
}
return(Json(new DataTableResponse
{
sEcho = request.sEcho,
iDisplayLength = request.iDisplayLength,
iTotalRecords = _count,
iDisplayStart = request.iDisplayStart,
iTotalDisplayRecords = _count,
aaData = _rows
}, JsonRequestBehavior.AllowGet));
}
public async Task <JsonResult> List(DataTableRequest request, string daterange)
{
var _query = from i in db.Investments
join u in db.Users on i.UserID equals u.ID
select new
{
i.ID,
i.Mode,
i.Amount,
i.Status,
i.InitializedOn,
i.LastUpdatedOn,
i.TxRefNoUpdatedOn,
i.TxReferenceNumber,
i.UserID,
i.Token,
i.Type,
i.HasTransferred,
i.TokenAmount
,
i.ReceivedAmount
};
if (!string.IsNullOrEmpty(daterange))
{
string[] _daterange = daterange.Split(new string[] { " " }, StringSplitOptions.RemoveEmptyEntries);
DateTime?_start = Convert.ToDateTime(_daterange[0], new CultureInfo("en-CA"));
DateTime?_end = Convert.ToDateTime(_daterange[2], new CultureInfo("en-CA"));
_end = _end.Value.AddDays(1);
_query = _query.Where(u => u.LastUpdatedOn >= _start.Value && u.LastUpdatedOn < _end.Value);
}
_query = _query.Where(i => i.UserID == AppManager.User.ID);
if (!string.IsNullOrEmpty(request.sSearch))
{
_query = _query.Where(u => u.LastUpdatedOn.ToString().Contains(request.sSearch) || u.InitializedOn.ToString().Contains(request.sSearch) || u.Type.ToString().Contains(request.sSearch) || u.Mode.Contains(request.sSearch) || u.Amount.ToString().Contains(request.sSearch) || u.Status.Contains(request.sSearch) || u.Token.ToString().Contains(request.sSearch));
}
switch (request.iSortCol_0)
{
case 1:
_query = request.sSortDir_0 == "asc" ? _query.OrderBy(i => i.Type) : _query.OrderByDescending(i => i.Type);
break;
case 3:
_query = request.sSortDir_0 == "asc" ? _query.OrderBy(i => i.Status) : _query.OrderByDescending(i => i.Status);
break;
case 4:
_query = request.sSortDir_0 == "asc" ? _query.OrderByDescending(i => i.InitializedOn) : _query.OrderBy(i => i.InitializedOn);
break;
default:
_query = _query.OrderByDescending(u => u.ID);
break;
}
int _count = await _query.CountAsync();
var _data = await _query.Skip(request.iDisplayStart).Take(request.iDisplayLength).ToListAsync();
List <DataTableRow> _rows = new List <DataTableRow>();
foreach (var _rowData in _data)
{
DataTableRow _row = new DataTableRow();
string _statusHtml = "";
_row.Add($"<a href='/users/investments/details/{ _rowData.ID }' title='Details'>{_rowData.Token}</a>");
_row.Add(_rowData.Type);
switch (_rowData.Mode)
{
case "AUD":
_row.Add($"{ String.Format("{0:0.00}", _rowData.Amount, MidpointRounding.AwayFromZero) } {_rowData.Mode}");
break;
case "CAD":
_row.Add($"{ String.Format("{0:0.00}", _rowData.Amount, MidpointRounding.AwayFromZero) } {_rowData.Mode}");
break;
case "CHF":
_row.Add($"{ String.Format("{0:0.00}", _rowData.Amount, MidpointRounding.AwayFromZero) } {_rowData.Mode}");
break;
case "CNY":
_row.Add($"{ String.Format("{0:0.00}", _rowData.Amount, MidpointRounding.AwayFromZero) } {_rowData.Mode}");
break;
case "EUR":
_row.Add($"{ String.Format("{0:0.00}", _rowData.Amount, MidpointRounding.AwayFromZero) } {_rowData.Mode}");
break;
case "USD":
_row.Add($"{ String.Format("{0:0.00}", _rowData.Amount, MidpointRounding.AwayFromZero) } {_rowData.Mode}");
break;
case "GBP":
_row.Add($"{ String.Format("{0:0.00}", _rowData.Amount, MidpointRounding.AwayFromZero) } {_rowData.Mode}");
break;
case "JPY":
_row.Add($"{ String.Format("{0:0.00}", _rowData.Amount, MidpointRounding.AwayFromZero) } {_rowData.Mode}");
break;
case "SEK":
_row.Add($"{ String.Format("{0:0.00}", _rowData.Amount, MidpointRounding.AwayFromZero) } {_rowData.Mode}");
break;
case "NZD":
_row.Add($"{ String.Format("{0:0.00}", _rowData.Amount, MidpointRounding.AwayFromZero) } {_rowData.Mode}");
break;
case "MXN":
_row.Add($"{ String.Format("{0:0.00}", _rowData.Amount, MidpointRounding.AwayFromZero) } {_rowData.Mode}");
break;
case "SGD":
_row.Add($"{ String.Format("{0:0.00}", _rowData.Amount, MidpointRounding.AwayFromZero) } {_rowData.Mode}");
break;
case "HKD":
_row.Add($"{ String.Format("{0:0.00}", _rowData.Amount, MidpointRounding.AwayFromZero) } {_rowData.Mode}");
break;
case "NOK":
_row.Add($"{ String.Format("{0:0.00}", _rowData.Amount, MidpointRounding.AwayFromZero) } {_rowData.Mode}");
break;
case "KRW":
_row.Add($"{ String.Format("{0:0.00}", _rowData.Amount, MidpointRounding.AwayFromZero) } {_rowData.Mode}");
break;
case "TRY":
_row.Add($"{ String.Format("{0:0.00}", _rowData.Amount, MidpointRounding.AwayFromZero) } {_rowData.Mode}");
break;
case "RUB":
_row.Add($"{ String.Format("{0:0.00}", _rowData.Amount, MidpointRounding.AwayFromZero) } {_rowData.Mode}");
break;
case "INR":
_row.Add($"{ String.Format("{0:0.00}", _rowData.Amount, MidpointRounding.AwayFromZero) } {_rowData.Mode}");
break;
case "BRL":
_row.Add($"{ String.Format("{0:0.00}", _rowData.Amount, MidpointRounding.AwayFromZero) } {_rowData.Mode}");
break;
case "ZAR":
_row.Add($"{ String.Format("{0:0.00}", _rowData.Amount, MidpointRounding.AwayFromZero) } {_rowData.Mode}");
break;
default:
_row.Add($"{_rowData.Amount} {_rowData.Mode}");
break;
}
switch (_rowData.Status)
{
case "Waiting for transaction reference number":
case "Waiting for you to update your payment reference":
_statusHtml = $"<span class=\"label label-default\">Waiting for you to update your payment reference</span> [<a class='confirm' data-confirm='Please confirm your action as this could only be done once?' href='/users/investments/updatereferencenumber/{ _rowData.ID }' title='Confirm using your Wallet Address/ Bank Payment Reference'>Update</a>]";
break;
case "Waiting for Confirmation":
_statusHtml = "<span class=\"label label-primary\">Waiting for Confirmation</span>";
break;
case "Waiting for Wallet to be ready":
case "Confirmed":
_statusHtml = $"<span class=\"label label-success\">Confirmed</span>";
break;
//if (_rowData.WalletPassPhrase != null)
//{
// _statusHtml =
// $"<span class=\"label label-success\">Waiting for Wallet to be ready</span> [<a href='/users/investments/printreceipt/{ _rowData.ID }' target='_blank' title='Add Wallet Password Phrase'>Download Receipt</a>]";
//}
//else
//{
// _statusHtml = $"<span class=\"label label-success\">Confirmed</span> [<a href='/users/investments/addwalletpassphrase/{ _rowData.ID }' title='Add Wallet Password Phrase'>Update</a>] [<a href='/users/investments/printreceipt/{ _rowData.ID }' target='_blank' title='Add Wallet Password Phrase'>Download Receipt</a>]";
//}
//break;
//case "Waiting for Wallet to be ready":
// _statusHtml = $"<span class=\"label label-success\">Waiting for Wallet to be ready</span> [<a href='/users/investments/printreceipt/{ _rowData.ID }' target='_blank' >Download Receipt</a>]";
// break;
//case "Wallet Created":
// _statusHtml = $"<span class=\"label label-success\">Wallet Created</span> [<a href='/users/investments/download/{ _rowData.UserID }' target='_blank' >Download Wallet</a>]";
// break;
case "Rejected":
_statusHtml = $"<span class=\"label label-danger\">Rejected</span>";
break;
//case "Coins Issued":
// _statusHtml = $"<span class=\"label label-info\">Coins Issued</span> [<a href='/users/investments/download/{ _rowData.UserID }' target='_blank' >Download Wallet</a>]";
// break;
default:
_statusHtml = "Unknown";
break;
}
if (_rowData.Type == "Growth Token" && _rowData.Status == "Confirmed" && _rowData.HasTransferred == true)
{
_statusHtml = $"<span class='label label-success'>YOUR {_rowData.ReceivedAmount} SER TOKENS HAVE NOW BEEN TRANSFERRED TO THE GROWTH TOKEN CRYPTOFUND</span>";
}
else if (_rowData.Type == "Growth Token" && _rowData.Status == "Confirmed")
{
_statusHtml = "<span class='label label-success1'>INVESTMENT CONFIRMED, PENDING TRANSFER TO THE GROWTH TOKEN CRYPTOFUND</span>";
}
_row.Add(_statusHtml);
_row.Add(_rowData.InitializedOn.ToString());
_rows.Add(_row);
}
return(Json(new DataTableResponse
{
sEcho = request.sEcho,
iDisplayLength = request.iDisplayLength,
iTotalRecords = _count,
iDisplayStart = request.iDisplayStart,
iTotalDisplayRecords = _count,
aaData = _rows
}, JsonRequestBehavior.AllowGet));
}
public ActionResult KeywordContentList(DataTable dataTable, int keywordId = 0)
{
var isSearchEmpty = string.IsNullOrWhiteSpace(dataTable.sSearch);
var totalCount =
_context.Contents.Count(p => p.KeywordId == keywordId && (p.Description.ToLower().Contains(dataTable.sSearch.ToLower()) || isSearchEmpty));
var contentList = _context.Contents
.Include("Language")
.Include("CreateUser")
.Where(
p =>
p.KeywordId == keywordId &&
(p.Description.ToLower().Contains(dataTable.sSearch.ToLower()) ||
isSearchEmpty))
.Select(p => new ContentViewModel
{
KeywordId = p.KeywordId,
LanguageDefinition = p.Language.Definition,
Description = p.Description,
UserName = p.CreateUser.UserName,
ContentId = p.ContentId,
Approved = p.Approved,
Complaint = p.Complaint,
CreateDate = p.CreateDate,
ContentType = p.ContentType,
Url = p.Url
});
//...
// Order by clause
var sortColumn = HttpContext.Request.Form["iSortCol_0"];
var sortDirection = HttpContext.Request.Form["sSortDir_0"];
switch (sortColumn)
{
case "0":
contentList = sortDirection.Equals("asc")
? contentList.OrderBy(p => p.LanguageDefinition)
: contentList.OrderByDescending(p => p.LanguageDefinition);
break;
case "1":
contentList = sortDirection.Equals("asc")
? contentList.OrderBy(p => p.Description)
: contentList.OrderByDescending(p => p.Description);
break;
case "2":
contentList = sortDirection.Equals("asc")
? contentList.OrderBy(p => p.UserName)
: contentList.OrderByDescending(p => p.UserName);
break;
case "3":
contentList = sortDirection.Equals("asc")
? contentList.OrderBy(p => p.Complaint)
: contentList.OrderByDescending(p => p.Complaint);
break;
default:
contentList = sortDirection.Equals("asc")
? contentList.OrderBy(p => p.CreateDate)
: contentList.OrderByDescending(p => p.CreateDate);
break;
}
//...
// Filtering
contentList = contentList
.Skip(dataTable.iDisplayStart)
.Take(dataTable.iDisplayLength);
var resultTable = new List <DataTableRow>();
foreach (var content in contentList)
{
var operations = new StringBuilder();
operations.Append("<table>");
operations.Append("<tr>");
operations.Append(
string.Format(
@"<td>
<input type='checkbox' title='Onayla' data-toggle='tooltip' data-content-id='{0}' data-content-type='{1}' onclick='ToggleContentActivation(this);' {2} />
</td>",
content.ContentId, content.ContentType, content.Approved ? "checked" : ""));
operations.Append(
string.Format(
@"<td>
<div class='icon-remove-sign' title='Sil' data-toggle='tooltip' style='cursor:pointer;' data-content-id='{0}' data-content-type='{1}' onclick='DeleteContent(this);'></div>
</td>", content.ContentId, content.ContentType));
operations.Append("</tr>");
operations.Append("</table>");
//...
// Reset content description
content.Description = string.Format("<div class='icon-comment'></div> {0}", content.Description);
var row = new DataTableRow
{
content.LanguageDefinition,
content.Description,
string.Format("<a target='_blank' href='/Management/KeywordList/?UserName={0}'>{0}</a>", content.UserName ?? "Anonym"),
content.Complaint.ToString(CultureInfo.InvariantCulture),
String.Format("{0:d/M/yyyy HH:mm}", content.CreateDate),
operations.ToString()
};
resultTable.Add(row);
}
return(new DataTableResultExt(dataTable, totalCount, totalCount, resultTable));
}
public ActionResult KeywordList(DataTable dataTable, string userName = "")
{
var isSearchEmpty = string.IsNullOrWhiteSpace(dataTable.sSearch);
//...
// User portfolio
var createUserId = WebSecurity.GetUserId(userName);
var totalCount =
_context
.Keywords
.Count(p => (p.Definition.ToLower().Contains(dataTable.sSearch.ToLower()) || isSearchEmpty) && (createUserId == -1 || p.CreateUserId == createUserId));
//...
// Where clause
var keywordList = _context.Keywords
.Include("Language")
.Include("CreateUser")
.Where(p => (p.Definition.ToLower().Contains(dataTable.sSearch.ToLower()) || isSearchEmpty) && (createUserId == -1 || p.CreateUserId == createUserId));
//...
// Order by clause
var sortColumn = HttpContext.Request.Form["iSortCol_0"];
var sortDirection = HttpContext.Request.Form["sSortDir_0"];
switch (sortColumn)
{
case "0":
keywordList = sortDirection.Equals("asc")
? keywordList.OrderBy(p => p.KeywordId)
: keywordList.OrderByDescending(p => p.KeywordId);
break;
case "1":
keywordList = sortDirection.Equals("asc")
? keywordList.OrderBy(p => p.Definition)
: keywordList.OrderByDescending(p => p.Definition);
break;
case "2":
keywordList = sortDirection.Equals("asc")
? keywordList.OrderBy(p => p.LanguageId)
: keywordList.OrderByDescending(p => p.LanguageId);
break;
case "3":
keywordList = sortDirection.Equals("asc")
? keywordList.OrderBy(p => p.CreateUserId)
: keywordList.OrderByDescending(p => p.CreateUserId);
break;
default:
keywordList = sortDirection.Equals("asc")
? keywordList.OrderBy(p => p.CreateDate)
: keywordList.OrderByDescending(p => p.CreateDate);
break;
}
//...
// Filtering
keywordList = keywordList
.Skip(dataTable.iDisplayStart)
.Take(dataTable.iDisplayLength);
var resultTable = new List <DataTableRow>();
foreach (var keyword in keywordList)
{
var operations = new StringBuilder();
operations.Append("<table>");
operations.Append("<tr>");
operations.Append(
string.Format(
@"<td>
<a href='/Management/KeywordContentList?keywordId={0}' target='_blank'>İçerikler</a>
</td>",
keyword.KeywordId));
operations.Append(
string.Format(
@"<td>
<a target='_blank' href='/Management/KeywordTagSelection?KeywordId={0}'>Tag Ekle</a>
</td>", keyword.KeywordId));
operations.Append(
string.Format(
@"<td>
<a target='_blank' href='/Management/CreateContent?KeywordId={0}'>İçerik Ekle</a>
</td>", keyword.KeywordId));
operations.Append(
string.Format(
@"<td>
<input type='checkbox' title='Onayla' data-toggle='tooltip' data-keyword-id='{0}' onclick='ToggleKeywordActivation(this);' {1} />
</td>",
keyword.KeywordId, keyword.Approved ? "checked" : ""));
operations.Append(
string.Format(
@"<td>
<div class='icon-remove-sign' title='Sil' data-toggle='tooltip' style='cursor:pointer;' data-keyword-id='{0}' onclick='DeleteKeyword(this);'></div>
</td>", keyword.KeywordId));
operations.Append("</tr>");
operations.Append("</table>");
var row = new DataTableRow
{
keyword.KeywordId.ToString(CultureInfo.InvariantCulture),
keyword.Definition,
keyword.Language.Definition,
keyword.CreateUser == null ? "Anonym" : keyword.CreateUser.UserName,
String.Format("{0:d/M/yyyy HH:mm}", keyword.CreateDate),
operations.ToString()
};
resultTable.Add(row);
}
return(new DataTableResultExt(dataTable, totalCount, totalCount, resultTable));
}
public DataTableRowChangeEvent(DataTableRow row, global::System.Data.DataRowAction action)
{
this.eventRow = row;
this.eventAction = action;
}
public async Task <JsonResult> List(DataTableRequest request, string daterange)
{
var _query = from o in db.Offers
where o.IsDataActive
select new
{
o.ID,
o.Title,
o.Discount,
o.LastDate,
o.LastUpdatedOn,
o.CreatedByID,
o.LastUpdatedByID,
CreatedBy = db.Administrators.FirstOrDefault(a => a.IsDataActive && a.ID == o.CreatedByID).Name,
EditedBy = db.Administrators.FirstOrDefault(a => a.IsDataActive && a.ID == o.LastUpdatedByID).Name
};
if (!string.IsNullOrEmpty(daterange))
{
string[] _daterange = daterange.Split(new string[] { " " }, StringSplitOptions.RemoveEmptyEntries);
DateTime?_start = Convert.ToDateTime(_daterange[0], new CultureInfo("en-CA"));
DateTime?_end = Convert.ToDateTime(_daterange[2], new CultureInfo("en-CA"));
_end = _end.Value.AddDays(1);
_query = _query.Where(o => o.LastUpdatedOn >= _start.Value && o.LastUpdatedOn < _end.Value);
}
if (!string.IsNullOrEmpty(request.sSearch))
{
_query = _query.Where(o => o.Title.Contains(request.sSearch) || o.Discount.ToString().Contains(request.sSearch) || o.LastDate.ToString().Contains(request.sSearch) || o.CreatedBy.ToString().Contains(request.sSearch) || o.EditedBy.ToString().Contains(request.sSearch) || o.LastUpdatedOn.ToString().Contains(request.sSearch));
}
switch (request.iSortCol_0)
{
case 0:
_query = request.sSortDir_0 == "asc" ? _query.OrderBy(o => o.Title) : _query.OrderByDescending(o => o.Title);
break;
case 1:
_query = request.sSortDir_0 == "asc" ? _query.OrderBy(o => o.Discount) : _query.OrderByDescending(o => o.Discount);
break;
case 2:
_query = request.sSortDir_0 == "asc" ? _query.OrderBy(o => o.CreatedBy) : _query.OrderByDescending(o => o.CreatedBy);
break;
case 3:
_query = request.sSortDir_0 == "asc" ? _query.OrderBy(o => o.EditedBy) : _query.OrderByDescending(o => o.EditedBy);
break;
case 4:
_query = request.sSortDir_0 == "asc" ? _query.OrderBy(o => o.LastDate) : _query.OrderByDescending(o => o.LastDate);
break;
case 5:
_query = request.sSortDir_0 == "asc" ? _query.OrderBy(o => o.LastUpdatedOn) : _query.OrderByDescending(o => o.LastUpdatedOn);
break;
default:
_query = _query.OrderByDescending(o => o.ID);
break;
}
int _count = await _query.CountAsync();
var _data = await _query.Skip(request.iDisplayStart).Take(request.iDisplayLength).ToListAsync();
List <DataTableRow> _rows = new List <DataTableRow>();
foreach (var _rowData in _data)
{
DataTableRow _row = new DataTableRow();
_row.Add(_rowData.Title);
_row.Add(_rowData.Discount);
if (AppManager.Administrator.IsSuperAdmin || AppManager.Administrator.ID == _rowData.CreatedByID)
{
_row.Add(@"<a href='/L0C5A3E8915871B710C2CC98073748424/administrators/details/" + _rowData.CreatedByID + "'>" + _rowData.CreatedBy + "</a>");
}
else
{
_row.Add(_rowData.CreatedBy);
}
if (AppManager.Administrator.IsSuperAdmin || AppManager.Administrator.ID == _rowData.LastUpdatedByID)
{
_row.Add(@"<a href='/L0C5A3E8915871B710C2CC98073748424/administrators/details/" + _rowData.LastUpdatedByID + "'>" + _rowData.EditedBy + "</a>");
}
else
{
_row.Add(_rowData.EditedBy);
}
_row.Add(_rowData.LastDate.ToShortDateString());
_row.Add(_rowData.LastUpdatedOn.ToString());
_row.Add(@"<a href='/L0C5A3E8915871B710C2CC98073748424/offers/edit/" + _rowData.ID + "' title='Edit' class='mr5'><i class='icon-pencil7'></i></a> <a class='confirm' data-confirm='Are you sure you want to delete this Offer?' href='/L0C5A3E8915871B710C2CC98073748424/offers/delete/" + _rowData.ID + "' title='Delete'><i class='icon-cancel-square'></i></a> ");
_rows.Add(_row);
}
return(Json(new DataTableResponse
{
sEcho = request.sEcho,
iDisplayLength = request.iDisplayLength,
iTotalRecords = _count,
iDisplayStart = request.iDisplayStart,
iTotalDisplayRecords = _count,
aaData = _rows
}, JsonRequestBehavior.AllowGet));
}
public async Task <JsonResult> List(DataTableRequest request, string daterange)
{
var _query = from u in db.Users
where u.IsDataActive
select new
{
u.ID,
u.FirstName,
u.Title,
u.LastName,
u.Position,
u.Organization,
u.Email,
u.Phone,
u.LastUpdatedOn,
u.PostalCode
};
if (!string.IsNullOrEmpty(daterange))
{
string[] _daterange = daterange.Split(new string[] { " " }, StringSplitOptions.RemoveEmptyEntries);
DateTime?_start = Convert.ToDateTime(_daterange[0], new CultureInfo("en-CA"));
DateTime?_end = Convert.ToDateTime(_daterange[2], new CultureInfo("en-CA"));
_end = _end.Value.AddDays(1);
_query = _query.Where(u => u.LastUpdatedOn >= _start.Value && u.LastUpdatedOn < _end.Value);
}
if (!string.IsNullOrEmpty(request.sSearch))
{
_query = _query.Where(u => u.FirstName.Contains(request.sSearch) || u.Email.Contains(request.sSearch) || u.PostalCode.Contains(request.sSearch) || u.Phone.Contains(request.sSearch) || u.Position.Contains(request.sSearch) || u.Organization.Contains(request.sSearch) || u.LastUpdatedOn.ToString().Contains(request.sSearch));
}
switch (request.iSortCol_0)
{
case 0:
_query = request.sSortDir_0 == "asc" ? _query.OrderBy(u => u.FirstName) : _query.OrderByDescending(u => u.FirstName);
break;
case 1:
_query = request.sSortDir_0 == "asc" ? _query.OrderBy(u => u.Email) : _query.OrderByDescending(u => u.Email);
break;
case 2:
_query = request.sSortDir_0 == "asc" ? _query.OrderBy(u => u.Phone) : _query.OrderByDescending(u => u.Phone);
break;
case 3:
_query = request.sSortDir_0 == "asc" ? _query.OrderBy(u => u.PostalCode) : _query.OrderByDescending(u => u.PostalCode);
break;
case 4:
_query = request.sSortDir_0 == "asc" ? _query.OrderBy(u => u.Position) : _query.OrderByDescending(u => u.Position);
break;
case 5:
_query = request.sSortDir_0 == "asc" ? _query.OrderBy(u => u.Organization) : _query.OrderByDescending(u => u.Organization);
break;
case 6:
_query = request.sSortDir_0 == "asc" ? _query.OrderBy(u => u.LastUpdatedOn) : _query.OrderByDescending(u => u.LastUpdatedOn);
break;
default:
_query = _query.OrderByDescending(u => u.ID);
break;
}
int _count = await _query.CountAsync();
var _data = await _query.Skip(request.iDisplayStart).Take(request.iDisplayLength).ToListAsync();
List <DataTableRow> _rows = new List <DataTableRow>();
foreach (var _rowData in _data)
{
DataTableRow _row = new DataTableRow();
_row.Add(_rowData.Title + ". " + _rowData.FirstName + " " + _rowData.LastName);
_row.Add(@"<a href='/L0C5A3E8915871B710C2CC98073748424/users/details/" + _rowData.ID + "'>" + _rowData.Email + "</a>");
if (!string.IsNullOrEmpty(_rowData.Phone))
{
_row.Add(_rowData.Phone);
}
else
{
_row.Add("-");
}
if (!string.IsNullOrEmpty(_rowData.PostalCode))
{
_row.Add(_rowData.PostalCode);
}
else
{
_row.Add("-");
}
if (!string.IsNullOrEmpty(_rowData.Position))
{
_row.Add(_rowData.Position);
}
else
{
_row.Add("-");
}
if (!string.IsNullOrEmpty(_rowData.Organization))
{
_row.Add(_rowData.Organization);
}
else
{
_row.Add("-");
}
_row.Add(_rowData.LastUpdatedOn.ToString());
_rows.Add(_row);
}
return(Json(new DataTableResponse
{
sEcho = request.sEcho,
iDisplayLength = request.iDisplayLength,
iTotalRecords = _count,
iDisplayStart = request.iDisplayStart,
iTotalDisplayRecords = _count,
aaData = _rows
}, JsonRequestBehavior.AllowGet));
}
private async Task <string> GenerateExcelFile()
{
DateTime Now = AppManager.Now.Date;
var _query = from u in db.Users
where u.IsDataActive
select new
{
u.ID,
u.FirstName,
u.LastName,
u.Title,
u.Position,
u.Organization,
u.Email,
u.Phone,
u.PostalCode,
u.LastUpdatedOn,
};
var _data = await _query.OrderByDescending(o => o.ID).ToListAsync();
List <DataTableRow> _rows = new List <DataTableRow>();
foreach (var _rowData in _data)
{
DataTableRow _row = new DataTableRow();
string _statusHtml = string.Empty;
_row.Add(_rowData.FirstName + " " + _rowData.LastName);
_row.Add(_rowData.Email);
_row.Add(_rowData.Phone);
_row.Add(_rowData.PostalCode);
_row.Add(_rowData.Position);
_row.Add(_rowData.Organization);
_row.Add(_rowData.LastUpdatedOn.ToString());
_rows.Add(_row);
}
var _workbook = new XLWorkbook();
var _worksheet = _workbook.Worksheets.Add("Users");
_worksheet.Cell("A1").Value = "Name";
_worksheet.Cell("B1").Value = "Email";
_worksheet.Cell("C1").Value = "Phone";
_worksheet.Cell("D1").Value = "Postal Code";
_worksheet.Cell("E1").Value = "Position";
_worksheet.Cell("F1").Value = "Organization";
_worksheet.Cell("G1").Value = "Last Updated On";
int _rowIndex = 2;
foreach (DataTableRow _row in _rows)
{
_worksheet.Cell("A" + _rowIndex).Value = _row.ElementAt(0);
_worksheet.Cell("B" + _rowIndex).Value = _row.ElementAt(1);
_worksheet.Cell("C" + _rowIndex).Value = "'" + _row.ElementAt(2);
_worksheet.Cell("D" + _rowIndex).Value = "'" + _row.ElementAt(3);
_worksheet.Cell("E" + _rowIndex).Value = "'" + _row.ElementAt(4);
_worksheet.Cell("F" + _rowIndex).Value = _row.ElementAt(5);
_worksheet.Cell("G" + _rowIndex).Value = _row.ElementAt(6);
_rowIndex++;
}
_worksheet.Row(1).Style.Font.Bold = true;
_workbook.SaveAs(HostingEnvironment.MapPath("/Exports/users.xlsx"));
return("/Exports/users.xlsx");
}
public ActionResult UserList(DataTable dataTable)
{
var isSearchEmpty = string.IsNullOrWhiteSpace(dataTable.sSearch);
var totalCount =
_context.UserProfiles.Count(
p => p.UserName.ToLower().Contains(dataTable.sSearch.ToLower()) || isSearchEmpty);
//...
// Where clause
var userList = _context.UserProfiles
.Where(p => p.UserName.ToLower().Contains(dataTable.sSearch.ToLower()) || isSearchEmpty);
//...
// Order by clause
var sortColumn = HttpContext.Request.Form["iSortCol_0"];
var sortDirection = HttpContext.Request.Form["sSortDir_0"];
switch (sortColumn)
{
case "0":
userList = sortDirection.Equals("asc")
? userList.OrderBy(p => p.UserId)
: userList.OrderByDescending(p => p.UserId);
break;
case "1":
userList = sortDirection.Equals("asc")
? userList.OrderBy(p => p.UserName)
: userList.OrderByDescending(p => p.UserName);
break;
case "2":
userList = sortDirection.Equals("asc")
? userList.OrderBy(p => p.Email)
: userList.OrderByDescending(p => p.Email);
break;
default:
userList = sortDirection.Equals("asc")
? userList.OrderBy(p => p.UserName)
: userList.OrderByDescending(p => p.UserName);
break;
}
//...
// Filtering
userList = userList
.Skip(dataTable.iDisplayStart)
.Take(dataTable.iDisplayLength);
var resultTable = new List <DataTableRow>();
foreach (var user in userList)
{
var operations = new StringBuilder();
operations.Append("<table>");
operations.Append("<tr>");
operations.Append(
string.Format(
@"<td>
<a href='{0}' class='btn open-modal' title='Rol Tanımla' data-toggle='tooltip'>Rol</a>
</td>",
string.Format("/Management/UserRoleSelection?userId={0}", user.UserId)));
operations.Append(
string.Format(
@"<td>
<div class='icon-remove-sign' title='Sil' data-toggle='tooltip' style='cursor:pointer;' data-user-id='{0}' onclick='DeleteUser(this);'></div>
</td>", user.UserId));
operations.Append("</tr>");
operations.Append("</table>");
var row = new DataTableRow
{
user.UserId.ToString(CultureInfo.InvariantCulture),
user.UserName,
user.Email,
operations.ToString()
};
resultTable.Add(row);
}
return(new DataTableResultExt(dataTable, totalCount, totalCount, resultTable));
}
public async Task <JsonResult> List(DataTableRequest request)
{
List <AssestsRequest> _requests = await db.AssestsRequests.Where(r => (r.HasApproved || r.HasRejected)).ToListAsync();
foreach (AssestsRequest _item in _requests)
{
if (_item.UserID == AppManager.User.ID)
{
_item.HasRejected = false;
_item.HasApproved = false;
await db.SaveChangesAsync();
}
}
var _query = from r in db.AssestsRequests
select new
{
r.ID,
r.UserID,
r.Assest,
r.Quantity,
r.CreatedOn,
r.StatusChangedOn,
r.User,
r.Status
};
if (!string.IsNullOrEmpty(request.sSearch))
{
_query = _query.Where(r => r.User.NickName.Contains(request.sSearch) || r.User.Username.Contains(request.sSearch) || r.CreatedOn.ToString().Contains(request.sSearch) || r.StatusChangedOn.ToString().Contains(request.sSearch) || r.Assest.Contains(request.sSearch));
}
if (!AppManager.User.IsSuperAdmin)
{
_query = _query.Where(i => i.UserID == AppManager.User.ID);
}
switch (request.iSortCol_0)
{
case 0:
_query = request.sSortDir_0 == "asc" ? _query.OrderBy(r => (string.IsNullOrEmpty(r.User.NickName) ? r.User.Username : r.User.NickName)) : _query.OrderBy(r => (string.IsNullOrEmpty(r.User.NickName) ? r.User.Username : r.User.NickName));
break;
case 1:
_query = request.sSortDir_0 == "asc" ? _query.OrderBy(r => r.Assest) : _query.OrderByDescending(r => r.Assest);
break;
case 2:
_query = request.sSortDir_0 == "asc" ? _query.OrderByDescending(r => r.Quantity) : _query.OrderBy(r => r.Quantity);
break;
case 3:
_query = request.sSortDir_0 == "asc" ? _query.OrderByDescending(r => r.Status) : _query.OrderBy(r => r.Status);
break;
case 4:
_query = request.sSortDir_0 == "asc" ? _query.OrderByDescending(r => r.CreatedOn) : _query.OrderBy(r => r.CreatedOn);
break;
case 5:
_query = request.sSortDir_0 == "asc" ? _query.OrderBy(r => r.StatusChangedOn) : _query.OrderByDescending(r => r.StatusChangedOn);
break;
default:
_query = _query.OrderByDescending(r => r.ID);
break;
}
var _count = await _query.CountAsync();
var _data = await _query.Skip(request.iDisplayStart).Take(request.iDisplayLength).ToListAsync();
List <DataTableRow> _rows = new List <DataTableRow>();
foreach (var _rowData in _data)
{
DataTableRow _row = new DataTableRow();
_row.Add(_rowData.User.NickName == null ? "@" + _rowData.User.Username : _rowData.User.NickName);
_row.Add(_rowData.Assest);
_row.Add(String.Format("{0:0.00000000}", _rowData.Quantity));
switch (_rowData.Status)
{
case "Pending":
if (!AppManager.User.IsSuperAdmin)
{
_row.Add(@"<span class='label label-primary'>" + _rowData.Status + "</span>");
}
else
{
_row.Add(@"<span class='label label-primary'>" + _rowData.Status + "</span><div><span>");
}
break;
case "Rejected":
_row.Add(@"<span class='label label-danger'>" + _rowData.Status + "</span>");
break;
case "Approved":
_row.Add(@"<span class='label label-success'>" + _rowData.Status + "</span>");
break;
}
_row.Add(_rowData.CreatedOn.ToString("dd/MM/yyyy hh:mm tt"));
_row.Add(_rowData.StatusChangedOn != null ? _rowData.CreatedOn.ToString("dd/MM/yyyy hh:mm tt") : "-");
if (_rowData.Status == "Pending" && AppManager.User.IsSuperAdmin)
{
_row.Add(@"<a href='/wallet/approve/" + _rowData.ID + "'><i class='confirm mr5' title='Approve' data-confirm='Are you sure you want to approve this Request?'><i class='icon-checkmark4 text-primary'></i></i></a> <a href='/wallet/reject/" + _rowData.ID + "'><i class='confirm mr5' title='Reject' data-confirm='Are you sure you want to reject this Request?'><i class='icon-cross2 text-primary'></i></i></a></span><div>");
}
else
{
_row.Add("N/A");
}
_rows.Add(_row);
}
return(Json(new DataTableResponse
{
sEcho = request.sEcho,
iDisplayLength = request.iDisplayLength,
iTotalRecords = _count,
iDisplayStart = request.iDisplayStart,
iTotalDisplayRecords = _count,
aaData = _rows
}, JsonRequestBehavior.AllowGet));
}
public async Task <JsonResult> List(DataTableRequest request)
{
List <Request> _requests = await db.Requests.Where(r => r.IsDataActive && r.HasRejected).ToListAsync();
foreach (Request _item in _requests)
{
if (_item.SenderID == AppManager.User.ID)
{
_item.HasRejected = false;
await db.SaveChangesAsync();
}
}
var _query = from r in db.Requests
where r.IsDataActive && r.SenderID == AppManager.User.ID || r.Recipient == AppManager.User.Email
select new
{
r.ID,
r.Message,
r.Status,
r.SentOn,
r.RespondedOn,
r.SenderID,
r.Recipient,
r.HasDownloaded,
r.User,
Receiver = db.Users.FirstOrDefault(u => u.IsDataActive && (u.Email == r.Recipient || u.NickName == r.Recipient))
};
if (!string.IsNullOrEmpty(request.sSearch))
{
_query = _query.Where(r => r.User.NickName.Contains(request.sSearch) | r.User.Username.Contains(request.sSearch) || r.Recipient.Contains(request.sSearch) || r.SentOn.ToString().Contains(request.sSearch) || r.RespondedOn.ToString().Contains(request.sSearch) || r.Status.Contains(request.sSearch));
}
switch (request.iSortCol_0)
{
case 0:
_query = request.sSortDir_0 == "asc" ? _query.OrderBy(r => (string.IsNullOrEmpty(r.User.NickName) ? r.User.Username : r.User.NickName)) : _query.OrderByDescending(r => (string.IsNullOrEmpty(r.User.NickName) ? r.User.Username : r.User.NickName));
break;
case 1:
_query = request.sSortDir_0 == "asc" ? _query.OrderBy(r => (string.IsNullOrEmpty(r.Receiver.NickName) ? r.Receiver.Username : r.Receiver.NickName)) : _query.OrderByDescending(r => (string.IsNullOrEmpty(r.Receiver.NickName) ? r.Receiver.Username : r.Receiver.NickName));
break;
case 2:
_query = request.sSortDir_0 == "asc" ? _query.OrderByDescending(r => r.SentOn) : _query.OrderBy(r => r.SentOn);
break;
case 3:
_query = request.sSortDir_0 == "asc" ? _query.OrderBy(r => r.RespondedOn) : _query.OrderByDescending(r => r.RespondedOn);
break;
case 4:
_query = request.sSortDir_0 == "asc" ? _query.OrderBy(r => r.Status) : _query.OrderByDescending(r => r.Status);
break;
default:
_query = _query.OrderByDescending(r => r.ID);
break;
}
var _count = await _query.CountAsync();
var _data = await _query.Skip(request.iDisplayStart).Take(request.iDisplayLength).ToListAsync();
List <DataTableRow> _rows = new List <DataTableRow>();
foreach (var _rowData in _data)
{
DataTableRow _row = new DataTableRow();
_row.Add((string.IsNullOrEmpty(_rowData.User.NickName) ? "@" + _rowData.User.Username : _rowData.User.NickName));
if (_rowData.Receiver != null)
{
_row.Add((string.IsNullOrEmpty(_rowData.Receiver.NickName) ? "@" + _rowData.Receiver.Username : _rowData.Receiver.NickName));
}
else
{
_row.Add("-");
}
_row.Add(_rowData.SentOn.ToString("dd/MM/yyyy hh:mm tt"));
switch (_rowData.Status)
{
case "Pending":
_row.Add(@"<span class='label label-primary'>" + _rowData.Status + "</span>");
break;
case "Rejected":
_row.Add(@"<span class='label label-danger'>" + _rowData.Status + "</span>");
break;
case "Approved":
_row.Add(@"<span class='label label-success'>" + _rowData.Status + "</span>");
break;
}
if (_rowData.RespondedOn != null)
{
_row.Add(_rowData.RespondedOn.Value.ToString("dd/MM/yyyy hh:mm tt"));
}
else
{
_row.Add("-");
}
if (_rowData.Status == "Approved" && !_rowData.HasDownloaded && (_rowData.User.Email == AppManager.User.Email || _rowData.User.Username == AppManager.User.Username))
{
_row.Add(@"<a href='/requests/details/" + _rowData.ID + "'><i class='icon-magazine text-primary'></i></a> | <a href='/pv/printpv/?email=" + _rowData.Recipient + "&id=" + _rowData.ID + "'><i class='icon-file-download2 text-primary'></i></a>");
}
else
{
_row.Add(@"<a href='/requests/details/" + _rowData.ID + "'><i class='icon-magazine text-primary'></i></a>");
}
_rows.Add(_row);
}
return(Json(new DataTableResponse
{
sEcho = request.sEcho,
iDisplayLength = request.iDisplayLength,
iTotalRecords = _count,
iDisplayStart = request.iDisplayStart,
iTotalDisplayRecords = _count,
aaData = _rows
}, JsonRequestBehavior.AllowGet));
}
public async Task <JsonResult> List(DataTableRequest request, string daterange)
{
var _query = from i in db.Wallets
join u in db.Users on i.UserID equals u.ID
join a in db.Administrators on i.CreatedByID equals a.ID
where i.IsDataActive
select new
{
i.ID,
i.Address,
i.WalletFile,
i.WalletHTMLFile,
i.WalletImageFile,
i.LastUpdatedOn,
i.CreatedByID,
u.LastName,
u.Title,
u.FirstName,
a.Name,
u.Email,
};
if (!string.IsNullOrEmpty(daterange))
{
string[] _daterange = daterange.Split(new string[] { " " }, StringSplitOptions.RemoveEmptyEntries);
DateTime?_start = Convert.ToDateTime(_daterange[0], new CultureInfo("en-CA"));
DateTime?_end = Convert.ToDateTime(_daterange[2], new CultureInfo("en-CA"));
_end = _end.Value.AddDays(1);
_query = _query.Where(u => u.LastUpdatedOn >= _start.Value && u.LastUpdatedOn < _end.Value);
}
if (!string.IsNullOrEmpty(request.sSearch))
{
_query = _query.Where(u => u.LastUpdatedOn.ToString().Contains(request.sSearch) || u.Address.Contains(request.sSearch) || u.Email.Contains(request.sSearch));
}
switch (request.iSortCol_0)
{
case 0:
_query = request.sSortDir_0 == "asc" ? _query.OrderBy(i => i.Email) : _query.OrderByDescending(i => i.Email);
break;
case 1:
_query = request.sSortDir_0 == "asc" ? _query.OrderBy(i => i.Address) : _query.OrderByDescending(i => i.Address);
break;
case 4:
_query = request.sSortDir_0 == "asc" ? _query.OrderBy(i => i.LastUpdatedOn) : _query.OrderByDescending(i => i.LastUpdatedOn);
break;
default:
_query = _query.OrderByDescending(i => i.ID);
break;
}
var _count = await _query.CountAsync();
var _data = await _query.Skip(request.iDisplayStart).Take(request.iDisplayLength).ToListAsync();
List <DataTableRow> _rows = new List <DataTableRow>();
foreach (var _rowData in _data)
{
DataTableRow _row = new DataTableRow();
_row.Add(_rowData.Email);
_row.Add(_rowData.Address);
_row.Add(@"<a href='/uploads/" + _rowData.WalletFile + "' target=_blank>Download</a>");
_row.Add(@"<a href='/uploads/" + _rowData.WalletHTMLFile + "' target=_blank>Download</a>");
_row.Add(@"<a href='/uploads/" + _rowData.WalletImageFile + "' target=_blank>Download</a>");
_row.Add(_rowData.LastUpdatedOn.ToString());
_row.Add(@"<a href='/L0C5A3E8915871B710C2CC98073748424/wallets/details/" + _rowData.ID + "' title='Details' class='mr5'><i class='icon-magazine'></i></a>");
_rows.Add(_row);
}
return(Json(new DataTableResponse
{
sEcho = request.sEcho,
iDisplayLength = request.iDisplayLength,
iTotalRecords = _count,
iDisplayStart = request.iDisplayStart,
iTotalDisplayRecords = _count,
aaData = _rows
}, JsonRequestBehavior.AllowGet));
}
private async Task <string> GenerateExcelFile(string type)
{
if (type == "seratio")
{
type = "Seratio Coin";
}
else if (type == "womenscoin")
{
type = "Womens Coin";
}
else if (type == "studentcoin")
{
type = "Student Coin";
}
else if (type == "10xgrowth")
{
type = "Growth Token";
}
else if (type == "ttc")
{
type = "TimeTraveler Coin";
}
var _query = from i in db.Investments
join u in db.Users on i.UserID equals u.ID
where i.Type == type
select new
{
i.ID,
i.Mode,
i.Amount,
i.Status,
i.InitializedOn,
i.LastUpdatedOn,
i.TxRefNoUpdatedOn,
i.TxReferenceNumber,
i.UserID,
u.Title,
u.FirstName,
i.ReceivedAmount,
u.LastName,
i.Token,
u.Email,
i.ExchangeRate,
i.ConfirmedOn,
i.RejectedOn,
i.OriginalExchangeRate,
i.UserSessionID,
i.UserSession,
i.CampaignCode,
i.InvestmentType,
i.TokenAmount,
i.Type,
u.Phone,
u.ReferralSource,
i.HasTransferred,
u.PostalCode
};
var _data = await _query.OrderByDescending(o => o.ID).ToListAsync();
List <DataTableRow> _rows = new List <DataTableRow>();
foreach (var _rowData in _data)
{
DataTableRow _row = new DataTableRow();
_row.Add(_rowData.Title);
_row.Add($"{_rowData.FirstName} {_rowData.LastName}");
_row.Add(_rowData.Email);
_row.Add(_rowData.Phone);
_row.Add(_rowData.Mode);
_row.Add(_rowData.Type);
_row.Add(_rowData.Amount);
_row.Add(_rowData.Token);
if (_rowData.UserSessionID != null)
{
_row.Add(_rowData.UserSession.IPAddress);
}
else
{
_row.Add("N/A");
}
_row.Add(_rowData.CampaignCode);
if (_rowData.InvestmentType != null)
{
_row.Add(_rowData.InvestmentType);
}
else
{
_row.Add("N/A");
}
_row.Add(_rowData.InitializedOn.ToString());
if (_rowData.OriginalExchangeRate != null)
{
_row.Add(String.Format("'{0:0.0000000}", _rowData.OriginalExchangeRate.ToString()));
}
else
{
_row.Add("N/A");
}
if (_rowData.TxReferenceNumber != null)
{
_row.Add(_rowData.TxReferenceNumber);
}
else
{
_row.Add("Pending");
}
if (_rowData.ConfirmedOn != null)
{
_row.Add(_rowData.ConfirmedOn);
}
else
{
_row.Add("Pending");
}
if (_rowData.ConfirmedOn != null)
{
_row.Add(_rowData.ReceivedAmount.ToString());
}
else
{
_row.Add("Pending");
}
if (_rowData.ExchangeRate != null)
{
_row.Add(String.Format("{0:0.00}", _rowData.ExchangeRate.ToString()));
}
else
{
_row.Add("N/A");
}
string _statusHtml = "";
if (_rowData.ConfirmedOn != null)
{
_statusHtml = "Confirmed";
}
else
{
if (_rowData.RejectedOn != null)
{
_statusHtml = "Rejected";
}
else
{
_statusHtml = "Pending";
}
}
if (_rowData.Type == "Growth Token" && _rowData.Status == "Confirmed" && _rowData.HasTransferred == true)
{
_statusHtml = $"YOUR {_rowData.ReceivedAmount} SER TOKENS HAVE NOW BEEN TRANSFERRED TO THE GROWTH TOKEN CRYPTOFUND";
}
else if (_rowData.Type == "Growth Token" && _rowData.Status == "Confirmed")
{
_statusHtml = "INVESTMENT CONFIRMED, PENDING TRANSFER TO THE GROWTH TOKEN CRYPTOFUND";
}
_row.Add(_statusHtml);
if (!string.IsNullOrEmpty(_rowData.TokenAmount))
{
_row.Add(_rowData.TokenAmount);
}
else
{
_row.Add("N/A");
}
_row.Add(_rowData.ReferralSource);
_row.Add(_rowData.PostalCode);
_rows.Add(_row);
}
var _workbook = new XLWorkbook();
var _worksheet = _workbook.Worksheets.Add("Investments");
_worksheet.Cell("A1").Value = "Contributor (Title)";
_worksheet.Cell("B1").Value = "Contributor (Name)";
_worksheet.Cell("C1").Value = "Contributor (Email)";
_worksheet.Cell("D1").Value = "Contributor (Phone)";
_worksheet.Cell("E1").Value = "Contribution Type";
_worksheet.Cell("F1").Value = "ICO Type";
_worksheet.Cell("G1").Value = "Amount";
_worksheet.Cell("H1").Value = "Token ID ";
_worksheet.Cell("I1").Value = "IP Address";
_worksheet.Cell("J1").Value = "Campaign code";
_worksheet.Cell("K1").Value = "Token Type";
_worksheet.Cell("L1").Value = "Contribution Requested On";
_worksheet.Cell("M1").Value = "Original Exchange rate";
_worksheet.Cell("N1").Value = "Transaction ID";
_worksheet.Cell("O1").Value = "Contribution Received On";
_worksheet.Cell("P1").Value = "Contribution Received Amount";
_worksheet.Cell("Q1").Value = "Exchange Rate";
_worksheet.Cell("R1").Value = "Confirmed";
_worksheet.Cell("S1").Value = "Token Amount";
_worksheet.Cell("T1").Value = "Referral Source";
_worksheet.Cell("U1").Value = "Postal Address";
int _rowIndex = 2;
foreach (DataTableRow _row in _rows)
{
_worksheet.Cell("A" + _rowIndex).Value = _row.ElementAt(0);
_worksheet.Cell("B" + _rowIndex).Value = _row.ElementAt(1);
_worksheet.Cell("C" + _rowIndex).Value = _row.ElementAt(2);
_worksheet.Cell("D" + _rowIndex).Value = "'" + _row.ElementAt(3);
_worksheet.Cell("E" + _rowIndex).Value = "'" + _row.ElementAt(4);
_worksheet.Cell("F" + _rowIndex).Value = _row.ElementAt(5);
_worksheet.Cell("G" + _rowIndex).Value = _row.ElementAt(6);
_worksheet.Cell("H" + _rowIndex).Value = _row.ElementAt(7);
_worksheet.Cell("I" + _rowIndex).Value = _row.ElementAt(8);
_worksheet.Cell("J" + _rowIndex).Value = _row.ElementAt(9);
_worksheet.Cell("K" + _rowIndex).Value = _row.ElementAt(10);
_worksheet.Cell("L" + _rowIndex).Value = _row.ElementAt(11);
_worksheet.Cell("M" + _rowIndex).Value = _row.ElementAt(12);
_worksheet.Cell("N" + _rowIndex).Value = "'" + _row.ElementAt(13);
_worksheet.Cell("O" + _rowIndex).Value = "'" + _row.ElementAt(14);
_worksheet.Cell("P" + _rowIndex).Value = _row.ElementAt(15);
_worksheet.Cell("Q" + _rowIndex).Value = _row.ElementAt(16);
_worksheet.Cell("R" + _rowIndex).Value = _row.ElementAt(17);
_worksheet.Cell("S" + _rowIndex).Value = _row.ElementAt(18);
_worksheet.Cell("T" + _rowIndex).Value = _row.ElementAt(19);
_worksheet.Cell("U" + _rowIndex).Value = _row.ElementAt(20);
_rowIndex++;
}
_worksheet.Row(1).Style.Font.Bold = true;
_workbook.SaveAs(HostingEnvironment.MapPath($"/Exports/Investments_{type}.xlsx"));
return($"/Exports/Investments_{type}.xlsx");
}
