public ActionResult DeleteConfirmed(int id)
{
try
{
CategoryProperty categoryProperty = db.CategoryProperties.Find(id);
List <CategoryPropertyValue> categoryPropertyValue =
db.CategoryPropertyValues.Where(x => x.CategoryPropertyId == id).ToList();
foreach (var item in categoryPropertyValue)
{
db.CategoryPropertyValues.Remove(item);
PropertyPropertyValues propertyPropertyValues =
db.PropertyPropertyValueses.FirstOrDefault(x => x.CategoryPropertyId == categoryProperty.Id &&
x.CategoryPropertyValueId == item.Id);
db.PropertyPropertyValueses.Remove(propertyPropertyValues);
}
db.CategoryProperties.Remove(categoryProperty);
db.SaveChanges();
}
catch (Exception e)
{
return(View());
}
return(RedirectToAction("Index"));
}
public ActionResult DeleteConfirmed(int id)
{
CategoryPropertyValue categoryPropertyValue = db.CategoryPropertyValues.Find(id);
db.CategoryPropertyValues.Remove(categoryPropertyValue);
PropertyPropertyValues propertyPropertyValues =
db.PropertyPropertyValueses.FirstOrDefault(
x => x.CategoryPropertyId == categoryPropertyValue.CategoryPropertyId &&
x.CategoryPropertyValueId == categoryPropertyValue.Id);
if (propertyPropertyValues != null)
{
db.PropertyPropertyValueses.Remove(propertyPropertyValues);
}
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create([Bind(Include = "ID,CategoryPropertyId,Value,CreateDateTime,CreateUserId,UpdateDateTime,UpdateUserId")] CategoryPropertyValue categoryPropertyValue)
{
if (ModelState.IsValid)
{
//Property Create
categoryPropertyValue.CreateDateTime = DateTime.Now;
categoryPropertyValue.CreateUserId = AdminLoginUserId;
db.CategoryPropertyValues.Add(categoryPropertyValue);
db.SaveChanges();
//PropVal Create
PropertyPropertyValues propertyPropertyValues = new PropertyPropertyValues();
propertyPropertyValues.CategoryPropertyId = categoryPropertyValue.CategoryPropertyId;
propertyPropertyValues.CategoryPropertyValueId = categoryPropertyValue.Id;
propertyPropertyValues.CreateDateTime = DateTime.Now;
propertyPropertyValues.CreateUserId = AdminLoginUserId;
db.PropertyPropertyValueses.Add(propertyPropertyValues);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CategoryPropertyId = new SelectList(db.CategoryProperties, "ID", "Name", categoryPropertyValue.CategoryPropertyId);
return(View(categoryPropertyValue));
}
public int Create(int productId, List <int> pList, List <int> pValList)
{
int basketCount = 0;
try
{
BasketClass.BasketItem basketItem = new BasketClass.BasketItem();
Product product = db.Products.FirstOrDefault(x => x.Id == productId);
basketItem.Product = product;
basketItem.Quantity = 1;
basketItem.Tax = 0;
List <PropertyPropertyValues> propertyPropertyValues = new List <PropertyPropertyValues>();
if (pList != null)
{
for (int i = 0; i < pList.Count; i++)
{
int pId = pList[i];
int pVal = pValList[i];
PropertyPropertyValues dbpropertyPropertyValues = db.PropertyPropertyValueses.Include(x => x.CategoryProperty).Include(x => x.CategoryPropertyValue).FirstOrDefault(x => x.CategoryPropertyId == pId && x.CategoryPropertyValueId == pVal);
propertyPropertyValues.Add(dbpropertyPropertyValues);
}
}
basketItem.PropertyPropertyValueses = propertyPropertyValues;
//basketItem.CategoryPropertyList = pList;
//basketItem.CategoryPropertyValues = pValList;
BasketClass s = new BasketClass();
s.SepeteEkle(basketItem);
s = (BasketClass)Session["AktifSepet"];
basketCount = s.Products.Count;
if (_loginState.IsLogin())
{
int id = _loginState.IsLoginUser().Id;
Basket userBasket = db.Baskets.FirstOrDefault(x => x.UserId == id && x.StatusId == 1);
OrderProduct orderProduct = db.OrderProducts.FirstOrDefault(x => x.Product.Id == product.Id && x.UserId == id && x.InTheBasket);
if (userBasket == null)
{
//Basket newBasket=new Basket();
//newBasket.UserId = id;
//newBasket.StatusId = 1;
//newBasket.CreateUserId = id;
_functions.GirisSepetControl();
orderProduct = new OrderProduct();
orderProduct.CreateDateTime = DateTime.Now;
orderProduct.CreateUserId = _loginState.IsLoginUser().Id;
orderProduct.BasketId = s.BasketId;
orderProduct.InTheBasket = true;
orderProduct.ProductId = product.Id;
orderProduct.UserId = _loginState.IsLoginUser().Id;
orderProduct.Quantity = s.Products.FirstOrDefault(x => x.Product.Id == productId).Quantity;
orderProduct.Amount = (double)s.Products.FirstOrDefault(x => x.Product.Id == product.Id).Total;
orderProduct.BasketId = s.BasketId;
db.OrderProducts.Add(orderProduct);
db.SaveChanges();
}
else
{
if (orderProduct != null)
{
orderProduct.Amount = (double)s.Products.FirstOrDefault(x => x.Product.Id == product.Id).Total;
orderProduct.Quantity = orderProduct.Quantity + 1;
db.Entry(orderProduct).State = EntityState.Modified;
}
else
{
orderProduct = new OrderProduct();
orderProduct.CreateDateTime = DateTime.Now;
orderProduct.CreateUserId = _loginState.IsLoginUser().Id;
orderProduct.BasketId = userBasket.Id;
orderProduct.InTheBasket = true;
orderProduct.ProductId = product.Id;
orderProduct.UserId = _loginState.IsLoginUser().Id;
orderProduct.Quantity = s.Products.FirstOrDefault(x => x.Product.Id == productId).Quantity;
orderProduct.Amount = (double)s.Products.FirstOrDefault(x => x.Product.Id == product.Id).Total;
db.OrderProducts.Add(orderProduct);
}
db.SaveChanges();
}
Basket basket = db.Baskets.FirstOrDefault(x => x.BasketKey == s.BasketKey);
s = (BasketClass)Session["AktifSepet"];
basket.Amount = s.TotalAmount;
db.Entry(basket).State = EntityState.Modified;
db.SaveChanges();
}
}
catch (Exception e)
{
}
return(basketCount);
}
