public JsonResult Put(TasksSkills ts) { string query = @" update dbo.Tasks set AssignedToPersonID='" + ts.PersonID + @"' where Task='" + ts.Task + @"' "; DataTable table = new DataTable(); string sqlDataSource = _configuration.GetConnectionString("LUCapstoneDB"); SqlDataReader myReader; using (SqlConnection myCon = new SqlConnection(sqlDataSource)) { myCon.Open(); using (SqlCommand myCommand = new SqlCommand(query, myCon)) { myReader = myCommand.ExecuteReader(); table.Load(myReader);; myReader.Close(); myCon.Close(); } } return(new JsonResult("Updated Successfully")); }
public JsonResult Post(TasksSkills ts) { string query = @" insert into dbo.TasksSkills values ( '" + ts.TaskID + @"' ,'" + ts.SkillID + @"' ) "; DataTable table = new DataTable(); string sqlDataSource = _configuration.GetConnectionString("LUCapstoneDB"); SqlDataReader myReader; using (SqlConnection myCon = new SqlConnection(sqlDataSource)) { myCon.Open(); using (SqlCommand myCommand = new SqlCommand(query, myCon)) { myReader = myCommand.ExecuteReader(); table.Load(myReader);; myReader.Close(); myCon.Close(); } } return(new JsonResult("Added Successfully")); }