void item_Click(object sender, RoutedEventArgs e) { selected_instructor = ((Instructor)((MenuItem)sender).Tag); SelectedInstructorLabel.Content = selected_instructor.ToString(); NameTextBox.Text = ((MenuItem)sender).Header.ToString(); }
public Group(String name, String description, timeperiod time, DateTime date, Instructor instructor, GymRoom room) { this.Name = name; this.Description = description; this.Time = time; this.Date = date; this.Instructor = instructor; this.Room = room; this.Clients = new List<Client>(); }
private bool CompareForAutoComplete(string input, Instructor instructor) { if (instructor.Name.ToLower().StartsWith(input.ToLower()) || instructor.LastName.ToLower().StartsWith(input.ToLower())) { return true; } else { return false; } }
private List<Group> LoadGroupsForInstructor(Instructor instructor) { List<Group> groups = new List<Group>(); using (DataSet ds = DataAccess.GetGroupsForInstructor(instructor, connection)) { int id; string name; string lastName; string description; timeperiod time; DateTime date; GymRoom room; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { room = new GymRoom(); id = ((int)ds.Tables[0].Rows[i]["Id"]); name = ds.Tables[0].Rows[i]["Name"].ToString(); description = ds.Tables[0].Rows[i]["Description"].ToString(); time = (timeperiod)ds.Tables[0].Rows[i]["TimePeriod"]; date = (DateTime)ds.Tables[0].Rows[i]["Date"]; using (DataSet roomds = DataAccess.GetRoom(ds.Tables[0].Rows[i]["RoomID"].ToString(), connection)) { for (int y = 0; y < roomds.Tables[0].Rows.Count; y++)//Should go over it only once { room.Id = ((int)roomds.Tables[0].Rows[y]["Id"]); room.Type = roomds.Tables[0].Rows[y]["Type"].ToString(); } } groups.Add(new Group(id, name, description, (timeperiod)time, date, instructor, room)); } foreach (Group item in groups) { using (DataSet data = DataAccess.GetClientsForTheGroup(item.Id, connection)) { for (int i = 0; i < data.Tables[0].Rows.Count; i++) { id = ((int)data.Tables[0].Rows[i]["Id"]); name = data.Tables[0].Rows[i]["Name"].ToString(); lastName = data.Tables[0].Rows[i]["LastName"].ToString(); item.Clients.Add(new Client(id, name, lastName)); } } } } return groups; }
private void InstructorList_SelectionChanged(object sender, SelectionChangedEventArgs e) { if (((ListView)sender).SelectedItem != null) { selected_instructor = ((Instructor)((ListView)sender).SelectedItem); SelectedInstructorLabel.Content = selected_instructor.ToString(); } }
private void LoadAllGroups() { using (DataSet ds = DataAccess.GetAllTableElements("Groups", connection))//We get all groups from DB { //temporary variables to store data before it is saved in Groups collection int id; string name; string lastName; string description; timeperiod time; DateTime date; Instructor instructor; GymRoom room; for (int i = 0; i < ds.Tables[0].Rows.Count; i++)//For all rows in resulting datatable { instructor = new Instructor();//Initialized here to avoid linked type weirdness room = new GymRoom();// id = ((int)ds.Tables[0].Rows[i]["Id"]);//Placing all the relevant data into temporary vars name = ds.Tables[0].Rows[i]["Name"].ToString(); description = ds.Tables[0].Rows[i]["Description"].ToString(); time = (timeperiod)ds.Tables[0].Rows[i]["TimePeriod"]; date = (DateTime)ds.Tables[0].Rows[i]["Date"]; using (DataSet secondary_ds = DataAccess.GetInstructor(ds.Tables[0].Rows[i]["InstructorID"].ToString(), connection)) {//Getting isntructor by ID, that we have in groups table, it will be only one in any case, thus no for cycle; instructor.Id = (int)secondary_ds.Tables[0].Rows[0]["Id"]; instructor.Name = secondary_ds.Tables[0].Rows[0]["Name"].ToString(); instructor.LastName = secondary_ds.Tables[0].Rows[0]["LastName"].ToString(); } using (DataSet secondary_ds = DataAccess.GetRoom(ds.Tables[0].Rows[i]["RoomID"].ToString(), connection)) {//Getting room by id, that we have in groups table, it will be only one in any case, thus no for cycle; room.Id = ((int)secondary_ds.Tables[0].Rows[0]["Id"]); room.Type = secondary_ds.Tables[0].Rows[0]["Type"].ToString(); } //adding new group to collection based on temp variables groups.Add(new Group(id, name, description, (timeperiod)time, date, instructor, room)); } foreach (Group item in groups) {//And basically in the same way we get all clients that are "subscribed" to this group using (DataSet data = DataAccess.GetClientsForTheGroup(item.Id, connection)) { for (int i = 0; i < data.Tables[0].Rows.Count; i++) { id = ((int)data.Tables[0].Rows[i]["Id"]); name = data.Tables[0].Rows[i]["Name"].ToString(); lastName = data.Tables[0].Rows[i]["LastName"].ToString(); item.Clients.Add(new Client(id, name, lastName)); } } } } }
private void LoadGroups() { groups.Clear(); String tablename = "Groups"; DataSet ds = DataAccess.GetAllTableElements(tablename, connection); int id; string name; string description; timeperiod time; DateTime date; Instructor instructor; GymRoom room; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { instructor = new Instructor(); room = new GymRoom(); id = ((int)ds.Tables[0].Rows[i]["Id"]); name = ds.Tables[0].Rows[i]["Name"].ToString(); description = ds.Tables[0].Rows[i]["Description"].ToString(); time = (timeperiod)ds.Tables[0].Rows[i]["TimePeriod"]; date = (DateTime)ds.Tables[0].Rows[i]["Date"]; using (DataSet secondary_ds = DataAccess.GetInstructor(ds.Tables[0].Rows[i]["InstructorID"].ToString(), connection)) { instructor.Id = (int)secondary_ds.Tables[0].Rows[0]["Id"]; instructor.Name = secondary_ds.Tables[0].Rows[0]["Name"].ToString(); instructor.LastName = secondary_ds.Tables[0].Rows[0]["LastName"].ToString(); } using (DataSet secondary_ds = DataAccess.GetRoom(ds.Tables[0].Rows[i]["RoomID"].ToString(), connection)) { room.Id = ((int)secondary_ds.Tables[0].Rows[0]["Id"]); room.Type = secondary_ds.Tables[0].Rows[0]["Type"].ToString(); } groups.Add(new Group(id, name, description, (timeperiod)time, date, instructor, room)); } }
private void AddButton_Click(object sender, RoutedEventArgs e) { Instructor instructor = new Instructor(NameTextBox.Text, LastNameTextBox.Text); DataAccess.CreateNewInstructor(connection, instructor); this.Close(); }
public static void DeleteInstructor(SqlConnection connection, Instructor instructor) { using (SqlCommand command = new SqlCommand("DeleteInstructor", connection)) { command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@targetId", instructor.Id); command.ExecuteNonQuery(); } }
public static void CreateNewInstructor(SqlConnection connection, Instructor instructor) { using (SqlCommand command = new SqlCommand("AddInstructor", connection)) { command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@name", instructor.Name); command.Parameters.AddWithValue("@lastname", instructor.LastName); command.ExecuteNonQuery(); } }
public static DataSet GetGroupsForInstructor(Instructor instructor, SqlConnection connection) { string query = "Select * from Groups where InstructorID =" + instructor.Id; using (DataSet ds = new DataSet()) { using (SqlCommand command = new SqlCommand(query, connection)) { SqlDataAdapter adapter = new SqlDataAdapter(command); adapter.Fill(ds); return ds; } } }