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