public ActionResult SaveItems(ItemsVM items)
{
Itemsrepo objitemsrepo = new Itemsrepo();
objitemsrepo.Insert(items);
return(View("SaveItems"));
}
private void generateAndFilterCollectionFromModel()
{
ItemsVM.Clear();
foreach (var item in itemsModel.GetItems(category))
{
ItemsVM.Add(new ItemViewModel(new Item(item), itemsModel));
}
}
public ActionResult AddItem()
{
ItemsVM item = new ItemsVM();
item.Categories = new SelectList(db.Categories.ToList(), "Id", "Name");
return(View(item));
}
/// <summary>
/// constructor
/// </summary>
/// <param name="vehicleSelection">vehicle selection view model</param>
public DataVM(VehicleSelection vehicleSelection)
{
Data = new Data();
Data.ReadData();
ItemsVM = new ItemsVM(Data);
VehiclesVM = new VehiclesVM(Data);
RoutesVM = new RoutesVM(this, vehicleSelection);
}
public void DeleteItem(IItemViewModel <DataModelType, DataViewModelType> itemVM)
{
if (CanDeleteItem())
{
ItemsVM.Remove(itemVM);
var deleteModel = itemVM.GetItemModel();
var currentModel = CurrentVM.GetItemModel();
if (deleteModel.DataModel.Equals(currentModel.DataModel))
{
CurrentVM = null;
}
addedAndDelatedItems[deleteModel] = ChangeStatus.Delete;
Debug.Assert(StateCanChanged != null);
StateCanChanged(this, new EventArgs());
}
}
void UpdateList(List <IItemViewModel <DataModelType, DataViewModelType> > itemViewModels)
{
//сохраняем текущий элемент
//это необходимо, т.к. при последующей очистки списка, элемент обнуляется, из-за привязки
var savedSelectedItem = SelectedItem;
//производим полное обновление
if (ItemsVM == null)
{
ItemsVM = new ObservableCollection <IItemViewModel <DataModelType, DataViewModelType> >(itemViewModels);
}
else
{
ItemsVM.Clear();
foreach (var viewModel in itemViewModels)
{
ItemsVM.Add(viewModel);
}
}
//делаем необходимые действия если был выбранный элемент
if (savedSelectedItem != null)
{
//ищем его в списке
var selectedItemFromUpdate = itemViewModels.FirstOrDefault(itm => itm.DataViewModel.Equals(savedSelectedItem.DataViewModel));
//текущего элемента нет в обновлении
if (selectedItemFromUpdate == null)
{
CurrentVM = null;
SelectedItem = null;
}
//в противном случае, НЕ надо чтобы выбранный элемент был обновленным
//он сам мебя должен обновлять
//(такое ограничение, из-за того, что он сам может содержать свой список, который должен поддерживать текущий элемент)
//устанавливаем только VM(не детальный)
else
{
selectedItem = selectedItemFromUpdate;
NotifyPropertyChanged("SelectedItem");
//var saveCurVM = CurrentVM;
//SelectedItem = selectedItemFromUpdate;
//CurrentVM = saveCurVM;
}
}
}
public void Insert(ItemsVM Items)
{
var _context = new storeDBEntities();
ItemsVM vm = new ItemsVM();
item newitemobj = new item(); //table
newitemobj.itemname = Items.itemname;
newitemobj.price = Items.price;
newitemobj.discount = Items.discount;
newitemobj.manufacturedate = Items.manufacturedate;
newitemobj.expirydate = Items.expirydate;
newitemobj.manufacturerid = 1;
newitemobj.itemtypeid = 1;
_context.items.Add(newitemobj);
_context.SaveChanges();
}
public ActionResult EditItem(int id)
{
ItemsVM item;
using (Db db = new Db())
{
ItemsDTO dto = db.Items.Find(id);
if (dto == null)
{
return(Content("The item doesn't exist"));
}
item = new ItemsVM(dto);
List <CategoryVM> categories;
item.Categories = new SelectList(db.Categories.ToList(), "Id", "Name");
}
return(View(item));
}
public string AddNewStockItem(ItemsVM objItem)
{
para = new SqlParameter[]
{
new SqlParameter("@MainCategoryID", objItem.MainCategoryID),
new SqlParameter("@SubCategoryID", objItem.SubCategoryID),
new SqlParameter("@MeasureUnitID", objItem.MeasureUnitID),
new SqlParameter("@DetailValues", Comman.ConvertList(objItem.DetailValues))
};
int i = obj.InsertInTo("spAddNewStockItem", para);
string msg = string.Empty;
if (i > 0)
{
msg = "Item Added Succesfullylllll";
}
else
{
msg = "ItemNotAdded";
}
return(msg);
}
public ActionResult ItemDetails(string name)
{
ItemsVM model;
ItemsDTO item;
int id = 0;
using (Db db = new Db())
{
if (!db.Items.Any(x => x.Title.Equals(name)))
{
return(RedirectToAction("Index", "Shop"));
}
item = db.Items.Where(x => x.Title == name).FirstOrDefault();
id = item.Id;
model = new ItemsVM(item);
}
return(View("ItemDetails", model));
}
public void AddItem()
{
if (CanAddItem())
{
//создаем IDetailItemViewModel
var dataItemModel = _itemModelCreator.CreateNewDataModel();
var itemModel = _itemModelCreator.CreateItemModel(dataItemModel);
var detailItemViewModel = _creator.CreateDetailViewModel(itemModel);
CurrentVM = detailItemViewModel;
//IItemViewModel
var itemViewModel = _creator.CreateItemViewModel(itemModel);
ItemsVM.Add(itemViewModel);
addedAndDelatedItems[itemModel] = ChangeStatus.Add;
CurrentVM.Edit();
Debug.Assert(StateCanChanged != null);
StateCanChanged(this, new EventArgs());
}
}
public ActionResult EditItem(ItemsVM item, HttpPostedFileBase file)
{
using (Db db = new Db())
{
item.Categories = new SelectList(db.Categories.ToList(), "Id", "Name");
}
if (!ModelState.IsValid)
{
return(View(item));
}
//unique name
using (Db db = new Db())
{
if (db.Items.Where(x => x.Id != item.Id).Any(x => x.Title == item.Title))
{
ModelState.AddModelError("", "That item name is already taken! :(");
return(View(item));
}
}
using (Db db = new Db())
{
ItemsDTO dto = db.Items.Find(item.Id);
dto.Id = item.Id;
dto.Title = item.Title;
dto.Description = item.Description;
dto.Price = item.Price;
dto.Image = item.Image;
int id = dto.Id;
var directory = new DirectoryInfo(string.Format("{0}Images\\Uploads", Server.MapPath(@"\")));
var path1 = Path.Combine(directory.ToString(), "Items");
var path2 = Path.Combine(directory.ToString(), "Items" + id.ToString());
if (!Directory.Exists(path1))
{
Directory.CreateDirectory(path1);
}
if (!Directory.Exists(path2))
{
Directory.CreateDirectory(path2);
}
if (file != null && file.ContentLength > 0)
{
string extension = file.ContentType.ToLower();
if (extension != "image/jpg" && extension != "image/jpeg" && extension != "image/png")
{
item.Categories = new SelectList(db.Categories.ToList(), "Id", "Name");
ModelState.AddModelError("", "The image was not uploaded - wrong image extension.");
return(View(item));
}
string imageName = file.FileName;
ItemsDTO dto1 = db.Items.Find(id);
dto1.Image = imageName;
db.SaveChanges();
file.SaveAs(string.Format("{0}\\{1}", path2, imageName));
WebImage img = new WebImage(file.InputStream);
img.Resize(200, 200);
img.Save(path2, "png", true);
}
CategoriesDTO catDto = db.Categories.FirstOrDefault(x => x.Id == item.CategoryId);
dto.CategoryName = catDto.Name;
db.SaveChanges();
TempData["Status"] = "Item edited! <3";
}
return(RedirectToAction("Items"));
}
public string AddNewStockItem(ItemsVM obj)
{
return(objData.AddNewStockItem(obj));
}
public ActionResult Items()
{
ItemsVM items = new ItemsVM()
{
Categories = new List <Category>()
{
new Category()
{
Id = 1, Title = "Soups", Description = "There are various forms of soups available.", TotalItems = 8, Discount = 0.00f, ImagePath = "~/Images/Menu/CategoriesVM/biryani.jpg"
},
new Category()
{
Id = 2, Title = "Rotis", Description = "Roti is a flat bread originating from the Indian subcontinent.", TotalItems = 10, Discount = 5.00f, ImagePath = "~/Images/Menu/CategoriesVM/rotis.jpg"
},
new Category()
{
Id = 3, Title = "Curries", Description = "Various parts of the sub-continent have their own regional variations of curry.", TotalItems = 15, Discount = 3.00f, ImagePath = "~/Images/Menu/CategoriesVM/curries.jpg"
},
new Category()
{
Id = 4, Title = "Noodles", Description = "Noodles are made of acorn meal, wheat flour, wheat germ, and salt.", TotalItems = 20, Discount = 5.00f, ImagePath = "~/Images/Menu/CategoriesVM/noodles.jpg"
},
new Category()
{
Id = 5, Title = "Pizzas", Description = "Pizza bread is a type of sandwich that is often served open-faced.", TotalItems = 16, Discount = 8.00f, ImagePath = "~/Images/Menu/CategoriesVM/pizza.jpg"
},
new Category()
{
Id = 6, Title = "Beverages", Description = "Any one of various liquids for drinking, usually excluding water.", TotalItems = 7, Discount = 10.00f, ImagePath = "~/Images/Menu/CategoriesVM/beverages.jpg"
},
new Category()
{
Id = 7, Title = "Desserts", Description = "Dessert is a course that concludes a main meal.", TotalItems = 11, Discount = 15.00f, ImagePath = "~/Images/Menu/CategoriesVM/desserts.jpg"
},
},
Items = new List <Item>()
{
new Item()
{
ID = 1, CategoryID = 1, Name = "Albondigas", Price = 250.00f, Description = "Soup Item", ImagePath = "~/Images/Menu/Items/Soups/albondigas-soup.png"
},
new Item()
{
ID = 2, CategoryID = 1, Name = "Avgolemono", Price = 250.00f, Description = "Soup Item", ImagePath = "~/Images/Menu/Items/Soups/Avgolemono.png"
},
new Item()
{
ID = 3, CategoryID = 1, Name = "Borscht", Price = 250.00f, Description = "Soup Item", ImagePath = "~/Images/Menu/Items/Soups/Borscht-soup.png"
},
new Item()
{
ID = 4, CategoryID = 1, Name = "Bouillabaisse", Price = 250.00f, Description = "Soup Item", ImagePath = "~/Images/Menu/Items/Soups/Bouillabaisse-soup.png"
},
new Item()
{
ID = 5, CategoryID = 1, Name = "Broccoli Cheese", Price = 250.00f, Description = "Soup Item", ImagePath = "~/Images/Menu/Items/Soups/BroccoliCheese-soup.png"
},
new Item()
{
ID = 6, CategoryID = 1, Name = "Caldo verde", Price = 250.00f, Description = "Soup Item", ImagePath = "~/Images/Menu/Items/Soups/CaldoVerde-soup.png"
},
new Item()
{
ID = 7, CategoryID = 1, Name = "Callaloo", Price = 250.00f, Description = "Soup Item", ImagePath = "~/Images/Menu/Items/Soups/Callaloo-soup.png"
},
new Item()
{
ID = 8, CategoryID = 1, Name = "C**k-a-leekie", Price = 250.00f, Description = "Soup Item", ImagePath = "~/Images/Menu/Items/Soups/default-soup.png"
}
},
DefaultActiveCategory = 1,
DefaultImagePath = "~/Images/Menu/Items/Soups/albondigas-soup.png"
};
return(View(items));
}
public void ItemVM_DeleteEvent(ItemViewModel itemVM)
{
ItemsVM.Remove(itemVM);
}
//[HttpPost]
//[ValidateAntiForgeryToken]
//public ActionResult SaveSorting(FormCollection collection)
//{
// try
// {
// var listId = int.Parse(collection["ShoppingList_Id"]);
// var sortingName = collection["SortingName"];
// var listEntries = collection["listEntries"];
// UserListSortingService listSortingService = new UserListSortingService();
// ShoppingListService listService = new ShoppingListService();
// UserListSortingDto sortingDto = new UserListSortingDto
// {
// Id = (int)listService.Get(listId).ChosenSortingId,
// UserSortingName = sortingName,
// ShoppingList_Id = listId
// };
// listSortingService.SaveSorting(sortingDto, listEntries);
// TempData["SuccessMessage"] = "Saved this sorting successfully.";
// return RedirectToAction("SingleList", "List", new { @id = listId });
// }
// catch
// {
// TempData["ErrorMessage"] = "Saving this sorting wasn't possible.";
// return RedirectToAction("SingleList");
// }
//}
#endregion Sorting
#region Items
//GET List/Item -> EditItemView
public ActionResult Item(int?id, int?listId)
{
if (Session["UserId"] != null)
{
ViewBag.Message = TempData["SuccessMessage"];
ViewBag.Error = TempData["ErrorMessage"];
ItemsVM item = new ItemsVM
{
ListId = (int)listId,
ProductId = (int)id
};
LanguageService languageService = new LanguageService();
var langId = languageService.GetByCode(Session["LanguageCode"].ToString()).Id;
ProductService productService = new ProductService();
var entry = productService.Get(langId, (int)id, (int)listId); //Gets productDto by langId(for translation if default or api product) and ProductId
item.Id = entry.Id;
item.Name = entry.Name;
item.Price = entry.Price;
item.Quantity = Convert.ToUInt32(entry.Quantity);
item.Unit_Id = entry.Unit_Id;
item.Currency_Id = entry.Currency_Id;
item.Category_Id = entry.Category_Id;
item.ProductTypeId = entry.ProductTypeId;
UnitTypeService unitTypeService = new UnitTypeService();
item.UnitTypesListId = item.Unit_Id; //saved value from db entry
item.UnitTypesList = (from x in unitTypeService.GetUnitTypesByLanguage(langId)
select new SelectListItem()
{
Text = x.Name,
Value = x.Id.ToString()
}).ToList();
CurrencyService currencyService = new CurrencyService();
item.CurrencyListId = item.Currency_Id; //saved value from db entry
item.CurrencyList = (from x in currencyService.GetAll()
select new SelectListItem()
{
Text = x.Code,
Value = x.Id.ToString()
}).ToList();
CategoryService categoryService = new CategoryService();
if (item.Category_Id == null)
{
item.CategoryListId = 0;
}
else
{
item.CategoryListId = (int)item.Category_Id; //saved value from db entry
}
if (item.ProductTypeId == 1) //if deafult product -> only show UserCategories
{
item.CategoryList = (from x in categoryService.GetUserCategories(langId, int.Parse(Session["UserId"].ToString()))
select new SelectListItem()
{
Text = x.Name,
Value = x.Id.ToString()
}).ToList();
}
else
{
item.CategoryList = (from x in categoryService.GetAllCategories(langId, int.Parse(Session["UserId"].ToString()))
select new SelectListItem()
{
Text = x.Name,
Value = x.Id.ToString()
}).ToList();
}
return(View(item));
}
else if (id == 0 || listId == 0)
{
TempData["ErrorMessage"] = "There is no item of a specific list selected to edit.";
return(Redirect(Request.UrlReferrer.ToString()));
}
else
{
return(RedirectToAction("Login", "User"));
}
}
public ActionResult AddItem(ItemsVM item, HttpPostedFileBase file)
{
//rebuild the selectList
item.Categories = new SelectList(db.Categories.ToList(), "Id", "Name");
if (!ModelState.IsValid)
{
return(View(item));
}
ItemsDTO dto = new ItemsDTO();
dto.Title = item.Title;
dto.Description = item.Description;
dto.Price = item.Price;
dto.Score = -1;
dto.CategoryId = item.CategoryId;
CategoriesDTO catDto = db.Categories.FirstOrDefault(x => x.Id == item.CategoryId);
dto.CategoryName = catDto.Name;
//insert and commit
db.Items.Add(dto);
db.SaveChanges();
TempData["Status"] = "The item was added! <3";
//also insert the item in the request table for approval
RequestsDTO dto2 = new RequestsDTO();
dto2.UserId = 0;
dto2.ItemId = dto.Id;
db.Requests.Add(dto2);
db.SaveChanges();
int id = dto.Id;
var directory = new DirectoryInfo(string.Format("{0}Images\\Uploads", Server.MapPath(@"\")));
var path1 = Path.Combine(directory.ToString(), "Items");
var path2 = Path.Combine(directory.ToString(), "Items" + id.ToString());
if (file != null && file.ContentLength > 0)
{
string extension = file.ContentType.ToLower();
if (extension != "image/jpg" && extension != "image/jpeg" && extension != "image/png")
{
item.Categories = new SelectList(db.Categories.ToList(), "Id", "Name");
ModelState.AddModelError("", "The image was not uploaded - wrong image extension.");
return(View(item));
}
string imageName = file.FileName;
ItemsDTO dto1 = db.Items.Find(id);
dto1.Image = imageName;
db.SaveChanges();
file.SaveAs(string.Format("{0}.png", path2));
WebImage img = new WebImage(file.InputStream);
img.Resize(200, 200);
img.Save(path2, "png", true);
}
return(RedirectToAction("AddItem"));
}
