private void Button_Click(object sender, RoutedEventArgs e) { OProject projectObj = new OProject(); SqlConnection conn = new SqlConnection(); try { //Create a connection to database conn.ConnectionString = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\lds21\Desktop\CapstoneProject-master\CapstoneProject-master\CapstoneProject\CapstoneProject\database\SmartPertDB.mdf; Integrated Security = True"; // Issue a command SqlCommand comm = new SqlCommand(); //comm.CommandText = "SELECT * FROM Projects"; comm.CommandText = "sprocProjectGetAll"; comm.CommandType = System.Data.CommandType.StoredProcedure; comm.Connection = conn; // Open the connection conn.Open(); // Execute command SqlDataReader dr = comm.ExecuteReader(); // Read Result Project newProject = new Project(); while (dr.Read()) { int id = (int)dr["ProjectId"]; string name = dr["Name"].ToString(); string description = dr["Description"].ToString(); double workingHours = (double)dr["WorkingHours"]; newProject.Id = id; newProject.Name = name; newProject.Description = description; newProject.WorkingHours = workingHours; ProjectDropDownMenu.Items.Add(newProject); } //tbxName.Text = newProject.Name; //tbxDescription.Text = newProject.Description; //tbxWorkingHours.Text = newProject.WorkingHours.ToString(); btnConnect.Content = "Connected!"; btnConnect.Visibility = Visibility.Hidden; } catch (Exception ex) { Console.WriteLine("Error occur in database"); } finally { // Close connection conn.Close(); } // Read Results }
private void ProjectDropDownMenu_SelectionChanged(object sender, SelectionChangedEventArgs e) { Project selectedProject = (Project)ProjectDropDownMenu.SelectedItem; OProject dal = new OProject(); Project displayProject = dal.getProject(selectedProject.Id); tbxName.Text = displayProject.Name; tbxDescription.Text = displayProject.Description; tbxWorkingHours.Text = displayProject.WorkingHours.ToString(); //dpStartDate.SelectedDate = displayProject.StartDate; }