public ActionResult ViewPost(int id) { Post post = new Post(); var userID = Convert.ToInt32(Session["id"]); bool exist; using (MyDatabaseEntities db = new MyDatabaseEntities()) { post = db.Posts.Where(x => x.PostID == id).FirstOrDefault(); exist = db.Likes.Any(x => x.PostId == id && x.UserId == userID); if (exist == false) { ViewBag.Like = false; } else { ViewBag.Like = true; } post.Likes = db.Likes.Count(x => x.PostId == id); db.Entry(post).Property("Likes").IsModified = true; db.SaveChanges(); post.Comments = db.Comments.Count(x => x.PostId == id); db.Entry(post).Property("Comments").IsModified = true; db.SaveChanges(); } return(View(post)); }
public void Remove(Tbl_Entity entity) { if (_DBEntity.Entry(entity).State == EntityState.Detached) { _dbSet.Attach(entity); } _dbSet.Remove(entity); }
public ActionResult _Gallery() { //using (MyDatabaseEntities db = new MyDatabaseEntities()) //{ // Session["id"] = db.Users.Where(u => u.EmailID == User.Identity.Name).FirstOrDefault().UserID; // var id = Convert.ToInt32(Session["id"]); // UserData usrD = new UserData // { // ProfileImage = db.UserDatas.Where(x => x.Id == id).FirstOrDefault().ProfileImage // }; // ViewBag.Pic = usrD; //} try { int id = Convert.ToInt32(Session["id"]); string image = Session["img"].ToString(); using (MyDatabaseEntities db = new MyDatabaseEntities()) { var user = db.UserDatas.Where(x => x.Id == id).FirstOrDefault(); user.ProfileImage = image; foreach (var item in db.Posts) { if (item.UserID == id) { item.UserPicture = image; db.Entry(item).Property("UserPicture").IsModified = true; //db.SaveChanges(); } } db.Entry(user).Property("ProfileImage").IsModified = true; db.SaveChanges(); } } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } throw; } return(RedirectToAction("Index", "Home")); }
public ActionResult addData(Service service) { var result = new JsonResult(); if (ModelState.IsValid) { service.CreatedByUserId = 1; service.CreatedByUserName = "******"; service.CreatedByUSerDate = DateTime.Now; _context.Entry(service).State = EntityState.Added; _context.SaveChanges(); } return(Json(result)); }
public IHttpActionResult PutTransaction(int id, Transaction transaction) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != transaction.Id) { return(BadRequest()); } db.Entry(transaction).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!TransactionExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public ActionResult saveuser(int id, string propertyName, string value) { var status = false; var message = ""; //Update data to database using (MyDatabaseEntities dc = new MyDatabaseEntities()) { var user = dc.SiteUsers.Find(id); object updateValue = value; bool isValid = true; if (propertyName == "RoleID") { int newRoleID = 0; if (int.TryParse(value, out newRoleID)) { updateValue = newRoleID; //Update value field value = dc.UserRoles.Where(a => a.ID == newRoleID).First().RoleName; } else { isValid = false; } } else if (propertyName == "DOB") { DateTime dob; if (DateTime.TryParseExact(value, "dd-MM-yyyy", new CultureInfo("en-US"), DateTimeStyles.None, out dob)) { updateValue = dob; } else { isValid = false; } } if (user != null && isValid) { dc.Entry(user).Property(propertyName).CurrentValue = updateValue; dc.SaveChanges(); status = true; } else { message = "Error!"; } } var response = new { value = value, status = status, message = message }; JObject o = JObject.FromObject(response); return(Content(o.ToString())); }
public ActionResult Edit(User_Folder user_folder) { if (ModelState.IsValid) { db.Entry(user_folder).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(user_folder)); }
public ActionResult Edit(Thread thread) { if (ModelState.IsValid) { db.Entry(thread).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(thread)); }
public ActionResult Edit([Bind(Include = "CustomerId,Name,Address,Phone,OrderDate")] Customer customer) { if (ModelState.IsValid) { db.Entry(customer).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(customer)); }
public ActionResult Edit([Bind(Include = "Id,name,address,city,email,phonne")] Employee employee) { if (ModelState.IsValid) { db.Entry(employee).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(employee)); }
public ActionResult Edit([Bind(Include = "OrderID,OrderNo,OrderDate,Description")] OrderMaster orderMaster) { if (ModelState.IsValid) { db.Entry(orderMaster).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(orderMaster)); }
public ActionResult Edit([Bind(Include = "Id,Название_маршрута,Примечание")] Маршрут маршрут) { if (ModelState.IsValid) { db.Entry(маршрут).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(маршрут)); }
public ActionResult Edit([Bind(Include = "ProductID,CategoryID,ProductName")] Product product) { if (ModelState.IsValid) { db.Entry(product).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(product)); }
public ActionResult Edit(ProductGalary productgalary) { if (ModelState.IsValid) { db.Entry(productgalary).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(productgalary)); }
public ActionResult Edit([Bind(Include = "DoctorID,FirstName,LastName,Job,Directory,Date")] Doctor doctor) { if (ModelState.IsValid) { db.Entry(doctor).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(doctor)); }
public ActionResult Edit(message Message) { if (ModelState.IsValid) { db.Entry(Message).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(Message)); }
public ActionResult Edit([Bind(Include = "LocationID,Title,Lat,Long,Address,Phone,ImagePath,Detail,Price,Bed,Wardrobe,Conditioner,Desk,Toilet,Refrigrator,Wifi")] Location location) { if (ModelState.IsValid) { db.Entry(location).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(location)); }
public ActionResult Edit([Bind(Include = "CategoryID,CategoryName")] Category category) { if (ModelState.IsValid) { db.Entry(category).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(category)); }
public ActionResult Edit([Bind(Include = "name,email,mobilePhone,birthday,contactTime,remark")] Account account) { if (ModelState.IsValid) { db.Entry(account).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(account)); }
public ActionResult editData(Module module) { if (ModelState.IsValid) { _context.Entry(module).State = EntityState.Modified; _context.SaveChanges(); return(RedirectToAction("Index")); } return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "PacjentID,FirstName,LastName,Choroba,Date,Telefon,DoctorID")] Pacjent pacjent) { if (ModelState.IsValid) { db.Entry(pacjent).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.DoctorID = new SelectList(db.Doctors, "DoctorID", "FirstName", pacjent.DoctorID); return(View(pacjent)); }
public ActionResult addData(Component comp) { var result = new JsonResult(); if (ModelState.IsValid) { { _context.Entry(comp).State = EntityState.Added; _context.SaveChanges(); return(RedirectToAction("Index")); } } else { ViewBag.Message = ModelState.GetModelStateErrors(); result.IsSuccess = false; result.Message = "validation failed"; } return(Json(result)); }
public ActionResult Edit([Bind(Include = "Id,Название_типа")] Тип_ТС тип_ТС) { if (ModelState.IsValid) { db.Entry(тип_ТС).State = EntityState.Modified; тип_ТС.Название_типа = тип_ТС.Название_типа.Trim(); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(тип_ТС)); }
public async Task <ActionResult> Edit([Bind(Include = "id,name,email,address")] User user) { if (ModelState.IsValid) { db.Entry(user).State = EntityState.Modified; await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(user)); }
public ActionResult Edit([Bind(Include = "OrderId,ProductName,Quantity,Price,Amount,CustomerId")] Order order) { if (ModelState.IsValid) { db.Entry(order).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CustomerId = new SelectList(db.Customers, "CustomerId", "Name", order.CustomerId); return(View(order)); }
public void UpdateStudent(int id, string name, DateTime brithday, int class_id) { var db = new MyDatabaseEntities(); var student = db.Students.Find(id); student.Name = name; student.Brithay = brithday; student.Class_id = class_id; db.Entry(student).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); }
public ActionResult Edit([Bind(Include = "OrderDetailsID,OrderID,ProductID,Rate,Quantity")] OrderDetail orderDetail) { if (ModelState.IsValid) { db.Entry(orderDetail).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.OrderID = new SelectList(db.OrderMasters, "OrderID", "OrderNo", orderDetail.OrderID); return(View(orderDetail)); }
public ActionResult editData(ControllerDetail postEdit) { if (ModelState.IsValid) { _context.Entry(postEdit).State = EntityState.Modified; _context.SaveChanges(); return(RedirectToAction("Index")); } return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "Id,Название_задачи,Группа_задачID,Примечание")] Задача задача) { if (ModelState.IsValid) { db.Entry(задача).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.Группа_задачID = new SelectList(db.Группы_задач, "Id", "Название_группы", задача.Группа_задачID); return(View(задача)); }
public ActionResult editData(Developer developer) { var result = new JsonResult(); if (ModelState.IsValid) { _context.Entry(developer).State = EntityState.Modified; _context.SaveChanges(); return(RedirectToAction("Index")); } return(Json(result)); }