private void AddfdEvent_Click(object sender, RoutedEventArgs e)
{
try
{
Account ACC = (Account)listViewAccounts.SelectedItems[0];
if (textBoxAccountLogin.Text == "" || textBoxAccountPassword.Text == "" || (textBoxAccountLogin.Text == "" && textBoxAccountPassword.Text == ""))
{
MessageBox.Show("Нужно заполнить все поля");
}
else
{
QueriesManager.Execute(Queries.NewAccount(textBoxAccountLogin.Text, textBoxAccountPassword.Text, ACC.ID));
SnackbarOne.IsActive = true;
listViewAccounts.ItemsSource = ALVM.LoadAccounts(Queries.GetAccounts);
textBoxAccountLogin.IsEnabled = false;
textBoxAccountPassword.IsEnabled = false;
buttonCreateAccount.IsEnabled = false;
buttonDeleteAccount.IsEnabled = true;
}
}
catch
{
MessageBox.Show("Нужно выбрать учителя");
}
}
private void Decline_Click(object sender, RoutedEventArgs e)
{
try
{
AdminMessageList AML = (AdminMessageList)listViewAdminMessageBox.SelectedItems[0];
QueriesManager.Execute(Queries.UpdateMessageStatus("Отклонено", AML.ID));
listViewAdminMessageBox.ItemsSource = AMLVM.LoadMAList(Queries.GetAdminMessageListSort(""));
}
catch
{
MessageBox.Show("Нужно выбрать заявку");
}
}
private void SendRequest_Click(object sender, RoutedEventArgs e)
{
if (cbRequestEvent.SelectedItem != null)
{
QueriesManager.Execute(Queries.AddMessage(GIVM.LoadID(Queries.GetTeacherID(2, sLogin), "id_teacher"),
GIVM.LoadID(Queries.GetEventID(cbRequestEvent.SelectedItem.ToString()), "id_event"), DateTime.Now));
listViewTeacherMessageBox.ItemsSource = AMLVM.LoadMAList(Queries.GetTeacherMessageList(sLogin, _iYear, _iSemestr));
Snackbar2.IsActive = true;
}
else
{
MessageBox.Show("Нужно выбрать мероприятие");
}
}
private void Button_Click_17(object sender, RoutedEventArgs e)
{
if (cbGrantCoinEvents.Text == "" || cbAddCoinType.Text == "" || (cbGrantCoinEvents.Text == "" && cbAddCoinType.Text == ""))
{
MessageBox.Show("Нужно заполнить все поля");
}
else
{
_idCoinType = DCT.CoinType(cbAddCoinType.Text);
_idEvent = GIVM.LoadID(Queries.GetEventID(cbGrantCoinEvents.Text), "id_event");
QueriesManager.Execute(Queries.AddCoin(_idEvent, _idTeacher, _idCoinType, textBoxCommentCoin.Text));
cbGrantCoinEvents.Items.Clear();
textBoxCommentCoin.Text = "";
stackPanelNewCoinPanel.Visibility = Visibility.Hidden;
colorZoneNewNight.Visibility = Visibility.Hidden;
stackPanelNewCoinPanel.Visibility = Visibility.Hidden;
cbAddCoinType.Items.Clear();
}
}
private void Button_Click_4(object sender, RoutedEventArgs e)
{
if (cbEvents.Text == "" || cbTypeOfCoin.Text == "" || (cbEvents.Text == "" && cbTypeOfCoin.Text == ""))
{
MessageBox.Show("Нужно заполнить все поля");
}
else
{
_idCoinType = DCT.CoinType(cbTypeOfCoin.Text);
_idEvent = GIVM.LoadID(Queries.GetEventID(cbEvents.Text), "id_event");
QueriesManager.Execute(Queries.AddCoin(_idEvent, _idTeacher, _idCoinType, textBoxComment.Text));
listViewCoinsList.ItemsSource = CLVM.LoadCoinsList(Queries.GetCoinsList(textBlockTeachersName.Text, _iYear, _iSemestr));
listViewRating.ItemsSource = RWM.LoadRating(Queries.GetRatingTotal(_iYear, _iSemestr));
gridCoinsImg.DataContext = CCVM.LoadCoinsCount(Queries.GetCoinsCount(textBlockTeachersName.Text, _iYear, _iSemestr));
cbEvents.Items.Clear();
textBoxComment.Text = "";
stackPanelNewCoin.Visibility = Visibility.Hidden;
}
}
private void Button_Click_8(object sender, RoutedEventArgs e)
{
if (datePickerCalendar.SelectedDate != null)
{
if (cbEventType.SelectedItem != null)
{
if (textBoxEventCaption.Text == "" || textBoxEventPlace.Text == "" || (textBoxEventCaption.Text == "" && textBoxEventPlace.Text == ""))
{
MessageBox.Show("Нужно указать данные о мероприятии");
}
else
{
if (_bIsNewEvent == true)
{
QueriesManager.Execute(Queries.AddEvent(textBoxEventCaption.Text, textBoxEventPlace.Text, textBoxEventDescription.Text,
GIVM.LoadID(Queries.GetEventTypeID(cbEventType.SelectedItem.ToString()), "id"), datePickerCalendar.SelectedDate.Value));
}
else
{
Events EvE = (Events)listViewEvents.SelectedItems[0];
QueriesManager.Execute(Queries.UpdateEvent(textBoxEventCaption.Text, textBoxEventPlace.Text, textBoxEventDescription.Text,
GIVM.LoadID(Queries.GetEventTypeID(cbEventType.SelectedItem.ToString()), "id"), datePickerCalendar.SelectedDate.Value,
GIVM.LoadID(Queries.GetEventID(EvE.Caption), "id_event")));
}
gridNewEvent.Visibility = Visibility.Hidden;
textBoxEventCaption.Text = "";
textBoxEventPlace.Text = "";
cbEventType.SelectedItem = null;
listViewEvents.ItemsSource = EVM.LoadEvents(Queries.GetEventsList(_iYear, _iSemestr));
textBlockEventInfo.Text = textBoxEventDescription.Text;
textBoxEventDescription.Text = "";
}
}
else
{
MessageBox.Show("Нужно указать тип мероприятия");
}
}
else
{
MessageBox.Show("Нужно указать дату мероприятия");
}
}
private void Button_Click_2(object sender, RoutedEventArgs e)
{
if (listViewCoinsList.SelectedItems.Count >= 1)
{
CoinsList CoL = (CoinsList)listViewCoinsList.SelectedItems[0];
MessageBoxResult Result = MessageBox.Show("Удалить коин?", "Удалить", MessageBoxButton.YesNo);
if (Result == MessageBoxResult.Yes)
{
QueriesManager.Execute(Queries.DeleteCoin(CoL.IDCoin));
listViewCoinsList.ItemsSource = CLVM.LoadCoinsList(Queries.GetCoinsList(textBlockTeachersName.Text, _iYear, _iSemestr));
listViewRating.ItemsSource = RWM.LoadRating(Queries.GetRatingTotal(_iYear, _iSemestr));
gridCoinsImg.DataContext = CCVM.LoadCoinsCount(Queries.GetCoinsCount(textBlockTeachersName.Text, _iYear, _iSemestr));
}
}
else
{
MessageBox.Show("Сначала нужно выбрать, что удалять");
}
}
private void AddTeacherButton_Click(object sender, RoutedEventArgs e)
{
try
{
if (imageTeachersPortrait.Source != null)
{
if (_bIsNewTeacher == true)
{
IIVM.InsertImage(sFilePath);
QueriesManager.Execute(Queries.AddTeacher(textBoxTeachersFio.Text, textBoxTeachersSpeciality.Text,
textBoxTeachersInfo.Text, LIIVM.LastImageID()));
imageTeachersCardPhoto.Source = null;
textBlockTeachersCardName.Text = "";
textBlockTeachersCardInfo.DataContext = null;
textBlockTeachersCardSpeciality.DataContext = null;
}
else
{
IIVM.InsertImage(sFilePath);
QueriesManager.Execute(Queries.UpdateTeacher(textBoxTeachersFio.Text, textBoxTeachersSpeciality.Text,
textBoxTeachersInfo.Text, LIIVM.LastImageID(), _idTeacher));
textBlockTeachersCardName.Text = textBoxTeachersFio.Text;
textBlockTeachersCardSpeciality.DataContext = TCVM.LoadTeacherCard(Queries.GetTeacherCard(textBoxTeachersFio.Text));
textBlockTeachersCardInfo.DataContext = TCVM.LoadTeacherCard(Queries.GetTeacherCard(textBoxTeachersFio.Text));
imageTeachersCardPhoto.Source = TPVM.LoadTeacherPhoto(Queries.GetTeacherPhoto(textBoxTeachersFio.Text));
}
listViewTeachers.ItemsSource = TLVM.LoadTeachersList(Queries.GetTeachersList);
gridTeacherPage.Visibility = Visibility.Hidden;
colorZoneTeacherPage.Visibility = Visibility.Hidden;
stackPanelTeacherPanel.Visibility = Visibility.Hidden;
}
else
{
MessageBox.Show("Нужно выбрать фото");
}
}
catch
{
MessageBox.Show("Нужно выбрать/обновить фото (при обновлении можно выбрать то же самое)");
}
}
private void Button_Click_13(object sender, RoutedEventArgs e)
{
if (cbAcceptRequestCoinType.Text == "")
{
MessageBox.Show("Нужно заполнить все поля");
}
else
{
_idCoinType = DCT.CoinType(cbAddCoinType.Text);
AdminMessageList AML = (AdminMessageList)listViewAdminMessageBox.SelectedItems[0];
_idEvent = GIVM.LoadID(Queries.GetEventID(textBlockAcceptRequestEvent.Text), "id_event");
_idTeacher = GIVM.LoadID(Queries.GetTeacherID(1, sTeacher), "id_teacher");
QueriesManager.Execute(Queries.AddCoin(_idEvent, _idTeacher, _idCoinType, textBoxAcceptRequestComment.Text));
textBoxAcceptRequestComment.Text = "";
QueriesManager.Execute(Queries.UpdateMessageStatus("Принято", AML.ID));
listViewAdminMessageBox.ItemsSource = AMLVM.LoadMAList(Queries.GetAdminMessageListSort(""));
colorZoneTeacherPage.Visibility = Visibility.Hidden;
gridResponce.Visibility = Visibility.Hidden;
listViewRating.ItemsSource = RWM.LoadRating(Queries.GetRatingTotal(_iYear, _iSemestr));
}
}
private void buttonDeleteTeacher_Click(object sender, RoutedEventArgs e)
{
if (listViewTeachers.SelectedItems.Count >= 1)
{
MessageBoxResult result = MessageBox.Show("Удалить учителя?", "Удалить", MessageBoxButton.YesNo);
if (result == MessageBoxResult.Yes)
{
QueriesManager.Execute(Queries.DeleteTeacher(_idTeacher));
listViewTeachers.ItemsSource = TLVM.LoadTeachersList(Queries.GetTeachersList);
imageTeachersCardPhoto.Source = null;
textBlockTeachersCardName.Text = "";
textBlockTeachersCardInfo.DataContext = null;
textBlockTeachersCardSpeciality.DataContext = null;
}
}
else
{
MessageBox.Show("Сначала нужно выбрать, что удалять");
}
}
private void DeleteEvent_Click(object sender, RoutedEventArgs e)
{
MessageBoxResult Result = MessageBox.Show("Удалить мероприятие? Все коины, связанные с ним, исчезнут", "Удалить",
MessageBoxButton.YesNo);
if (Result == MessageBoxResult.Yes)
{
Events EvE = (Events)listViewEvents.SelectedItems[0];
QueriesManager.Execute(Queries.DeleteEvent(GIVM.LoadID(Queries.GetEventID(EvE.Caption), "id_event")));
listViewEvents.ItemsSource = EVM.LoadEvents(Queries.GetEventsList(_iYear, _iSemestr));
textBlockEventInfo.DataContext = null;
}
else
{
}
cbEventsPlaces.Items.Clear();
cbEventsPlaces.Items.Add("Все");
foreach (string Item in cESBTVM.LoadTypes(Queries.GetCB_EventPlaces, "event_place"))
{
cbEventsPlaces.Items.Add(Item);
}
}
private void DeleteAccount_Click(object sender, RoutedEventArgs e)
{
try
{
MessageBoxResult result = MessageBox.Show("Удалить аккаунт?", "Удалить", MessageBoxButton.YesNo);
if (result == MessageBoxResult.Yes)
{
QueriesManager.Execute(Queries.DeleteAccount(textBoxAccountLogin.Text, textBoxAccountLogin.Text));
SnackbarOne.IsActive = true;
listViewAccounts.ItemsSource = ALVM.LoadAccounts(Queries.GetAccounts);
textBoxAccountLogin.Text = "";
textBoxAccountPassword.Text = "";
textBoxAccountLogin.IsEnabled = true;
textBoxAccountPassword.IsEnabled = true;
buttonCreateAccount.IsEnabled = true;
buttonDeleteAccount.IsEnabled = false;
}
else
{
}
}
catch { }
}
