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();
}
