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