public User_Defaults(User User) { queries = new Queries2(); UserId = User.UserID; List <string> strs = queries.User_Defaults(UserId); TimesheetCode = queries.TimesheetCode(strs[0]); TaskType = strs[1]; Project = queries.Project(strs[2]); userDefault4 = strs[3]; userDefault5 = strs[4]; userDefault6 = strs[5]; userDefault7 = strs[6]; userDefault8 = strs[7]; userDefault9 = strs[8]; userDefault10 = strs[9]; userDefault11 = strs[10]; userDefault12 = strs[11]; userDefault13 = strs[12]; userDefault14 = strs[13]; userDefault15 = strs[14]; userDefault16 = strs[15]; userDefault17 = strs[16]; userDefault18 = strs[17]; userDefault19 = strs[18]; userDefault20 = strs[19]; }
private void LoadSelectedEntry() { cbxTimeCode.SelectedValue = new TimesheetCode(entry.timesheet_code).Code_Description; cbxTaskType.SelectedValue = (new TaskType(entry.task_type)).Id; if (!string.IsNullOrEmpty(entry.project_serial)) { cbxJob.SelectedValue = queries.Project(entry.project_serial).Serial_Customer_Machine; } cbxSection.SelectedValue = entry.number_section; dtpDate.SelectedDate = new DateTime?(entry.date); txtHours.Text = entry.hours.ToString(); txtDescription.Text = entry.description; }
private void cbxProjectNumber_SelectionChanged(object sender, SelectionChangedEventArgs e) { Project project = queries.Project(cbxProjectNumber.SelectedItem.ToString()); lblBFCReference.Content = project.Number_BFC; lblIsInWarranty.Content = project.IsWarrantyOpen; lblMAS90Reference.Content = project.Number_MAS90; lblProjectEquipment.Content = project.Machine; lblProjectName.Content = project.Customer; lblSAPReference.Content = project.Number_SAP; dgSections.DataContext = null; string[] tSectionsCNumberSection = new string[] { "SELECT ", queries.t_Sections_c_Number_Section, ", ", queries.t_Sections_c_Description_Section, ", ", queries.t_Sections_c_Number_Activity, ", ", queries.t_Sections_c_Description_Activity, " FROM ", queries.t_Sections, " WHERE ", queries.t_Sections_c_Number_Project_Network, "= '", queries.ProjectNumber_Network(cbxProjectNumber.SelectedItem.ToString()), "'" }; string str = string.Concat(tSectionsCNumberSection); MySqlCommand mySqlCommand = new MySqlCommand(str, myConnection.MySqlConnection); MySqlDataAdapter mySqlDataAdapter = new MySqlDataAdapter(mySqlCommand); DataSet dataSet = new DataSet(); mySqlDataAdapter.Fill(dataSet, "LoadDataBinding"); dgSections.DataContext = dataSet; }