public ActionResult DieticianDeleteConfirmed(int id) { Dietician dietician = db.Dieticians.Find(id); db.Dieticians.Remove(dietician); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult User_Register(User user) { if (ModelState.IsValid) { var userLoggedIn = db.Users.SingleOrDefault(x => x.Email == user.Email); if (userLoggedIn == null) { ViewBag.message = "Register"; db.Users.Add(user); db.SaveChanges(); return(RedirectToAction("Login", "Home")); } else { ViewBag.triedOnce = "yes"; return(View()); } } else { return(View()); } }
public ActionResult User_Register(User user) { if (ModelState.IsValid) { using (var context = new Medicaldbcontext()) { context.Users.Add(user); context.SaveChanges(); } return(View("Search", user)); } else { return(View()); } }
public ActionResult DieticianReg(Dietician diet, HttpPostedFileBase postedFile) { if (ModelState.IsValid) { if (postedFile != null) { string fileName = Path.GetFileName(postedFile.FileName); ////Set the Image File Path. string filePath = "~/Uploads/" + fileName; ////Save the Image File in Folder. postedFile.SaveAs(Server.MapPath(filePath)); diet.filepath = filePath; } ////Insert the Image File details in Table. //// FilesEntities entities = new FilesEntities(); //db.images.Add(new Dietician //{ // Name = fileName, // FilePath = filePath //}); using (var context = new Medicaldbcontext()) { try { context.Dieticians.Add(diet); context.SaveChanges(); } catch (Exception) { ViewBag.Email = "Duplicate Email"; return(View(diet)); } } return(View("Search", diet)); } else { return(View()); } }
public ActionResult DieticianDataEntry(DieticianDataEntry dde, string Add, string Search, string Update, string Delete, string adddisease) { if (Session["email"] == null) { return(RedirectToAction("Login", "Home")); } else { DataTable ds = new DataTable(); List <String> dr = new List <String>(); string constr = ConfigurationManager.ConnectionStrings["Medicaldbcontext"].ConnectionString; ViewBag.email = Session["email"]; string email = Session["email"].ToString(); string name = db.Database.SqlQuery <string>("Select name from Dieticians where email=@email", new SqlParameter("@email", email)).FirstOrDefault(); ViewBag.Name = name; int experience = db.Database.SqlQuery <int>("Select experience from Dieticians where email=@email", new SqlParameter("@email", email)).FirstOrDefault(); ViewBag.Experience = experience; int dieticianid = db.Database.SqlQuery <int>("Select did from Dieticians where email=@email", new SqlParameter("@email", email)).FirstOrDefault(); //var dieticianLoggedIn = db.Dieticians.SingleOrDefault(x => x.Email == email); using (SqlConnection con = new SqlConnection(constr)) { string query = "SELECT distinct Disease FROM DieticianDataEntries order by Disease "; using (SqlCommand cmd = new SqlCommand(query)) { cmd.Connection = con; using (SqlDataAdapter sda = new SqlDataAdapter(cmd)) { if (adddisease != null && adddisease != "") { dr.Add(adddisease); } sda.Update(ds); sda.Fill(ds); foreach (DataRow row in ds.Rows) { dr.Add(row["Disease"].ToString()); } ViewBag.dis = new SelectList(dr); } } } if (Add == "Add") { if (ModelState.IsValid) { var alreadyExist = db.DieticianDataEntries.SingleOrDefault(x => x.Disease == dde.Disease && x.dieticianid == dieticianid); if (alreadyExist == null) { dde.dieticianid = dieticianid; db.DieticianDataEntries.Add(dde); db.SaveChanges(); ViewBag.Success = "Inserted"; return(RedirectToAction("DieticianDataEntry", "DieticianDataEntry")); } else { ViewBag.AlreadyExist = "Record with same Disease Already Exist. Try Search & Update."; return(View()); } } else { return(View()); } } else if (Search == "Search") { if (ModelState.IsValid) { var alreadyExist = db.DieticianDataEntries.SingleOrDefault(x => x.Disease == dde.Disease && x.dieticianid == dieticianid); if (alreadyExist != null) { ViewBag.whatte = "What TO Eat: " + alreadyExist.WhatToEat; //ViewData["whatte"] = dde.WhatToEat; ViewBag.notte = "What TO Avoid" + ": " + alreadyExist.NotToEat; ViewBag.Success = "Search Completed"; return(View()); } else { ViewBag.AlreadyExist = "No Record with Disease Exist . Try ADD."; return(View()); } } else { return(View()); } } else if (Update == "Update") { if (ModelState.IsValid) { var alreadyExist = db.DieticianDataEntries.SingleOrDefault(x => x.Disease == dde.Disease && x.dieticianid == dieticianid); if (alreadyExist == null) { db.DieticianDataEntries.Add(dde); db.SaveChanges(); ViewBag.Success = "Inserted"; return(View()); } else { alreadyExist.Disease = dde.Disease; alreadyExist.WhatToEat = dde.WhatToEat; alreadyExist.NotToEat = dde.NotToEat; alreadyExist.dieticianid = dieticianid; db.SaveChanges(); ViewBag.Success = "Updated"; return(View()); } } else { return(View()); } } else if (Delete == "Delete") { if (ModelState.IsValid) { var dise = dde.Disease; //int result = db.Database.ExecuteSqlCommand("delete from DieticianDataEntries where Disease = "); int ddeid = db.Database.SqlQuery <int>("Select ddeID from DieticianDataEntries where Disease=@dise", new SqlParameter("@dise", dise)).FirstOrDefault(); DieticianDataEntry dieticianDataEntry = db.DieticianDataEntries.Find(ddeid); db.DieticianDataEntries.Remove(dieticianDataEntry); db.SaveChanges(); ViewBag.Success = "Deleted"; return(RedirectToAction("DieticianDataEntry", "DieticianDataEntry")); } else { return(View()); } } else { return(View()); } } }