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));
}
}
