public async Task <IActionResult> OnPostAsync(int?id) { if (id == null) { return(NotFound()); } List <Product> list = _context.Product.ToList(); var test = list.Last(); string removing = _environment.WebRootPath.ToString() + "/Images/" + test.P_Image; if (System.IO.File.Exists(removing)) { System.IO.File.Delete(removing); } Models.Product p = _context.getProduct(id.GetValueOrDefault()); List <RazorPagesTutorial.Models.Orders> order = _context.getOrderList(); foreach (Models.Orders O in order) { if (id.GetValueOrDefault() == O.O_PIDS) { if (O.O_Status.Contains("Processing")) { SqlConnection sql = new SqlConnection(_context.connection); SqlCommand cm = new SqlCommand("dbo.delete_Order", sql); cm.Parameters.Add("@id", SqlDbType.Int).Value = O.O_ID; cm.Parameters.Add("@p_id", SqlDbType.Int).Value = p.P_ID; cm.Parameters.Add("@p_amount", SqlDbType.Int).Value = p.P_Amount + 1; cm.CommandType = CommandType.StoredProcedure; sql.Open(); cm.ExecuteNonQuery(); sql.Close(); } } } SqlConnection sqlConnection = new SqlConnection(_context.connection); SqlCommand cmd = new SqlCommand("dbo.delete_Product", sqlConnection); cmd.Parameters.Add("@id", SqlDbType.Int).Value = id.GetValueOrDefault(); cmd.CommandType = CommandType.StoredProcedure; sqlConnection.Open(); cmd.ExecuteNonQuery(); sqlConnection.Close(); return(RedirectToPage("./Index")); }
public async Task OnGetAsync() { if (HttpContext.Session.Get("Id") != null) { byte[] str = HttpContext.Session.Get("Id"); string ID = Encoding.UTF8.GetString(str, 0, str.Length); ViewData["Userid"] = ID; } if (HttpContext.Session.Get("Role") != null) { byte[] str = HttpContext.Session.Get("Role"); string Role = Encoding.UTF8.GetString(str, 0, str.Length); ViewData["UserRole"] = Role; } Orders = _context.getOrderList(); }