private async void DeleteTermBtn_Click(object sender, RoutedEventArgs e)
{
IParentWindow parent = ParentFinder.FindParent <AdminPanelWindow>(this);
MessageDialogResult r = await parent.ShowMessage("Warning",
"Are you sure you want to delete this term",
MessageDialogStyle.AffirmativeAndNegative);
if (r == MessageDialogResult.Negative)
{
return;
}
Button btn = (Button)sender;
ActiveTermModel model = new ActiveTermModel();
model = (ActiveTermModel)btn.Tag;
if (GlobalConfig.Connection.DeleteActiveTerm_ById(model.Id))
{
Terms.Remove(model);
WireUpLists();
// TODO - Delete the selected term
}
else
{
await parent.ShowMessage("Deletion Error",
"The selected term can't be deleted beacause it has an exam",
MessageDialogStyle.Affirmative);
// TODO - ADD a MessageBox
}
}
public void ActiveTermComplete(ActiveTermModel model)
{
Terms.Remove(model);
Terms.Add(model);
WireUpLists();
termsList.SelectedIndex = termsList.Items.Count - 1;
}
public CreateActiveTermWindow(IActiveTermRequester caller, ActiveTermModel model)
{
InitializeComponent();
CallingWindow = caller;
LoadListsData();
update = true;
createActiveTermBtn.Content = "Update";
titleText.Text = "Update The Active Term";
title.Title = "UPDATE ACTIVE TERM";
activeTerm = model;
// TODO Foreach'sız nasıl olurdu
foreach (var year in Years)
{
if (year.Id == activeTerm.Year.Id)
{
yearsCombobox.SelectedItem = year;
}
}
termsCombobox.SelectedItem = activeTerm.Term;
//
}
void GetCourse()
{
if (departmentsCombobox.SelectedItem == null || activeTermsCombobox.SelectedItem == null)
{
coursesCombobox.IsHitTestVisible = false;
}
else
{
DepartmentModel departmentModel = (DepartmentModel)departmentsCombobox.SelectedItem;
ActiveTermModel activeTermModel = (ActiveTermModel)activeTermsCombobox.SelectedItem;
Courses = GlobalConfig.Connection.GetCourse_ValidByDepartmentIdAndActiveTermId(departmentModel.Id, activeTermModel.Id);
if (update)
{
if (departmentModel.Id == assignmentModel.Department.Id && activeTermModel.Id == assignmentModel.ActiveTerm.Id)
{
Courses.Add(assignmentModel.Course);
}
}
coursesCombobox.ItemsSource = Courses;
if (!Courses.Any())
{
coursesCombobox.IsHitTestVisible = false;
}
else
{
coursesCombobox.IsHitTestVisible = true;
}
}
}
public void CreateActiveTerm(ActiveTermModel model)
{
using (IDbConnection connection = new SqlConnection(GlobalConfig.CnnString(databaseName)))
{
var p = new DynamicParameters();
p.Add("@Yearid", model.Year.Id);
p.Add("@TermId", model.Term.Id);
p.Add("@id", 0, dbType: DbType.Int32, direction: ParameterDirection.Output);
connection.Execute("dbo.spActiveTerms_Insert", p, commandType: CommandType.StoredProcedure);
model.Id = p.Get <int>("@id");
}
}
public void UpdateActiveTerms(ActiveTermModel model)
{
using (IDbConnection connection = new SqlConnection(GlobalConfig.CnnString(databaseName)))
{
var p = new DynamicParameters();
p.Add("@ActiveTermId", model.Id);
p.Add("@YearId", model.Year.Id);
p.Add("@TermId", model.Term.Id);
connection.Execute("dbo.spActiveTerms_UpdateByYearIdAndTermId", p, commandType: CommandType.StoredProcedure);
}
}
private void UpdateTermBtn_Click(object sender, RoutedEventArgs e)
{
Button btn = (Button)sender;
ActiveTermModel model = new ActiveTermModel();
model = (ActiveTermModel)btn.Tag;
// TODO - Update the selected term
CreateActiveTermWindow win = new CreateActiveTermWindow(this, model);
win.ShowDialog();
WireUpLists();
}
private void FilterAssignments()
{
if (departmentsCombobox.SelectedItem == null && activeTermsCombobox.SelectedItem == null)
{
WireUpLists(Assignments);
return;
}
if (departmentsCombobox.SelectedItem == null)
{
//filter by activeTerm
FilteredAssignments = new List <AssignmentModel>();
foreach (AssignmentModel model in Assignments)
{
ActiveTermModel a = (ActiveTermModel)activeTermsCombobox.SelectedItem;
if (model.ActiveTerm.Id == a.Id)
{
FilteredAssignments.Add(model);
}
}
WireUpLists(FilteredAssignments);
return;
}
if (activeTermsCombobox.SelectedItem == null)
{
//filter by department
FilteredAssignments = new List <AssignmentModel>();
foreach (AssignmentModel model in Assignments)
{
DepartmentModel d = (DepartmentModel)departmentsCombobox.SelectedItem;
if (model.Department.Id == d.Id)
{
FilteredAssignments.Add(model);
}
}
WireUpLists(FilteredAssignments);
return;
}
FilteredAssignments = new List <AssignmentModel>();
foreach (AssignmentModel model in Assignments)
{
DepartmentModel d = (DepartmentModel)departmentsCombobox.SelectedItem;
ActiveTermModel a = (ActiveTermModel)activeTermsCombobox.SelectedItem;
if (model.Department.Id == d.Id && model.ActiveTerm.Id == a.Id)
{
FilteredAssignments.Add(model);
}
}
WireUpLists(FilteredAssignments);
return;
}
