public List <ItemModelview> GetMyTrade(string username) { var ImageStorerepo = new ImageStoreService(); var Itemrepo = new ItemService(); List <ItemModelview> lstItemModelview = new List <ItemModelview>(); var lstimgId = ImageStorerepo.GetAll().FindAll(x => x.UserName.Equals(username)).Select(w => w.imgId); List <string> lstItemref = new List <string>(); foreach (var item in lstimgId) { string x = item.Substring(0, item.Length - 1); if (!lstItemref.Contains(x)) { lstItemref.Add(x); } } foreach (var item in lstItemref) { var _item = Itemrepo.GetById(item); ItemModelview _ItemModelview = new ItemModelview { ItemName = _item.ItemName, ItemPrice = _item.ItemPrice, ItemDescription = _item.ItemDescription, ItemRef = _item.ItemRef, src = ImageStorerepo.GetById(item + "0").imgByte }; lstItemModelview.Add(_ItemModelview); } return(lstItemModelview); }
public ItemModelview DetailsItemApp(string id) { var ImageStorerepo = new ImageStoreService(); List <byte[]> lst = new List <byte[]>(); using (var Itemrepo = new ItemService()) { string itemid = id + "0"; ItemModelview _ItemModelview = new ItemModelview(); if (!id.Equals(string.Empty)) { //find the item in item table var item = Itemrepo.GetAll().Find(x => x.ItemRef.Equals(id)); _ItemModelview.ItemName = item.ItemName; _ItemModelview.ItemPrice = item.ItemPrice; //find client username in the storeImage table _ItemModelview.UserName = ImageStorerepo.GetById(itemid).UserName; _ItemModelview.ItemDescription = item.ItemDescription; _ItemModelview.ItemRef = id; _ItemModelview.date = ImageStorerepo.GetById(itemid).date; foreach (var img in GetAllImage()) { if (img.imgId.Substring(0, img.imgId.Length - 1).Equals(id)) { lst.Add(img.imgByte); } } _ItemModelview.Lstsrc = lst; } return(_ItemModelview); } }
public IHttpActionResult Edit(ItemModelview model) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } _ItemBusiness.PostEditItem(model); return(Ok()); }
public IHttpActionResult Create(ItemModelview model) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } model.UserName = ClaimsPrincipal.Current.Identity.Name;; _ItemBusiness.CreateItem(model); return(Ok()); }
// this is method is the same with the find public ItemModelview GetEditItem(string id) { ItemModelview _ItemModelview = new ItemModelview(); using (var repo = new ItemService()) { var item = repo.GetById(id); _ItemModelview.ItemName = item.ItemName; _ItemModelview.ItemPrice = item.ItemPrice; _ItemModelview.ItemRef = item.ItemRef; _ItemModelview.ItemDescription = item.ItemDescription; return(_ItemModelview); } }
public void PostEditItem(ItemModelview model) { using (var repo = new ItemService()) { var Itemtopdate = repo.GetById(model.ItemRef); Itemtopdate = new Item { ItemName = model.ItemName, ItemPrice = model.ItemPrice, ItemDescription = model.ItemDescription }; _ImageStoreBusiness.PostEdit(model); repo.Update(Itemtopdate); } }
public bool DeleteItem(string id) { ItemModelview _ItemModelview = new ItemModelview(); using (var repo = new ItemService()) { try { var item = repo.GetById(id); _ImageStoreBusiness.DeleteAllImage(id); repo.Delete(item); return(true); } catch (Exception) { return(false); } } }
public void CreateImageForItem(ItemModelview model) { using (var ImageStorerepo = new ImageStoreService()) { int count = 0; // from the website if (model.ImageFile != null) { foreach (var file in model.ImageFile) { byte[] imgbyte = null; BinaryReader reader = new BinaryReader(file.InputStream); imgbyte = reader.ReadBytes(file.ContentLength); ImageStore img = new ImageStore { imgId = model.ItemRef + count, UserName = model.UserName, ItemName = model.ItemName, date = DateTime.Now, imgByte = imgbyte }; ImageStorerepo.Insert(img); count++; } } // from app else { ImageStore img = new ImageStore { imgId = model.ItemRef + count, UserName = model.UserName, ItemName = model.ItemName, date = DateTime.Now, imgByte = model.src }; ImageStorerepo.Insert(img); } } }
public ItemModelview DetailsItem(string id) { var ImageStorerepo = new ImageStoreService(); using (var Itemrepo = new ItemService()) { string itemid = id + "0"; ItemModelview _ItemModelview = new ItemModelview(); if (!id.Equals("")) { //find the item in item table var item = Itemrepo.GetAll().Find(x => x.ItemRef.Equals(id)); _ItemModelview.ItemName = item.ItemName; _ItemModelview.ItemPrice = item.ItemPrice; //find client username in the storeImage table _ItemModelview.UserName = ImageStorerepo.GetById(itemid).UserName; _ItemModelview.ItemDescription = item.ItemDescription; _ItemModelview.ItemRef = id; } return(_ItemModelview); } }
public void CreateItem(ItemModelview model) { #region Create a ref number of the item string word = "ABCDEFGHIJKLMNOPQRSTUVWXYZ"; Random rd = new Random(); int num1 = rd.Next(-1, 24); string StampDate = DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Day.ToString() + DateTime.Now.Hour.ToString(); model.ItemRef = word.Substring(num1, 3) + model.ItemName.ToUpper().Substring(0, 1) + StampDate; #endregion using (var Itemrepo = new ItemService()) { _ImageStoreBusiness.CreateImageForItem(model); Item _Item = new Item { ItemName = model.ItemName, ItemPrice = model.ItemPrice, ItemDescription = model.ItemDescription, ItemRef = model.ItemRef }; Itemrepo.Insert(_Item); } }
public void PostEdit(ItemModelview model) { using (var repo = new ImageStoreService()) { // Find all item with the same reference number var ImageStore = repo.GetAll().Where(x => x.imgId.Substring(0, x.imgId.Length - 1).Equals(model.ItemRef)).ToList(); //from website if (model.ImageFile != null) { //check the number of picture int NumberOfItem = model.ImageFile.Count(); if (ImageStore.Count() > NumberOfItem) { //will delete the remaining of ImageStore int count = 0; byte[] imgbyte = null; //update item with new details foreach (var item in ImageStore) { BinaryReader reader = new BinaryReader(model.ImageFile[count].InputStream); imgbyte = reader.ReadBytes(model.ImageFile[count].ContentLength); item.ItemName = model.ItemName; item.imgByte = imgbyte; repo.Update(item); count++; } //delete the remainig for (int i = model.ImageFile.Count() + 1; i < ImageStore.Count(); i++) { var ItemToDelete = ImageStore[i]; repo.Delete(ItemToDelete); } } else { // will add the remaing of model.ImageFile } } //from app else { for (int i = 0; i < model.Lstsrc.Count(); i++) { var itemToUpdate = ImageStore[i]; itemToUpdate.ItemName = model.ItemName; itemToUpdate.imgByte = model.Lstsrc[i]; repo.Update(itemToUpdate); } // Delete the remaining item //1 bcz they will be only one pic from app and //the number of img in imageStore must not be one if (model.Lstsrc.Count() == 1 && ImageStore.Count() > 1) { for (int i = 1; i < ImageStore.Count(); i++) { var ItemToDelete = ImageStore[i]; repo.Delete(ItemToDelete); } } } } }
public ActionResult Create(ItemModelview model) { model.UserName = User.Identity.Name; _ItemBusiness.CreateItem(model); return(RedirectToAction("MyIndex")); }