public ActionResult AddTime([Bind(Include = "id,title,Description,leader,time,startDate,endDate,inputs")] Project project, double AddVal) { if (ModelState.IsValid) { Project.timeLog t = new Project.timeLog(User.Identity.Name, AddVal, DateTime.Now); project.time += AddVal; SqlConnection conn = new SqlConnection("Data Source = (localdb)\\MSSQLLocalDB; Initial Catalog = test8.Models.ProjetDBContext; Integrated Security = True; Connect Timeout = 30; Encrypt = False; TrustServerCertificate = True; ApplicationIntent = ReadWrite; MultiSubnetFailover = False"); conn.Open(); string sql = "INSERT INTO[dbo].[timeLogs] ([user], [time], [date], [Project_id]) VALUES(@u, @t, @d, @i)"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@u", t.user); cmd.Parameters.AddWithValue("@t", t.time); cmd.Parameters.AddWithValue("@d", t.date); cmd.Parameters.AddWithValue("@i", project.id); cmd.ExecuteNonQuery(); //if (project.inputs == null) // project.inputs = new List<Project.timeLog>(); //project.inputs.Add(t); db.Entry(project).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } var errors = ModelState.Values.SelectMany(v => v.Errors); return(View(project)); }
// GET: Projects/TimeDetails/2 public ActionResult TimePerUser(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Project project = db.Projects.Find(id); if (project == null) { return(HttpNotFound()); } SqlConnection conn = new SqlConnection("Data Source = (localdb)\\MSSQLLocalDB; Initial Catalog = test8.Models.ProjetDBContext; Integrated Security = True; Connect Timeout = 30; Encrypt = False; TrustServerCertificate = True; ApplicationIntent = ReadWrite; MultiSubnetFailover = False"); conn.Open(); SqlCommand cmd = new SqlCommand("SELECT [user], [time], [date], [Project_id] FROM dbo.timeLogs", conn); SqlDataReader rdr = cmd.ExecuteReader(); project.inputs = new List <Project.timeLog>(); while (rdr.Read()) { if (rdr.GetInt32(3) == id) { Project.timeLog t = new Project.timeLog(rdr.GetString(0), rdr.GetDouble(1), rdr.GetDateTime(2)); project.inputs.Add(t); } } project.inputs = project.inputs.OrderBy(i => i.user).ToList(); ViewBag.Project = project.title; ViewBag.ID = project.id; return(View(project.inputs.ToList())); }