public JsonResult PostUpdateOneSale(ProductSold prodsold) { if (ModelState.IsValid) { try { var query = db.ProductSolds.Where(user => user.Id == prodsold.Id).Select(col => new { col.CustomerId, col.ProductId, col.StoreId, col.DateSold }).Single(); string text_date = Request.Form["date"]; // initial date DateTime date = Convert.ToDateTime(text_date); // convert to Datetime query = new { CustomerId = prodsold.CustomerId, ProductId = prodsold.ProductId, StoreId = prodsold.StoreId, DateSold = date }; db.Entry(prodsold).State = EntityState.Modified; // allow to update the entity db.SaveChanges(); return(Json(new { Success = true }, JsonRequestBehavior.AllowGet)); } catch (Exception e) { return(Json(new { Success = false, e }, JsonRequestBehavior.DenyGet)); } } return(Json(new { Success = false }, JsonRequestBehavior.DenyGet)); }
public ActionResult Edit([Bind(Include = "ClassID,Class_Name,Class_Day,Class_Time,Class_Level")] ClassTiming classTiming) { if (ModelState.IsValid) { db.Entry(classTiming).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(classTiming)); }
public ActionResult Edit([Bind(Include = "InventoryID,Product_Name,Product_Desc,Product_Cost,Product_SellPrice")] Inventory inventory) { if (ModelState.IsValid) { db.Entry(inventory).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(inventory)); }
public ActionResult Edit([Bind(Include = "MembershipID,Membership_Name,Membership_Fee")] MembershipType membershipType) { if (ModelState.IsValid) { db.Entry(membershipType).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(membershipType)); }
public ActionResult Edit([Bind(Include = "RankID,Rank_Name")] Rank rank) { if (ModelState.IsValid) { db.Entry(rank).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(rank)); }
public ActionResult Edit([Bind(Include = "StudentID,StudentName,DateOfBirth,DateOfJoining,Student_Phone,Student_Email,Student_Address,isActive,isAdult")] Student student) { if (ModelState.IsValid) { db.Entry(student).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(student)); }
public ActionResult Edit([Bind(Include = "ParentID,StudentID,Mother_Name,Father_Name,Parent_Email,isStudent")] Parent parent) { if (ModelState.IsValid) { db.Entry(parent).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.StudentID = new SelectList(db.Students, "StudentID", "StudentName", parent.StudentID); return(View(parent)); }
public ActionResult Edit([Bind(Include = "TestID,TestFees,RankID")] TestFee testFee) { if (ModelState.IsValid) { db.Entry(testFee).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.RankID = new SelectList(db.Ranks, "RankID", "Rank_Name", testFee.RankID); return(View(testFee)); }
public ActionResult Edit([Bind(Include = "StudentRankDetialID,StudentID,RankID")] StudentRankDetail studentRankDetail) { if (ModelState.IsValid) { db.Entry(studentRankDetail).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.RankID = new SelectList(db.Ranks, "RankID", "Rank_Name", studentRankDetail.RankID); ViewBag.StudentID = new SelectList(db.Students, "StudentID", "StudentName", studentRankDetail.StudentID); return(View(studentRankDetail)); }
public ActionResult Edit([Bind(Include = "Attendence_ID,StudentID,Student_datetime,ClassID")] StudentAttendence studentAttendence) { if (ModelState.IsValid) { db.Entry(studentAttendence).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ClassID = new SelectList(db.ClassTimings, "ClassID", "Class_Name", studentAttendence.ClassID); ViewBag.StudentID = new SelectList(db.Students, "StudentID", "StudentName", studentAttendence.StudentID); return(View(studentAttendence)); }
public ActionResult Edit([Bind(Include = "StudentFeeID,StudentID,TestID,MembershipID,InventoryID,StudentFee_datetime")] StudentFee studentFee) { if (ModelState.IsValid) { db.Entry(studentFee).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.InventoryID = new SelectList(db.Inventories, "InventoryID", "Product_Name", studentFee.InventoryID); ViewBag.MembershipID = new SelectList(db.MembershipTypes, "MembershipID", "Membership_Name", studentFee.MembershipID); ViewBag.StudentID = new SelectList(db.Students, "StudentID", "StudentName", studentFee.StudentID); ViewBag.TestID = new SelectList(db.TestFees, "TestID", "TestID", studentFee.TestID); return(View(studentFee)); }
public JsonResult PostUpdateOneCustomer(Customer customer) { if (ModelState.IsValid) { try { var query = db.Customers.Where(user => user.Id == customer.Id).Select(col => new { col.Name, col.Address }).Single(); query = new { customer.Name, customer.Address }; db.Entry(customer).State = EntityState.Modified; // allow to update the entity db.SaveChanges(); return(Json(db.Customers.ToList(), JsonRequestBehavior.AllowGet)); } catch (Exception e) { Console.WriteLine(e); } } return(Json(db.Customers.ToList(), JsonRequestBehavior.DenyGet)); }
public JsonResult PostUpdateOneProduct(Product product) { if (ModelState.IsValid) { try { var query = db.Products.Where(prod => prod.Id == product.Id).Select(col => new { col.Name, col.Price }).Single(); query = new { product.Name, product.Price }; db.Entry(product).State = EntityState.Modified; // allow to update the entity db.SaveChanges(); return(Json(db.Products.ToList(), JsonRequestBehavior.AllowGet)); } catch (Exception e) { Console.WriteLine(e); } } return(Json(db.Products.ToList(), JsonRequestBehavior.DenyGet)); }