public ActionResult BDeleteConfirmed(int id)
{
string que = "SELECT Id From Mobile WHERE BrandId = '" + id + "'";
if (con1.State == System.Data.ConnectionState.Closed)
{
con1.Open();
}
SqlCommand cmd = new SqlCommand(que, con1);
SqlDataReader reader = cmd.ExecuteReader();
List <Int32> list1 = new List <Int32>();
int v = 0;
int z = 0;
int i = 0;
while (reader.Read())
{
v = Int32.Parse(reader[0].ToString());
int a = v;
db.Pictures.Where(x => x.MobileId == a).ToList().ForEach(x => db.Pictures.Remove(x));
int b = v;
db.Mobiles.Where(x => x.Id == b).ToList().ForEach(x => db.Mobiles.Remove(x));
i++;
}
Brand user = db.Brands.Find(id);
db.Brands.Remove(user);
db.SaveChanges();
return(RedirectToAction("BIndex"));
}
public ActionResult GiveReview(Review r, int?idp)
{
if (ModelState.IsValid)
{
r.MobileId = (int)idp;
r.RDate = DateTime.Today;
db.Reviews.Add(r);
db.SaveChanges();
ModelState.Clear();
r = null;
ViewBag.Message = "Submitted";
return(RedirectToAction("MobileDetails", "Home", new { id = idp }));
}
return(View(r));
}
public ActionResult Edit(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);
db.Entry(obj).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("BIndex"));
}
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"));
}
}
