public ActionResult DeleteOrder(int id, OrderViewModel collection) { // TODO: Add delete logic here DBZipShipEntities db = new DBZipShipEntities(); var order = db.Orders.Where(x => x.Id == id).First(); db.Entry(order).State = System.Data.Entity.EntityState.Deleted; db.SaveChanges(); string message = "Your Order is Deleted"; return(RedirectToAction("Index", "Order", new { Message = message })); }
public ActionResult Select(int id) { DBZipShipEntities db = new DBZipShipEntities(); var order = db.Orders.Where(x => x.Id == id).First(); string shopperid = order.AddedBy; var shopper = db.AspNetUsers.Where(x => x.Id == shopperid).First(); order.Status = "Deleivered"; CompletedOrder comorder = new CompletedOrder(); var deal = db.Deals.Where(x => x.OrderId == order.Id).First(); var traveller = db.AspNetUsers.Where(x => x.Id == deal.SelectedBy).First(); comorder.OrderName = order.Name; comorder.OrderCountry = order.Country; comorder.ShopperName = shopper.Name; comorder.TravellerName = traveller.Name; comorder.ImagePath = order.ImagePath; comorder.TravellerId = traveller.Id; comorder.ShopperId = shopper.Id; db.CompletedOrders.Add(comorder); var admin = db.Admins.First(); long p = Convert.ToInt16(order.DealPrice - order.Price); double earnings = Convert.ToDouble((0.07 * order.Price) + (0.07 * p)); admin.Earnings = Convert.ToInt16(admin.Earnings + earnings); string message = "Deal Between" + traveller.Name + " and " + shopper.Name + " is Completed! " + earnings + " Rs is added to ZipShip Earnings"; db.Entry(order).State = System.Data.Entity.EntityState.Deleted; db.Entry(deal).State = System.Data.Entity.EntityState.Deleted; db.SaveChanges(); return(RedirectToAction("Index", "Order", new { Message = message })); }
public ActionResult Delete(UserViewModel collection) { // TODO: Add delete logic here DBZipShipEntities db = new DBZipShipEntities(); string id = User.Identity.GetUserId(); var orders = db.Orders.Where(x => x.AddedBy == id).ToList(); foreach (var i in orders) { db.Entry(i).State = System.Data.Entity.EntityState.Deleted; } db.SaveChanges(); var trips = db.Trips.Where(x => x.AddedBy == id).ToList(); foreach (var i in trips) { db.Entry(i).State = System.Data.Entity.EntityState.Deleted; } db.SaveChanges(); /*var reviews = db.Reviews.Where(x => x.AddedBy == id).ToList(); * foreach (var i in reviews) * { * db.Entry(i).State = System.Data.Entity.EntityState.Deleted; * }*/ db.SaveChanges(); var user = db.AspNetUsers.Where(x => x.Id == id).First(); db.Entry(user).State = System.Data.Entity.EntityState.Deleted; db.SaveChanges(); AuthenticationManager.SignOut(DefaultAuthenticationTypes.ApplicationCookie); string message = "Your Account is Deleted" + user.Name; return(RedirectToAction("Index", "Account", new { Message = message })); }
public ActionResult Delete(int id, FormCollection collection) //Delete for Deal { try { // TODO: Add delete logic here DBZipShipEntities db = new DBZipShipEntities(); var order = db.Deals.Where(x => x.OrderId == id).First(); db.Entry(order).State = System.Data.Entity.EntityState.Deleted; var s = db.Orders.Where(x => x.Id == id).First(); s.Status = null; db.SaveChanges(); string message = "Your Deal is Deleted"; return(RedirectToAction("Index", "Order", new { Message = message })); } catch { return(View()); } }
public ActionResult Delete(int id, TripViewModel collection) { try { // TODO: Add delete logic here DBZipShipEntities db = new DBZipShipEntities(); var det = db.Trips.Where(x => x.Id == id).First(); db.Entry(det).State = System.Data.Entity.EntityState.Deleted; db.SaveChanges(); string iduser = User.Identity.GetUserId(); var user = db.AspNetUsers.Where(x => x.Id == iduser).First(); string message = "Your Trip is Deleted Successfully " + user.Name; return(RedirectToAction("Index", "Trips", new { Message = message })); } catch { return(View()); } }