public ActionResult Delete(int?id) //It will take the id as input and remove the product
{
using (UserEntities1 db = new UserEntities1())
{
Product p = db.Products.Find(id);
db.Products.Remove(p);
string currentImage = Request.MapPath(p.SmallImage);
string currentImage1 = Request.MapPath(p.LargeImage);
Session["Delete"] = "Deleted";
db.SaveChanges();
//It will Remove the image from folder
if (System.IO.File.Exists(currentImage))
{
System.IO.File.Delete(currentImage);
}
if (System.IO.File.Exists(currentImage1))
{
System.IO.File.Delete(currentImage1);
}
HttpCookie cookie = new HttpCookie("CookieDelete");
cookie.Value = "Delete";
Response.Cookies.Add(cookie);
cookie.Expires = DateTime.Now.AddSeconds(10);
return(RedirectToAction("Display"));
}
}
private bool checkIfUserExists(UserLogin u)
{
UserEntities1 db = new UserEntities1();
Register tmp = db.Registers.Where(p => p.UserName == u.UserName).First();
if (tmp != null)
{
return(true);
}
else
{
return(false);
}
}
private Register IsAuthenticated(UserLogin u)
{
UserEntities1 db = new UserEntities1();
Register tmp = db.Registers.Where(p => p.UserName == u.UserName).First();
if (u.Password == tmp.Password)
{
tmp.Password = "";
return(tmp);
}
else
{
return(null);
}
}
public ActionResult Details(int?id) //When user clicks on Product Name, the id of that will be catched here.
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
using (UserEntities1 db = new UserEntities1())
{
var product = db.Products.Find(id);
if (product == null) //If the 'product' object's value is 'null'
{
return(HttpNotFound());
}
return(View(product));
}
}
public ActionResult Add(Product p)//Add Product(Post Method)
{
if (p != null)
{
if (p.ImageFile1 != null)//Optional Image
{
String filename1 = Path.GetFileNameWithoutExtension(p.ImageFile1.FileName);
String extension1 = Path.GetExtension(p.ImageFile1.FileName);
filename1 = filename1 + DateTime.Now.ToString("yymmssfff") + extension1;
p.LargeImage = "~/Images/Large/" + filename1;
filename1 = Path.Combine(Server.MapPath("~/Images/Large/"), filename1);
p.ImageFile1.SaveAs(filename1);
}
else
{
p.LargeImage = "NA";
}
String filename = Path.GetFileNameWithoutExtension(p.ImageFile.FileName);
String extension = Path.GetExtension(p.ImageFile.FileName);
filename = filename + DateTime.Now.ToString("yymmssfff") + extension;
p.SmallImage = "~/Images/Small/" + filename;
filename = Path.Combine(Server.MapPath("~/Images/Small/"), filename);
p.ImageFile.SaveAs(filename);
if (p.LongDescription == null)//Optional Description
{
p.LongDescription = "NA";
}
using (UserEntities1 db = new UserEntities1())
{
db.Products.Add(p);//Add all the details
db.SaveChanges();
}
ModelState.Clear();
//Toster Message For Add Prouct
HttpCookie cookie = new HttpCookie("CookieAdd");
cookie.Value = "Add";
Response.Cookies.Add(cookie);
cookie.Expires = DateTime.Now.AddSeconds(10);
return(RedirectToAction("Add", "Myproduct"));
}
else
{
return(View());
}
}
public ActionResult Display(string SearchBy, string search, int?i, string sortBy, string advance_search) //Show All The Entry
{
UserEntities1 db = new UserEntities1();
ViewBag.SortNameParameter = string.IsNullOrEmpty(sortBy) ? "ProductName desc" : "";
ViewBag.SortCategoryParameter = sortBy == "Category" ? "Category desc" : "Category";
var p = db.Products.AsQueryable();
if (SearchBy == "ProductName")
{
p = p.Where(x => x.ProductName.StartsWith(search) || search == null);
}
else if (SearchBy == "Category")
{
p = p.Where(x => x.Category.StartsWith(search) || search == null);
}
else if (advance_search != null)
{
return(View(db.Products.Where(x => x.ProductName.StartsWith(advance_search) || x.Category.StartsWith(advance_search) || x.ShortDescription
.StartsWith(advance_search) || x.Price.StartsWith(advance_search) || search == null).ToList().ToPagedList(i ?? 1, 3)));
}
switch (sortBy)
{
case "ProductName desc":
p = p.OrderByDescending(x => x.ProductName);
break;
case "Category desc":
p = p.OrderByDescending(x => x.Category);
break;
case "Category":
p = p.OrderBy(x => x.Category);
break;
default:
p = p.OrderBy(x => x.ProductName);
break;
}
return(View(p.ToPagedList(i ?? 1, 3)));//Page List(Each page will display 3 entry)
}
public ActionResult Deleteall(string[] id)//Multiple Delete
{
int[] getid = null;
if (id != null)
{
getid = new int[id.Length];
int j = 0;
foreach (string i in id)
{
int.TryParse(i, out getid[j++]);//Fetch all id
}
List <Product> pids = new List <Product>();
UserEntities1 db = new UserEntities1();
pids = db.Products.Where(x => getid.Contains(x.ProductId)).ToList();
foreach (var s in pids)
{
db.Products.Remove(s);//Remove product one by one using product id
}
db.SaveChanges();
return(RedirectToAction("Display"));
}
return(RedirectToAction("Display"));
}
public ActionResult Edit(int id, Product p)//Edit Product(Post Method)
{
try
{
string oldpath1 = Session["imgpath1"].ToString();
string oldpath2 = Session["imgpath2"].ToString();
//If conditions for optional image as well as compulsory image.
if (p.SmallImage != null && p.LargeImage != null)
{
String filename = Path.GetFileNameWithoutExtension(p.ImageFile.FileName);
String extension = Path.GetExtension(p.ImageFile.FileName);
filename = filename + DateTime.Now.ToString("yymmssfff") + extension;
p.SmallImage = "~/Images/Small/" + filename;
filename = Path.Combine(Server.MapPath("~/Images/Small/"), filename);
p.ImageFile.SaveAs(filename);
if (p.SmallImage != oldpath1)
{
string p1 = Request.MapPath(oldpath1);
if (System.IO.File.Exists(p1))
{
System.IO.File.Delete(p1);
}
}
String filename1 = Path.GetFileNameWithoutExtension(p.ImageFile1.FileName);
String extension1 = Path.GetExtension(p.ImageFile1.FileName);
filename1 = filename1 + DateTime.Now.ToString("yymmssfff") + extension1;
p.LargeImage = "~/Images/Large/" + filename1;
filename1 = Path.Combine(Server.MapPath("~/Images/Large/"), filename1);
p.ImageFile1.SaveAs(filename1);
if (p.LargeImage != oldpath2)
{
string p2 = Request.MapPath(oldpath2);
if (System.IO.File.Exists(p2))
{
System.IO.File.Delete(p2);
}
}
}
if (p.ImageFile != null)
{
String filename = Path.GetFileNameWithoutExtension(p.ImageFile.FileName);
String extension = Path.GetExtension(p.ImageFile.FileName);
filename = filename + DateTime.Now.ToString("yymmssfff") + extension;
p.SmallImage = "~/Images/Small/" + filename;
filename = Path.Combine(Server.MapPath("~/Images/Small/"), filename);
p.ImageFile.SaveAs(filename);
if (p.LargeImage == null)
{
p.LargeImage = oldpath2;
}
if (p.SmallImage != oldpath1)
{
string p1 = Request.MapPath(oldpath1);
if (System.IO.File.Exists(p1))
{
System.IO.File.Delete(p1);
}
}
}
if (p.ImageFile1 != null)
{
String filename1 = Path.GetFileNameWithoutExtension(p.ImageFile1.FileName);
String extension1 = Path.GetExtension(p.ImageFile1.FileName);
filename1 = filename1 + DateTime.Now.ToString("yymmssfff") + extension1;
p.LargeImage = "~/Images/Large/" + filename1;
filename1 = Path.Combine(Server.MapPath("~/Images/Large/"), filename1);
p.ImageFile1.SaveAs(filename1);
if (p.SmallImage == null)
{
p.SmallImage = oldpath1;
}
if (p.LargeImage != oldpath2)
{
string p2 = Request.MapPath(oldpath2);
if (System.IO.File.Exists(p2))
{
System.IO.File.Delete(p2);
}
}
}
if (p.SmallImage == null && p.LargeImage == null)
{
p.SmallImage = oldpath1;
p.LargeImage = oldpath2;
}
if (p.LongDescription == null)
{
p.LongDescription = "NA";
}
UserEntities1 db = new UserEntities1();
db.Entry(p).State = EntityState.Modified;//Modify The Data
db.SaveChanges();
//Toster Message For Edit Product.
HttpCookie cookie2 = new HttpCookie("CookieEdit");
cookie2.Value = "Edit";
Response.Cookies.Add(cookie2);
cookie2.Expires = DateTime.Now.AddSeconds(5);
return(RedirectToAction("Display"));
}
catch (Exception e)
{
Console.WriteLine(e);
}
return(View());
}
public ActionResult Edit(int?id) //Edit Product(Get Method)
{
using (UserEntities1 db = new UserEntities1())
{
List <SelectListItem> Category = new List <SelectListItem>()
{
new SelectListItem {
Text = "Fashion", Value = "Fashion"
},
new SelectListItem {
Text = "Appliances", Value = "Appliances"
},
new SelectListItem {
Text = "Beauty", Value = "Beauty"
},
new SelectListItem {
Text = "Sports", Value = "Sports"
},
new SelectListItem {
Text = "Grocery", Value = "Grocery"
}
};
List <SelectListItem> Quantity = new List <SelectListItem>()
{
new SelectListItem {
Text = "1", Value = "1"
},
new SelectListItem {
Text = "2", Value = "2"
},
new SelectListItem {
Text = "3", Value = "3"
},
new SelectListItem {
Text = "4", Value = "4"
},
new SelectListItem {
Text = "5", Value = "5"
},
new SelectListItem {
Text = "6", Value = "6"
},
new SelectListItem {
Text = "7", Value = "7"
}
};
ViewData["Quantity"] = Quantity;
ViewData["Category"] = Category;
try
{
var xyz = db.Products.Find(id);//Fetch The Data With using id
Session["imgpath1"] = xyz.SmallImage;
Session["imgpath2"] = xyz.LargeImage;
//return Json(xyz, JsonRequestBehavior.AllowGet);
if (xyz.LargeImage == "NA")
{
ViewBag.Largeimg = true;
}
if (xyz.LongDescription == "NA")
{
ViewBag.Longdsp = true;
}
}
catch
{
Console.WriteLine("xyz");
}
return(View(db.Products.Where(x => x.ProductId == id).FirstOrDefault()));
}
}
