public MEDItemDto MEDItemsById(long id) { MEDItemDto ItemDto = new MEDItemDto(); using (EAharaDB context = new EAharaDB()) { var acctype = context.MEDItems.FirstOrDefault(x => x.IsActive == true && x.Id == id); if (acctype != null) { ItemDto.Id = acctype.Id; ItemDto.MEDOfferId = acctype.MEDOfferId; ItemDto.Name = acctype.Name; ItemDto.MEDSubCategoryId = acctype.MEDSubCategoryId; ItemDto.Image1 = acctype.Image1; ItemDto.OfferPrice = acctype.OfferPrice; ItemDto.Price = acctype.Price; ItemDto.Image2 = acctype.Image2; ItemDto.Description = acctype.Description; ItemDto.Tagline = acctype.Tagline; ItemDto.Image3 = acctype.Image3; ItemDto.IsAvailable = acctype.IsAvailable; ItemDto.Image4 = acctype.Image4; ItemDto.IsActive = true; ItemDto.MEDCategoryId = acctype.MEDCategoryId; ItemDto.MEDBrandId = acctype.MEDBrandId; ItemDto.MEDShopId = acctype.MEDShopId; ItemDto.MEDBrand = new MEDBrandDto { Id = acctype.MEDBrand != null ? acctype.MEDBrand.Id : 0, Name = acctype.MEDBrand != null ? acctype.MEDBrand.Name : "", }; ItemDto.MEDShop = new MEDShopDto { Id = acctype.MEDShop != null ? acctype.MEDShop.Id : 0, Name = acctype.MEDShop != null ? acctype.MEDShop.Name : "", }; ItemDto.MEDOffer = new MEDOfferDto { Id = acctype.MEDOffer != null ? acctype.MEDOffer.Id :0, Image = acctype.MEDOffer != null ? acctype.MEDOffer.Image : "", Title = acctype.MEDOffer != null ? acctype.MEDOffer.Title : "", Percentage = acctype.MEDOffer != null ? acctype.MEDOffer.Percentage : 0, }; ItemDto.MEDSubCategory = new MEDSubCategoryDto { Id = acctype.MEDSubCategory.Id, Name = acctype.MEDSubCategory.Name, }; } } return(ItemDto); }
public MEDItemDto GetMEDItemInCart(long id) { MEDItemDto ItemDto = new MEDItemDto(); using (EAharaDB context = new EAharaDB()) { var acctype = context.MEDItems.FirstOrDefault(x => x.IsActive == true && x.Id == id); if (acctype != null) { ItemDto.Id = acctype.Id; ItemDto.MEDOfferId = acctype.MEDOfferId; ItemDto.Name = acctype.Name; ItemDto.MEDSubCategoryId = acctype.MEDSubCategoryId; ItemDto.OfferPrice = acctype.OfferPrice; ItemDto.Price = acctype.Price; ItemDto.Description = acctype.Description; ItemDto.Tagline = acctype.Tagline; ItemDto.IsAvailable = acctype.IsAvailable; ItemDto.IsActive = true; } } return(ItemDto); }
public bool AddMEDItems(MEDItemDto itemDto) { if (itemDto != null) { using (EAharaDB context = new EAharaDB()) { if (itemDto.Id > 0) { var data = context.MEDItems.FirstOrDefault(x => x.Id == itemDto.Id); if (data != null) { data.Name = itemDto.Name; data.Tagline = itemDto.Tagline; data.Price = itemDto.Price; data.MEDOfferId = itemDto.MEDOfferId; data.MEDSubCategoryId = itemDto.MEDSubCategoryId; data.IsAvailable = itemDto.IsAvailable; data.OfferPrice = itemDto.Price; data.Description = itemDto.Description; data.MEDCategoryId = itemDto.MEDCategoryId; data.MEDBrandId = itemDto.MEDBrandId; data.MEDShopId = itemDto.MEDShopId; data.Bookings = itemDto.Bookings; if (data.MEDOfferId > 0) { var offer = context.MEDOffers.FirstOrDefault(x => x.Id == data.MEDOfferId); if (offer.IsPercentage) { data.OfferPrice = data.OfferPrice - (data.OfferPrice * offer.Percentage) / 100; } else { data.OfferPrice = data.OfferPrice - offer.Percentage; } } context.Entry(data).Property(x => x.Name).IsModified = true; context.Entry(data).Property(x => x.MEDShopId).IsModified = true; context.Entry(data).Property(x => x.Tagline).IsModified = true; context.Entry(data).Property(x => x.Price).IsModified = true; context.Entry(data).Property(x => x.MEDOfferId).IsModified = true; context.Entry(data).Property(x => x.MEDSubCategoryId).IsModified = true; context.Entry(data).Property(x => x.IsAvailable).IsModified = true; context.Entry(data).Property(x => x.OfferPrice).IsModified = true; context.Entry(data).Property(x => x.Description).IsModified = true; context.Entry(data).Property(x => x.MEDCategoryId).IsModified = true; context.Entry(data).Property(x => x.MEDBrandId).IsModified = true; context.Entry(data).Property(x => x.Bookings).IsModified = true; if (itemDto.Image1 != null && itemDto.Image1 != "" && data.Image1 != itemDto.Image1 && !itemDto.Image1.Contains("localhost") && !itemDto.Image1.Contains("http")) { data.Image1 = storeImage(itemDto.Image1); context.Entry(data).Property(x => x.Image1).IsModified = true; } if (itemDto.Image2 != null && itemDto.Image2 != "" && data.Image2 != itemDto.Image2 && !itemDto.Image2.Contains("localhost:") && !itemDto.Image1.Contains("http")) { data.Image2 = storeImage(itemDto.Image2); context.Entry(data).Property(x => x.Image2).IsModified = true; } if (itemDto.Image3 != null && itemDto.Image3 != "" && data.Image3 != itemDto.Image3 && !itemDto.Image3.Contains("localhost:") && !itemDto.Image1.Contains("http")) { data.Image3 = storeImage(itemDto.Image3); context.Entry(data).Property(x => x.Image3).IsModified = true; } if (itemDto.Image4 != null && itemDto.Image4 != "" && data.Image4 != itemDto.Image4 && !itemDto.Image4.Contains("localhost:") && !itemDto.Image1.Contains("http")) { data.Image4 = storeImage(itemDto.Image4); context.Entry(data).Property(x => x.Image4).IsModified = true; } context.SaveChanges(); return(true); } return(false); } else { MEDItem item = new MEDItem(); item.Name = itemDto.Name; item.Tagline = itemDto.Tagline; item.Price = itemDto.Price; item.MEDOfferId = itemDto.MEDOfferId; item.MEDSubCategoryId = itemDto.MEDSubCategoryId; item.IsAvailable = itemDto.IsAvailable; item.MEDBrandId = itemDto.MEDBrandId; item.OfferPrice = itemDto.Price; item.Description = itemDto.Description; item.MEDCategoryId = itemDto.MEDCategoryId; item.MEDShopId = itemDto.MEDShopId; item.IsActive = true; if (item.MEDOfferId > 0) { var offer = context.MEDOffers.FirstOrDefault(x => x.Id == item.MEDOfferId); if (offer.IsPercentage) { item.OfferPrice = item.OfferPrice - (item.OfferPrice * offer.Percentage) / 100; } else { item.OfferPrice = item.OfferPrice - offer.Percentage; } } if (itemDto.Image1 != null && itemDto.Image1 != "") { item.Image1 = storeImage(itemDto.Image1); } if (itemDto.Image2 != null && itemDto.Image2 != "") { item.Image2 = storeImage(itemDto.Image2); } if (itemDto.Image3 != null && itemDto.Image3 != "") { item.Image3 = storeImage(itemDto.Image3); } if (itemDto.Image4 != null && itemDto.Image4 != "") { item.Image4 = storeImage(itemDto.Image4); } context.MEDItems.Add(item); context.SaveChanges(); return(true); } } } return(false); }