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