public ActionResult Edit([Bind(Include = "ItemPostId,ItemCategoryId_,LocationId_,ItemName,PhoneNumber,EmailAddress_,Quantity,Description,Photo1,Photo2,Photo3,UserTypeId,CreatedOn,ModifiedOn,ItemStatusId,ContactByEmail,ContactByPhone,DisplayMyPhoneNo,DisplayMyEmail_,ItemCollectPreferenceId")] ItemPost itempost) { if (ModelState.IsValid) { itempost.UserId = GetUserId(itempost); db.Entry(itempost).State = EntityState.Modified; db.SaveChanges(); string toAddress = itempost.EmailAddress_.ToString(); string subject = "DonateForGood: " + itempost.ItemName.ToString(); string body = string.Empty; string pageURL = System.Web.HttpContext.Current.Request.Url.ToString(); pageURL = pageURL.Replace("Create", string.Empty); string EditURL = pageURL + "Edit/" + itempost.ItemPostId.ToString(); string DeleteURL = pageURL + "Delete/" + itempost.ItemPostId.ToString(); body = "Please click on these links if you want to <a href='" + EditURL + "'>EDIT</a> OR <a href='" + DeleteURL + "'>DELETE</a> your item post from DonateForGood website"; if (SendMail(toAddress, subject, body) == "Successful") { return(RedirectToAction("Index", "Home")); } return(RedirectToAction("Index", "Home")); } ViewBag.ItemCategoryId_ = new SelectList(db.ItemCategories, "ItemCategoryId", "ItemCategoryName", itempost.ItemCategoryId_); ViewBag.ItemCollectPreferenceId = new SelectList(db.ItemCollectPreferences, "ItemCollectPreferenceId", "ItemCollectPreferenceName", itempost.ItemCollectPreferenceId); ViewBag.LocationId_ = new SelectList(db.Locations, "LocationId", "LocationName", itempost.LocationId_); ViewBag.ItemStatusId = new SelectList(db.ItemStatus, "ItemStatusId", "ItemStatusName", itempost.ItemStatusId); return(View(itempost)); }
public void urlImg(String urlI) { info.Text = "Imagen subida"; this.urlI = urlI; SolidColorBrush brush = new SolidColorBrush(); brush.Color = Color.FromArgb(0xff, 0, 0, 0); newImage.Fill = brush; //*ItemPost*// try { ItemPost newPost = new ItemPost() { Place = NewPlace.Text, Product = newProduct.Text, Usuario = PhoneApplicationService.Current.State["Username"].ToString(), ImageProduct = urlI, Time = DateTime.Now.ToShortDateString(), CoordPlace = place }; itemPostMongo.insertDocument(newPost); MessageBox.Show("Recomendación publicada", "¡Aviso!", MessageBoxButton.OK); NavigationService.Navigate(new Uri("/Main.xaml", UriKind.Relative)); } catch (Exception) { MessageBox.Show("Compruebe la conexión a internet", "Error de conexión", MessageBoxButton.OK); throw; } }
public JsonResult PostItem([FromBody] ItemPost itemPost) { try { Item item = itemPost.item; int[] tagIds = itemPost.tagIds; if (item is not null) { db.Items.Add(item); db.SaveChanges(); if (tagIds.Length != 0) { int item_id = item.id; for (int i = 0; i < tagIds.Length; i++) { db.ItemsTags.Add(new ItemsTag() { item_id = item_id, tag_id = tagIds[i] }); } db.SaveChanges(); } } return(Json(item)); } catch (SqlException e) { return(Json(e.Message)); } }
public ActionResult DeleteConfirmed(int id) { ItemPost itempost = db.ItemPosts.Find(id); db.ItemPosts.Remove(itempost); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Create([Bind(Include = "ItemPostId,ItemCategoryId_,LocationId_,ItemName,PhoneNumber,EmailAddress_,Quantity,Description,Photo1,Photo2,Photo3,UserTypeId,CreatedOn,ModifiedOn,ItemStatusId,ContactByEmail,ContactByPhone,DisplayMyPhoneNo,DisplayMyEmail_,ItemCollectPreferenceId")] ItemPost itempost) { if (ModelState.IsValid) { DonateForGood.Models.User user = new Models.User { UserTypeId = 2, PhoneNumber = itempost.PhoneNumber, EmailAddress = itempost.EmailAddress_ }; int userId = 0; var query = (from tableUser in db.Users where (tableUser.PhoneNumber == user.PhoneNumber || tableUser.EmailAddress == user.EmailAddress) select tableUser.UserId); if (!(query.Any())) { db.Users.Add(user); db.SaveChanges(); userId = (from tableUser in db.Users where (tableUser.PhoneNumber == user.PhoneNumber || tableUser.EmailAddress == user.EmailAddress) select tableUser.UserId).First(); } else { userId = (from tableUser in db.Users where (tableUser.PhoneNumber == user.PhoneNumber || tableUser.EmailAddress == user.EmailAddress) select tableUser.UserId).First(); } itempost.UserId = userId; db.ItemPosts.Add(itempost); db.SaveChanges(); string toAddress = itempost.EmailAddress_.ToString(); string subject = "DonateForGood: " + itempost.ItemName.ToString(); string body = string.Empty; string pageURL = System.Web.HttpContext.Current.Request.Url.ToString(); pageURL = pageURL.Replace("Create", string.Empty); string EditURL = pageURL + "Edit/" + itempost.ItemPostId.ToString(); string DeleteURL = pageURL + "Delete/" + itempost.ItemPostId.ToString(); body = "Please click on these links if you want to <a href='" + EditURL + "'>EDIT</a> OR <a href='" + DeleteURL + "'>DELETE</a> your item post from DonateForGood website"; if (SendMail(toAddress, subject, body) == "Successful") { return(RedirectToAction("Index")); } } ViewBag.ItemCategoryId_ = new SelectList(db.ItemCategories, "ItemCategoryId", "ItemCategoryName", itempost.ItemCategoryId_); ViewBag.ItemCollectPreferenceId = new SelectList(db.ItemCollectPreferences, "ItemCollectPreferenceId", "ItemCollectPreferenceName", itempost.ItemCollectPreferenceId); ViewBag.LocationId_ = new SelectList(db.Locations, "LocationId", "LocationName", itempost.LocationId_); ViewBag.ItemStatusId = new SelectList(db.ItemStatus, "ItemStatusId", "ItemStatusName", itempost.ItemStatusId); return(View(itempost)); }
// GET: /Item/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ItemPost itempost = db.ItemPosts.Find(id); if (itempost == null) { return(HttpNotFound()); } return(View(itempost)); }
public ActionResult Edit([Bind(Include = "ItemPostId,ItemCategoryId_,LocationId_,ItemName,PhoneNumber,EmailAddress_,Quantity,Description,Photo1,Photo2,Photo3,UserTypeId,CreatedOn,ModifiedOn,ItemStatusId,ContactByEmail,ContactByPhone,DisplayMyPhoneNo,DisplayMyEmail_,ItemCollectPreferenceId")] ItemPost itempost) { if (ModelState.IsValid) { db.Entry(itempost).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ItemCategoryId_ = new SelectList(db.ItemCategories, "ItemCategoryId", "ItemCategoryName", itempost.ItemCategoryId_); ViewBag.ItemCollectPreferenceId = new SelectList(db.ItemCollectPreferences, "ItemCollectPreferenceId", "ItemCollectPreferenceName", itempost.ItemCollectPreferenceId); ViewBag.LocationId_ = new SelectList(db.Locations, "LocationId", "LocationName", itempost.LocationId_); ViewBag.ItemStatusId = new SelectList(db.ItemStatus, "ItemStatusId", "ItemStatusName", itempost.ItemStatusId); return(View(itempost)); }
public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } TempData["Id"] = id; ItemPost itempost = db.ItemPosts.Find(id); if (itempost == null) { return(HttpNotFound()); } return(View(itempost)); }
// GET: /Item/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ItemPost itempost = db.ItemPosts.Find(id); if (itempost == null) { return(HttpNotFound()); } ViewBag.ItemCategoryId_ = new SelectList(db.ItemCategories, "ItemCategoryId", "ItemCategoryName", itempost.ItemCategoryId_); ViewBag.ItemCollectPreferenceId = new SelectList(db.ItemCollectPreferences, "ItemCollectPreferenceId", "ItemCollectPreferenceName", itempost.ItemCollectPreferenceId); ViewBag.LocationId_ = new SelectList(db.Locations, "LocationId", "LocationName", itempost.LocationId_); ViewBag.ItemStatusId = new SelectList(db.ItemStatus, "ItemStatusId", "ItemStatusName", itempost.ItemStatusId); return(View(itempost)); }
public int GetUserId(ItemPost itempost) { int userId = 0; if (Session["LoggedInUserId"] != null) { userId = int.Parse(Session["LoggedInUserId"].ToString()); } if (userId == 0) { string[] email = itempost.EmailAddress_.Split('@'); string username = email[0]; DonateForGood.Models.User user = new Models.User { UserTypeId = 2, PhoneNumber = itempost.PhoneNumber, EmailAddress = itempost.EmailAddress_, UserName = username }; var query = (from tableUser in db.Users where (tableUser.PhoneNumber == user.PhoneNumber || tableUser.EmailAddress == user.EmailAddress) select tableUser.UserId); if (!(query.Any())) { db.Users.Add(user); db.SaveChanges(); userId = (from tableUser in db.Users where (tableUser.PhoneNumber == user.PhoneNumber || tableUser.EmailAddress == user.EmailAddress) select tableUser.UserId).First(); } else { userId = (from tableUser in db.Users where (tableUser.PhoneNumber == user.PhoneNumber || tableUser.EmailAddress == user.EmailAddress) select tableUser.UserId).First(); } } return(userId); }
// GET: /Item/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ItemPost itempost = db.ItemPosts.Find(id); if (itempost == null) { return(HttpNotFound()); } ViewBag.ItemCategoryId_ = new SelectList(db.ItemCategories, "ItemCategoryId", "ItemCategoryName", itempost.ItemCategoryId_); ViewBag.LocationId_ = new SelectList(db.Locations, "LocationId", "LocationName", itempost.LocationId_); ViewBag.ItemName = itempost.ItemName; ViewBag.PhoneNumber = itempost.PhoneNumber; ViewBag.EmailAddress = itempost.EmailAddress_; ViewBag.Quantity = itempost.Quantity; ViewBag.Description = itempost.Description; ViewBag.ItemCollectPreferenceId = new SelectList(db.ItemCollectPreferences, "ItemCollectPreferenceId", "ItemCollectPreferenceName", itempost.ItemCollectPreferenceId); ViewBag.ItemStatusId = new SelectList(db.ItemStatus, "ItemStatusId", "ItemStatusName", itempost.ItemStatusId); return(View(itempost)); }