public ActionResult Create([Bind(Include = "Id,CaloriesEaten1,Type,Date,UserId")] CaloriesEaten caloriesEaten) { if (ModelState.IsValid) { SqlConnection con1 = new SqlConnection("Data Source=(LocalDb)\\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\\Authentication.mdf;Integrated Security=True"); DataTable dt = new DataTable(); string id = User.Identity.GetUserName().ToString(); SqlCommand myCommand = new SqlCommand("SELECT TOP 1 Id FROM CaloriesEaten ORDER BY Id DESC", con1); con1.Open(); SqlDataAdapter da = new SqlDataAdapter(myCommand); ////replace with userid from email id da.Fill(dt); if (dt.Rows.Count > 0) { caloriesEaten.Id = Convert.ToInt32(dt.Rows[0]["id"]) + 1; } caloriesEaten.UserId = User.Identity.GetUserId(); //} //userDetail.UserId = dt.Rows[0].Id; con1.Close(); da.Dispose(); db.CaloriesEatens.Add(caloriesEaten); db.SaveChanges(); TempData["success"] = "Calories Eaten has been added"; return(RedirectToAction("Index")); } return(View(caloriesEaten)); }
public ActionResult Create([Bind(Include = "Id,CaloriesEaten1,Type,Date,UserId")] CaloriesEaten caloriesEaten) { if (ModelState.IsValid) { SqlConnection con1 = new SqlConnection("Data Source=(LocalDb)\\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\\Authentication.mdf;Integrated Security=True"); DataTable dt = new DataTable(); string id = User.Identity.GetUserName().ToString(); SqlCommand myCommand = new SqlCommand("Select * from AspNetUsers where Email = '" + id + "'", con1); con1.Open(); SqlDataAdapter da = new SqlDataAdapter(myCommand); //replace with userid from email id da.Fill(dt); if (dt.Rows.Count > 0) { caloriesEaten.UserId = Convert.ToString(dt.Rows[0]["id"]); } //userDetail.UserId = dt.Rows[0].Id; con1.Close(); da.Dispose(); db.Entry(caloriesEaten).State = EntityState.Modified; //db.CaloriesEatens.Add(caloriesEaten); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(caloriesEaten)); }
public ActionResult DeleteConfirmed(int id) { CaloriesEaten caloriesEaten = db.CaloriesEatens.Find(id); db.CaloriesEatens.Remove(caloriesEaten); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult DeleteConfirmed(int id) { CaloriesEaten caloriesEaten = db.CaloriesEatens.Find(id); db.CaloriesEatens.Remove(caloriesEaten); db.SaveChanges(); TempData["success"] = "Calories Eaten has been deleted"; return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "Id,CaloriesEaten1,Type,Date,UserId")] CaloriesEaten caloriesEaten) { if (ModelState.IsValid) { db.Entry(caloriesEaten).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(caloriesEaten)); }
// GET: CaloriesEatens/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } CaloriesEaten caloriesEaten = db.CaloriesEatens.Find(id); if (caloriesEaten == null) { return(HttpNotFound()); } return(View(caloriesEaten)); }