public ActionResult Minus_To_Cart(int id)
{
//Console.WriteLine("Add to shoppingcart is succesfully called");
int?ProductId;
ProductId = id;
using (new_testEntities db = new new_testEntities())
{
//user user = db.user.FirstOrDefault(x => x.ID == id);
shoppingcart Shoppingcart = db.shoppingcart.FirstOrDefault(x => x.ProductId == id);
Shoppingcart.Quantity -= 1;
db.SaveChanges();
if (Shoppingcart.Quantity <= 0)
{
db.shoppingcart.Remove(Shoppingcart);
db.SaveChanges();
}
return(RedirectToAction("Index", "Shoppingcart"));
}
}
public ActionResult CheckOut()
{
List <shoppingcart> shoppingcartitems = new List <shoppingcart>();
product product = new product();
EmailService mail = new EmailService();
IdentityMessage message = new IdentityMessage();
var keys = Request.Form.AllKeys;
message.Destination = Request.Form.Get(keys[0]);
message.Subject = "Order confirmation Bright Yellow";
message.Body = "Thank you for your purchase. <br />You purchased the following items:";
using (new_testEntities db = new new_testEntities())
{
string userid = "0";
if (Request.IsAuthenticated)
{
userid = User.Identity.GetUserId();
}
shoppingcartitems = db.shoppingcart.Where(x => x.UserId == userid).ToList();
foreach (shoppingcart item in shoppingcartitems)
{
product = db.product.FirstOrDefault(x => x.ID == item.ProductId);
product.stock = product.stock - item.Quantity;
message.Body = message.Body + "<br />" + product.ProductName;
if (product.PurchasedQuantity == null)
{
product.PurchasedQuantity = 1;
}
product.PurchasedQuantity = product.PurchasedQuantity + item.Quantity;
db.SaveChanges();
db.shoppingcart.Remove(item);
db.SaveChanges();
int productid = item.ProductId;
int quantity = (int)item.Quantity;
DateTime date = DateTime.Now;
string productname = product.ProductName;
string imagePath = product.imagepath;
purchasehistory ph = new purchasehistory
{
ProductID = productid,
UserID = userid,
Quantity = quantity,
PurchaseDate = date,
ProductName = productname,
imagepath = imagePath
};
db.purchasehistory.Add(ph);
db.SaveChanges();
}
try
{
mail.SendAsync(message);
}
catch
{
}
}
return(View());
}
public ActionResult Index()
{
using (new_testEntities db = new new_testEntities())
{
return(View(db.ssd.ToList()));
}
}
public ActionResult Index()
{
using (new_testEntities db = new new_testEntities())
{
return(View(db.internalharddisk.ToList()));
}
}
public ActionResult View(int id)
{
ssd ssdimage = new ssd();
using (new_testEntities db = new new_testEntities())
{
//db.ram.Add(new ram
//{
// Brand = "testbrand",
// CompositionOfMemory = "wut",
// MemoryType = "testtype",
// Clockspeed = 1,
// CASlatency = 1,
// Voltage = 1,
// MemoryModuleConnection = 50,
// MemorySuitableFor = "datatest",
// ImagePath = "C:/Users/Erik/Desktop/Prj5-6/project-5-6 - Copy/webshop2/webshop2/Contentram1.jpg"
//});
//db.SaveChanges();
ssdimage = db.ssd.Where(x => x.ID == id).FirstOrDefault();
}
return(View(ssdimage));
}
//[HttpGet]
public ActionResult Add_To_Wishlist(int id)
{
//Console.WriteLine("Add to wishlist is succesfully called");
ID = id;
using (new_testEntities db = new new_testEntities())
{
//user user = db.user.FirstOrDefault(x => x.ID == id);
product product = db.product.FirstOrDefault(x => x.ID == id);
string userid = User.Identity.GetUserId();
wishlist Wishlist = db.wishlist.FirstOrDefault(x => x.ProductId == id && x.UserId == userid);
if (Wishlist == null)
{
db.wishlist.Add(new wishlist {
ProductId = product.ID, UserId = userid, Quantity = 1, ProductName = product.ProductName, Price = product.price, Imagepath = product.imagepath
});
db.SaveChanges();
}
else
{
Wishlist.Quantity += 1;
db.SaveChanges();
}
return(RedirectToAction("Index", "Wishlist"));
}
}
public ActionResult Minus_To_Wishlist(int id)
{
//Console.WriteLine("Add to wishlist is succesfully called");
int?ProductId;
ProductId = id;
using (new_testEntities db = new new_testEntities())
{
//user user = db.user.FirstOrDefault(x => x.ID == id);
wishlist Wishlist = db.wishlist.FirstOrDefault(x => x.ProductId == id);
Wishlist.Quantity -= 1;
db.SaveChanges();
if (Wishlist.Quantity <= 0)
{
db.wishlist.Remove(Wishlist);
db.SaveChanges();
}
return(RedirectToAction("Index", "Wishlist"));
}
}
public ActionResult Add_To_Cart(int id)
{
//Console.WriteLine("Add to wishlist is succesfully called");
int?ProductId;
ProductId = id;
using (new_testEntities db = new new_testEntities())
{
product product = db.product.FirstOrDefault(x => x.ID == id);
string userid = "0";
if (Request.IsAuthenticated)
{
userid = User.Identity.GetUserId();
}
shoppingcart shoppingcart = db.shoppingcart.FirstOrDefault(x => x.ProductId == id && x.UserId == userid);
wishlist Wishlist = db.wishlist.FirstOrDefault(x => x.ProductId == id);
if (shoppingcart == null)
{
db.shoppingcart.Add(new shoppingcart {
ProductId = Wishlist.ProductId, UserId = User.Identity.GetUserId(), Quantity = Wishlist.Quantity, ProductName = Wishlist.ProductName, Price = Wishlist.Price, Imagepath = Wishlist.Imagepath
});
db.SaveChanges();
}
else
{
shoppingcart.Quantity += Wishlist.Quantity;
db.SaveChanges();
}
return(RedirectToAction("Index", "Shoppingcart"));
}
}
public ActionResult FilterRam(string searchstring)
{
using (new_testEntities db = new new_testEntities())
{
var data = db.ram.Where(r => r.Name.Contains(searchstring) || r.Brand.Contains(searchstring) || r.MemorySuitableFor.Contains(searchstring) || r.MemoryType.Contains(searchstring)).ToList();
return(View(data));
}
}
// GET: Statistics/Details/5
public ActionResult Details(int id)
{
ram ram = new ram();
using (new_testEntities db = new new_testEntities())
{
ram = db.ram.FirstOrDefault(x => x.ID == id);
}
return(View(ram));
}
public ActionResult View(int id)
{
wishlist wishlist = new wishlist();
using (new_testEntities db = new new_testEntities())
{
wishlist = db.wishlist.FirstOrDefault(x => x.ProductId == 1);
}
return(View(wishlist));
}
public ActionResult Delete(int id)
{
using (new_testEntities db = new new_testEntities())
{
shoppingcart shoppingcart = db.shoppingcart.FirstOrDefault(x => x.ProductId == id);
db.shoppingcart.Remove(shoppingcart);
db.SaveChanges();
}
return(RedirectToAction("Index", "Shoppingcart"));
}
public ActionResult Index() //laten zien van de wishlist
{
List <wishlist> list_wishlist = new List <wishlist>();
using (new_testEntities db = new new_testEntities())
{
using (ApplicationDbContext db2 = new ApplicationDbContext())
{
string userid = User.Identity.GetUserId();
return(View(db.wishlist.Where(item => item.UserId == userid).ToList()));
}
}
}
public ActionResult Create(FormCollection collection)
{
try
{
using (ApplicationDbContext db2 = new ApplicationDbContext())
{
if (User.IsInRole("Admin"))
{
// TODO: Add insert logic here
using (new_testEntities db = new new_testEntities())
{
product p = new product
{
price = Convert.ToDecimal(collection[11]),
imagepath = collection[9],
stock = 100,
Brand = collection[1],
Supplier = "testsupplier",
ProductName = collection[10]
};
ram r = new ram
{
ID = p.ID,
Brand = p.Brand,
CompositionOfMemory = collection[2],
MemoryType = collection[3],
Clockspeed = Convert.ToInt32(collection[4]),
CASlatency = Convert.ToInt32(collection[5]),
Voltage = (float)Convert.ToDouble(collection[6]),
MemoryModuleConnection = Convert.ToInt32(collection[7]),
MemorySuitableFor = collection[8],
ImagePath = p.imagepath,
Name = p.ProductName,
Price = p.price,
Ramsize = Convert.ToInt32(collection[12])
};
db.product.Add(p);
db.ram.Add(r);
db.SaveChanges();
}
}
}
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
// GET: Statistics/Edit/5
public ActionResult Edit(int id)
{
using (ApplicationDbContext db2 = new ApplicationDbContext())
{
ram ram = new ram();
if (User.IsInRole("Admin"))
{
using (new_testEntities db = new new_testEntities())
{
ram = db.ram.FirstOrDefault(r => r.ID == id);
}
}
return(View(ram));
}
}
// GET: Shoppingcart
public ActionResult Index()
{
if (Request.HttpMethod == "POST")
{
return(CheckOut());
}
else
{
ViewBag.Message = "Your Shopping Cart.";
List <shoppingcart> listshoppingcartitems = new List <shoppingcart>();
using (new_testEntities db = new new_testEntities())
{
string userid = "0";
if (Request.IsAuthenticated)
{
userid = User.Identity.GetUserId();
}
listshoppingcartitems = db.shoppingcart.Where(x => x.UserId == userid).ToList();
if (listshoppingcartitems.Count > 0)
{
int totalquantity = 0;
decimal totalprice = 0;
foreach (var item in listshoppingcartitems)
{
totalquantity += (int)item.Quantity;
totalprice += (decimal)item.Price * (int)item.Quantity;
}
listshoppingcartitems.Add(
new shoppingcart
{
Quantity = totalquantity,
Price = totalprice,
ProductName = " ",
Imagepath = " "
});
}
if (Request.IsAuthenticated && listshoppingcartitems.Count > 0)
{
using (ApplicationDbContext db2 = new ApplicationDbContext())
{
listshoppingcartitems[0].email = db2.Users.FirstOrDefault(user => user.Id == userid).Email;
}
}
}
return(View(listshoppingcartitems));
}
}
// GET: Statistics/Delete/5
public ActionResult Delete(int id)
{
using (ApplicationDbContext db2 = new ApplicationDbContext())
{
if (User.IsInRole("Admin"))
{
using (new_testEntities db = new new_testEntities())
{
ram ram = db.ram.FirstOrDefault(r => r.ID == id);
product product = db.product.FirstOrDefault(p => p.ID == id);
db.ram.Remove(ram);
db.product.Remove(product);
db.SaveChanges();
}
}
}
return(RedirectToAction("Index"));
}
// GET: Statistics
public ActionResult Index()
{
List <product> listproducts = new List <product>();
using (ApplicationDbContext db2 = new ApplicationDbContext())
{
if (User.IsInRole("Admin"))
{
using (new_testEntities db = new new_testEntities())
{
listproducts = db.product.ToList();
}
}
}
return(View(listproducts));
}
// GET: purchasehistory
public ActionResult Index()
{
using (new_testEntities db = new new_testEntities())
{
using (ApplicationDbContext db2 = new ApplicationDbContext())
{
string userID = User.Identity.GetUserId();
if (User.IsInRole("Admin"))
{
return(View(db.purchasehistory.ToList()));
}
else
{
return(View(db.purchasehistory.Where(ph => ph.UserID == userID).ToList()));
}
}
}
}
public ActionResult Edit(int id, FormCollection collection)
{
try
{
using (ApplicationDbContext db2 = new ApplicationDbContext())
{
if (User.IsInRole("Admin"))
{
using (new_testEntities db = new new_testEntities())
{
// TODO: Add update logic here
ram ram = db.ram.FirstOrDefault(r => r.ID == id);
product product = db.product.FirstOrDefault(p => p.ID == id);
ram.ImagePath = collection[10];
product.imagepath = collection[10];
ram.Brand = collection[2];
product.Brand = collection[2];
ram.CompositionOfMemory = collection[3];
ram.MemoryType = collection[4];
ram.Clockspeed = Convert.ToInt32(collection[5]);
ram.CASlatency = Convert.ToInt32(collection[6]);
ram.Voltage = (float)Convert.ToDouble(collection[7]);
ram.MemoryModuleConnection = Convert.ToInt32(collection[8]);
ram.MemorySuitableFor = collection[9];
ram.Name = collection[11];
product.ProductName = collection[11];
ram.Price = Convert.ToDecimal(collection[12]);
product.price = Convert.ToDecimal(collection[12]);
ram.Ramsize = Convert.ToInt32(collection[13]);
db.SaveChanges();
}
}
return(RedirectToAction("Index"));
}
}
catch
{
return(View());
}
}
public ActionResult View(int?id)
{
ram ram = new ram();
ID = id;
using (new_testEntities db = new new_testEntities())
{
//db.product.Add(new product
//{
// ID = id,
// price = 80,
// imagepath = "~/images/ram/ram1.jpg",
// stock = 100,
// Brand = "Kingston",
// Supplier = "testsupplier"
//});
//db.SaveChanges();
//product product = db.product.FirstOrDefault(x => x.ID == id);
//db.ram.Add(new ram
//{
// ID = product.ID,
// Brand = "Kingston",
// CompositionOfMemory = "1x",
// MemoryType = "DDR3",
// Clockspeed = 2133,
// CASlatency = 15,
// Voltage = (float)1.2 ,
// MemoryModuleConnection = 1,
// MemorySuitableFor = "Desktop",
// ImagePath = "~/images/ram/ram1.jpg",
// Name = "Kingston123",
// Price = 80,
// Ramsize = 8
//});
//db.SaveChanges();
ram = db.ram.Where(x => x.ID == ID).FirstOrDefault();
}
return(View(ram));
}
public ActionResult ShowChart()
{
using (new_testEntities db = new new_testEntities())
{
List <string> listproductnames = new List <string>();
List <string> listproductpurchasedquantity = new List <string>();
foreach (product p in db.product)
{
if (p.PurchasedQuantity > 0)
{
listproductnames.Add(p.ProductName.ToString());
listproductpurchasedquantity.Add(p.PurchasedQuantity.ToString());
}
}
var chart = new Chart(width: 600, height: 400)
.AddSeries(
chartType: "column",
xValue: listproductnames,
yValues: listproductpurchasedquantity)
.GetBytes("png");
return(File(chart, "image/bytes"));
}
}
public ActionResult FilterRam(int?minprice, int?maxprice, int?minsize, int?maxsize, string brands, string ramType)
{
using (new_testEntities db = new new_testEntities())
{
if (ramType == "")
{
if (brands == "")
{
if (minprice == null)
{
if (maxprice == null)
{
if (minsize == null)
{
if (maxsize == null)
{
return(View(db.ram.ToList()));
}
else
{
return(View(db.ram.Where(r => r.Ramsize <= maxsize).ToList()));
}
}
else
{
if (maxsize == null)
{
return(View(db.ram.Where(r => r.Ramsize >= minsize).ToList()));
}
else
{
return(View(db.ram.Where(r => r.Ramsize >= minsize && r.Ramsize <= maxsize).ToList()));
}
}
}
else
{
if (minsize == null)
{
if (maxsize == null)
{
return(View(db.ram.Where(r => r.Price <= maxprice).ToList()));
}
else
{
return(View(db.ram.Where(r => r.Price <= maxprice && r.Ramsize <= maxsize).ToList()));
}
}
else
{
if (maxsize == null)
{
return(View(db.ram.Where(r => r.Price <= maxprice && r.Ramsize >= minsize).ToList()));
}
else
{
return(View(db.ram.Where(r => r.Price <= maxprice && r.Ramsize >= minsize && r.Ramsize <= maxsize).ToList()));
}
}
}
}
else
{
if (maxprice == null)
{
if (minsize == null)
{
if (maxsize == null)
{
return(View(db.ram.Where(r => r.Price >= minprice).ToList()));
}
else
{
return(View(db.ram.Where(r => r.Price >= minprice && r.Ramsize <= maxsize).ToList()));
}
}
else
{
if (maxsize == null)
{
return(View(db.ram.Where(r => r.Price >= minprice && r.Ramsize >= minsize).ToList()));
}
else
{
return(View(db.ram.Where(r => r.Price >= minprice && r.Ramsize >= minsize && r.Ramsize <= maxsize).ToList()));
}
}
}
else
{
if (minsize == null)
{
if (maxsize == null)
{
return(View(db.ram.Where(r => r.Price >= minprice && r.Price <= maxprice).ToList()));
}
else
{
return(View(db.ram.Where(r => r.Price >= minprice && r.Price <= maxprice && r.Ramsize <= maxsize).ToList()));
}
}
else
{
if (maxsize == null)
{
return(View(db.ram.Where(r => r.Price >= minprice && r.Price <= maxprice && r.Ramsize >= minsize).ToList()));
}
else
{
return(View(db.ram.Where(r => r.Price >= minprice && r.Price <= maxprice && r.Ramsize >= minsize && r.Ramsize <= maxsize).ToList()));
}
}
}
}
}
else
{
if (minprice == null)
{
if (maxprice == null)
{
if (minsize == null)
{
if (maxsize == null)
{
return(View(db.ram.Where(r => r.Brand == brands).ToList()));
}
else
{
return(View(db.ram.Where(r => r.Ramsize <= maxsize && r.Brand == brands).ToList()));
}
}
else
{
if (maxsize == null)
{
return(View(db.ram.Where(r => r.Ramsize >= minsize && r.Brand == brands).ToList()));
}
else
{
return(View(db.ram.Where(r => r.Ramsize >= minsize && r.Ramsize <= maxsize && r.Brand == brands).ToList()));
}
}
}
else
{
if (minsize == null)
{
if (maxsize == null)
{
return(View(db.ram.Where(r => r.Price <= maxprice && r.Brand == brands).ToList()));
}
else
{
return(View(db.ram.Where(r => r.Price <= maxprice && r.Ramsize <= maxsize && r.Brand == brands).ToList()));
}
}
else
{
if (maxsize == null)
{
return(View(db.ram.Where(r => r.Price <= maxprice && r.Ramsize >= minsize && r.Brand == brands).ToList()));
}
else
{
return(View(db.ram.Where(r => r.Price <= maxprice && r.Ramsize >= minsize && r.Ramsize <= maxsize && r.Brand == brands).ToList()));
}
}
}
}
else
{
if (maxprice == null)
{
if (minsize == null)
{
if (maxsize == null)
{
return(View(db.ram.Where(r => r.Price >= minprice && r.Brand == brands).ToList()));
}
else
{
return(View(db.ram.Where(r => r.Price >= minprice && r.Ramsize <= maxsize && r.Brand == brands).ToList()));
}
}
else
{
if (maxsize == null)
{
return(View(db.ram.Where(r => r.Price >= minprice && r.Ramsize >= minsize && r.Brand == brands).ToList()));
}
else
{
return(View(db.ram.Where(r => r.Price >= minprice && r.Ramsize >= minsize && r.Ramsize <= maxsize && r.Brand == brands).ToList()));
}
}
}
else
{
if (minsize == null)
{
if (maxsize == null)
{
return(View(db.ram.Where(r => r.Price >= minprice && r.Price <= maxprice && r.Brand == brands).ToList()));
}
else
{
return(View(db.ram.Where(r => r.Price >= minprice && r.Price <= maxprice && r.Ramsize <= maxsize && r.Brand == brands).ToList()));
}
}
else
{
if (maxsize == null)
{
return(View(db.ram.Where(r => r.Price >= minprice && r.Price <= maxprice && r.Ramsize >= minsize && r.Brand == brands).ToList()));
}
else
{
return(View(db.ram.Where(r => r.Price >= minprice && r.Price <= maxprice && r.Ramsize >= minsize && r.Ramsize <= maxsize && r.Brand == brands).ToList()));
}
}
}
}
}
}
else
{
if (brands == "")
{
if (minprice == null)
{
if (maxprice == null)
{
if (minsize == null)
{
if (maxsize == null)
{
return(View(db.ram.Where(r => r.MemoryType == ramType).ToList()));
}
else
{
return(View(db.ram.Where(r => r.Ramsize <= maxsize && r.MemoryType == ramType).ToList()));
}
}
else
{
if (maxsize == null)
{
return(View(db.ram.Where(r => r.Ramsize >= minsize && r.MemoryType == ramType).ToList()));
}
else
{
return(View(db.ram.Where(r => r.Ramsize >= minsize && r.Ramsize <= maxsize && r.MemoryType == ramType).ToList()));
}
}
}
else
{
if (minsize == null)
{
if (maxsize == null)
{
return(View(db.ram.Where(r => r.Price <= maxprice && r.MemoryType == ramType).ToList()));
}
else
{
return(View(db.ram.Where(r => r.Price <= maxprice && r.Ramsize <= maxsize && r.MemoryType == ramType).ToList()));
}
}
else
{
if (maxsize == null)
{
return(View(db.ram.Where(r => r.Price <= maxprice && r.Ramsize >= minsize && r.MemoryType == ramType).ToList()));
}
else
{
return(View(db.ram.Where(r => r.Price <= maxprice && r.Ramsize >= minsize && r.Ramsize <= maxsize && r.MemoryType == ramType).ToList()));
}
}
}
}
else
{
if (maxprice == null)
{
if (minsize == null)
{
if (maxsize == null)
{
return(View(db.ram.Where(r => r.Price >= minprice && r.MemoryType == ramType).ToList()));
}
else
{
return(View(db.ram.Where(r => r.Price >= minprice && r.Ramsize <= maxsize && r.MemoryType == ramType).ToList()));
}
}
else
{
if (maxsize == null)
{
return(View(db.ram.Where(r => r.Price >= minprice && r.Ramsize >= minsize && r.MemoryType == ramType).ToList()));
}
else
{
return(View(db.ram.Where(r => r.Price >= minprice && r.Ramsize >= minsize && r.Ramsize <= maxsize && r.MemoryType == ramType).ToList()));
}
}
}
else
{
if (minsize == null)
{
if (maxsize == null)
{
return(View(db.ram.Where(r => r.Price >= minprice && r.Price <= maxprice && r.MemoryType == ramType).ToList()));
}
else
{
return(View(db.ram.Where(r => r.Price >= minprice && r.Price <= maxprice && r.Ramsize <= maxsize && r.MemoryType == ramType).ToList()));
}
}
else
{
if (maxsize == null)
{
return(View(db.ram.Where(r => r.Price >= minprice && r.Price <= maxprice && r.Ramsize >= minsize && r.MemoryType == ramType).ToList()));
}
else
{
return(View(db.ram.Where(r => r.Price >= minprice && r.Price <= maxprice && r.Ramsize >= minsize && r.Ramsize <= maxsize && r.MemoryType == ramType).ToList()));
}
}
}
}
}
else
{
if (minprice == null)
{
if (maxprice == null)
{
if (minsize == null)
{
if (maxsize == null)
{
return(View(db.ram.Where(r => r.Brand == brands && r.MemoryType == ramType).ToList()));
}
else
{
return(View(db.ram.Where(r => r.Ramsize <= maxsize && r.Brand == brands && r.MemoryType == ramType).ToList()));
}
}
else
{
if (maxsize == null)
{
return(View(db.ram.Where(r => r.Ramsize >= minsize && r.Brand == brands && r.MemoryType == ramType).ToList()));
}
else
{
return(View(db.ram.Where(r => r.Ramsize >= minsize && r.Ramsize <= maxsize && r.Brand == brands && r.MemoryType == ramType).ToList()));
}
}
}
else
{
if (minsize == null)
{
if (maxsize == null)
{
return(View(db.ram.Where(r => r.Price <= maxprice && r.Brand == brands && r.MemoryType == ramType).ToList()));
}
else
{
return(View(db.ram.Where(r => r.Price <= maxprice && r.Ramsize <= maxsize && r.Brand == brands && r.MemoryType == ramType).ToList()));
}
}
else
{
if (maxsize == null)
{
return(View(db.ram.Where(r => r.Price <= maxprice && r.Ramsize >= minsize && r.Brand == brands && r.MemoryType == ramType).ToList()));
}
else
{
return(View(db.ram.Where(r => r.Price <= maxprice && r.Ramsize >= minsize && r.Ramsize <= maxsize && r.Brand == brands && r.MemoryType == ramType).ToList()));
}
}
}
}
else
{
if (maxprice == null)
{
if (minsize == null)
{
if (maxsize == null)
{
return(View(db.ram.Where(r => r.Price >= minprice && r.Brand == brands && r.MemoryType == ramType).ToList()));
}
else
{
return(View(db.ram.Where(r => r.Price >= minprice && r.Ramsize <= maxsize && r.Brand == brands && r.MemoryType == ramType).ToList()));
}
}
else
{
if (maxsize == null)
{
return(View(db.ram.Where(r => r.Price >= minprice && r.Ramsize >= minsize && r.Brand == brands && r.MemoryType == ramType).ToList()));
}
else
{
return(View(db.ram.Where(r => r.Price >= minprice && r.Ramsize >= minsize && r.Ramsize <= maxsize && r.Brand == brands && r.MemoryType == ramType).ToList()));
}
}
}
else
{
if (minsize == null)
{
if (maxsize == null)
{
return(View(db.ram.Where(r => r.Price >= minprice && r.Price <= maxprice && r.Brand == brands && r.MemoryType == ramType).ToList()));
}
else
{
return(View(db.ram.Where(r => r.Price >= minprice && r.Price <= maxprice && r.Ramsize <= maxsize && r.Brand == brands && r.MemoryType == ramType).ToList()));
}
}
else
{
if (maxsize == null)
{
return(View(db.ram.Where(r => r.Price >= minprice && r.Price <= maxprice && r.Ramsize >= minsize && r.Brand == brands && r.MemoryType == ramType).ToList()));
}
else
{
return(View(db.ram.Where(r => r.Price >= minprice && r.Price <= maxprice && r.Ramsize >= minsize && r.Ramsize <= maxsize && r.Brand == brands && r.MemoryType == ramType).ToList()));
}
}
}
}
}
}
}
}
