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