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> 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 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 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 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.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));
}
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 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");
}
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");
}