public IActionResult ListOrders()
{
ApplicationDbContext database = new ApplicationDbContext();
string currentUser = User.Identity.Name;
var qUser = database.Users.Where(c => c.UserName == currentUser && c.EmailConfirmed == true).FirstOrDefault();
if (qUser == null)
{
return(Redirect(nameof(AccountController.Profile)));
}
var qInvoice = database.Tbl_Invoice.Where(c => c.UserId_FK == qUser.Id).OrderByDescending(c => c.InvoiceId).ToList();
if (qInvoice.Count == 0)
{
return(View());
}
List <VmPay> lstInvoice = new List <VmPay>();
foreach (var item in qInvoice)
{
VmPay vm = new VmPay();
vm.Authority = item.Authority;
vm.DateOrder = item.DateOrder;
vm.InvoiceId = item.InvoiceId;
vm.RefID = item.RefID;
vm.StatusPay = item.StatusPay;
vm.SumPrice = item.SumPrice;
vm.UserId_FK = item.UserId_FK;
lstInvoice.Add(vm);
}
return(View(lstInvoice ?? null));
}
public IActionResult Index(bool?statusPay)
{
ApplicationDbContext database = new ApplicationDbContext();
List <Invoice> qInvoice = new List <Invoice>();
if (statusPay == true)
{
qInvoice = database.Tbl_Invoice.Where(c => c.StatusPay == true).OrderByDescending(c => c.InvoiceId).ToList();
if (qInvoice.Count == 0)
{
return(View());
}
List <VmPay> lstInvoice = new List <VmPay>();
foreach (var item in qInvoice)
{
VmPay vm = new VmPay();
vm.Authority = item.Authority;
vm.DateOrder = item.DateOrder;
vm.InvoiceId = item.InvoiceId;
vm.RefID = item.RefID;
vm.StatusPay = item.StatusPay;
vm.SumPrice = item.SumPrice;
vm.UserId_FK = item.UserId_FK;
lstInvoice.Add(vm);
}
return(View(lstInvoice ?? null));
}
else if (statusPay == false)
{
qInvoice = database.Tbl_Invoice.Where(c => c.StatusPay == false).OrderByDescending(c => c.InvoiceId).ToList();
if (qInvoice.Count == 0)
{
return(View());
}
List <VmPay> lstInvoice = new List <VmPay>();
foreach (var item in qInvoice)
{
VmPay vm = new VmPay();
vm.Authority = item.Authority;
vm.DateOrder = item.DateOrder;
vm.InvoiceId = item.InvoiceId;
vm.RefID = item.RefID;
vm.StatusPay = item.StatusPay;
vm.SumPrice = item.SumPrice;
vm.UserId_FK = item.UserId_FK;
lstInvoice.Add(vm);
}
return(View(lstInvoice ?? null));
}
else
{
qInvoice = database.Tbl_Invoice.OrderByDescending(c => c.InvoiceId).ToList();
if (qInvoice.Count == 0)
{
return(View());
}
List <VmPay> lstInvoice = new List <VmPay>();
foreach (var item in qInvoice)
{
VmPay vm = new VmPay();
vm.Authority = item.Authority;
vm.DateOrder = item.DateOrder;
vm.InvoiceId = item.InvoiceId;
vm.RefID = item.RefID;
vm.StatusPay = item.StatusPay;
vm.SumPrice = item.SumPrice;
vm.UserId_FK = item.UserId_FK;
lstInvoice.Add(vm);
}
return(View(lstInvoice ?? null));
}
}
