private void goBack_Click(object sender, RoutedEventArgs e)
{
MySqlCommand clear_Fake = new MySqlCommand();
clear_Fake.Connection = globalConnection;
clear_Fake.CommandText = "DELETE FROM Students WHERE Name = 'FAKE';";
clear_Fake.ExecuteNonQuery();
MySqlCommand clear_FakeOT = new MySqlCommand();
clear_FakeOT.Connection = globalConnection;
clear_FakeOT.CommandText = "DELETE FROM OtherLiving WHERE Name = 'FAKE';";
clear_FakeOT.ExecuteNonQuery();
if (studentRoom.Content.ToString() != "")
{
Common_Functions.delete_FromRoom(globalConnection, studentRoom.Content.ToString());
}
if (otherLiving == 1)
{
MySqlCommand deleteotherID = new MySqlCommand();
deleteotherID.Connection = globalConnection;
deleteotherID.CommandText = "DELETE FROM OtherLivingID WHERE Id = '" + otherLivingID + "';";
deleteotherID.ExecuteNonQuery();
}
d();
}
private void RoomClear_Click(object sender, RoutedEventArgs e)
{
rSelect.Visibility = Visibility.Visible;
studentRoom.Visibility = System.Windows.Visibility.Hidden;
RoomClear.Visibility = System.Windows.Visibility.Hidden;
Common_Functions.delete_FromRoom(globalConnection, studentRoom.Content.ToString());
}
private void Page_Unloaded(object sender, RoutedEventArgs e)
{
if (studentRoom.Content != "")
{
Common_Functions.delete_FromRoom(globalConnection, studentRoom.Content.ToString());
deleteFakeOL();
deleteFakeST();
}
}
private void roomChange_Click(object sender, RoutedEventArgs e)
{
selectRoom.Visibility = Visibility.Visible;
roomChange.Visibility = Visibility.Hidden;
roomNumber.Visibility = Visibility.Hidden;
change.IsEnabled = false;
Close.IsEnabled = false;
evictionBT.IsEnabled = false;
evictTill.IsEnabled = false;
Common_Functions.delete_FromRoom(globalConnection, roomNumber.Content.ToString());
}
private void evict_Click(object sender, RoutedEventArgs e)
{
MySqlCommand evict = new MySqlCommand();
evict.Connection = globalConnection;
if (type == "S")
{
evict.CommandText = "UPDATE Students SET evicted = 1, EvictedTill = '" + ((DateTime)evictDate.SelectedDate).ToString("yyyy-MM-dd H:mm:ss") + "', Room = null WHERE Student_ID = '" + globalWindow.id.Text + "';";
}
else
{
evict.CommandText = "UPDATE OtherLiving SET evicted = 1, EvictedTill = '" + ((DateTime)evictDate.SelectedDate).ToString("yyyy-MM-dd H:mm:ss") + "', Room = null WHERE ID = '" + globalWindow.id.Text + "';";
}
evict.ExecuteNonQuery();
Common_Functions.delete_FromRoom(globalConnection, globalWindow.roomNumber.Content.ToString());
globalWindow.Close();
this.Close();
}
private void initionalTest()
{
Action action = () =>
{
bool f = true;
bool f2 = true;
MySqlCommand settings = new MySqlCommand();
settings.Connection = globalConnection;
settings.CommandText = "SELECT * FROM Settings";
settings.ExecuteNonQuery();
string outTimeMessage = "";
string sDateCheck = "";
string aDateCheck = "";
MySqlDataAdapter sDA = new MySqlDataAdapter(settings);
DataTable sDT = new DataTable();
sDA.Fill(sDT);
var mySData = sDT.Select();
outTimeMessage = mySData[0].ItemArray[3].ToString();
sDateCheck = mySData[0].ItemArray[4].ToString();
aDateCheck = mySData[0].ItemArray[5].ToString();
if (mySData[0].ItemArray[6].ToString() == "Не проверять")
{
f = false;
}
else
{
f = true;
if (mySData[0].ItemArray[6].ToString() != "При каждом запуске")
{
DateTime checkDate = DateTime.Now;
switch (mySData[0].ItemArray[6].ToString())
{
case "Раз в неделю": checkDate = DateTime.Now.AddDays(-7); break;
case "Раз в месяц": checkDate = DateTime.Now.AddMonths(-1); break;
default: break;
}
if (checkDate != DateTime.Now)
{
DateTime lastCheck = (DateTime)mySData[0].ItemArray[7];
if (lastCheck <= checkDate)
{
f2 = true;
}
else
{
f2 = false;
}
}
}
else
{
f2 = true;
}
}
if (f == true && f2 == true)
{
string message1 = "Есть проживающие, не оплатившие проживание";
string message2 = "Есть проживающие, у которых закончился период проживания";
string message3 = "";
string message4 = "";
bool fl1 = false;
bool fl2 = false;
string today = DateTime.Now.ToString("yyyy-MM-dd H:mm:ss");
archiveDelete(outTimeMessage);
message3 = dateCheck(aDateCheck, sDateCheck);
MySqlCommand search = new MySqlCommand();
search.Connection = globalConnection;
search.CommandText = "SELECT * FROM Students;";
search.ExecuteNonQuery();
MySqlDataAdapter da = new MySqlDataAdapter(search);
DataTable dt = new DataTable();
da.Fill(dt);
var myData = dt.Select();
for (int i = 0; i < myData.Length; i++)
{
if (myData[i].ItemArray[1].ToString() == "FAKE")
{
Common_Functions.delete_FromRoom(globalConnection, myData[i].ItemArray[7].ToString());
MySqlCommand deleteFake = new MySqlCommand();
deleteFake.Connection = globalConnection;
deleteFake.CommandText = "DELETE FROM Students WHERE Name = 'FAKE';";
deleteFake.ExecuteNonQuery();
deleteFake.CommandText = "DELETE FROM OtherLiving WHERE Name = 'FAKE';";
deleteFake.ExecuteNonQuery();
continue;
}
if (Convert.ToDateTime(myData[i].ItemArray[8]) < Convert.ToDateTime(today))
{
fl1 = true;
}
if (Convert.ToDateTime(myData[i].ItemArray[13]) < Convert.ToDateTime(today))
{
fl2 = true;
}
if (Convert.ToBoolean(myData[i].ItemArray[15]) == true)
{
if (Convert.ToDateTime(myData[i].ItemArray[16]) <= Convert.ToDateTime(today))
{
message4 = "Есть временно выселенные проживающие ожидающие заселения";
}
}
}
if (fl1 == false || fl2 == false || message4 == "")
{
search.CommandText = "SELECT * FROM OtherLiving;";
search.ExecuteNonQuery();
MySqlDataAdapter da1 = new MySqlDataAdapter(search);
DataTable dt1 = new DataTable();
da1.Fill(dt1);
var myData1 = dt1.Select();
for (int i = 0; i < myData1.Length; i++)
{
if (Convert.ToDateTime(myData1[i].ItemArray[6]) < Convert.ToDateTime(today))
{
fl1 = true;
}
if (Convert.ToDateTime(myData1[i].ItemArray[9]) < Convert.ToDateTime(today))
{
fl2 = true;
}
if (Convert.ToBoolean(myData1[i].ItemArray[13]) == true)
{
if (Convert.ToDateTime(myData1[i].ItemArray[14]) <= Convert.ToDateTime(today))
{
message4 = "Есть временно выселенные проживающие ожидающие заселения";
}
}
if (fl1 == true && fl2 == true && message4 != "")
{
break;
}
}
}
//message3 = evictedCheck();
if (fl1 == true && fl2 == false && message3 == "" && message4 == "")
{
testLabel1.Content = message1;
}
if (fl1 == true && fl2 == false && message3 == "" && message4 != "")
{
testLabel1.Content = message1;
testLabel2.Content = message4;
}
if (fl1 == false && fl2 == false && message3 != "" && message4 == "")
{
testLabel1.Content = message3;
}
if (fl1 == false && fl2 == false && message3 != "" && message4 != "")
{
testLabel1.Content = message3;
testLabel2.Content = message4;
}
if (fl1 == false && fl2 == true && message3 != "" && message4 == "")
{
testLabel1.Content = message2;
testLabel2.Content = message3;
}
if (fl1 == false && fl2 == true && message3 != "" && message4 != "")
{
testLabel1.Content = message2;
testLabel2.Content = message3;
testLabel3.Content = message4;
}
if (fl1 == true && fl2 == false && message3 != "" && message4 == "")
{
testLabel1.Content = message1;
testLabel2.Content = message3;
}
if (fl1 == true && fl2 == false && message3 != "" && message4 != "")
{
testLabel1.Content = message1;
testLabel2.Content = message3;
testLabel3.Content = message4;
}
if (fl1 == true && fl2 == true && message3 == "" && message4 == "")
{
testLabel1.Content = message1;
testLabel2.Content = message2;
}
if (fl1 == true && fl2 == true && message3 == "" && message4 != "")
{
testLabel1.Content = message1;
testLabel2.Content = message2;
testLabel3.Content = message4;
}
if (fl1 == true && fl2 == true && message3 != "" && message4 == "")
{
testLabel1.Content = message1;
testLabel2.Content = message2;
testLabel3.Content = message3;
}
if (fl1 == true && fl2 == true && message3 != "" && message4 != "")
{
testLabel1.Content = message1;
testLabel2.Content = message2;
testLabel3.Content = message3;
testLabel4.Content = message4;
}
if (fl1 == false && fl2 == true && message3 == "" && message4 == "")
{
testLabel1.Content = message2;
}
if (fl1 == false && fl2 == true && message3 == "" && message4 != "")
{
testLabel1.Content = message2;
testLabel2.Content = message4;
}
if (fl1 == false && fl2 == false && message3 == "" && message4 != "")
{
testLabel1.Content = message4;
}
if (fl1 == false && fl2 == false && message3 == "" && message4 == "")
{
testLabel1.Content = "Сообщений нет";
}
DateTime todayCheckDate = DateTime.Now;
string cDate = todayCheckDate.ToString("yyyy-MM-dd H:mm:ss");
MySqlCommand insertDate = new MySqlCommand();
insertDate.Connection = globalConnection;
insertDate.CommandText = "UPDATE Settings SET LastCheckDate = '" + cDate + "' WHERE ID = 1;";
insertDate.ExecuteNonQuery();
}
};
this.Dispatcher.Invoke(action);
}
