IEnumerable <DieticianDataEntry> getdata() { using (Medicaldbcontext db = new Medicaldbcontext()) { return(db.DieticianDataEntries.ToList <DieticianDataEntry>()); } }
IEnumerable <User> getuser() { using (Medicaldbcontext db = new Medicaldbcontext()) { return(db.Users.ToList <User>()); } }
IEnumerable <Dietician> getdietician() { using (Medicaldbcontext db = new Medicaldbcontext()) { return(db.Dieticians.ToList <Dietician>()); } }
public ActionResult DieticianDataEntry(DieticianDataEntry dde) { Medicaldbcontext db = new Medicaldbcontext(); DataTable ds = new DataTable(); List <String> dr = new List <String>(); string constr = ConfigurationManager.ConnectionStrings["Medicaldbcontext"].ConnectionString; 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)) { sda.Fill(ds); foreach (DataRow row in ds.Rows) { dr.Add(row["Disease"].ToString()); } ViewBag.dis = new SelectList(dr); } } } if (Session["email"] == null) { return(RedirectToAction("Login", "Home")); } else { 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; //var dieticiandata = dde.Dietician.(x => x.Email == email); // if (dieticiandata != null) // { // ViewBag.Name = dde.Dietician.Name; // ViewBag.Experience = dde.Dietician.Experience; // } 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()); } }