public string Update(int id, string name, decimal price, HttpPostedFileBase imageurl, string itemdesc, int catid, string available)
{
if (imageurl == null)
{
return("Please select an image!");
}
//set new upload location
string location = Server.MapPath("~/Content/Images/");
//generate folder if it doessnt exist
if (!Directory.Exists(location))
{
Directory.CreateDirectory(location);
}
//get file name
var fileName = Path.GetFileName(imageurl.FileName);
//get file extension
string extension = Path.GetExtension(imageurl.FileName);
//create unique file name
string uniquefilename = Guid.NewGuid().ToString("N") + extension;
//Combine location with image
string fileinpath = Path.Combine(location + uniquefilename);
//Store image
imageurl.SaveAs(fileinpath);
string dbpath = "/Content/Images/" + uniquefilename;
ShopMgtSystemDBContext db = new ShopMgtSystemDBContext();
Item item = db.Items.Where(a => a.ID == id).FirstOrDefault();
item.Name = name;
item.Price = price;
item.ImageURL = dbpath;
item.ItemDescription = itemdesc;
item.CategoryID = catid;
item.Availability = available;
int count = db.SaveChanges();
if (count > 0)
{
return("1");
}
else
{
return("An error occured. Please try again.");
}
}
public string Delete(int id)
{
ShopMgtSystemDBContext db = new ShopMgtSystemDBContext();
Item item = db.Items.Where(a => a.ID == id).FirstOrDefault();
db.Items.Remove(item);
int count = db.SaveChanges();
if (count > 0)
{
return("You have deleted this item. Click 'OK' to continue...");
}
else
{
return("An error occured. Try again.");
}
}
public string Delete(int id)
{
ShopMgtSystemDBContext db = new ShopMgtSystemDBContext();
var del = db.Categories.Where(a => a.ID == id).FirstOrDefault();
db.Categories.Remove(del);
int count = db.SaveChanges();
if (count > 0)
{
return("Deleted Successfully! Press 'OK' to continue...");
}
else
{
return("An error occured!");
}
}
public string Update(string cname, int id)
{
ShopMgtSystemDBContext db = new ShopMgtSystemDBContext();
Category cat = db.Categories.Where(a => a.ID == id).FirstOrDefault();
cat.CategoryName = cname;
int count = db.SaveChanges();
if (count > 0)
{
return("Updated Successfully! Press 'OK' to continue...");
}
else
{
return("An error occurred!");
}
}
public string AddCategories(string cname)
{
ShopMgtSystemDBContext db = new ShopMgtSystemDBContext();
Category category = new Category();
category.CategoryName = cname;
db.Categories.Add(category);
int count = db.SaveChanges();
if (count > 0)
{
return("You have added a new category.");
}
else
{
return("An error occured.");
}
}