public ActionResult DeleteConfirmed(Guid id)
{
ram ram = db.rams.Find(id);
db.rams.Remove(ram);
db.SaveChanges();
return(RedirectToAction("Index"));
}
// 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 Edit([Bind(Include = "GID,Name,Specs,Image,Manufacture")] ram ram)
{
var myrole = new Class1();
var userID = User.Identity.GetUserId();
ViewBag.currentrole = myrole.a(userID);
if (ModelState.IsValid)
{
db.Entry(ram).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(ram));
}
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));
}
}
public ActionResult Create([Bind(Include = "GID,Name,Specs,Image,Manufacture")] ram ram)
{
var myrole = new Class1();
var userID = User.Identity.GetUserId();
ViewBag.currentrole = myrole.a(userID);
if (ModelState.IsValid)
{
ram.GID = Guid.NewGuid();
db.rams.Add(ram);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(ram));
}
public bool addRam(int ram)
{
try
{
DBModel dBModel = new DBModel();
ram r = new ram();
r.RAM1 = ram;
dBModel.rams.Add(r);
dBModel.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
// 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"));
}
public ActionResult Details(Guid?id)
{
var myrole = new Class1();
var userID = User.Identity.GetUserId();
ViewBag.currentrole = myrole.a(userID);
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ram ram = db.rams.Find(id);
if (ram == null)
{
return(HttpNotFound());
}
return(View(ram));
}
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 bool delRam(int ram)
{
try
{
DBModel dBModel = new DBModel();
ram r = dBModel.rams.Where(x => x.RAM1 == ram).FirstOrDefault();
if (r != null)
{
dBModel.rams.Attach(r);
dBModel.rams.Remove(r);
dBModel.SaveChanges();
return(true);
}
else
{
return(false);
}
}
catch (Exception e)
{
return(false);
}
}
