public ActionResult Index(register model) { if (ModelState.IsValid) { try { var DeleteRecord = db.registers.Where(x => x.EventName == model.EventName).Where(i => i.Email == model.Email).ToList(); if (DeleteRecord.Count() > 0) { TempData["duplicate"] = "Error: Event Data already registered under this client"; ViewBag.EventName = new SelectList(db.events, "EventName", "EventName"); ViewBag.Email = new SelectList(db.clients, "Email", "Email"); return(View()); //return RedirectToAction("Index"); } db.registers.Add(model); db.SaveChanges(); ModelState.Clear(); TempData["msg"] = "Event Data registered successfully"; db.Dispose(); return(RedirectToAction("Index")); } catch { TempData["duplicate"] = "Something went wrong!, please verify your network connectivity"; return(View()); } } else { TempData["duplicate"] = "Inserted data not valid. Please recheck your data and register again"; return(View()); } }
public ActionResult Index(client model) { if (ModelState.IsValid) { try { var mydb = new myDBEntities(); if (mydb.clients.Any(exist => exist.Email == model.Email)) { TempData["duplicate"] = "Duplicate Email found!, please recheck your client's email"; return(View()); } mydb.clients.Add(model); mydb.SaveChanges(); ModelState.Clear(); TempData["msg"] = "Client data registred successfully!"; mydb.Dispose(); return(RedirectToAction("Index")); } catch { TempData["duplicate"] = "Something went wrong!, please verify your network connectivity"; return(View()); } } else { TempData["duplicate"] = "Inserted data not valid. Please recheck your data and register again"; return(View()); } }
protected override void Dispose(bool disposing) { if (disposing) { db.Dispose(); } base.Dispose(disposing); }
public ActionResult Index(register model) { try { var DeleteRecord = myDB.registers.Where(x => x.EventName == model.EventName).Where(i => i.Email == model.Email).ToList(); foreach (var i in DeleteRecord) { myDB.registers.Remove(i); } //myDB.registers.Remove(DeleteRecord); myDB.SaveChanges(); ModelState.Clear(); TempData["msg"] = "Event data deleted successfully!"; // myDB.Dispose(); return(RedirectToAction("Index")); } catch { TempData["duplicate"] = "Something went wrong!, please verify data provided or contact your system administrator"; myDB.Dispose(); return(RedirectToAction("Index")); } }