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));
}
