public ActionResult Delete(int id) { List <int> UploadFileIDs = _entities.AnnouncementUploadFiles.Where(a => a.UploadFileID == id).Select(a => a.AnnouncementID).ToList(); if (UploadFileIDs.Count() == 0) { UploadFileIDs = _entities.EventUploadFiles.Where(a => a.UploadFileID == id).Select(a => a.EventID).ToList(); } else if (UploadFileIDs.Count() == 0) { UploadFileIDs = _entities.ProductUploadFiles.Where(a => a.UploadFileID == id).Select(a => a.ProductID).ToList(); } else if (UploadFileIDs.Count() == 0) { UploadFileIDs = _entities.LocationUploadFiles.Where(a => a.UploadFileID == id).Select(a => a.LocationID).ToList(); } if (UploadFileIDs.Count() > 0) { TempData["ImageStatus"] = "Image was used by another user, so it is impossible to delete."; } else { var uploadFile = _entities.UploadFiles.Single(a => a.ID == id); _entities.DeleteObject(uploadFile); } return(View()); }
public ActionResult Delete(int id, FormCollection collection) { if (id != 0) { var aEvent = _entities.Events.Single(a => a.ID == id); //// Delete all the record in EventRegistration Table //var eventRegistrations = from r in _entities.EventRegistrations where r.EventID == id select r; //if (eventRegistrations != null) //{ // EventRegistrationController erc = new EventRegistrationController(); // foreach (EventRegistration eventRegistration in eventRegistrations) // { // DeleteEventRegistration(eventRegistration); // } //} _entities.DeleteObject(aEvent); ////delete all record in EventActivity table //var eventActivities = from r in _entities.EventActivities where r.EventID == id select r; //{ // foreach (EventActivity eventActivity in eventActivities) // { // _entities.EventActivities.DeleteObject(eventActivity); // } //} //// Delete all the record in EventSchedule Table //var eventSchedules = from r in _entities.EventSchedules where r.EventID == id select r; //if (eventSchedules != null) //{ // foreach (EventSchedule eventSchedule in eventSchedules) // { // _entities.DeleteObject(eventSchedule); // // Delete all the record in LocalRetreatVolunteerJobs Table // var localRetreatVolunteerJobs = from r in _entities.EventVolunteerJobs where r.EventScheduleID == eventSchedule.ID select r; // if (localRetreatVolunteerJobs != null) // { // foreach (EventVolunteerJob temp in localRetreatVolunteerJobs) // { // _entities.DeleteObject(temp); // } // } // } //} _entities.SaveChanges(); } return(View("Deleted")); }
public ActionResult Delete(int id, FormCollection collection) { if (id != 0) { BlackListMember BlackListMembers = _entities.BlackListMembers.Single(a => a.ID == id); _entities.DeleteObject(BlackListMembers); _entities.SaveChanges(); } return(View("Deleted")); }
public ActionResult Delete(int id, FormCollection collection) { if (id != 0) { ProductOrder productOrder = _entities.ProductOrders.Single(a => a.ID == id); _entities.DeleteObject(productOrder); _entities.SaveChanges(); } return(View("Deleted")); }
public ActionResult DeleteAttendData(int GMAttendID, FormCollection collection) { GroupMeditationAttendance gMAttend = _entities.GroupMeditationAttendances.Single(a => a.ID == GMAttendID); int GMID = gMAttend.GroupMeditationID; _entities.DeleteObject(gMAttend); _entities.SaveChanges(); return(RedirectToAction("Details", new { eventID = GMID, descending = true })); }
public ActionResult Delete(Guid memberID, int volunteerJobTypeID, FormCollection collection) { GMVolunteerJobName gmVolunteerJobName = _entities.GMVolunteerJobNames.Single(a => a.MemberID == memberID && a.VolunteerJobTypeID == volunteerJobTypeID); ViewData["Name"] = gmVolunteerJobName.MemberInfo.Name; ViewData["volunteerJobTypeID"] = gmVolunteerJobName.VolunteerJobTypeID; _entities.DeleteObject(gmVolunteerJobName); _entities.SaveChanges(); return(View("Deleted")); }
public ActionResult Delete(int id, FormCollection collection) { if (id != 0) { ProductDiscount productDiscount = _entities.ProductDiscounts.SingleOrDefault(a => a.ID == id); _entities.DeleteObject(productDiscount); _entities.SaveChanges(); } return(View("Deleted")); }
public ActionResult Delete(Guid IMemberID, DateTime FromDate, DateTime ToDate, FormCollection collection) { if (IMemberID != Guid.Empty) { MemberFeePayment mep = _entities.MemberFeePayments.Single(a => a.IMemberID == IMemberID && a.FromDate == FromDate && a.ToDate == ToDate); _entities.DeleteObject(mep); _entities.SaveChanges(); return(RedirectToAction("Index")); } return(View("Deleted")); }
public ActionResult Delete(int id, FormCollection collection) { if (id != 0) { var location = _entities.Locations.Single(a => a.ID == id); _entities.DeleteObject(location); _entities.SaveChanges(); } return(View("Deleted")); }
public ActionResult Delete(int id, FormCollection collection) { if (id != 0) { var initateVisitor = _entities.InitiateVisitors.Single(a => a.ID == id); _entities.DeleteObject(initateVisitor); _entities.SaveChanges(); } return(View("Deleted")); }
public ActionResult Delete(int id, FormCollection collection) { if (id != 0) { var localRetreatSchedule = _entities.EventSchedules.Include("EventActivity").Single(a => a.ID == id); ViewData["LocalRetreatID"] = localRetreatSchedule.EventID; _entities.DeleteObject(localRetreatSchedule); // Delete all the record in LocalRetreatVolunteerJobs Table var localRetreatVolunteerJobs = from r in _entities.EventVolunteerJobs where r.EventScheduleID == id select r; if (localRetreatVolunteerJobs != null) { foreach (EventVolunteerJob temp in localRetreatVolunteerJobs) { _entities.DeleteObject(temp); } } _entities.SaveChanges(); } return(View("Deleted")); }
public ActionResult Delete(int id, FormCollection collection) { if (id != 0) { var announcement = _entities.Announcements.Single(a => a.ID == id); ViewData["AnnounceGroupID"] = announcement.AnnounceGroupID; _entities.DeleteObject(announcement); _entities.SaveChanges(); } return(View("Deleted")); }
public ActionResult Delete(int id, FormCollection collection) { if (id != 0) { ProductDetail productDetail = _entities.ProductDetails.SingleOrDefault(a => a.ID == id); ViewData["ProductID"] = productDetail.ProductID; _entities.DeleteObject(productDetail); _entities.SaveChanges(); } return(View("Deleted")); }
public void AddToProductOrders(FormCollection collection, int productOrderID) { ProductOrder productOrder = _entities.ProductOrders.SingleOrDefault(a => a.ID == productOrderID); List <ProductOrderDetail> productOrderDetails = _entities.ProductOrderDetails.Where(a => a.ProductOrderID == productOrderID).ToList(); List <int> productIDs = productOrderDetails.Select(a => a.ProductID).ToList(); //if (selectedProductIDs == null) //{ // List<int> temp = new List<int>(); // foreach (Product product in viewModel) // { // temp.Add(product.ID); // } // selectedProductIDs = temp.AsEnumerable(); //} string[] keys = collection.AllKeys; for (int i = 1; i < keys.Length - 1; i++) //Remove DropDownList [0] and buttom [Length] { string temp = collection.Get(keys[i].ToString()); int productID = int.Parse(keys[i]); if (!string.IsNullOrEmpty(temp) && temp.ToLower().StartsWith("true") && !productIDs.Contains(productID)) { ProductOrderDetail pod = new ProductOrderDetail(); pod.ProductID = productID; productOrder.ProductOrderDetails.Add(pod); } else if (!string.IsNullOrEmpty(temp) && temp.ToLower().StartsWith("false") && productIDs.Contains(productID)) { ProductOrderDetail pod = _entities.ProductOrderDetails.SingleOrDefault(a => a.ProductID == productID && a.ProductOrderID == productOrderID); _entities.DeleteObject(pod); } } UpdateModel(productOrder, "ProductOrder"); _entities.SaveChanges(); }
public void DeleteUser(Guid id) { string userName = Membership.GetUser(id).UserName; if (!_entities.EventRegistrations.Any(a => a.MemberID == id) && !_entities.MemberOrders.Any(a => a.MemberID == id)) { List <Guid> IDs = (from r in _entities.MemberInfos select r.MemberID).ToList(); if (IDs.Contains(id)) { var memberInfo = _entities.MemberInfos.Single(a => a.MemberID == id); //SMCHDBLocalEntities _localEntities = new SMCHDBLocalEntities(); //IDs = (from r in _localEntities.OrdinaryMemberInfos select r.IMemberID).ToList(); //if (IDs.Contains(id)) //{ // var iMemberInfo = _localEntities.OrdinaryMemberInfos.Single(a => a.IMemberID == id); // _localEntities.DeleteObject(iMemberInfo); // _localEntities.SaveChanges(); //} _entities.DeleteObject(memberInfo); _entities.SaveChanges(); } Membership.DeleteUser(userName, true); if (userName == Membership.GetUser().UserName) { AccountController ac = new AccountController(); ac.FormsService = new FormsAuthenticationService(); ac.FormsService.SignOut(); } ViewData["message"] = userName + " was successfully deleted."; } else { ViewData["message"] = userName + " has been registered event or ordered product, can't be removed. if you still need to remove, please contact administrator."; } }
public ActionResult AddToOrderBag(FormCollection collection, int productID, int productOrderID, int?page, Guid?memberID) { if (!memberID.HasValue) { memberID = (Guid)Membership.GetUser().ProviderUserKey; } MemberOrder memberOrder = new MemberOrder(); if (_entities.MemberOrders.Where(a => a.ProductOrderID == productOrderID && a.MemberID == memberID.Value && a.OrderStatusID == 1).Any()) { memberOrder = _entities.MemberOrders.Single(a => a.ProductOrderID == productOrderID && a.MemberID == memberID.Value && a.OrderStatusID == 1); } else { memberOrder.MemberID = memberID.Value; memberOrder.ProductOrderID = productOrderID; memberOrder.OrderStatusID = 1; } memberOrder.LatestOrderDateTime = DateTime.Now.ToUniversalTime().AddHours(8); try { int memberOrderDetailCounts = RemoveMemberOrderDetailsFromMemberOrder(productID, memberOrder); AddToMemberOrderDetailForProduct(collection, memberOrder, productID); _entities.SaveChanges(); if (!ModelState.IsValid) { if (memberOrderDetailCounts > 0 && memberOrder.MemberOrderDetails.Count == 0) { _entities.DeleteObject(memberOrder); _entities.SaveChanges(); return(RedirectToAction("ProductList", new { productOrderID = productOrderID, page = page })); } else if (memberOrderDetailCounts > 0) { return(RedirectToAction("Details", new { memberOrderID = memberOrder.ID, orderStatusID = memberOrder.OrderStatusID, page = page })); } throw new Exception(); } if (memberOrder.ID == 0) { _entities.AddToMemberOrders(memberOrder); memberOrder = (from r in _entities.MemberOrders where r.ProductOrderID == productOrderID select r).OrderByDescending(x => x.ID).First(); } else { UpdateModel(memberOrder, "MemberOrder"); } _entities.SaveChanges(); return(RedirectToAction("Details", new { memberOrderID = memberOrder.ID, orderStatusID = memberOrder.OrderStatusID, page = page })); } catch { List <ProductDetail> productDetails = _entities.ProductDetails.Where(a => a.ProductID == productID && a.UpdateDate > SMCHSGManager.Controllers.ProductController.updateTime && (a.UnitsInStock == null || a.UnitsInStock != null && a.UnitsInStock > 0)).OrderBy(a => a.ID).ToList(); List <string> productQuantities = GetProductDetailQuantities(productID, productOrderID, memberID.Value, productDetails); ViewData["productQuantities"] = productQuantities.ToArray(); var viewModel = new ProductDetailViewModel { Sizes = productDetails.Select(a => a.SizeDescription).ToList(), Product = _entities.Products.Single(a => a.ID == productID), }; viewModel.ProductDiscount = viewModel.Product.ProductDiscounts.Where(a => a.DateTo >= DateTime.Today).FirstOrDefault(); viewModel.ReadPrice = GetProductPriceAfterDiscount(viewModel.Product, 1); if (viewModel.Product.ProductUploadFiles.Count == 0) { UploadFile upload = _entities.UploadFiles.Single(a => a.ID == 1276); ProductUploadFile productUploadFile = new ProductUploadFile(); productUploadFile.UploadFile = upload; viewModel.Product.ProductUploadFiles.Add(productUploadFile); } return(View(viewModel)); } }