public IActionResult ShowDetailsOrder(int invoiceId)
{
ApplicationDbContext database = new ApplicationDbContext();
try
{
if (User.Identity.IsAuthenticated)
{
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 qShopping = database.Tbl_ShoppingCart.Where(c => c.InvoiceId == invoiceId)
.Include(c => c.Tbl_Products)
.ThenInclude(c => c.Tbl_Gallery)
.ToList();
var qInvoice = database.Tbl_Invoice.Where(c => c.InvoiceId == invoiceId).FirstOrDefault();
if (qShopping.Count > 0)
{
List <VmDetailsOrder> lstDetailsOrder = new List <VmDetailsOrder>();
foreach (var item in qShopping)
{
VmDetailsOrder vm = new VmDetailsOrder();
vm.ProductCount = item.ProductCount;
vm.InvoiceId = (int)item.InvoiceId;
vm.Date = item.DateShop;
vm.OffProduct = item.Tbl_Products.OffProduct;
vm.ProductId = item.ProductId_FK;
var PicName = database.Tbl_Gallery.Where(c => c.ProductId_FK == item.ProductId_FK &&
c.DefaultPicProduct == true).FirstOrDefault().PictureName;
vm.ProductImage = "/Files/Images/Products/" + PicName;
vm.ProductName = item.Tbl_Products.ProductNameFA;
vm.ProductPrice = item.Tbl_Products.Price;
vm.ShoppingId = item.ID;
vm.UserId = item.UserId_FK;
lstDetailsOrder.Add(vm);
}
ViewBag.InvoiceId = lstDetailsOrder[0].InvoiceId;
return(View(lstDetailsOrder ?? null));
}
else
{
return(View(null));
}
}
else
{
return(View(nameof(AccountController.Login)));
}
}
catch
{
throw;
}
}
public IActionResult ShowDetailsOrders(int invoiceId)
{
ApplicationDbContext database = new ApplicationDbContext();
try
{
var qShopping = database.Tbl_ShoppingCart.Where(c => c.InvoiceId == invoiceId)
.Include(c => c.Tbl_Products)
.ThenInclude(c => c.Tbl_Gallery)
.ToList();
var qInvoice = database.Tbl_Invoice.Where(c => c.InvoiceId == invoiceId).FirstOrDefault();
if (qShopping.Count > 0)
{
List <VmDetailsOrder> lstDetailsOrder = new List <VmDetailsOrder>();
foreach (var item in qShopping)
{
VmDetailsOrder vm = new VmDetailsOrder();
vm.ProductCount = item.ProductCount;
vm.InvoiceId = (int)item.InvoiceId;
vm.Date = item.DateShop;
vm.OffProduct = item.Tbl_Products.OffProduct;
vm.ProductId = item.ProductId_FK;
var PicName = database.Tbl_Gallery.Where(c => c.ProductId_FK == item.ProductId_FK &&
c.DefaultPicProduct == true).FirstOrDefault().PictureName;
vm.ProductImage = "/Files/Images/Products/" + PicName;
vm.ProductName = item.Tbl_Products.ProductNameFA;
vm.ProductPrice = item.Tbl_Products.Price;
vm.ShoppingId = item.ID;
vm.UserId = item.UserId_FK;
lstDetailsOrder.Add(vm);
}
ViewBag.InvoiceId = lstDetailsOrder[0].InvoiceId;
return(View(lstDetailsOrder ?? null));
}
else
{
return(View(null));
}
}
catch
{
throw;
}
}