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