private void ValueSaveData() { DataTable Value = new DataTable(); DataRow NewRow; DataRow FoundRow; decimal Year = ((NumericUpDown)MainProgram.Self.TabControl.Controls.Find("num_Admin_ValueYear", true).First()).Value; TextBox tb_AdminECCC = (TextBox)MainProgram.Self.TabControl.Controls.Find("tb_AdminECCC", true).First(); TextBox tb_AdminEuro = (TextBox)MainProgram.Self.TabControl.Controls.Find("tb_AdminEuro", true).First(); TextBox tb_AdminDolars = (TextBox)MainProgram.Self.TabControl.Controls.Find("tb_AdminDolars", true).First(); TextBox tb_AdminSEK = (TextBox)MainProgram.Self.TabControl.Controls.Find("tb_AdminSEK", true).First(); Data_Import.Singleton().Load_TxtToDataTable2(ref Value, "Kurs"); NewRow = Value.NewRow(); NewRow["Year"] = Year.ToString(); NewRow["ECCC"] = tb_AdminECCC.Text; NewRow["EURO"] = tb_AdminEuro.Text; NewRow["USD"] = tb_AdminDolars.Text; NewRow["SEK"] = tb_AdminSEK.Text; FoundRow = Value.Select(string.Format("Year LIKE '%{0}%'", Year.ToString())).FirstOrDefault(); if (FoundRow == null) { Value.Rows.Add(NewRow); } else { FoundRow.ItemArray = NewRow.ItemArray.Clone() as object[]; } Data_Import.Singleton().Save_DataTableToTXT2(ref Value, "Kurs"); }
private void ValueRefreshData() { DataTable Value = new DataTable(); DataRow FoundRow; decimal Year = ((NumericUpDown)MainProgram.Self.TabControl.Controls.Find("num_Admin_ValueYear", true).First()).Value; TextBox tb_AdminECCC = (TextBox)MainProgram.Self.TabControl.Controls.Find("tb_AdminECCC", true).First(); TextBox tb_AdminEuro = (TextBox)MainProgram.Self.TabControl.Controls.Find("tb_AdminEuro", true).First(); TextBox tb_AdminDolars = (TextBox)MainProgram.Self.TabControl.Controls.Find("tb_AdminDolars", true).First(); TextBox tb_AdminSEK = (TextBox)MainProgram.Self.TabControl.Controls.Find("tb_AdminSEK", true).First(); Data_Import.Singleton().Load_TxtToDataTable2(ref Value, "Kurs"); FoundRow = Value.Select(string.Format("Year LIKE '%{0}%'", Year.ToString())).FirstOrDefault(); if (FoundRow == null) { MessageBox.Show("Brak danych do wybranego roku, wprowadź je !"); return; } else { tb_AdminECCC.Text = FoundRow["ECCC"].ToString(); tb_AdminEuro.Text = FoundRow["EURO"].ToString(); tb_AdminDolars.Text = FoundRow["USD"].ToString(); tb_AdminSEK.Text = FoundRow["SEK"].ToString(); } }
public AdminFormHendler(MainProgram mainProgram, Action action, Admin admin, Data_Import ImportData) { this.mainProgram = mainProgram; this.action = action; this.admin = admin; this.ImportData = ImportData; }
private void AddRowForHistory(string What, decimal Year) { DataTable Action = new DataTable(); DataTable Historia = new DataTable(); Data_Import.Singleton().Load_TxtToDataTable2(ref Historia, "History"); Data_Import.Singleton().Load_TxtToDataTable2(ref Action, "Action"); DataColumn Col = Action.Columns.Add("History"); Col.SetOrdinal(0); foreach (DataRow ActionRow in Action.Rows) { if (ActionRow["StartYear"].ToString() == Year.ToString() || ActionRow["StartYear"].ToString() == (Year - 1).ToString() || ActionRow["StartYear"].ToString() == ("BU/" + Year).ToString() || ActionRow["StartYear"].ToString() == ("SA/" + Year).ToString()) { ActionRow["History"] = What + "/" + Year.ToString(); DataRow HistoriaNewRow = Historia.NewRow(); HistoriaNewRow.ItemArray = ActionRow.ItemArray; Historia.Rows.Add(HistoriaNewRow); } } Data_Import.Singleton().Save_DataTableToTXT2(ref Historia, "History"); }
private void ManulaUpadte(decimal Year) { DataTable STKTable = new DataTable(); Data_Import.Singleton().Load_TxtToDataTable2(ref STKTable, "STK"); if (STKTable.Columns.Contains(Year.ToString())) { DialogResult Results = MessageBox.Show("Dane STK na rok " + Year.ToString() + " istnieją!. Czy zamienić je ?", "Uwaga", MessageBoxButtons.YesNo); if (Results == DialogResult.Yes) { STKTable.Columns.Remove(Year.ToString()); STKTable.Columns.Remove("STK/" + Year.ToString()); } else { return; } } STKTable.Columns.Add(Year.ToString()); STKTable.Columns.Add("STK/" + Year.ToString()); Data_Import.Singleton().Save_DataTableToTXT2(ref STKTable, "STK"); _ = new AddData("Sprowadz dane dla STK", Year); //Data.Show(); }
//ładowanie tabeli z akcjami plus wyciągnięcie akcji która nas interesuje private DataRow ImportRowAction(string ActionName, decimal Year) { DataTable ActionList = new DataTable(); DataRow[] FoundArry; Data_Import.Singleton().Load_TxtToDataTable2(ref ActionList, "Action"); FoundArry = ActionList.Select(string.Format("Name LIKE '%{0}%'", ActionName)).ToArray(); foreach (DataRow Row in FoundArry.Take(FoundArry.Length)) { if (Row["Name"].ToString() == ActionName && Row["StartYear"].ToString() == Year.ToString()) { return(Row); } else if (Row["Name"].ToString() == ActionName && Row["StartYear"].ToString() == (Year - 1).ToString()) { return(Row); } else if (Row["Name"].ToString() == ActionName && Row["StartYear"].ToString() == "SA/" + Year.ToString()) { return(Row); } } return(null); }
private void SaveFromDataGridView(string Link) { DataTable Actiontable; DataGridView Dg_AdminActionGrid = (DataGridView)Tab_AdminAction.Controls.Find("Dg_AdminActionGrid", true).First(); Actiontable = (DataTable)(Dg_AdminActionGrid.DataSource); Data_Import.Singleton().Save_DataTableToTXT(ref Actiontable, Link); }
public static Data_Import Singleton() { if (instance == null) { instance = new Data_Import(); } return(instance); }
//LoadAction Table private DataTable LoadActionTable() { DataTable ActionList = new DataTable(); Data_Import.Singleton().Load_TxtToDataTable2(ref ActionList, "Action"); return(ActionList); }
private void ClearYear(decimal Year) { DataTable STKTable = new DataTable(); Data_Import.Singleton().Load_TxtToDataTable2(ref STKTable, "STK"); if (STKTable.Columns.Contains(Year.ToString())) { STKTable.Columns.Remove(Year.ToString()); STKTable.Columns.Remove("STK/" + Year.ToString()); Data_Import.Singleton().Save_DataTableToTXT2(ref STKTable, "STK"); } }
public void STK_LoadFile() { if (File.Exists(link)) { DataTable Table = new DataTable(); Data_Import.Singleton().Load_TxtToDataTable2(ref Table, "STK"); } else { MessageBox.Show("Brak Bazy danych, proszę skontaktować się z administratorem"); } //Dodać odrazu filtrowanie na bierzący rok, chyba przelicza wszystkie - sprawdzić }
public MainProgram() { try { data_Import = Data_Import.Singleton(); if (!data_Import.CheckConnectionToDataBase()) { Environment.Exit(0); } //Widocznoś Maina dla Wszystkich. Self = this; //Pobranie danych z bazy dla dostępów osób logujących się do programy Access = data_Import.Load_Access(); //Tworzenie Użytkowanika CreateUsers NewUsers = new CreateUsers(Access); //Inicjalizowanie programu InitializeComponent(); action = new Action(this, data_Import); admin = new Admin(); summaryDetails = new SummaryDetails(); //Budowanie Formsa w zależności od uprawnień buildForm.Tab_Control_Add(Access, this, action, summaryDetails, admin, data_Import); if (ApplicationDeployment.IsNetworkDeployed) { toolStripStatusLabel1.Text = ApplicationDeployment.CurrentDeployment.CurrentVersion.ToString() + " Beta Version"; } else { toolStripStatusLabel1.Text = "0.5.0.40 Beta Portable Version"; } if (Environment.UserName.ToString() == "BartkKon") { string Link = data_Import.CheckLink(); toolStripStatusLabel1.Text = toolStripStatusLabel1.Text + " " + Link; } } catch (Exception ex) { LogSingleton.Instance.SaveLog(ex.Message); } }
private void LoadToDataGridView(string Link) { DataTable ActionTable = new DataTable(); DataGridView Dg_AdminActionGrid = (DataGridView)Tab_AdminAction.Controls.Find("Dg_AdminActionGrid", true).First(); GroupBox Gb_AdminAction_NewColumn = (GroupBox)Tab_AdminAction.Controls.Find("Gb_AdminAction_NewColumn", true).First(); Label QuantityColumns = (Label)MainProgram.Self.TabControl.Controls.Find("Lab_ColumnQuantity", true).First(); Data_Import.Singleton().Load_TxtToDataTable(ref ActionTable, Link); Dg_AdminActionGrid.DataSource = ActionTable; foreach (DataGridViewColumn Column in Dg_AdminActionGrid.Columns) { Column.SortMode = DataGridViewColumnSortMode.NotSortable; } Dg_AdminActionGrid.Columns[0].Frozen = true; Gb_AdminAction_NewColumn.Enabled = true; Dg_AdminActionGrid.AutoSize = true; QuantityColumns.Text = (Dg_AdminActionGrid.Columns.Count - 1).ToString(); }
public void HistorySave() { DataTable Frozen = new DataTable(); DataRow FrozenRow; decimal Year = ((NumericUpDown)MainProgram.Self.TabControl.Controls.Find("num_SummaryDetailYear", true).First()).Value; Data_Import.Singleton().Load_TxtToDataTable2(ref Frozen, "Frozen"); FrozenRow = Frozen.Select(string.Format("Year LIKE '%{0}%'", Year.ToString())).First(); if (FrozenRow != null) { if (FrozenRow["BU"].ToString() == "Open") { DeleteRowFromHistory("BU", Year); AddRowForHistory("BU", Year); } if (FrozenRow["EA1"].ToString() == "Open") { DeleteRowFromHistory("EA1", Year); AddRowForHistory("EA1", Year); } if (FrozenRow["EA2"].ToString() == "Open") { DeleteRowFromHistory("EA2", Year); AddRowForHistory("RA2", Year); } if (FrozenRow["EA3"].ToString() == "Open") { DeleteRowFromHistory("EA3", Year); AddRowForHistory("EA3", Year); } for (int counter = 1; counter < 13; counter++) { if (FrozenRow[counter.ToString()].ToString() == "Open") { DeleteRowFromHistory(counter.ToString(), Year); AddRowForHistory(counter.ToString(), Year); } } } }
private void DeleteRowFromHistory(string what, decimal Year) { DataTable Historia = new DataTable(); DataRow[] ForDelete; Data_Import.Singleton().Load_TxtToDataTable2(ref Historia, "History"); ForDelete = Historia.Select(string.Format("History LIKE '%{0}%'", what + "/" + Year.ToString())).ToArray(); if (ForDelete != null) { foreach (DataRow Delete in ForDelete) { Historia.Rows.Remove(Delete); } } Data_Import.Singleton().Save_DataTableToTXT2(ref Historia, "History"); }
private void FrozenRefreshData() { DataTable Frozen = new DataTable(); DataRow FrozenRow; decimal Year = ((NumericUpDown)MainProgram.Self.TabControl.Controls.Find("num_Admin_FrozenYear", true).First()).Value; Data_Import.Singleton().Load_TxtToDataTable2(ref Frozen, "Frozen"); FrozenRow = Frozen.Select(string.Format("Year LIKE '%{0}%'", Year.ToString())).FirstOrDefault(); if (FrozenRow == null) { MessageBox.Show("Brak Danego roku w Bazie - dodaj go !!"); return; } else { foreach (DataColumn column in Frozen.Columns) { if (column.ColumnName != "Year") { if (FrozenRow[column.ColumnName].ToString() == "Close") { ((ComboBox)MainProgram.Self.TabControl.Controls.Find("Combo_Admin" + column.ColumnName, true).First()).SelectedIndex = 0; } else if (FrozenRow[column.ColumnName].ToString() == "Open") { ((ComboBox)MainProgram.Self.TabControl.Controls.Find("Combo_Admin" + column.ColumnName, true).First()).SelectedIndex = 1; } else if (FrozenRow[column.ColumnName].ToString() == "Approve") { ((ComboBox)MainProgram.Self.TabControl.Controls.Find("Combo_Admin" + column.ColumnName, true).First()).SelectedIndex = 2; } else { ((ComboBox)MainProgram.Self.TabControl.Controls.Find("Combo_Admin" + column.ColumnName, true).First()).SelectedIndex = 0; } } } } }
public void Approve_Info(string Devision, decimal Year, Data_Import data_Import) { DataTable Action = new DataTable(); DataTable ANC = new DataTable(); DataTable PNC = new DataTable(); DataTable Kurs = new DataTable(); string Link; string DevisionFinal = Dewizje[Devision]; //decimal Euro; Link = data_Import.Load_Link("Action"); data_Import.Load_TxtToDataTable(ref Action, Link); Link = data_Import.Load_Link("Kurs"); data_Import.Load_TxtToDataTable(ref Kurs, Link); Link = data_Import.Load_Link("ANC"); data_Import.Load_TxtToDataTable(ref ANC, Link); Link = data_Import.Load_Link("PNC"); data_Import.Load_TxtToDataTable(ref PNC, Link); //Euro = decimal.Parse((Kurs.Select(string.Format("Year LIKE '%{0}%'", Year)).FirstOrDefault())["EURO"].ToString()); foreach (DataRow Row in Action.Rows) { if (Row["Group"].ToString() == DevisionFinal && Row["StartYear"].ToString() == Year.ToString()) { //Row.ItemArray = CalcSpecjal(Row, Rewizion, Euro, ref ANC, ref PNC).ItemArray; } } Link = data_Import.Load_Link("Action"); data_Import.Save_DataTableToTXT(ref Action, Link); }
private void Pb_AddData_STK_Close_Click(object sender, EventArgs e) { Cursor.Current = Cursors.WaitCursor; string[] Row = tb_AddData_Data.Text.Split(new[] { Environment.NewLine }, StringSplitOptions.None); DataTable STK = new DataTable(); DataRow STKRow; Data_Import.Singleton().Load_TxtToDataTable2(ref STK, "STK"); foreach (string SingleRow in Row) { string[] Part = SingleRow.Split('\t'); if (Part.Length > 1) { Part[0] = Part[0].Replace(" ", ""); STKRow = STK.Select(string.Format("ANC LIKE '%{0}%'", Part[0])).FirstOrDefault(); if (STKRow != null) { STKRow[Year.ToString()] = "01/00/" + Year.ToString(); STKRow["STK/" + Year.ToString()] = Part[1]; } else { STKRow = STK.NewRow(); STKRow["ANC"] = Part[0].ToString(); STKRow[Year.ToString()] = "01/00/" + Year.ToString(); STKRow["STK/" + Year.ToString()] = Part[1]; STK.Rows.Add(STKRow); } } } Data_Import.Singleton().Save_DataTableToTXT2(ref STK, "STK"); this.Close(); Cursor.Current = Cursors.Default; }
private void FrozenSaveData() { DataTable Frozen = new DataTable(); DataRow NewRow; DataRow FoundRow; decimal Year = ((NumericUpDown)MainProgram.Self.TabControl.Controls.Find("num_Admin_FrozenYear", true).First()).Value; Data_Import.Singleton().Load_TxtToDataTable2(ref Frozen, "Frozen"); NewRow = Frozen.NewRow(); foreach (DataColumn column in Frozen.Columns) { if (column.ColumnName == "Year") { NewRow[column.ColumnName] = Year.ToString(); } else { ComboBox ComboBoxFrozen = (ComboBox)MainProgram.Self.TabControl.Controls.Find("Combo_Admin" + column.ColumnName, true).First(); NewRow[column.ColumnName] = ComboBoxFrozen.GetItemText(ComboBoxFrozen.SelectedItem); } } FoundRow = Frozen.Select(string.Format("Year LIKE '%{0}%'", Year.ToString())).FirstOrDefault(); if (FoundRow == null) { Frozen.Rows.Add(NewRow); } else { FoundRow.ItemArray = NewRow.ItemArray.Clone() as object[]; } Data_Import.Singleton().Save_DataTableToTXT2(ref Frozen, "Frozen"); }
//Sprawdzenie czy w Gridach jest coś zapisane już private bool GridCheck(decimal Year) { bool Grid = false; DataTable Frozen = new DataTable(); DataRow FrozenRow; DataGridView Table_Check = (DataGridView)MainProgram.Self.TabControl.Controls.Find("dg_Saving", true).First(); Data_Import.Singleton().Load_TxtToDataTable2(ref Frozen, "Frozen"); FrozenRow = Frozen.Select(string.Format("Year LIKE '%{0}%'", Year.ToString())).FirstOrDefault(); if (FrozenRow == null) { return(Grid); } for (int Row = 0; Row < 5; Row++) { for (int Column = 0; Column < 12; Column++) { if (Table_Check.Rows[Row].Cells[Column] != null && Table_Check.Rows[Row].Cells[Column].ToString() != "") { if (Row == 1) { if (FrozenRow["EA3"].ToString() == "Approve") { Grid = true; return(Grid); } } else if (Row == 2) { if (FrozenRow["EA2"].ToString() == "Approve") { Grid = true; return(Grid); } } else if (Row == 3) { if (FrozenRow["EA1"].ToString() == "Approve") { Grid = true; return(Grid); } } else if (Row == 4) { if (FrozenRow["BU"].ToString() == "Approve") { Grid = true; return(Grid); } } else { if (FrozenRow[(Column + 1).ToString()].ToString() == "Approve") { Grid = true; return(Grid); } } } } } return(Grid); }
public Level1(MainProgram mainProgram, Data_Import data_Import) { this.mainProgram = mainProgram; this.data_Import = data_Import; }
public STK() { link = Data_Import.Singleton().Load_Link("STK"); }
private void LoadNewSTKFile(string linkFile) { DataTable STKTable = new DataTable(); string line_help; string ANC; int Year; int Month; int Day; float STK; string Name; string day; string month; string IDCO; Data_Import.Singleton().Load_TxtToDataTable2(ref STKTable, "STK"); if (linkFile == "0") { MessageBox.Show("Plik nie był generowany od ponad miesiąca!"); } else { string[] STKFileupdate = File.ReadAllLines(linkFile); foreach (string line in STKFileupdate) { line_help = line; line_help = line_help.Remove(0, 2); ANC = line_help.Remove(9); line_help = line_help.Remove(0, 11); Year = int.Parse(line_help.Remove(2)); line_help = line_help.Remove(0, 2); Month = int.Parse(line_help.Remove(2)); line_help = line_help.Remove(0, 2); Day = int.Parse(line_help.Remove(2)); line_help = line_help.Remove(0, 2); STK = float.Parse(line_help.Remove(9)) / 10000; line_help = line_help.Remove(0, 154); Name = line_help.Remove(30).Trim(); line_help = line_help.Remove(0, 31); IDCO = line_help.Remove(4); Year = 2000 + Year; DataRow FoundRow = STKTable.Select(string.Format("ANC LIKE '%{0}%'", ANC)).FirstOrDefault(); if (FoundRow == null) { DataRow NewRow = STKTable.NewRow(); NewRow["ANC"] = ANC; NewRow["Description"] = Name; NewRow["IDCO"] = IDCO; if (Day < 10) { day = "0" + Day.ToString(); } else { day = Day.ToString(); } if (Month < 10) { month = "0" + Month.ToString(); } else { month = Month.ToString(); } if (!STKTable.Columns.Contains(Year.ToString())) { STKTable.Columns.Add(new DataColumn(Year.ToString())); STKTable.Columns.Add(new DataColumn("STK/" + Year)); } NewRow[Year.ToString()] = day + "/" + month + "/" + Year.ToString(); NewRow["STK/" + Year] = STK.ToString(); STKTable.Rows.Add(NewRow); } else { if (STKTable.Columns.Contains(Year.ToString())) { if (FoundRow["STK/" + Year].ToString() != STK.ToString()) { //Co się stanie jak nie jest równy. FoundRow["STK/" + Year] = STK.ToString(); if (Day < 10) { day = "0" + Day.ToString(); } else { day = Day.ToString(); } if (Month < 10) { month = "0" + Month.ToString(); } else { month = Month.ToString(); } FoundRow[Year.ToString()] = day + "/" + month + "/" + Year.ToString(); } if (FoundRow["IDCO"].ToString() != IDCO) { FoundRow["IDCO"] = IDCO; } } else { //Dodać kolumne z nowym rokiem i dopisać wartość STKTable.Columns.Add(new DataColumn(Year.ToString())); STKTable.Columns.Add(new DataColumn("STK/" + Year)); if (Day < 10) { day = "0" + Day.ToString(); } else { day = Day.ToString(); } if (Month < 10) { month = "0" + Month.ToString(); } else { month = Month.ToString(); } FoundRow[Year.ToString()] = day + "/" + month + "/" + Year.ToString(); FoundRow["STK/" + Year] = STK.ToString(); } } } Data_Import.Singleton().Save_DataTableToTXT2(ref STKTable, "STK"); } }
public PCRaports_Genereted(MainProgram mainProgram, Data_Import data_Import) { this.mainProgram = mainProgram; this.data_Import = data_Import; }
public STKCalculation(MainProgram mainProgram, Data_Import ImportData, int ANCChangeNumber) { this.mainProgram = mainProgram; this.ImportData = ImportData; this.ANCChangeNumber = ANCChangeNumber; }
private void Pb_AddData_Close_Click(object sender, EventArgs e) { //Action action = new Action(); Cursor.Current = Cursors.WaitCursor; string[] row = tb_AddData_Data.Text.Split(new[] { Environment.NewLine }, StringSplitOptions.None); int DuplicateCount = 0; bool IFCalc = false; if (row[0] != "") { if (Jak == "PNC") { DataGridView dg_PNC = (DataGridView)MainProgram.Self.TabControl.Controls.Find("dg_PNC", true).First(); if (dg_PNC.Rows.Count > 1) { DialogResult result = MessageBox.Show("Do you want replace all PNC in this Action ?", "Warning!", MessageBoxButtons.YesNo); if (result == DialogResult.Yes) { dg_PNC.Rows.Clear(); dg_PNC.Columns.Clear(); dg_PNC.Columns.Add("PNC", "PNC"); dg_PNC.Columns["PNC"].Width = 63; dg_PNC.Columns["PNC"].SortMode = DataGridViewColumnSortMode.NotSortable; IFCalc = true; } else if (result == DialogResult.No) { DialogResult result2 = MessageBox.Show("Do you want add this PNC to exisitng PNC for this Action ?", "Warning!", MessageBoxButtons.YesNo); if (result2 == DialogResult.Yes) { IFCalc = true; } else if (result2 == DialogResult.No) { IFCalc = false; } } } else { dg_PNC.Rows.Clear(); dg_PNC.Columns.Clear(); dg_PNC.Columns.Add("PNC", "PNC"); dg_PNC.Columns["PNC"].Width = 63; dg_PNC.Columns["PNC"].SortMode = DataGridViewColumnSortMode.NotSortable; IFCalc = true; } if (IFCalc) { foreach (string OneRow in row) { if (OneRow != "") { var Row = dg_PNC.Rows.Cast <DataGridViewRow>().Where(u => u.Cells["PNC"].Value.ToString().Equals(OneRow)).FirstOrDefault(); if (Row == null) { dg_PNC.Rows.Add(OneRow); } else { DuplicateCount++; } } } } this.Close(); Cursor.Current = Cursors.Default; if (DuplicateCount > 0) { MessageBox.Show($"Was remove {DuplicateCount} Duplicate Value", "Duplicate counter"); } return; } if (Jak == "PNCSpec") { DataGridView dg_PNC = (DataGridView)MainProgram.Self.TabControl.Controls.Find("dg_PNC", true).First(); if (dg_PNC.Rows.Count > 1) { DialogResult result = MessageBox.Show("Do you want replace all PNC in this Action ?", "Warning!", MessageBoxButtons.YesNo); if (result == DialogResult.Yes) { dg_PNC.Rows.Clear(); dg_PNC.Columns.Clear(); dg_PNC.Columns.Add("PNC", "PNC"); dg_PNC.Columns.Add("OLD ANC", "OLD ANC"); dg_PNC.Columns.Add("OLD Q", "Q"); dg_PNC.Columns.Add("NEW ANC", "NEW ANC"); dg_PNC.Columns.Add("NEW Q", "Q"); dg_PNC.Columns["PNC"].Width = 80; dg_PNC.Columns["OLD ANC"].Width = 65; dg_PNC.Columns["OLD ANC"].DefaultCellStyle.ForeColor = Color.Red; dg_PNC.Columns["OLD Q"].Width = 35; dg_PNC.Columns["OLD Q"].DefaultCellStyle.ForeColor = Color.Red; dg_PNC.Columns["NEW ANC"].Width = 65; dg_PNC.Columns["NEW ANC"].DefaultCellStyle.ForeColor = Color.Green; dg_PNC.Columns["NEW Q"].Width = 35; dg_PNC.Columns["NEW Q"].DefaultCellStyle.ForeColor = Color.Green; dg_PNC.Columns["PNC"].SortMode = DataGridViewColumnSortMode.NotSortable; dg_PNC.Columns["OLD ANC"].SortMode = DataGridViewColumnSortMode.NotSortable; dg_PNC.Columns["OLD Q"].SortMode = DataGridViewColumnSortMode.NotSortable; dg_PNC.Columns["NEW ANC"].SortMode = DataGridViewColumnSortMode.NotSortable; dg_PNC.Columns["NEW Q"].SortMode = DataGridViewColumnSortMode.NotSortable; IFCalc = true; } else if (result == DialogResult.No) { DialogResult result2 = MessageBox.Show("Do you want add this PNC to exisitng PNC for this Action ?", "Warning!", MessageBoxButtons.YesNo); if (result2 == DialogResult.Yes) { IFCalc = true; } else if (result2 == DialogResult.No) { IFCalc = false; } } } else { dg_PNC.Rows.Clear(); dg_PNC.Columns.Clear(); dg_PNC.Columns.Add("PNC", "PNC"); dg_PNC.Columns.Add("OLD ANC", "OLD ANC"); dg_PNC.Columns.Add("OLD Q", "Q"); dg_PNC.Columns.Add("NEW ANC", "NEW ANC"); dg_PNC.Columns.Add("NEW Q", "Q"); dg_PNC.Columns["PNC"].Width = 80; dg_PNC.Columns["OLD ANC"].Width = 65; dg_PNC.Columns["OLD ANC"].DefaultCellStyle.ForeColor = Color.Red; dg_PNC.Columns["OLD Q"].Width = 35; dg_PNC.Columns["OLD Q"].DefaultCellStyle.ForeColor = Color.Red; dg_PNC.Columns["NEW ANC"].Width = 65; dg_PNC.Columns["NEW ANC"].DefaultCellStyle.ForeColor = Color.Green; dg_PNC.Columns["NEW Q"].Width = 35; dg_PNC.Columns["NEW Q"].DefaultCellStyle.ForeColor = Color.Green; dg_PNC.Columns["PNC"].SortMode = DataGridViewColumnSortMode.NotSortable; dg_PNC.Columns["OLD ANC"].SortMode = DataGridViewColumnSortMode.NotSortable; dg_PNC.Columns["OLD Q"].SortMode = DataGridViewColumnSortMode.NotSortable; dg_PNC.Columns["NEW ANC"].SortMode = DataGridViewColumnSortMode.NotSortable; dg_PNC.Columns["NEW Q"].SortMode = DataGridViewColumnSortMode.NotSortable; IFCalc = true; } if (IFCalc) { foreach (string SingleRow in row) { if (SingleRow == string.Empty) { continue; } string[] SelectedRow = SingleRow.Split(';'); string PNC = SelectedRow[0]; string ECCC = string.Empty; int Limit = ((SelectedRow.Length - 3) / 2); if (SelectedRow[1].ToString() != string.Empty) { ECCC = "ECCC(" + SelectedRow[1] + ")"; } dg_PNC.Rows.Add(PNC, ECCC, string.Empty); dg_PNC.Rows[dg_PNC.Rows.Count - 1].DefaultCellStyle.BackColor = Color.LightBlue; dg_PNC.Rows[dg_PNC.Rows.Count - 1].DefaultCellStyle.Font = new Font(dg_PNC.Font, FontStyle.Bold); dg_PNC.Rows[dg_PNC.Rows.Count - 1].Cells[1].Style.Font = new Font(dg_PNC.Font, FontStyle.Regular); dg_PNC.Rows[dg_PNC.Rows.Count - 1].Cells[1].Style.Font = new Font("Tahoma", 10F, GraphicsUnit.Pixel); for (int counter2 = 2; counter2 < Limit + 2; counter2++) { if (SelectedRow[counter2] != string.Empty || SelectedRow[counter2 + Limit + 1] != string.Empty) { dg_PNC.Rows.Add(string.Empty, SelectedRow[counter2], SelectedRow[counter2 + 1], SelectedRow[counter2 + Limit + 1], SelectedRow[counter2 + Limit + 2]); } counter2++; } } } this.Close(); Cursor.Current = Cursors.Default; return; } } else { this.Close(); Cursor.Current = Cursors.Default; return; } if (Jak == "BU" || Jak == "EA1" || Jak == "EA2" || Jak == "EA3") { NumericUpDown Admin_Year = (NumericUpDown)MainProgram.Self.TabControl.Controls.Find("num_Admin_YearQuantity", true).First(); CheckBox cb_AdminPNC = (CheckBox)MainProgram.Self.TabControl.Controls.Find("cb_AdminPNC", true).First(); CheckBox cb_AdminANC = (CheckBox)MainProgram.Self.TabControl.Controls.Find("cb_AdminANC", true).First(); DataTable Baza = new DataTable(); DataRow FoundRow; int ile; if (cb_AdminANC.Checked) { Data_Import.Singleton().Load_TxtToDataTable2(ref Baza, "ANC"); } if (cb_AdminPNC.Checked) { Data_Import.Singleton().Load_TxtToDataTable2(ref Baza, "PNC"); } switch (Jak) { case "BU": ile = 1; break; case "EA1": ile = 3; break; case "EA2": ile = 6; break; case "EA3": ile = 9; break; default: return; } if (Baza.Columns.Contains(Jak + "/12/" + Admin_Year.Text)) { for (int counter = ile; counter <= 12; counter++) { Baza.Columns.Remove(Jak + "/" + counter + "/" + Admin_Year.Text); } } for (int counter = ile; counter <= 12; counter++) { Baza.Columns.Add(new DataColumn(Jak + "/" + counter + "/" + Admin_Year.Text)); } foreach (string OneRow in row) { string[] row2 = OneRow.Split('\t'); if (row2[0] != "") { if (cb_AdminANC.Checked) { FoundRow = Baza.Select(string.Format("BUANC LIKE '%{0}%'", row2[0])).FirstOrDefault(); } else { FoundRow = Baza.Select(string.Format("BUPNC LIKE '%{0}%'", row2[0])).FirstOrDefault(); } int zmienna; if (FoundRow != null) { zmienna = ile; for (int counter = 1; counter <= (13 - ile); counter++) { FoundRow[Jak + "/" + zmienna + "/" + Admin_Year.Text] = row2[counter]; zmienna++; } } else { DataRow NewRow = Baza.NewRow(); NewRow[0] = row2[0]; zmienna = ile; for (int counter = 1; counter <= (13 - ile); counter++) { NewRow[Jak + "/" + zmienna + "/" + Admin_Year.Text] = row2[counter]; zmienna++; } Baza.Rows.Add(NewRow); } } } if (cb_AdminANC.Checked) { Data_Import.Singleton().Save_DataTableToTXT2(ref Baza, "ANC"); } if (cb_AdminPNC.Checked) { Data_Import.Singleton().Save_DataTableToTXT2(ref Baza, "PNC"); } this.Close(); Cursor.Current = Cursors.Default; return; } if (Jak == "AddMonthANC" || Jak == "AddMonthPNC") { NumericUpDown Admin_Year = (NumericUpDown)MainProgram.Self.TabControl.Controls.Find("num_Admin_YearMonth", true).First(); NumericUpDown Admin_Month = (NumericUpDown)MainProgram.Self.TabControl.Controls.Find("num_Admin_QuantityMonth", true).First(); DataTable Quantity = new DataTable(); DataRow FoundRow; string Miesiac = Admin_Month.Value.ToString() + "/" + Admin_Year.Value.ToString(); if (Jak == "AddMonthANC") { Data_Import.Singleton().Load_TxtToDataTable2(ref Quantity, "ANCMonth"); } if (Jak == "AddMonthPNC") { Data_Import.Singleton().Load_TxtToDataTable2(ref Quantity, "PNCMonth"); } if (Quantity.Columns.Contains(Miesiac)) { Quantity.Columns.Remove(Miesiac); } Quantity.Columns.Add(new DataColumn(Miesiac)); foreach (string OneRow in row) { string[] NewValue = OneRow.Split('\t'); if (NewValue[0] != "") { if (Jak == "AddMonthANC") { FoundRow = Quantity.Select(string.Format("ANC LIKE '%{0}%'", NewValue[0])).FirstOrDefault(); } else { FoundRow = Quantity.Select(string.Format("PNC LIKE '%{0}%'", NewValue[0])).FirstOrDefault(); } if (FoundRow != null) { FoundRow[Miesiac] = NewValue[1]; } else { DataRow NewRow = Quantity.NewRow(); NewRow[0] = NewValue[0]; NewRow[Miesiac] = NewValue[1]; Quantity.Rows.Add(NewRow); } } } if (Jak == "AddMonthANC") { Data_Import.Singleton().Save_DataTableToTXT2(ref Quantity, "ANCMonth"); } if (Jak == "AddMonthPNC") { Data_Import.Singleton().Save_DataTableToTXT2(ref Quantity, "PNCMonth"); } this.Close(); Cursor.Current = Cursors.Default; return; } }
public void Tab_Control_Add(DataTable Access, MainProgram mainProgram, Action action, SummaryDetails summaryDetails, Admin admin, Data_Import ImportData) { Person = Access.Rows[0]; Users User = Users.Singleton(); // // Tab_Action // if (User.ActionTab) { TabPage tab_Action = new TabPage(); mainProgram.TabControl.Controls.Add(tab_Action); tab_Action.Location = new System.Drawing.Point(4, 22); tab_Action.Name = "tab_Action"; tab_Action.Padding = new Padding(3); tab_Action.Size = new System.Drawing.Size(1826, 877); tab_Action.TabIndex = 0; tab_Action.Text = "Action"; tab_Action.UseVisualStyleBackColor = true; //Tab_Action_Comp(); _ = new ActionForm(action); action.Action_NoChangeInAction(); } // // tab_SummaryDetail // if (User.SummaryTab) { TabPage tab_SummaryDetail = new TabPage { Location = new System.Drawing.Point(4, 22), Name = "tab_Summary", Size = new System.Drawing.Size(1826, 877), TabIndex = 1, Text = "Summary Detail", UseVisualStyleBackColor = true }; mainProgram.TabControl.Controls.Add(tab_SummaryDetail); TabPage tab_Summary = new TabPage { Location = new System.Drawing.Point(4, 22), Name = "tab_SummaryS", Size = new System.Drawing.Size(1826, 877), TabIndex = 2, Text = "Summary", UseVisualStyleBackColor = true }; mainProgram.TabControl.Controls.Add(tab_Summary); _ = new SummaryDetailsForm(Person, summaryDetails); } // // Tab Statistic- dane statystyczne // if (User.StatisticTab) { _ = new StatisticTabGenerator(); } // // Tab Platform Savings - dane statystyczne // if (User.PlatformTab) { _ = new PlatformTabGenerator(); } // // tab_STK // if (User.STKTab) { TabPage tab_STK = new TabPage { Location = new System.Drawing.Point(4, 22), Name = "tab_STK", Size = new System.Drawing.Size(1826, 877), TabIndex = 5, Text = "STK3", UseVisualStyleBackColor = true }; mainProgram.TabControl.Controls.Add(tab_STK); Tab_STK_Comp(); } // // tab_Quantity // if (User.QuantityTab) { TabPage tab_Quantity = new TabPage { Location = new System.Drawing.Point(4, 22), Name = "tab_Quantity", Size = new System.Drawing.Size(1826, 877), TabIndex = 6, Text = "Quantity", UseVisualStyleBackColor = true }; mainProgram.TabControl.Controls.Add(tab_Quantity); Tab_Quantity_Comp(); } // // tab_Admin // if (User.AdminTab) { TabPage tab_Admin = new TabPage { Location = new System.Drawing.Point(4, 22), Name = "tab_Admin", Size = new System.Drawing.Size(1826, 877), TabIndex = 7, Text = "Administration ", UseVisualStyleBackColor = true }; mainProgram.TabControl.Controls.Add(tab_Admin); _ = new AdminForm(mainProgram, action, admin, ImportData); TabPage tab_AdminAction = new TabPage { Location = new System.Drawing.Point(4, 22), Name = "tab_AdminAction", Size = new System.Drawing.Size(1826, 877), TabIndex = 8, Text = "Action Admin", UseVisualStyleBackColor = true, }; mainProgram.TabControl.Controls.Add(tab_AdminAction); _ = new ModifiActionForm(tab_AdminAction); } }
public void Pb_AdminAction_SaveAccess_Click(object sender, EventArgs e) { Cursor.Current = Cursors.WaitCursor; SaveFromDataGridView(Data_Import.Singleton().Load_Link("Access")); Cursor.Current = Cursors.Default; }
public void Pb_AdminAction_LoadFrozen_Click(object sender, EventArgs e) { Cursor.Current = Cursors.WaitCursor; LoadToDataGridView(Data_Import.Singleton().Load_Link("Frozen")); Cursor.Current = Cursors.Default; }
public AdminForm(MainProgram mainProgram, Action action, Admin admin, Data_Import ImportData) : base(mainProgram, action, admin, ImportData) { tab_Admin = (TabPage)mainProgram.TabControl.Controls.Find("tab_Admin", false).First(); Tab_Admin_Comp(); }