private void RefreshList()
{
MySqlConnection connection = new MySqlConnection(connectionString);
//Думаю, что не очень хорошо, когда в списке пользователей виден пароль!!! /* employees.Password, */
string query_text = getQueryText();
connection.Open();
DataTable dataTable = new DataTable();
MySqlCommand command = new MySqlCommand(query_text, connection);
MySqlDataAdapter adapter = new MySqlDataAdapter(command);
adapter.Fill(dataTable);
productsGrid.ItemsSource = dataTable.DefaultView;
connection.Close();
productsGrid.SelectedIndex = 0;
//Код алёши еблоши
List <int> ids = new List <int>();
foreach (DataRowView row in productsGrid.SelectedItems)
{
ids.Add((int)row.Row.ItemArray[0]);
}
if (ids.Count == 0)
{
ButtonDelete.Style = (Style)ButtonDelete.FindResource("NoActive");
ButtonEdit.Style = (Style)ButtonEdit.FindResource("NoActive");
ButtonOpenList.Style = (Style)ButtonOpenList.FindResource("NoActive");
}
}
private void RefreshList()
{
MySqlConnection connection = new MySqlConnection(connectionString);
string query_text = getQueryText();
connection.Open();
DataTable dataTable = new DataTable();
MySqlCommand command = new MySqlCommand(query_text, connection);
MySqlDataAdapter adapter = new MySqlDataAdapter(command);
adapter.Fill(dataTable);
productsGrid.ItemsSource = dataTable.DefaultView;
connection.Close();
List <int> ids = new List <int>();
foreach (DataRowView row in productsGrid.SelectedItems)
{
ids.Add((int)row.Row.ItemArray[0]);
}
if (ids.Count == 0)
{
ButtonEdit.Style = (Style)ButtonEdit.FindResource("NoActive");
ButtonDelete.Style = (Style)ButtonDelete.FindResource("NoActive");
}
}
private void RefreshList()
{
MySqlConnection connection = new MySqlConnection(connectionString);
string query_text = getQueryText();
connection.Open();
DataTable dataTable = new DataTable();
MySqlCommand command = new MySqlCommand(query_text, connection);
MySqlDataAdapter adapter = new MySqlDataAdapter(command);
adapter.Fill(dataTable);
fittingsGrid.ItemsSource = dataTable.DefaultView;
connection.Close();
fittingsGrid.SelectedIndex = 0;
List <HelpStruct> ids = new List <HelpStruct>();
foreach (DataRowView row in fittingsGrid.SelectedItems)
{
ids.Add(new HelpStruct {
customerNickname = row.Row.ItemArray[0].ToString(), idOrder = int.Parse(row.Row.ItemArray[1].ToString())
});
}
if (ids.Count == 0)
{
ButtonEdit.Style = (Style)ButtonEdit.FindResource("NoActive");
ButtonDelete.Style = (Style)ButtonDelete.FindResource("NoActive");
}
}
void ReleaseDesignerOutlets()
{
if (ButtonDelete != null)
{
ButtonDelete.Dispose();
ButtonDelete = null;
}
if (DeleteButtonZoneForTouch != null)
{
DeleteButtonZoneForTouch.Dispose();
DeleteButtonZoneForTouch = null;
}
if (DetailLabel != null)
{
DetailLabel.Dispose();
DetailLabel = null;
}
if (PictureView != null)
{
PictureView.Dispose();
PictureView = null;
}
if (TitleNameLabel != null)
{
TitleNameLabel.Dispose();
TitleNameLabel = null;
}
}
private void DataGridCell_LostFocus(object sender, RoutedEventArgs e)
{
// Если ничего не выделено, то стиль заблокированной кнопки
if (materialsGrid.SelectedItems.Count == 0)
{
ButtonEdit.Style = (Style)ButtonEdit.FindResource("NoActive");
ButtonDelete.Style = (Style)ButtonDelete.FindResource("NoActive");
}
}
private void RefreshList()
{
var dataTable = Customer.getListCustomers(connection);
customersGrid.ItemsSource = dataTable.DefaultView;
// Если ничего не выделено, то стиль заблокированной кнопки
if (customersGrid.SelectedItems.Count == 0)
{
ButtonEdit.Style = (Style)ButtonEdit.FindResource("NoActive");
ButtonDelete.Style = (Style)ButtonDelete.FindResource("NoActive");
}
}
public CodingMathRequest()
{
ConsoleTextBox.AddColor1();
HowSaveFile.AddColor1();
OpenFile.AddColor1();
ButtonCopy.AddColor1();
ButtonPaste.AddColor1();
ButtonDelete.AddColor1();
ButtonEnter.AddColor1();
SaveFile.AddColor1();
CloseFile.AddColor1();
ButtonDelete.Click += new EventHandler(delegate(object sender, EventArgs e){ TextArea.Clear(); });
ButtonCopy.Click += new EventHandler(Copy);
ButtonPaste.Click += new EventHandler(Paste);
ButtonEnter.Click += new EventHandler(StartScript);
Console.SuspendLayout();
TBLayout.SuspendLayout();
Console.ResumeLayout(false);
Console.PerformLayout();
TBLayout.ResumeLayout(false);
// CodingMathRequest
Controls.Add(Console);
Controls.Add(TBLayout);
Controls.Add(TextArea);
Name = "CodingMathRequest";
OpenFile.Click += new EventHandler(OpenFiles);
SaveFile.Click += new EventHandler(SaveFiles);
CloseFile.Click += new EventHandler(CloseFiles);
HowSaveFile.Click += new EventHandler(HowSaveFiles);
TextArea.DragEnter += new DragEventHandler(DragEnterFile);
TextArea.DragDrop += new DragEventHandler(DragDropFile);
ConsoleTitle.DoubleClick += new EventHandler(OpenConsole);
// Console
Console.Controls.Add(ConsoleTextBox);
Console.Controls.Add(ConsoleTitle);
Console.Dock = DockStyle.Bottom;
Console.Location = new Point(0, 479);
Console.Margin = new Padding(0);
Console.MaximumSize = new Size(487, 250);
Console.MinimumSize = new Size(487, 44);
Console.Name = "Console";
Console.Size = new Size(487, 44);
Console.TabIndex = 0;
TBLayout.Controls.AddRange(new Control[] {
OpenFile, SaveFile, HowSaveFile, CloseFile, ButtonPaste, ButtonCopy, ButtonDelete, ButtonEnter
});
}
private void DataGridCell_LostFocus(object sender, RoutedEventArgs e)
{
List <int> ids = new List <int>();
foreach (DataRowView row in productsGrid.SelectedItems)
{
ids.Add((int)row.Row.ItemArray[0]);
}
if (ids.Count == 0)
{
ButtonEdit.Style = (Style)ButtonEdit.FindResource("NoActive");
ButtonDelete.Style = (Style)ButtonDelete.FindResource("NoActive");
}
}
private void DataGridCell_LostFocus(object sender, RoutedEventArgs e)
{
List <HelpStruct> ids = new List <HelpStruct>();
foreach (DataRowView row in payrollsGrid.SelectedItems)
{
ids.Add(new HelpStruct {
login = row.Row.ItemArray[0].ToString(), period = row.Row.ItemArray[1].ToString()
});
}
if (ids.Count == 0)
{
ButtonEdit.Style = (Style)ButtonEdit.FindResource("NoActive");
ButtonDelete.Style = (Style)ButtonDelete.FindResource("NoActive");
}
}
private void DataGridCell_LostFocus(object sender, RoutedEventArgs e)
{
List <HelpStruct> ids = new List <HelpStruct>();
foreach (DataRowView row in fittingsGrid.SelectedItems)
{
ids.Add(new HelpStruct {
customerNickname = row.Row.ItemArray[0].ToString(), idOrder = int.Parse(row.Row.ItemArray[1].ToString())
});
}
if (ids.Count == 0)
{
ButtonEdit.Style = (Style)ButtonEdit.FindResource("NoActive");
ButtonDelete.Style = (Style)ButtonDelete.FindResource("NoActive");
}
}
private void LoadApplications(object sender, EventArgs e)
{
foreach (Button i in applicationButtons)
{
i.Show();
}
sort[0].Show();
sort[1].Show();
ApplicationTextBox.Clear();
ApplicationTextBox.Hide();
ButtonApproved.Hide();
ButtonMeeting.Hide();
ButtonNotApproved.Hide();
ButtonReturn.Hide();
ButtonDelete.Hide();
}
// Update is called once per frame
void Update()
{
if (Input.GetMouseButtonDown(0))
{
Ray ray = Camera.main.ScreenPointToRay(Input.mousePosition);
RaycastHit rayCastHit;
if (Physics.Raycast(ray.origin, ray.direction, out rayCastHit, Mathf.Infinity))
{
ButtonDelete del = rayCastHit.transform.GetComponent <ButtonDelete>();
if (del)
{
Debug.Log("should be backspace 1");
box.morgueAnswer = box.morgueAnswer.Remove(box.morgueAnswer.Length - 1);
Debug.Log(box.MorgueAnswer());
}
}
}
}
public ConverterDigits()
{
TBLayout.SuspendLayout();
Controls.Add(TBLayout);
Controls.Add(TextArea);
Controls.Add(TextLine);
Name = "ConverterDigits";
Button7.AddColor1(); Button7.Click += new EventHandler(InsertText);
Button8.AddColor1(); Button8.Click += new EventHandler(InsertText);
Button9.AddColor1(); Button9.Click += new EventHandler(InsertText);
ButtonBackspace.AddColor1(); ButtonBackspace.Click += new EventHandler(Backspace);
ButtonC.AddColor1(); ButtonC.Click += new EventHandler(InsertText);
ButtonD.AddColor1(); ButtonD.Click += new EventHandler(InsertText);
ButtonDelete.AddColor1(); ButtonDelete.Click += new EventHandler(Delete);
ButtonEnter.AddColor1(); ButtonEnter.Click += new EventHandler(GetAnswer);
ButtonI.AddColor1(); ButtonI.Click += new EventHandler(InsertText);
ButtonL.AddColor1(); ButtonL.Click += new EventHandler(InsertText);
ButtonM.AddColor1(); ButtonM.Click += new EventHandler(InsertText);
ButtonV.AddColor1(); ButtonV.Click += new EventHandler(InsertText);
ButtonX.AddColor1(); ButtonX.Click += new EventHandler(InsertText);
Button0.AddColor1(); Button0.Click += new EventHandler(InsertText);
Button1.AddColor1(); Button1.Click += new EventHandler(InsertText);
Button2.AddColor1(); Button2.Click += new EventHandler(InsertText);
Button3.AddColor1(); Button3.Click += new EventHandler(InsertText);
Button4.AddColor1(); Button4.Click += new EventHandler(InsertText);
Button5.AddColor1(); Button5.Click += new EventHandler(InsertText);
Button6.AddColor1(); Button6.Click += new EventHandler(InsertText);
TextArea.AddColor1();
TextLine.AddColor1();
TBLayout.Controls.AddRange(new Control[] {
Button7, Button8, Button9, ButtonD, ButtonEnter,
Button4, Button5, Button6, ButtonC, ButtonBackspace,
Button1, Button2, Button3, ButtonL, ButtonDelete,
Button0, ButtonI, ButtonV, ButtonX, ButtonM
});
ResumeLayout(false);
PerformLayout();
TBLayout.ResumeLayout(false);
}
void ReleaseDesignerOutlets()
{
if (ImagePuzzle != null)
{
ImagePuzzle.Dispose();
ImagePuzzle = null;
}
if (ButtonDelete != null)
{
ButtonDelete.Dispose();
ButtonDelete = null;
}
if (LabelPlayer1Time != null)
{
LabelPlayer1Time.Dispose();
LabelPlayer1Time = null;
}
if (LabelPlayer2Time != null)
{
LabelPlayer2Time.Dispose();
LabelPlayer2Time = null;
}
if (ImagePlayer1 != null)
{
ImagePlayer1.Dispose();
ImagePlayer1 = null;
}
if (ImagePlayer2 != null)
{
ImagePlayer2.Dispose();
ImagePlayer2 = null;
}
}
public void SetupPastResultsViewCell(string shooterName, int totalHit, string date, bool hasRound)
{
if (StackView == null)
{
StackView = new UIStackView(new CGRect(0f, 0f, this.Frame.Width, this.Frame.Height));
}
StackView.Alignment = UIStackViewAlignment.Center;
StackView.Axis = UILayoutConstraintAxis.Horizontal;
StackView.Distribution = UIStackViewDistribution.FillEqually;
StackView.Spacing = 10;
if (LabelName == null)
{
LabelName = new UILabel(new CGRect(0f, 10f, this.Frame.Width, 18f));
}
LabelName.Text = shooterName;
LabelName.TextAlignment = UITextAlignment.Left;
LabelName.TextColor = ColorConstants.TextColor;
LabelName.Lines = 1;
LabelName.LineBreakMode = UILineBreakMode.Clip;
LabelName.AdjustsFontSizeToFitWidth = true;
if (ButtonClays == null)
{
ButtonClays = new UIButton(new CGRect(0f, 0f, this.Frame.Width, 50f));
}
ButtonClays.ImageEdgeInsets = new UIEdgeInsets(0, 0, 0, 0);
ButtonClays.ContentEdgeInsets = new UIEdgeInsets(0, 0, 0, 0);
ButtonClays.BackgroundColor = ColorConstants.BackgroundColor;
ButtonClays.SetImage(UIImage.FromBundle("HitClay"), UIControlState.Disabled);
ButtonClays.ContentMode = UIViewContentMode.ScaleAspectFit;
ButtonClays.SetTitle($"x {totalHit}", UIControlState.Normal);
ButtonClays.SetTitleColor(ColorConstants.PrimaryColor, UIControlState.Disabled);
ButtonClays.Enabled = false;
if (ButtonRound == null)
{
ButtonRound = new UIButton(new CGRect(this.Frame.Width + 10, 0f, 120f, this.Frame.Height));
}
ButtonRound.ImageEdgeInsets = new UIEdgeInsets(0, 0, 0, 0);
ButtonRound.ContentEdgeInsets = new UIEdgeInsets(0, 0, 0, 0);
ButtonRound.BackgroundColor = ColorConstants.GreenColor;
ButtonRound.SetTitle("View Round", UIControlState.Normal);
ButtonRound.SetTitleColor(ColorConstants.BackgroundColor, UIControlState.Normal);
ButtonRound.TouchUpInside += ButtonViewRound_Clicked;
if (ButtonDelete == null)
{
ButtonDelete = new UIButton();
}
ButtonDelete.Frame = new CGRect(this.Frame.Width + (hasRound ? 140 : 10), 0f, 120f, this.Frame.Height);
ButtonDelete.ImageEdgeInsets = new UIEdgeInsets(0, 0, 0, 0);
ButtonDelete.ContentEdgeInsets = new UIEdgeInsets(0, 0, 0, 0);
ButtonDelete.BackgroundColor = ColorConstants.RedColor;
ButtonDelete.SetTitle("Delete", UIControlState.Normal);
ButtonDelete.SetTitleColor(ColorConstants.BackgroundColor, UIControlState.Normal);
ButtonDelete.TouchUpInside += ButtonDelete_TouchUpInside;
if (LabelDate == null)
{
LabelDate = new UILabel(new CGRect(0f, 10f, this.Frame.Width, 18f));
}
LabelDate.Text = date;
LabelDate.TextAlignment = UITextAlignment.Right;
LabelDate.TextColor = ColorConstants.TextColor;
LabelDate.Lines = 1;
LabelDate.LineBreakMode = UILineBreakMode.Clip;
LabelDate.AdjustsFontSizeToFitWidth = true;
StackView.AddArrangedSubview(LabelName);
StackView.AddArrangedSubview(ButtonClays);
StackView.AddArrangedSubview(LabelDate);
if (ScrollView == null)
{
ScrollView = new UIScrollView(new CGRect(0f, 0f, this.Frame.Width, this.Frame.Height));
}
ScrollView.ShowsHorizontalScrollIndicator = false;
ScrollView.ContentSize = new CGSize(this.Frame.Width + (hasRound ? 260f : 130f), this.Frame.Height);
ScrollView.SetContentOffset(new CGPoint(0f, 0f), false);
ScrollView.AddSubview(StackView);
if (hasRound)
{
ScrollView.AddSubview(ButtonRound);
}
ScrollView.AddSubview(ButtonDelete);
this.ContentView.AddSubview(ScrollView);
}
public void ClickOnDeleteButton()
{
ButtonDelete.Click();
}
private void DataGridCell_GotFocus(object sender, RoutedEventArgs e)
{
ButtonDelete.Style = (Style)ButtonDelete.FindResource("Active");
ButtonEdit.Style = (Style)ButtonEdit.FindResource("Active");
ButtonOpenList.Style = (Style)ButtonOpenList.FindResource("Active");
}
private void DataGridCell_GotFocus(object sender, RoutedEventArgs e)
{
ButtonDelete.Style = (System.Windows.Style)ButtonDelete.FindResource("Active");
ButtonEdit.Style = (System.Windows.Style)ButtonEdit.FindResource("Active");
ButtonListProducts.Style = (System.Windows.Style)ButtonListProducts.FindResource("Active");
}
private void loadApplication(object sender, EventArgs e)
{
Button a = (Button)sender;
BD bd = new BD();
DataTable table = new DataTable();
MySqlDataAdapter adapter = new MySqlDataAdapter();
MySqlCommand command = new MySqlCommand(getEverythingFromBD, bd.getConnection());
command.Parameters.Add("@nm", MySqlDbType.VarChar).Value = a.Tag;
bd.openBD();
MySqlDataReader reader = command.ExecuteReader();
id = Convert.ToInt32(a.Tag);
while (reader.Read())
{
dataFromBD[0] = Convert.ToString(reader.GetInt32(0));
dataFromBD[1] = Convert.ToString(reader.GetString(1));
dataFromBD[2] = Convert.ToString(reader.GetString(2));
dataFromBD[3] = Convert.ToString(reader.GetString(3));
dataFromBD[4] = Convert.ToString(reader.GetString(4));
dataFromBD[5] = Convert.ToString(reader.GetString(5));
dataFromBD[6] = Convert.ToString(reader.GetString(6));
dataFromBD[7] = Convert.ToString(reader.GetString(7));
dataFromBD[8] = Convert.ToString(reader.GetString(8));
dataFromBD[9] = Convert.ToString(reader.GetString(9));
dataFromBD[10] = Convert.ToString(reader.GetDateTime(10));
dataFromBD[11] = Convert.ToString(reader.GetString(11));
}
reader.Close();
bd.closeBD();
foreach (Button i in applicationButtons)
{
i.Hide();
}
sort[0].Hide();
sort[1].Hide();
ButtonApproved.Show();
ButtonMeeting.Show();
ButtonNotApproved.Show();
ButtonReturn.Show();
ButtonDelete.Show();
//Тут тоже костыль, можно вместо потехи с 6 строками, сделать цикл, пробегающийся по двумерному массиву -
// - 1 строка это имена столбцов, а 2 - сами данные. Пока что только так
ApplicationTextBox.Visible = true;
ApplicationTextBox.Text += $"Номер анкеты: {dataFromBD[0]}\n\n";
ApplicationTextBox.Text += $"Имя: {dataFromBD[1]}\n\n";
ApplicationTextBox.Text += $"Ник в игре: {dataFromBD[2]}\n\n";
ApplicationTextBox.Text += $"Ник в дискорде: {dataFromBD[3]}\n\n";
ApplicationTextBox.Text += $"Возраст: {dataFromBD[4]}\n\n";
ApplicationTextBox.Text += $"О себе: {dataFromBD[5]}\n\n";
ApplicationTextBox.Text += $"Любимая книга: {dataFromBD[6]}\n\n";
ApplicationTextBox.Text += $"Кем себя видит: {dataFromBD[7]}\n\n";
ApplicationTextBox.Text += $"Причина: {dataFromBD[8]}\n\n";
ApplicationTextBox.Text += $"Правила: {dataFromBD[9]}\n\n";
ApplicationTextBox.Text += $"Дата поступления анкеты: {dataFromBD[10]}\n\n";
ApplicationTextBox.Text += $"IP: {dataFromBD[11]}\n\n";
try
{
if (int.Parse(dataFromBD[4]) < 16)
{
int positionInText = ApplicationTextBox.Find("Возраст");
string lengthInText = $"Возраст: {dataFromBD[4]}\n\n";
ApplicationTextBox.SelectionStart = positionInText;
ApplicationTextBox.SelectionLength = lengthInText.Length;
ApplicationTextBox.SelectionColor = Color.Red;
}
}
catch (Exception exce)
{
}
finally
{
}
}
