public ActionResult AddToBasket(OfferDet offer)
{
if (offer == null)
{
return(Json(new { success = false }));
}
using (PriceDataModel2 db = new PriceDataModel2())
{
OfferDet offerdet = db.OfferDet.FirstOrDefault(x => x.ID == offer.ID);
if (offerdet == null)
{
return(Json(new { success = false }));
}
offerdet.ColorName = offer.ColorName;
offerdet.Height = offer.Height;
offerdet.Width = offer.Width;
offerdet.System = offer.System;
offerdet.Quantity = offer.Quantity;
db.OfferDet.Add(offerdet);
db.SaveChanges();
}
return(Json(new { success = true }));
}
public ActionResult Index(OfferDet basket)
{
var user = User.Identity.GetUserId();
using (PriceDataModel2 db = new PriceDataModel2())
{
var basketMas = db.OfferMas.SingleOrDefault(a => a.User == user && a.IsActive && a.Status == 0);
if (basketMas == null)
{
var userCard = userManager.Users.FirstOrDefault(a => a.Id == user);
var lastindex = db.Reference.FirstOrDefault(c => c.StoreId == userCard.StoreId && c.Type == "Offer");
if (lastindex == null)
{
Reference lastindex1 = new Reference();
lastindex1.StoreId = userCard.StoreId;
lastindex1.Type = "Offer";
lastindex1.LastReference = 1;
lastindex = lastindex1;
lastindex.LastReference += 1;
db.Reference.Add(lastindex1);
db.SaveChanges();
}
else
{
lastindex.LastReference += 1;
db.SaveChanges();
}
var store = db.Stores.FirstOrDefault(a => a.Id == userCard.StoreId);
OfferMas bmas = new OfferMas();
bmas.User = user;
bmas.Store = store;
bmas.IsActive = true;
bmas.IsDeleted = false;
bmas.RevisionId = 0;
bmas.Date = DateTime.Now;
string lastindex2 = "000000" + lastindex.LastReference;
bmas.ReferenceNo = "LM" + store.StoreCode + lastindex2.Substring(lastindex2.Length - 6, 6);
basket.OfferMas = bmas;
db.OfferDet.Add(basket);
db.SaveChanges();
}
else
{
basket.BasketMas_ID = basketMas.ID;
basketMas.Date = DateTime.Now;
db.OfferDet.Add(basket);
db.SaveChanges();
}
}
return(Json(new { success = true }));
}
public JsonResult SaveTempOffer(List <BasketView> tempData)
{
if (tempData == null)
{
return(Json(new { success = false }, JsonRequestBehavior.AllowGet));
}
int id = 0;
var first = tempData.First();
using (PriceDataModel2 db = new PriceDataModel2())
{
var offerMas = db.OfferMas.FirstOrDefault(a => a.ID == first.MasId);
if (offerMas != null)
{
offerMas.IsActive = false;
db.SaveChanges();
offerMas.IsActive = true;
offerMas.RevisionId += 1;
db.OfferMas.Add(offerMas);
db.SaveChanges();
id = offerMas.ID;
}
List <OfferDet> offerDetList = new List <OfferDet>();
foreach (var el in tempData)
{
OfferDet offerDet = new OfferDet()
{
ArmType = el.ArmType,
ColorName = el.Color,
Direction = el.Direction,
Height = el.Height,
OfferMas = offerMas,
Price = el.Price,
ProductId = el.ProductId,
Quantity = el.Quantity,
System = el.System,
Width = el.Width
};
offerDetList.Add(offerDet);
}
db.OfferDet.AddRange(offerDetList);
db.SaveChanges();
}
return(Json(new { success = true, masId = id }, JsonRequestBehavior.AllowGet));
}
public ActionResult UpdateQuantity(OfferDet oDet)
{
var user = User.Identity.GetUserId();
using (PriceDataModel2 db = new PriceDataModel2())
{
try
{
var offerDet = db.OfferDet.FirstOrDefault(a => a.ID == oDet.ID && a.OfferMas.User == user);
offerDet.Quantity = oDet.Quantity;
db.SaveChanges();
return(Json(new { success = true }, JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
return(Json(new { success = false }, JsonRequestBehavior.AllowGet));
}
}
}
public ActionResult AddToBasket(OfferDet offer)
{
if (offer == null)
{
return(Json(new { success = false }));
}
using (PriceDataModel2 db = new PriceDataModel2())
{
OfferDet offerdet = db.OfferDet.FirstOrDefault(x => x.ID == offer.ID);
if (offerdet == null)
{
return(Json(new { success = false }));
}
offerdet.ColorName = offer.ColorName;
offerdet.Height = offer.Height;
offerdet.Width = offer.Width;
offerdet.System = offer.System;
offerdet.Quantity = offer.Quantity;
offerdet.ProductId = db.OfferDet.FirstOrDefault(a => a.ID == offer.ID).ProductId;
int systemId = Convert.ToInt32(offerdet.System == "Pro 7006 ®" ? "0" : offer.System == "Pro 7006 ® 2" ? "2" : "1");
bool colorName = offerdet.ColorName != "bianco";
var priceMatrix = db.Prices.Where(p => p.ProductId == offerdet.ProductId && p.Activity && p.Profil == systemId && p.Color == colorName).ToList();
foreach (var item in priceMatrix)
{
if (offerdet.Width > item.Width - 100 && offerdet.Width <= item.Width && offerdet.Height > item.Height - 100 && offerdet.Height <= item.Height && item.Color == colorName)
{
offerdet.Price = item.Prices;
offerdet.Price = Math.Ceiling(offerdet.Price);
}
} //////////////////3. profil çeşidi fiyat hesap alanı
db.OfferDet.Add(offerdet);
db.SaveChanges();
}
return(Json(new { success = true }));
}
