private void LoadConstantsFromDb()
{
cbxProject.DisplayMemberPath = "Serial_Customer_Machine";
cbxProject.SelectedValuePath = "Serial_Customer_Machine";
cbxTimesheetCode.DisplayMemberPath = "Code_Description";
cbxTimesheetCode.SelectedValuePath = "Code_Description";
foreach (TimesheetCode timesheetCode in queries.TimesheetCodeAll())
{
cbxTimesheetCode.Items.Add(timesheetCode);
}
foreach (string str in queries.TaskTypes())
{
cbxTaskType.Items.Add(str);
}
foreach (Project project in queries.ProjectAll())
{
cbxProject.Items.Add(project);
}
if (user_Defaults.TimesheetCode != null)
{
cbxTimesheetCode.SelectedValue = user_Defaults.TimesheetCode.Code_Description;
}
if (!string.IsNullOrEmpty(user_Defaults.TaskType))
{
cbxTaskType.SelectedValue = user_Defaults.TaskType;
}
if (user_Defaults.Project != null)
{
cbxProject.SelectedValue = user_Defaults.Project.Serial_Customer_Machine;
}
}
private void LoadConstantsFromDb()
{
cbxJob.DisplayMemberPath = "Serial_Customer_Machine";
cbxJob.SelectedValuePath = "Serial_Customer_Machine";
cbxTimeCode.DisplayMemberPath = "Code_Description";
cbxTimeCode.SelectedValuePath = "Code_Description";
cbxSection.DisplayMemberPath = "SectionNumber_SectionDescription";
cbxSection.SelectedValuePath = "SectionNumber_SectionDescription";
foreach (TimesheetCode timesheetCode in queries.TimesheetCodeAll())
{
cbxTimeCode.Items.Add(timesheetCode);
}
foreach (string str in queries.TaskTypes())
{
cbxTaskType.Items.Add(str);
}
foreach (Project project in queries.ProjectAll())
{
if ((functions.IntToBool(project.IsOpen) ? true : functions.IntToBool(project.IsWarrantyOpen)))
{
cbxJob.Items.Add(project);
}
}
sectionsAll = queries.Sections();
myConnection.Close();
}
public void RefreshListBox_TaskTypes()
{
unusedTaskTypes = allTaskTypes;
usedTaskTypes = new List <TaskType>();
if (lbxSections.SelectedItem != null)
{
Section selectedItem = lbxSections.SelectedItem as Section;
foreach (TaskType taskType in queries.TaskTypes(selectedItem))
{
usedTaskTypes.Add(taskType);
unusedTaskTypes = (
from X in unusedTaskTypes
where X.Id != taskType.Id
select X).ToList <TaskType>();
}
}
else
{
usedTaskTypes = null;
}
lbxSections_TaskTypes_ActNumber.ItemsSource = usedTaskTypes;
lbxSections_TaskTypes_Unused.ItemsSource = unusedTaskTypes;
}
private void LoadConstantsFromDB()
{
List <string> userDisplayOptions = new List <string>()
{
"Show Approvees",
"Show Active Users",
"Show All Users"
};
List <string> datePresetDisplayOptions = new List <string>()
{
"Use Custom Range",
"Today",
"Week To Date",
"Month To Date",
"Year To Date"
};
datePreset.ItemsSource = datePresetDisplayOptions;
datePreset.SelectedIndex = 0;
userSelect.ItemsSource = userDisplayOptions;
userSelect.SelectedIndex = 0;
LoadUsersRules();
availableTables = new List <string>()
{
"Not Submitted",
"Submitted, Not Approved",
"Approved",
"Archived"
};
table.ItemsSource = availableTables;
foreach (TimesheetCode timesheetCode in queries.TimesheetCodeAll())
{
timesheet_code.Items.Add(timesheetCode);
}
foreach (string str in queries.TaskTypes())
{
task_type.Items.Add(str);
}
foreach (Project project in queries.ProjectAll())
{
if (functions.IntToBool(project.IsOpen))
{
projectSelect.Items.Add(project.Number_Serial);
}
}
timesheet_code.DisplayMemberPath = "Code_Description";
timesheet_code.SelectedValuePath = "Code";
colNames = new List <string>();
foreach (PropertyInfo prop in typeof(Entry).GetProperties())
{
colNames.Add(prop.Name);
}
columns.ItemsSource = colNames;
}