public async Task <List <BannedAccount> > GetBannedAccounts()
{
DataTable dt = await ExecuteQuery("SELECT * FROM `account_banned` WHERE active = 1;");
List <BannedAccount> bannedAccounts = new List <BannedAccount>();
foreach (DataRow row in dt.Rows)
{
int id = Convert.ToInt32((uint)row["id"]);
DateTime banDate = Convert.ToInt64(((uint)row["bandate"])).ToDateTime();
DateTime unbanDate = Convert.ToInt64(((uint)row["unbandate"])).ToDateTime();
string bannedby = (string)row["bannedby"];
string banreason = (string)row["banreason"];
bool active = ((byte)row["active"]) == 1;
BannedAccount bannedAccount = new BannedAccount();
bannedAccount.Id = id;
bannedAccount.BanDate = banDate;
bannedAccount.UnbanDate = unbanDate;
bannedAccount.BannedBy = bannedby;
bannedAccount.BanReason = banreason;
bannedAccount.Active = active;
bannedAccounts.Add(bannedAccount);
}
return(bannedAccounts);
}
public async Task <List <BannedAccount> > SearchForBannedAccount(string like)
{
List <Account> accountsLike = await SearchForAccount(like);
List <BannedAccount> bannedAccountsLike = new List <BannedAccount>();
foreach (var account in accountsLike)
{
BannedAccount ban = await GetBannedAccount(account.Id);
if (ban == null)
{
continue;
}
if (ban.Active)
{
continue;
}
bannedAccountsLike.Add(ban);
}
return(bannedAccountsLike);
}
public ActionResult BannedAccount(int accountId)
{
var bannedAccount = new BannedAccount();
var account = _context.Accounts.FirstOrDefault(a => a.Id == accountId);
bannedAccount.AccountId = accountId;
bannedAccount.Account = account;
return(View(bannedAccount));
}
public ActionResult BannedAccount(int accountId, string reason)
{
var bannedAccount = new BannedAccount()
{
AccountId = accountId,
Reason = reason
};
_context.BannedAccounts.Add(bannedAccount);
_context.SaveChanges();
messageScreen.Typr = "true";
messageScreen.Content = "تم حضر الحساب بنجاح";
messageScreen.Action = "Products";
messageScreen.Control = "Admin";
return(RedirectToAction("Index", "Message", messageScreen));
}
private BannedAccount BuildAccountBan(DataRow row)
{
int id = Convert.ToInt32((uint)row["id"]);
DateTime banDate = Convert.ToInt64(((uint)row["bandate"])).ToDateTime();
DateTime unbanDate = Convert.ToInt64(((uint)row["unbandate"])).ToDateTime();
string bannedby = (string)row["bannedby"];
string banreason = (string)row["banreason"];
bool active = ((byte)row["active"]) == 1;
BannedAccount bannedAccount = new BannedAccount();
bannedAccount.Id = id;
bannedAccount.BanDate = banDate;
bannedAccount.UnbanDate = unbanDate;
bannedAccount.BannedBy = bannedby;
bannedAccount.BanReason = banreason;
bannedAccount.Active = active;
return(bannedAccount);
}
