public wpfUpdateDesc()
{
InitializeComponent();
Sqlite = new clsSQLite();
Query = new SQLquery();
}
public wpfDescription()
{
InitializeComponent();
Sqlite = new clsSQLite();
Query = new SQLquery();
}
public wpfStudentEdit()
{
InitializeComponent();
Sqlite = new clsSQLite();
Query = new SQLquery();
}
public wpfMoreGroupDetail()
{
InitializeComponent();
Sqlite = new clsSQLite();
Query = new SQLquery();
dataTracker = new clsDataTracker();
}
public wpfDescDetail()
{
InitializeComponent();
Sqlite = new clsSQLite();
Query = new SQLquery();
dataTracker = new clsDataTracker();
dgDesc.ItemsSource = dataTracker.makeDescriptionList();
}
public wpfStudentDetail()
{
Sqlite = new clsSQLite();
Query = new SQLquery();
dataTracker = new clsDataTracker();
InitializeComponent();
dgStudentList.ItemsSource = dataTracker.makeStudentList();
}
public clsDataTracker()
{
Sqlite = new clsSQLite();
Query = new SQLquery();
descList = new List <DescriptionDetail>();
StudentList = new List <StudentDetail>();
groupList = new List <GroupDetail>();
sGroupList = new List <StudentGroupList>();
gpAList = new List <GroupAssignmentList>();
studentScore = new List <StudentScoreDetail>();
}
public wpfStudent()
{
InitializeComponent();
Sqlite = new clsSQLite();
Query = new SQLquery();
if (int.TryParse(Sqlite.ExecuteScalarSQL(Query.getMaxIndex()).ToString(), out int mId))
{
maxId = mId + 1;
}
tbSId.IsEnabled = false;
tbSId.Text = maxId.ToString();
}
public wpfGroupDetail()
{
InitializeComponent();
Sqlite = new clsSQLite();
Query = new SQLquery();
dataTracker = new clsDataTracker();
dgGroupList.ItemsSource = dataTracker.makeGroupList();
}
public wpfAddStudent()
{
Sqlite = new clsSQLite();
Query = new SQLquery();
dataTracker = new clsDataTracker();
InitializeComponent();
lblGroup.Content = groupName;
dgAllStudents.ItemsSource = dataTracker.makeStudentList();
dgStudentsInGroup.ItemsSource = dataTracker.getGroupStudents(groupID.ToString());
}
public wpfGroup()
{
Sqlite = new clsSQLite();
Query = new SQLquery();
dataTracker = new clsDataTracker();
InitializeComponent();
FocusManager.SetFocusedElement(this, txtGroupName);
dteDate.SelectedDate = DateTime.Today;
for (int i = 0; i < hours.Length; i++)
{
cboxHour.Items.Add(hours[i]);
}
for (int i = 0; i < minutes.Length; i++)
{
cboxMin.Items.Add(minutes[i]);
}
Application.Current.ShutdownMode = ShutdownMode.OnMainWindowClose;
}
public wpfDataSheet()
{
Sqlite = new clsSQLite();
Query = new SQLquery();
dataTracker = new clsDataTracker();
InitializeComponent();
Application.Current.ShutdownMode = ShutdownMode.OnMainWindowClose;
//dgDesc.ItemsSource = dataTracker.makeDescriptionList();
// dgLesson.ItemsSource = dataTracker.makeStudentList();
dataTracker.makeGroupList();
for (int i = 0; i < dataTracker.groupList.Count; i++)
{
comboxGroup.Items.Add(dataTracker.groupList[i].groupName);
}
}