public ActionResult Create(proof_table obj) { if (Session["username"] == null || Session["userlevel"].ToString() != "admin") { return(this.RedirectToAction("Logout", "Account")); } if (ModelState.IsValid) { var usr = (from u in ags.proof_table where u.proofname == obj.proofname select u).FirstOrDefault(); if (usr == null) { var max = ags.proof_table.GroupBy(x => x.porder).Select(g => g.OrderByDescending(x => x.porder).FirstOrDefault()); ags.proof_table.Add(new proof_table { proofname = obj.proofname, porder = obj.porder, status = obj.status, datex = DateTime.Now.ToString(), addedby = Session["username"].ToString() }); ags.SaveChanges(); return(RedirectToAction("Proof")); } else { TempData["AE"] = "This Proof is already exist"; return(RedirectToAction("Proof")); // return Json(new { success = true, responseText = TempData["AE"] }, JsonRequestBehavior.AllowGet); } } return(View("~/Views/Admin_Mangement/AdminProofs/Proof.cshtml", obj)); }
public ActionResult DeleteConfirmed(int id) { proof_table proof_table = ags.proof_table.Find(id); var customerProof = ags.proof_customer_table.Where(x => x.proofid == id.ToString()); ags.proof_customer_table.RemoveRange(customerProof); ags.proof_table.Remove(proof_table); ags.SaveChanges(); return(RedirectToAction("Proof")); }
public ActionResult Create(proof_table obj) { if (Session["username"] == null || Session["userlevel"].ToString() != "super_admin") { return(this.RedirectToAction("Logout", "Account")); } if (ModelState.IsValid) { var usr = (from u in ags.proof_table where u.proofname == obj.proofname select u).FirstOrDefault(); if (usr == null) { var max = ags.proof_table.GroupBy(x => x.porder).Select(g => g.OrderByDescending(x => x.porder).FirstOrDefault()); proof_table proof = new proof_table(); proof.proofname = obj.proofname; proof.porder = obj.porder; proof.status = obj.status; proof.datex = DateTime.Now.ToString(); proof.addedby = Session["username"].ToString(); ags.proof_table.Add(proof); ags.SaveChanges(); //int last_insert_id = proof.id; //var customerLoans = (from s in ags.customer_profile_table select s).Distinct().ToList(); ////int countLoan = ags.customer_profile_table.ToList().Distinct().Count(); //foreach (var loans in customerLoans) //{ // ags.proof_customer_table.Add(new proof_customer_table // { // customerid = loans.customerid, // proofid = last_insert_id.ToString(), // datex = DateTime.Now.ToString(), // addedby = Session["username"].ToString() // }); //} //ags.SaveChanges(); return(RedirectToAction("Proof")); } else { TempData["AE"] = "This Proof is already exist"; return(RedirectToAction("Proof")); // return Json(new { success = true, responseText = TempData["AE"] }, JsonRequestBehavior.AllowGet); } } return(View(obj)); }
public ActionResult Delete(int?id) { if (Session["username"] == null || Session["userlevel"].ToString() != "super_admin") { return(this.RedirectToAction("Logout", "Account")); } if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } proof_table proof_table = ags.proof_table.Find(id); if (proof_table == null) { return(HttpNotFound()); } return(PartialView(proof_table)); }
//public JsonResult UsernameExists(string proofname) //{ // //var model = new agskeys.Models.proof_table(); // var proof_table = ags.proof_table.ToList(); // var proofdata = ""; // foreach (var items in proof_table) // { // if (proofname == items.proofname) // { // proofdata = items.proofname; // break; // } // else // { // proofdata = items.proofname; // continue; // } // } // return Json(!String.Equals(proofname, proofdata, StringComparison.OrdinalIgnoreCase)); //} // [HttpPost] // public JsonResult UsernameExists(string proofname, int id) //{ // return Json(IsUnique(proofname, id)); // } // private bool IsUnique(string proofname, int id) // { // if (id == 0) // its a new object // { // return !ags.proof_table.Any(x => x.proofname == proofname); // } // else // its an existing object so exclude existing objects with the id // { // return !ags.proof_table.Any(x => x.proofname == proofname && x.id != id); // } // } public ActionResult Edit(int?Id) { if (Session["username"] == null || Session["userlevel"].ToString() != "admin") { return(this.RedirectToAction("Logout", "Account")); } if (Id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } proof_table proof_table = ags.proof_table.Find(Id); if (proof_table == null) { return(HttpNotFound()); } return(PartialView("~/Views/Admin_Mangement/AdminProofs/Edit.cshtml", proof_table)); }
public ActionResult Edit(proof_table proof) { if (Session["username"] == null || Session["userlevel"].ToString() != "super_admin") { return(this.RedirectToAction("Logout", "Account")); } if (ModelState.IsValid) { proof_table existing = ags.proof_table.Find(proof.id); if (proof.status == "publish") { existing.status = proof.status; } else { existing.status = proof.status; } if (existing.proofname != proof.proofname) { var userCount = (from u in ags.proof_table where u.proofname == proof.proofname select u).Count(); if (userCount == 0) { existing.proofname = proof.proofname; } else { TempData["AE"] = "This Proof is already exist"; return(RedirectToAction("Proof")); } } if (existing.porder != proof.porder) { var proofCount = (from u in ags.proof_table where u.porder == proof.porder select u).Count(); if (proofCount == 0) { existing.porder = proof.porder; int last_insert_id = proof.id; int totalProofCount = ags.proof_table.Count(); var customerProofs = ags.proof_customer_table.GroupBy(x => x.proofid).Select(t => t.FirstOrDefault()).ToList(); int customerProofsCount = customerProofs.Count(); var customerLoans = ags.proof_customer_table.GroupBy(x => x.customerid).Select(t => t.FirstOrDefault()).ToList(); if (customerProofsCount < totalProofCount) { foreach (var loans in customerLoans) { ags.proof_customer_table.Add(new proof_customer_table { customerid = loans.customerid, proofid = last_insert_id.ToString(), proofans = "NotApplicable", datex = DateTime.Now.ToString(), addedby = Session["username"].ToString() }); } } } else { TempData["AE"] = "This Order Number is already exist"; return(RedirectToAction("Proof")); } } if (existing.addedby == null) { existing.addedby = Session["username"].ToString(); } if (existing.datex == null) { existing.datex = DateTime.Now.ToString(); } ags.SaveChanges(); return(RedirectToAction("Proof")); } return(PartialView(proof)); }