public ActionResult BrandMobiles(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
if (con1.State == System.Data.ConnectionState.Closed)
{
con1.Open();
}
string que = "SELECT [Name] From Brands WHERE Brands.Id = @param";
SqlCommand cmd = new SqlCommand(que, con1);
cmd.Parameters.AddWithValue("param", id);
string brandname = cmd.ExecuteScalar().ToString();
string que1 = "SELECT [Description] From Brands WHERE Brands.Id = @param1";
SqlCommand cmd1 = new SqlCommand(que1, con1);
cmd1.Parameters.AddWithValue("param1", id);
string branddesc = cmd1.ExecuteScalar().ToString();
ViewBag.linkablename = brandname;
ViewBag.linkabledesc = branddesc;
ViewBag.linkableId = id;
var entities = new DB16Entities();
return(View(entities.Mobiles.ToList()));
}
//***************************************** Pictures ******************************************//
public ActionResult PIndex()
{
using (DB16Entities db = new DB16Entities())
{
return(View(db.Pictures.ToList()));
}
}
public ActionResult BIndex()
{
using (DB16Entities db = new DB16Entities())
{
return(View(db.Brands.ToList()));
}
}
public ActionResult PDetails(int?id)
{
Picture p = new Picture();
using (DB16Entities db = new DB16Entities())
{
p = db.Pictures.Where(x => x.Id == id).FirstOrDefault();
}
return(View(p));
}
public ActionResult BDetails(int?id)
{
Brand b = new Brand();
using (DB16Entities db = new DB16Entities())
{
b = db.Brands.Where(x => x.Id == id).FirstOrDefault();
}
return(View(b));
}
public ActionResult BrandMobiles(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ViewBag.linkableId = id;
var entities = new DB16Entities();
return(View(entities.Mobiles.ToList()));
}
public ActionResult RegisterBrand(Brand obj)
{
string fileName = Path.GetFileNameWithoutExtension(obj.ImageFile.FileName);
string extension = Path.GetExtension(obj.ImageFile.FileName);
fileName = fileName + DateTime.Now.ToString("yymmssfff") + extension;
obj.Image = "~/Image/" + fileName;
fileName = Path.Combine(Server.MapPath("~/Image/"), fileName);
obj.ImageFile.SaveAs(fileName);
using (DB16Entities db = new DB16Entities())
{
db.Brands.Add(obj);
db.SaveChanges();
ModelState.Clear();
obj = null;
ViewBag.Message = "Registered Successful";
return(RedirectToAction("MIndex"));
}
}
public ActionResult RegisterPicture(Picture obj)
{
string fileName = Path.GetFileNameWithoutExtension(obj.ImageFile1.FileName);
string extension = Path.GetExtension(obj.ImageFile1.FileName);
fileName = fileName + DateTime.Now.ToString("yymmssfff") + extension;
obj.Image = "~/Image/" + fileName;
fileName = Path.Combine(Server.MapPath("~/Image/"), fileName);
obj.ImageFile1.SaveAs(fileName);
using (DB16Entities db = new DB16Entities())
{
db.Pictures.Add(obj);
db.SaveChanges();
ModelState.Clear();
obj = null;
TempData["msg"] = "<script>alert('Register successfully');</script>";
return(RedirectToAction("PIndex"));
}
}
public ActionResult MobileReviews(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
if (con1.State == System.Data.ConnectionState.Closed)
{
con1.Open();
}
string que = "SELECT [Name] From Mobile WHERE Mobile.Id = @param";
SqlCommand cmd = new SqlCommand(que, con1);
cmd.Parameters.AddWithValue("param", id);
string mobilename = cmd.ExecuteScalar().ToString();
ViewBag.linkablename = mobilename;
ViewBag.linkableId = id;
var entities = new DB16Entities();
return(View(entities.Reviews.ToList()));
}
public ActionResult Cam25to40()
{
var entities = new DB16Entities();
return(View(entities.Mobiles.ToList()));
}
public ActionResult Screen7to8()
{
var entities = new DB16Entities();
return(View(entities.Mobiles.ToList()));
}
public ActionResult RAMLess4GB()
{
var entities = new DB16Entities();
return(View(entities.Mobiles.ToList()));
}
public ActionResult Price50to99()
{
var entities = new DB16Entities();
return(View(entities.Mobiles.ToList()));
}
public ActionResult Index()
{
var entities = new DB16Entities();
return(View(entities.Brands.ToList()));
}
