Beispiel #1
0
        private void Comb_AdminTargetsComboBoxChange_SelectedItemChange(object sender, EventArgs e)
        {
            DataTable Targets = new DataTable();
            DataRow   TargetsRow;
            decimal   Year          = Num_AdminTargetsYear.Value;
            int       SelectedIndex = Comb_AdminTargetsRewizja.SelectedIndex;

            Data_Import.Singleton().Load_TxtToDataTable2(ref Targets, "Kurs");
            Tb_AdminTargetsDM.Text          = "";
            Tb_AdminTargetsPercent.Text     = "";
            Tb_AdminTargetsElePercent.Text  = "";
            Tb_AdminTargetsMechPercent.Text = "";
            Tb_AdminTargetsNVRPercent.Text  = "";

            TargetsRow = Targets.Select(string.Format("Year LIKE '%{0}%'", Year.ToString())).First();
            if (TargetsRow != null)
            {
                string[] DM   = (TargetsRow["DM"].ToString()).Split('/');
                string[] PC   = (TargetsRow["PC"].ToString()).Split('/');
                string[] Ele  = (TargetsRow["Ele"].ToString()).Split('/');
                string[] Mech = (TargetsRow["Mech"].ToString()).Split('/');
                string[] NVR  = (TargetsRow["NVR"].ToString()).Split('/');

                Tb_AdminTargetsDM.Text          = DM[SelectedIndex];
                Tb_AdminTargetsPercent.Text     = PC[SelectedIndex];
                Tb_AdminTargetsElePercent.Text  = Ele[SelectedIndex];
                Tb_AdminTargetsMechPercent.Text = Mech[SelectedIndex];
                Tb_AdminTargetsNVRPercent.Text  = NVR[SelectedIndex];
            }
        }
Beispiel #2
0
        private void LoadData()
        {
            DataTable AllData = new DataTable();

            DataRow[] ProjectRows;
            DataRow   SpecyficPNC;

            Data_Import.Singleton().Load_TxtToDataTable2(ref AllData, "PlatformPNCList");

            ProjectRows = AllData.Select(string.Format("Project LIKE '%{0}%'", _project)).ToArray();
            SpecyficPNC = AllData.NewRow();

            foreach (DataRow Row in ProjectRows)
            {
                if (Row["NewPNC"].ToString() == _newPNC)
                {
                    if (Row["OldPNC"].ToString() == _oldPNC)
                    {
                        SpecyficPNC.ItemArray = (object[])Row.ItemArray.Clone();
                        break;
                    }
                }
            }

            if (SpecyficPNC == null)
            {
                return;
            }

            LoadSpecificationToLabel(SpecyficPNC);
        }
Beispiel #3
0
        public NewAccount(TextBox BIZ)
        {
            DataTable Access = new DataTable();
            DataRow   NewAccount;

            Data_Import.Singleton().Load_TxtToDataTable2(ref Access, "Access");

            NewAccount = Access.NewRow();

            NewAccount["Name"]         = BIZ.Text;
            NewAccount["FullName"]     = "";
            NewAccount["Mail"]         = "";
            NewAccount["Role"]         = "Employee";
            NewAccount["tab_Action"]   = "false";
            NewAccount["Action"]       = "false";
            NewAccount["ActionEle"]    = "false";
            NewAccount["ActionMech"]   = "false";
            NewAccount["ActionNVR"]    = "false";
            NewAccount["tab_Summary"]  = "false";
            NewAccount["tab_STK"]      = "false";
            NewAccount["tab_Quantity"] = "false";
            NewAccount["tab_Admin"]    = "false";
            NewAccount["EleApprove"]   = "false";
            NewAccount["MechApprove"]  = "false";
            NewAccount["NVRApprove"]   = "false";
            NewAccount["PCApprove"]    = "false";

            Access.Rows.Add(NewAccount);

            Data_Import.Singleton().Save_DataTableToTXT2(ref Access, "Access");
        }
Beispiel #4
0
        public void SumPlanTable()
        {
            DataTable Kurs = new DataTable();
            DataRow   KursRow;
            decimal   Year;

            Year = MainProgram.Self.sdOptions1.GetYear();

            Data_Import.Singleton().Load_TxtToDataTable2(ref Kurs, "Kurs");

            KursRow = Kurs.Select(string.Format("Year LIKE '%{0}%'", Year.ToString())).FirstOrDefault();

            //Czyszczenie tablicy
            CleanSummTabel();

            //Sumowanie wartości z Actuala, CarryOver i ECCC
            dgv_SumPlan.Rows[0].Cells[0].Value = PlanTableSum(0);
            dgv_SumPlan.Rows[1].Cells[0].Value = PlanTableSum(1);
            dgv_SumPlan.Rows[2].Cells[0].Value = PlanTableSum(2);
            dgv_SumPlan.Rows[3].Cells[0].Value = PlanTableSum(3);
            dgv_SumPlan.Rows[4].Cells[0].Value = PlanTableSum(4);

            //Wyliczenie Procentów dostarczonych
            PercentWykonania();

            //Wyliczenie ile już dostarczyliśmy DM
            DMForRewizion(KursRow);

            //Wpisanie targetów
            TargetsSum(KursRow);

            //Delta
            DeltaSumm();
        }
Beispiel #5
0
 public SentTo(bool ElectronicMenager, bool MechanicMenager, bool NVRMenager, bool PCMenager)
 {
     _Import     = Data_Import.Singleton();
     _Electronic = ElectronicMenager;
     _Mechanic   = MechanicMenager;
     _NVR        = NVRMenager;
     _PC         = PCMenager;
 }
Beispiel #6
0
        private void LoadToTable()
        {
            DataTable Actions = new DataTable();

            string[] Klucz;
            string   ActionKey;
            int      StartMonth;
            string   Revision;

            DataGridView Actual    = (DataGridView)MainProgram.Self.TabControl.Controls.Find("gd_ActualAction", true).First();
            DataGridView CarryOver = (DataGridView)MainProgram.Self.TabControl.Controls.Find("gd_CarryOverAction", true).First();
            decimal      Year      = ((NumericUpDown)MainProgram.Self.TabControl.Controls.Find("num_SummaryDetailYear", true).First()).Value;
            CheckBox     Active    = (CheckBox)MainProgram.Self.TabControl.Controls.Find("CB_Active1", true).First();
            CheckBox     Idea      = (CheckBox)MainProgram.Self.TabControl.Controls.Find("CB_Idea1", true).First();
            ComboBox     Leader    = (ComboBox)MainProgram.Self.TabControl.Controls.Find("Comb_SummDetLeader", true).First();
            ComboBox     Devision  = (ComboBox)MainProgram.Self.TabControl.Controls.Find("Comb_SummDetDevision", true).First();
            CheckBox     Savings   = (CheckBox)MainProgram.Self.TabControl.Controls.Find("cb_SDOptionSavings", true).First();
            CheckBox     Quantity  = (CheckBox)MainProgram.Self.TabControl.Controls.Find("cb_SDOptionQuantity", true).First();
            CheckBox     ECCC      = (CheckBox)MainProgram.Self.TabControl.Controls.Find("cb_SDOptionECCC", true).First();
            CheckBox     Positive  = (CheckBox)MainProgram.Self.TabControl.Controls.Find("CB_Positive1", true).First();
            CheckBox     Negative  = (CheckBox)MainProgram.Self.TabControl.Controls.Find("CB_Negative1", true).First();

            Actual.Rows.Clear();
            CarryOver.Rows.Clear();

            Data_Import.Singleton().Load_TxtToDataTable2(ref Actions, "Action");

            StartMonth = WhatCanBePresented(Year);
            Revision   = WhatRevisionApprove(Year);

            //Tworzenie kluczy
            Klucz = CreateKey(Active.Checked, Idea.Checked, Year, Leader.Text, Devision.Text, Positive.Checked, Negative.Checked);

            foreach (DataRow ActionRow in Actions.Rows)
            {
                ActionKey = CreateActionKey(ActionRow, Active.Checked, Idea.Checked, Devision.Text, Leader.Text, Positive.Checked, Negative.Checked, Year);

                if (Klucz[0] == ActionKey || Klucz[1] == ActionKey || Klucz[2] == ActionKey)
                {
                    LoadActionSD(ActionRow, false, Savings.Checked, Quantity.Checked, ECCC.Checked, StartMonth, Revision);
                }
                else if (Klucz[3] == ActionKey)
                {
                    LoadActionSD(ActionRow, true, Savings.Checked, Quantity.Checked, ECCC.Checked, StartMonth, Revision);
                }
            }

            DataGridView Table = (DataGridView)MainProgram.Self.TabControl.Controls.Find("gd_CarryOverAction", true).First();

            Table.Columns["Name"].DefaultCellStyle.BackColor   = Color.FromArgb(252, 228, 214);
            Table.Columns["Option"].DefaultCellStyle.BackColor = Color.White;
            Table.Columns["Sum"].DefaultCellStyle.BackColor    = Color.FromArgb(244, 176, 132);

            Table = (DataGridView)MainProgram.Self.TabControl.Controls.Find("gd_ActualAction", true).First();
            Table.Columns["Name"].DefaultCellStyle.BackColor   = Color.FromArgb(252, 228, 214);
            Table.Columns["Option"].DefaultCellStyle.BackColor = Color.White;
            Table.Columns["Sum"].DefaultCellStyle.BackColor    = Color.FromArgb(244, 176, 132);
        }
Beispiel #7
0
        public LoadAccess(ComboBox AllPerson)
        {
            DataTable Access = new DataTable();

            Data_Import.Singleton().Load_TxtToDataTable2(ref Access, "Access");

            AllPerson.Items.Clear();
            AllPerson.Text = "";

            foreach (DataRow Row in Access.Rows)
            {
                AllPerson.Items.Add(Row["Name"]);
            }
        }
Beispiel #8
0
        public void PlanTable()
        {
            DataTable Kurs = new DataTable();
            DataRow   KursRow;
            decimal   Year;

            Year = MainProgram.Self.sdOptions1.GetYear();
            Data_Import.Singleton().Load_TxtToDataTable2(ref Kurs, "Kurs");

            KursRow = Kurs.Select(string.Format("Year LIKE '%{0}%'", Year.ToString())).FirstOrDefault();

            PlanTableCheck(dgv_SavingSum, dgv_PlanActual, KursRow);
            PlanTableCheck(dgv_CarryOverSum, dgv_PlanCarryOver, KursRow);
            PlanTableCheck(dgv_ECCCSum, dgv_PlanECCC, KursRow);
        }
Beispiel #9
0
        public DeleteAccount(TextBox BIZ)
        {
            DataTable Account = new DataTable();
            DataRow   FoundRow;

            Data_Import.Singleton().Load_TxtToDataTable2(ref Account, "Access");

            FoundRow = Account.Select(string.Format("Name LIKE '%{0}%'", BIZ.Text)).FirstOrDefault();
            if (FoundRow != null)
            {
                Account.Rows.Remove(FoundRow);
            }

            Data_Import.Singleton().Save_DataTableToTXT(ref Account, "Access");
        }
Beispiel #10
0
        private void TargetsLoad()
        {
            DataTable Targets = new DataTable();
            DataRow   TargetsRow;
            int       Revision = 5;

            Data_Import.Singleton().Load_TxtToDataTable2(ref Targets, "Kurs");

            TargetsRow = Targets.Select(string.Format("Year LIKE '%{0}%'", _Year.ToString())).First();
            if (TargetsRow != null)
            {
                string[] DM   = (TargetsRow["DM"].ToString()).Split('/');
                string[] PC   = (TargetsRow["PC"].ToString()).Split('/');
                string[] Ele  = (TargetsRow["Ele"].ToString()).Split('/');
                string[] Mech = (TargetsRow["Mech"].ToString()).Split('/');
                string[] NVR  = (TargetsRow["NVR"].ToString()).Split('/');

                for (int counter = 4; counter >= 0; counter--)
                {
                    if (DM[counter] != "")
                    {
                        Revision = counter;
                        break;
                    }
                }

                if (Revision != 5)
                {
                    ((ComboBox)MainProgram.Self.TabControl.Controls.Find("Comb_AdminTargetsRewizja", true).First()).SelectedIndex = Revision;
                    ((TextBox)MainProgram.Self.TabControl.Controls.Find("Tb_AdminTargetsDM", true).First()).Text          = DM[Revision];
                    ((TextBox)MainProgram.Self.TabControl.Controls.Find("Tb_AdminTargetsPercent", true).First()).Text     = PC[Revision];
                    ((TextBox)MainProgram.Self.TabControl.Controls.Find("Tb_AdminTargetsElePercent", true).First()).Text  = Ele[Revision];
                    ((TextBox)MainProgram.Self.TabControl.Controls.Find("Tb_AdminTargetsMechPercent", true).First()).Text = Mech[Revision];
                    ((TextBox)MainProgram.Self.TabControl.Controls.Find("Tb_AdminTargetsNVRPercent", true).First()).Text  = NVR[Revision];
                }
            }
            if (Revision == 5)
            {
                ((TextBox)MainProgram.Self.TabControl.Controls.Find("Tb_AdminTargetsPercent", true).First()).Text             = "";
                ((TextBox)MainProgram.Self.TabControl.Controls.Find("Tb_AdminTargetsElePercent", true).First()).Text          = "";
                ((TextBox)MainProgram.Self.TabControl.Controls.Find("Tb_AdminTargetsMechPercent", true).First()).Text         = "";
                ((TextBox)MainProgram.Self.TabControl.Controls.Find("Tb_AdminTargetsNVRPercent", true).First()).Text          = "";
                ((ComboBox)MainProgram.Self.TabControl.Controls.Find("Comb_AdminTargetsRewizja", true).First()).SelectedIndex = 0;
                ((TextBox)MainProgram.Self.TabControl.Controls.Find("Tb_AdminTargetsDM", true).First()).Text = "";
            }
        }
Beispiel #11
0
        private string WhatRevisionApprove(decimal Year)
        {
            DataTable Frozen = new DataTable();
            DataRow   FrozenYear;
            string    Revision = "";

            Data_Import.Singleton().Load_TxtToDataTable2(ref Frozen, "Frozen");
            FrozenYear = Frozen.Select(string.Format("Year LIKE '%{0}%'", Year.ToString())).First();

            if (Year < DateTime.UtcNow.Year)
            {
                Revision = "USE";
            }
            else if (Year > DateTime.UtcNow.Year)
            {
                if (FrozenYear["BU"].ToString() == "Approve" || FrozenYear["BU"].ToString() == "Open" || FrozenYear["BU"].ToString() == "Close")
                {
                    Revision = "BU";
                }
                else
                {
                    Revision = "";
                }
            }
            else
            {
                if (FrozenYear["BU"].ToString() == "Approve" || FrozenYear["BU"].ToString() == "Open")
                {
                    Revision = "BU";
                }
                if (FrozenYear["EA1"].ToString() == "Approve" || FrozenYear["EA1"].ToString() == "Open")
                {
                    Revision = "EA1";
                }
                if (FrozenYear["EA2"].ToString() == "Approve" || FrozenYear["EA2"].ToString() == "Open")
                {
                    Revision = "EA2";
                }
                if (FrozenYear["EA3"].ToString() == "Approve" || FrozenYear["EA3"].ToString() == "Open")
                {
                    Revision = "EA3";
                }
            }

            return(Revision);
        }
Beispiel #12
0
        private void LoadComboBox()
        {
            DataTable ProjectList = new DataTable();

            DataRow[] ProjectYear;

            Data_Import.Singleton().Load_TxtToDataTable2(ref ProjectList, "PlatformList");

            ProjectYear = ProjectList.Select(string.Format("StartYear LIKE '%{0}%'", _year.Value.ToString())).ToArray();

            if (ProjectYear != null)
            {
                foreach (DataRow Row in ProjectYear)
                {
                    _project.Items.Add(Row["Project"].ToString());
                }
            }
        }
Beispiel #13
0
        private void Load()
        {
            DataTable Access = new DataTable();

            Data_Import.Singleton().Load_TxtToDataTable2(ref Access, "Access");

            if (_AddAll)
            {
                _ActionLeader.Items.Add("All");
            }

            if (Users.Singleton.Role != "PCMenager")
            {
                _ActionLeader.Items.Add(Users.Singleton.Name);
            }

            foreach (DataRow AccessRow in Access.Rows)
            {
                if (AccessRow["Name"].ToString() != Users.Singleton.Name)
                {
                    if (Users.Singleton.Role == "Admin" || Users.Singleton.Role == "PCMenager")
                    {
                        if (Users.Singleton.Name != AccessRow["FullName"].ToString())
                        {
                            _ActionLeader.Items.Add(AccessRow["FullName"].ToString());
                        }
                        else if (Users.Singleton.Role == "EleMenager" && AccessRow["ActionEle"].ToString() == "true" && AccessRow["Role"].ToString() != "PCMenager")
                        {
                            _ActionLeader.Items.Add(AccessRow["FullName"].ToString());
                        }
                        else if (Users.Singleton.Role == "MechMenager" && AccessRow["ActionMech"].ToString() == "true" && AccessRow["Role"].ToString() != "PCMenager")
                        {
                            _ActionLeader.Items.Add(AccessRow["FullName"].ToString());
                        }
                        else if (Users.Singleton.Role == "NVRMenager" && AccessRow["ActionNVR"].ToString() == "true" && AccessRow["Role"].ToString() != "PCMenager")
                        {
                            _ActionLeader.Items.Add(AccessRow["FullName"].ToString());
                        }
                    }
                }
            }
            _ActionLeader.SelectedIndex = 0;
        }
Beispiel #14
0
        private void LoadPNCToTree()
        {
            DataTable PNCTable = new DataTable();

            DataRow[] ProjectPNC;

            Data_Import.Singleton().Load_TxtToDataTable2(ref PNCTable, "PlatformPNCList");

            ProjectPNC = PNCTable.Select(string.Format("Project LIKE '%{0}%'", _project.SelectedItem.ToString())).ToArray();

            AddTreeNodes(_project.SelectedItem.ToString());

            if (ProjectPNC != null)
            {
                foreach (DataRow Row in ProjectPNC)
                {
                    string PNCtoAdd = Row["NewPNC"].ToString() + "   (" + Row["OldPNC"].ToString() + ")";
                    AddToTreeNodes(_project.SelectedItem.ToString(), PNCtoAdd);
                }
            }
        }
Beispiel #15
0
        private decimal Load_ECCCKurs(string StartYear)
        {
            decimal   Kurs     = 0;
            DataTable AllKursy = new DataTable();
            DataRow   KursyYear;

            if (StartYear.Length != 4)
            {
                StartYear = StartYear.Remove(0, 3);
            }

            Data_Import.Singleton().Load_TxtToDataTable2(ref AllKursy, "Kurs");
            KursyYear = AllKursy.Select(string.Format("Year LIKE '%{0}%'", StartYear)).FirstOrDefault();
            if (KursyYear != null)
            {
                if (KursyYear["ECCC"] != null && KursyYear["ECCC"].ToString() != "")
                {
                    Kurs = decimal.Parse(KursyYear["ECCC"].ToString());
                }
            }

            return(Kurs);
        }
Beispiel #16
0
        private int WhatCanBePresented(decimal Year)
        {
            //Wartości od 1 do 12 - miesiąc w aktualnym roku;
            //Wartość 0 - Poprzedni rok (tylko Actual)
            //Wartość -1 - Nastęny rok, tylko BU
            int       StartMonth = -5;
            DataTable Frozen     = new DataTable();
            DataRow   FrozenYear;

            Data_Import.Singleton().Load_TxtToDataTable2(ref Frozen, "Frozen");

            if (Year < DateTime.UtcNow.Year)
            {
                StartMonth = 0;
            }
            else if (Year > DateTime.UtcNow.Year)
            {
                StartMonth = -1;
            }
            else
            {
                FrozenYear = Frozen.Select(string.Format("Year LIKE '%{0}%'", Year.ToString())).First();
                for (int counter = 1; counter <= 12; counter++)
                {
                    if (FrozenYear[counter.ToString()].ToString() == "Approve" || FrozenYear[counter.ToString()].ToString() == "Open")
                    {
                        StartMonth = counter;
                    }
                }
                if (StartMonth == -5 && Year == DateTime.UtcNow.Year)
                {
                    StartMonth = -1;
                }
            }

            return(StartMonth);
        }
Beispiel #17
0
        public DataRow Load()
        {
            DataTable AllAction = new DataTable();

            DataRow[] FoundRows;
            DataRow   FoundRow;

            Data_Import.Singleton().Load_TxtToDataTable2(ref AllAction, "Action");

            FoundRow = AllAction.NewRow();

            FoundRows = AllAction.Select(string.Format("Name LIKE '%{0}%'", _ActionName)).ToArray();

            foreach (DataRow Row in FoundRows)
            {
                if (Row["StartYear"].ToString() == _Year.ToString() || Row["StartYear"].ToString() == "SA/" + _Year.ToString())
                {
                    FoundRow.ItemArray = Row.ItemArray.Clone() as object[];
                    return(FoundRow);
                }
            }

            return(FoundRow);
        }
Beispiel #18
0
        private void Save()
        {
            DataTable AllAction = new DataTable();

            DataRow[] FoundRows;
            string[]  AllString;
            string[]  OnePNC;
            string[]  SumQuantity;
            string[]  SumSavings;
            decimal   AllQuantity = 0;
            decimal   AllSavings  = 0;
            decimal   AllECCC     = 0;

            Data_Import.Singleton().Load_TxtToDataTable2(ref AllAction, "Action");

            FoundRows = AllAction.Select(string.Format("Name LIKE '%{0}%'", _ActionName)).ToArray();

            foreach (DataRow Row in FoundRows)
            {
                if (Row["StartYear"].ToString() == _Year.ToString() || Row["StartYear"].ToString() == "SA/" + _Year.ToString())
                {
                    if (_SingleAction)
                    {
                        Row["StartYear"] = "SA/" + _Year;
                    }
                    Row["Comment"] = _Comment;

                    AllString     = Row["PerUSE"].ToString().Split('/');
                    Row["PerUSE"] = "";


                    for (int counter = 0; counter < AllString.Length - 1; counter++)
                    {
                        OnePNC             = AllString[counter].Split('|');
                        AllString[counter] = UpdateDataForTable(OnePNC);
                        Row["PerUse"]     += AllString[counter] + "/";
                    }



                    SumQuantity            = Row["CalcUseQuantity"].ToString().Split('/');
                    SumSavings             = Row["CalcUSESaving"].ToString().Split('/');
                    Row["CalcUseQuantity"] = "";
                    Row["CalcUSESaving"]   = "";
                    Row["CalcUSEECCC"]     = "";


                    //Sumowanie wszystkiego do wyświetlania w akcji
                    for (int counter = 1; counter <= 12; counter++)
                    {
                        if (_SumTable[counter.ToString(), 0].Value.ToString() != "" && _SumTable[counter.ToString(), 0].Value.ToString() != "0")
                        {
                            AllQuantity            += decimal.Parse(_SumTable[counter.ToString(), 0].Value.ToString());
                            Row["CalcUseQuantity"] += _SumTable[counter.ToString(), 0].Value.ToString();

                            AllSavings           += decimal.Parse(_SumTable[counter.ToString(), 1].Value.ToString());
                            Row["CalcUSESaving"] += Math.Round(decimal.Parse(_SumTable[counter.ToString(), 1].Value.ToString()), 0, MidpointRounding.AwayFromZero).ToString();

                            if (_SumTable[counter.ToString(), 1].Value.ToString() != "" && _SumTable[counter.ToString(), 1].Value.ToString() != "0")
                            {
                                AllECCC            += decimal.Parse(_SumTable[counter.ToString(), 1].Value.ToString());
                                Row["CalcUSEECCC"] += Math.Round(decimal.Parse(_SumTable[counter.ToString(), 2].Value.ToString()), 0, MidpointRounding.AwayFromZero).ToString();
                            }
                        }
                        Row["CalcUseQuantity"] += "/";
                        Row["CalcUSESaving"]   += "/";
                        Row["CalcUSEECCC"]     += "/";
                    }
                    Row["CalcUseQuantity"] += AllQuantity.ToString() + "/";
                    Row["CalcUSESaving"]   += Math.Round(AllSavings, 0, MidpointRounding.AwayFromZero).ToString() + "/";
                    Row["CalcUSEECCC"]     += Math.Round(AllECCC, 0, MidpointRounding.AwayFromZero).ToString() + "/";
                }
            }
            Data_Import.Singleton().Save_DataTableToTXT2(ref AllAction, "Action");
        }
Beispiel #19
0
        public SaveAccess()
        {
            DataTable Access = new DataTable();
            DataRow   FoundRow;

            ComboBox cb_comBox_AdminAccess = (ComboBox)MainProgram.Self.TabControl.Controls.Find("comBox_AdminAccess", true).First();

            Data_Import.Singleton().Load_TxtToDataTable2(ref Access, "Access");

            if (cb_comBox_AdminAccess.Text != "")
            {
                FoundRow = Access.Select(string.Format("Name LIKE '%{0}%'", cb_comBox_AdminAccess.Text)).FirstOrDefault();

                FoundRow["FullName"] = ((TextBox)MainProgram.Self.TabControl.Controls.Find("Tb_AdminAccessFullName", true).First()).Text;

                FoundRow["Mail"] = ((TextBox)MainProgram.Self.TabControl.Controls.Find("Tb_AdminAccess_Email", true).First()).Text;

                if (((ComboBox)MainProgram.Self.TabControl.Controls.Find("Cb_AdminAccessMenager", true).First()).Text == "Employee")
                {
                    FoundRow["Role"] = "Employee";
                }
                else if (((ComboBox)MainProgram.Self.TabControl.Controls.Find("Cb_AdminAccessMenager", true).First()).Text == "Electronic")
                {
                    FoundRow["Role"] = "EleMenager";
                }
                else if (((ComboBox)MainProgram.Self.TabControl.Controls.Find("Cb_AdminAccessMenager", true).First()).Text == "Mechanic")
                {
                    FoundRow["Role"] = "MechMenager";
                }
                else if (((ComboBox)MainProgram.Self.TabControl.Controls.Find("Cb_AdminAccessMenager", true).First()).Text == "NVR")
                {
                    FoundRow["Role"] = "NVRMenager";
                }
                else if (((ComboBox)MainProgram.Self.TabControl.Controls.Find("Cb_AdminAccessMenager", true).First()).Text == "PC")
                {
                    FoundRow["Role"] = "PCMenager";
                }
                else if (((ComboBox)MainProgram.Self.TabControl.Controls.Find("Cb_AdminAccessMenager", true).First()).Text == "Admin")
                {
                    FoundRow["Role"] = "Admin";
                }

                FoundRow["tab_Action"] = ((CheckBox)MainProgram.Self.TabControl.Controls.Find("cb_AdminTabAction", true).First()).Checked.ToString().ToLower();

                if (((RadioButton)MainProgram.Self.TabControl.Controls.Find("radbut_AdminViwer", true).First()).Checked)
                {
                    FoundRow["Action"] = "View";
                }
                else if (((RadioButton)MainProgram.Self.TabControl.Controls.Find("radbut_AdminDevelop", true).First()).Checked)
                {
                    FoundRow["Action"] = "Developer";
                }

                FoundRow["ActionEle"] = ((CheckBox)MainProgram.Self.TabControl.Controls.Find("cb_AdminElectronic", true).First()).Checked.ToString().ToLower();

                FoundRow["ActionMech"] = ((CheckBox)MainProgram.Self.TabControl.Controls.Find("cb_AdminMechanic", true).First()).Checked.ToString().ToLower();

                FoundRow["ActionNVR"] = ((CheckBox)MainProgram.Self.TabControl.Controls.Find("cb_AdminNVR", true).First()).Checked.ToString().ToLower();

                FoundRow["tab_Summary"] = ((CheckBox)MainProgram.Self.TabControl.Controls.Find("cb_AdminTabSummary", true).First()).Checked.ToString().ToLower();

                FoundRow["tab_Statistic"] = ((CheckBox)MainProgram.Self.TabControl.Controls.Find("cb_AdminTabStatistic", true).First()).Checked.ToString().ToLower();

                FoundRow["tab_Platform"] = ((CheckBox)MainProgram.Self.TabControl.Controls.Find("cb_AdminTabPlatform", true).First()).Checked.ToString().ToLower();

                FoundRow["tab_STK"] = ((CheckBox)MainProgram.Self.TabControl.Controls.Find("cb_AdminTabSTK", true).First()).Checked.ToString().ToLower();

                FoundRow["tab_Quantity"] = ((CheckBox)MainProgram.Self.TabControl.Controls.Find("cb_AdminTabQuantity", true).First()).Checked.ToString().ToLower();

                FoundRow["tab_Admin"] = ((CheckBox)MainProgram.Self.TabControl.Controls.Find("cb_AdminTabAdmin", true).First()).Checked.ToString().ToLower();

                FoundRow["EleApprove"] = ((CheckBox)MainProgram.Self.TabControl.Controls.Find("cb_Admin_RapEle", true).First()).Checked.ToString().ToLower();

                FoundRow["MechApprove"] = ((CheckBox)MainProgram.Self.TabControl.Controls.Find("cb_Admin_RapMech", true).First()).Checked.ToString().ToLower();

                FoundRow["NVRApprove"] = ((CheckBox)MainProgram.Self.TabControl.Controls.Find("cb_Admin_RapNVR", true).First()).Checked.ToString().ToLower();

                FoundRow["PCApprove"] = ((CheckBox)MainProgram.Self.TabControl.Controls.Find("cb_Admin_RapPC", true).First()).Checked.ToString().ToLower();
            }
            else
            {
                return;
            }

            Data_Import.Singleton().Save_DataTableToTXT2(ref Access, "Access");
        }
Beispiel #20
0
        public void GrupingPNC_Month()
        {
            decimal All      = 0;
            decimal DMD      = 0;
            decimal D45      = 0;
            decimal DMD_FS   = 0;
            decimal D45_FS   = 0;
            decimal DMD_FI   = 0;
            decimal D45_FI   = 0;
            decimal DMD_BI   = 0;
            decimal D45_BI   = 0;
            decimal DMD_FSBU = 0;
            decimal D45_FSBU = 0;

            Data_Import.Singleton().Load_TxtToDataTable2(ref PNC, "PNCMonth");

            Data_Import.Singleton().Load_TxtToDataTable2(ref SumPNC, "SumPNC");

            if (!PNC.Columns.Contains(_Month.ToString() + "/" + _Year.ToString()))
            {
                MessageBox.Show("Missing Data for: " + _Month.ToString() + "/" + _Year.ToString(), "Attention!");
                return;
            }

            if (SumPNC.Columns.Contains(_Month.ToString() + "/" + _Year.ToString()))
            {
                SumPNC.Columns.Remove(_Month.ToString() + "/" + _Year.ToString());
            }
            SumPNC.Columns.Add(_Month.ToString() + "/" + _Year.ToString());

            foreach (DataRow PNCRow in PNC.Rows)
            {
                if (PNCRow[_Month.ToString() + "/" + _Year.ToString()] != null && PNCRow[_Month.ToString() + "/" + _Year.ToString()].ToString() != "")
                {
                    decimal Value = decimal.Parse(PNCRow[_Month.ToString() + "/" + _Year.ToString()].ToString());
                    string  PNC   = PNCRow["PNC"].ToString();

                    //Dodanie do sumy wszystkich PNC
                    All += Value;

                    //Rozbiecie na DMD i D45
                    if (PNC.Remove(0, 3).Remove(1, 5) == "5")
                    {
                        //Dodanie do Sumy DMD
                        DMD += Value;

                        //Sprawdzenie czy FS, FI, BI/BU lub FSBU

                        switch (PNC.Remove(0, 4).Remove(1, 4))
                        {
                        case "1":
                            DMD_FS += Value;
                            break;

                        case "2":
                            DMD_BI += Value;
                            break;

                        case "3":
                            DMD_FI += Value;
                            break;

                        case "4":
                            DMD_FSBU += Value;
                            break;

                        default:
                            break;
                        }
                    }
                    else
                    {
                        //Dodanie do Sumy D45
                        D45 += Value;

                        switch (PNC.Remove(0, 4).Remove(1, 4))
                        {
                        case "5":
                            D45_FS += Value;
                            break;

                        case "6":
                            D45_BI += Value;
                            break;

                        case "7":
                            D45_FI += Value;
                            break;

                        case "8":
                            D45_FSBU += Value;
                            break;

                        default:
                            break;
                        }
                    }
                }
            }

            foreach (DataRow Row in SumPNC.Rows)
            {
                switch (Row["PNC"].ToString())
                {
                case "All":
                    Row[_Month.ToString() + "/" + _Year.ToString()] = All;
                    break;

                case "DMD":
                    Row[_Month.ToString() + "/" + _Year.ToString()] = DMD;
                    break;

                case "D45":
                    Row[_Month.ToString() + "/" + _Year.ToString()] = D45;
                    break;

                case "DMD_FS":
                    Row[_Month.ToString() + "/" + _Year.ToString()] = DMD_FS;
                    break;

                case "D45_FS":
                    Row[_Month.ToString() + "/" + _Year.ToString()] = D45_FS;
                    break;

                case "DMD_FI":
                    Row[_Month.ToString() + "/" + _Year.ToString()] = DMD_FI;
                    break;

                case "D45_FI":
                    Row[_Month.ToString() + "/" + _Year.ToString()] = D45_FI;
                    break;

                case "DMD_BI":
                    Row[_Month.ToString() + "/" + _Year.ToString()] = DMD_BI;
                    break;

                case "D45_BI":
                    Row[_Month.ToString() + "/" + _Year.ToString()] = D45_BI;
                    break;

                case "DMD_FSBU":
                    Row[_Month.ToString() + "/" + _Year.ToString()] = DMD_FSBU;
                    break;

                case "D45_FSBU":
                    Row[_Month.ToString() + "/" + _Year.ToString()] = D45_FSBU;
                    break;

                default:
                    break;
                }
            }

            Data_Import.Singleton().Save_DataTableToTXT2(ref SumPNC, "SumPNC");
        }
Beispiel #21
0
        public LoadPerson(ComboBox Person)
        {
            DataTable Access = new DataTable();
            DataRow   FoundAccess;

            Data_Import.Singleton().Load_TxtToDataTable2(ref Access, "Access");

            FoundAccess = Access.Select(string.Format("Name LIKE '%{0}%'", Person.Text)).FirstOrDefault();

            if (FoundAccess == null)
            {
                return;
            }

            ((TextBox)MainProgram.Self.TabControl.Controls.Find("Tb_AdminAccessFullName", true).First()).Text = FoundAccess["FullName"].ToString();
            ((TextBox)MainProgram.Self.TabControl.Controls.Find("Tb_AdminAccess_Email", true).First()).Text   = FoundAccess["Mail"].ToString();

            if (FoundAccess["Role"].ToString() == "Employee")
            {
                ((ComboBox)MainProgram.Self.TabControl.Controls.Find("Cb_AdminAccessMenager", true).First()).SelectedIndex = 0;
            }
            else if (FoundAccess["Role"].ToString() == "EleMenager")
            {
                ((ComboBox)MainProgram.Self.TabControl.Controls.Find("Cb_AdminAccessMenager", true).First()).SelectedIndex = 1;
            }
            else if (FoundAccess["Role"].ToString() == "MechMenager")
            {
                ((ComboBox)MainProgram.Self.TabControl.Controls.Find("Cb_AdminAccessMenager", true).First()).SelectedIndex = 2;
            }
            else if (FoundAccess["Role"].ToString() == "NVRMenager")
            {
                ((ComboBox)MainProgram.Self.TabControl.Controls.Find("Cb_AdminAccessMenager", true).First()).SelectedIndex = 3;
            }
            else if (FoundAccess["Role"].ToString() == "PCMenager")
            {
                ((ComboBox)MainProgram.Self.TabControl.Controls.Find("Cb_AdminAccessMenager", true).First()).SelectedIndex = 4;
            }
            else if (FoundAccess["Role"].ToString() == "Admin")
            {
                ((ComboBox)MainProgram.Self.TabControl.Controls.Find("Cb_AdminAccessMenager", true).First()).SelectedIndex = 5;
            }

            if (FoundAccess["Action"].ToString() == "Developer")
            {
                ((RadioButton)MainProgram.Self.TabControl.Controls.Find("radbut_AdminViwer", true).First()).Checked   = false;
                ((RadioButton)MainProgram.Self.TabControl.Controls.Find("radbut_AdminDevelop", true).First()).Checked = true;
            }
            else
            {
                ((RadioButton)MainProgram.Self.TabControl.Controls.Find("radbut_AdminViwer", true).First()).Checked   = true;
                ((RadioButton)MainProgram.Self.TabControl.Controls.Find("radbut_AdminDevelop", true).First()).Checked = false;
            }

            ((CheckBox)MainProgram.Self.TabControl.Controls.Find("cb_AdminTabAction", true).First()).Checked    = Convert.ToBoolean(FoundAccess["tab_Action"].ToString());
            ((CheckBox)MainProgram.Self.TabControl.Controls.Find("cb_AdminElectronic", true).First()).Checked   = Convert.ToBoolean(FoundAccess["ActionEle"].ToString());
            ((CheckBox)MainProgram.Self.TabControl.Controls.Find("cb_AdminMechanic", true).First()).Checked     = Convert.ToBoolean(FoundAccess["ActionMech"].ToString());
            ((CheckBox)MainProgram.Self.TabControl.Controls.Find("cb_AdminNVR", true).First()).Checked          = Convert.ToBoolean(FoundAccess["ActionNVR"].ToString());
            ((CheckBox)MainProgram.Self.TabControl.Controls.Find("cb_AdminTabSummary", true).First()).Checked   = Convert.ToBoolean(FoundAccess["tab_Summary"].ToString());
            ((CheckBox)MainProgram.Self.TabControl.Controls.Find("cb_AdminTabStatistic", true).First()).Checked = Convert.ToBoolean(FoundAccess["tab_Statistic"].ToString());
            ((CheckBox)MainProgram.Self.TabControl.Controls.Find("cb_AdminTabPlatform", true).First()).Checked  = Convert.ToBoolean(FoundAccess["tab_Platform"].ToString());
            ((CheckBox)MainProgram.Self.TabControl.Controls.Find("cb_AdminTabSTK", true).First()).Checked       = Convert.ToBoolean(FoundAccess["tab_STK"].ToString());
            ((CheckBox)MainProgram.Self.TabControl.Controls.Find("cb_AdminTabQuantity", true).First()).Checked  = Convert.ToBoolean(FoundAccess["tab_Quantity"].ToString());
            ((CheckBox)MainProgram.Self.TabControl.Controls.Find("cb_AdminTabAdmin", true).First()).Checked     = Convert.ToBoolean(FoundAccess["tab_Admin"].ToString());
            ((CheckBox)MainProgram.Self.TabControl.Controls.Find("cb_Admin_RapEle", true).First()).Checked      = Convert.ToBoolean(FoundAccess["EleApprove"].ToString());
            ((CheckBox)MainProgram.Self.TabControl.Controls.Find("cb_Admin_RapMech", true).First()).Checked     = Convert.ToBoolean(FoundAccess["MechApprove"].ToString());
            ((CheckBox)MainProgram.Self.TabControl.Controls.Find("cb_Admin_RapNVR", true).First()).Checked      = Convert.ToBoolean(FoundAccess["NVRApprove"].ToString());
            ((CheckBox)MainProgram.Self.TabControl.Controls.Find("cb_Admin_RapPC", true).First()).Checked       = Convert.ToBoolean(FoundAccess["PCApprove"].ToString());
        }
Beispiel #22
0
        /// <summary>
        /// Ładowanie Zrzutu z IDB do DataTable i zapis tej Tabeli do Bazy danych
        /// </summary>
        public IDBLoadDataBase()
        {
            _Import = Data_Import.Singleton();

            LoadDataBase();
        }
Beispiel #23
0
        public void UpdateReporting(object state)
        {
            lock (this)
            {
                DataTable Frozen = new DataTable();
                DataRow   FrozenYear;
                decimal   Year;
                bool      CanBeApprove = false;

                Data_Import.Singleton().Load_TxtToDataTable2(ref Frozen, "Frozen");
                Year = MainProgram.Self.sdOptions1.GetYear();

                FrozenYear = Frozen.Select(string.Format("Year LIKE '%{0}%'", Year.ToString())).First();

                //MessageBox.Show("zrobił");

                foreach (DataColumn Column in Frozen.Columns)
                {
                    if (Column.ColumnName != "Year" && Column.ColumnName != "EleApp" && Column.ColumnName != "MechApp" && Column.ColumnName != "NVRApp")
                    {
                        if (FrozenYear[Column].ToString() == "Open")
                        {
                            CanBeApprove = true;
                            break;
                        }
                    }
                }

                if (CanBeApprove && Users.Singleton.ElectronicApprove && FrozenYear["EleApp"].ToString() != "Approve")
                {
                    _sDReporting.Invoke(_sDReporting.myDeleate, new object[] { true, "Electronic" });
                }
                else
                {
                    _sDReporting.Invoke(_sDReporting.myDeleate, new object[] { false, "Electronic" });
                }

                if (CanBeApprove && Users.Singleton.MechanicApprove && FrozenYear["MechApp"].ToString() != "Approve")
                {
                    _sDReporting.Invoke(_sDReporting.myDeleate, new object[] { true, "Mechanic" });
                }
                else
                {
                    _sDReporting.Invoke(_sDReporting.myDeleate, new object[] { false, "Mechanic" });
                }

                if (CanBeApprove && Users.Singleton.NVRApprove && FrozenYear["NVRApp"].ToString() != "Approve")
                {
                    _sDReporting.Invoke(_sDReporting.myDeleate, new object[] { true, "NVR" });
                }
                else
                {
                    _sDReporting.Invoke(_sDReporting.myDeleate, new object[] { false, "NVR" });
                }

                if (CanBeApprove && Users.Singleton.PCApprove && FrozenYear["EleApp"].ToString() == "Approve" && FrozenYear["MechApp"].ToString() != "Approve" && FrozenYear["NVRApp"].ToString() != "Approve")
                {
                    _sDReporting.Invoke(_sDReporting.myDeleate, new object[] { true, "PC" });
                }
                else
                {
                    _sDReporting.Invoke(_sDReporting.myDeleate, new object[] { false, "PC" });
                }

                if (Users.Singleton.PCApprove)
                {
                    if (FrozenYear["EleApp"].ToString() == "Approve")
                    {
                        _sDReporting.Invoke(_sDReporting.myDeleate2, new object[] { true, "Electronic" });
                    }
                    else
                    {
                        if (Users.Singleton.Role != "Admin")
                        {
                            _sDReporting.Invoke(_sDReporting.myDeleate2, new object[] { false, "Electronic" });
                        }
                    }
                    if (FrozenYear["MechApp"].ToString() == "Approve")
                    {
                        _sDReporting.Invoke(_sDReporting.myDeleate2, new object[] { true, "Mechanic" });
                    }
                    else
                    {
                        if (Users.Singleton.Role != "Admin")
                        {
                            _sDReporting.Invoke(_sDReporting.myDeleate2, new object[] { false, "Mechanic" });
                        }
                    }
                    if (FrozenYear["MechApp"].ToString() == "Approve")
                    {
                        _sDReporting.Invoke(_sDReporting.myDeleate2, new object[] { true, "NVR" });
                    }
                    else
                    {
                        if (Users.Singleton.Role != "Admin")
                        {
                            _sDReporting.Invoke(_sDReporting.myDeleate2, new object[] { false, "PC" });
                        }
                    }
                }
            }
        }
Beispiel #24
0
        public StatisticDMLoad()
        {
            _Import = Data_Import.Singleton();

            LoadData_DM();
        }
        public StatisticQuantityMonthLoad()
        {
            _Import = Data_Import.Singleton();

            LoadData_QuantityMonth();
        }
Beispiel #26
0
        private void TargetSave()
        {
            DataTable Targets = new DataTable();
            DataRow   TargetsRow;
            int       Revision;

            Data_Import.Singleton().Load_TxtToDataTable2(ref Targets, "Kurs");

            TargetsRow = Targets.Select(string.Format("Year LIKE '%{0}%'", _Year.ToString())).First();
            if (TargetsRow != null)
            {
                string[] DM      = (TargetsRow["DM"].ToString()).Split('/');
                string[] PC      = (TargetsRow["PC"].ToString()).Split('/');
                string[] Ele     = (TargetsRow["Ele"].ToString()).Split('/');
                string[] Mech    = (TargetsRow["Mech"].ToString()).Split('/');
                string[] NVR     = (TargetsRow["NVR"].ToString()).Split('/');
                string   DMSum   = "";
                string   PCSum   = "";
                string   EleSum  = "";
                string   MechSum = "";
                string   NVRSum  = "";

                Revision = ((ComboBox)MainProgram.Self.TabControl.Controls.Find("Comb_AdminTargetsRewizja", true).First()).SelectedIndex;

                DM[Revision]   = ((TextBox)MainProgram.Self.TabControl.Controls.Find("Tb_AdminTargetsDM", true).First()).Text.Replace(" ", "");
                PC[Revision]   = ((TextBox)MainProgram.Self.TabControl.Controls.Find("Tb_AdminTargetsPercent", true).First()).Text.Replace(" ", "");
                Ele[Revision]  = ((TextBox)MainProgram.Self.TabControl.Controls.Find("Tb_AdminTargetsElePercent", true).First()).Text.Replace(" ", "");
                Mech[Revision] = ((TextBox)MainProgram.Self.TabControl.Controls.Find("Tb_AdminTargetsMechPercent", true).First()).Text.Replace(" ", "");
                NVR[Revision]  = ((TextBox)MainProgram.Self.TabControl.Controls.Find("Tb_AdminTargetsNVRPercent", true).First()).Text.Replace(" ", "");

                for (int counter = 0; counter <= 4; counter++)
                {
                    DMSum   = DMSum + DM[counter] + "/";
                    PCSum   = PCSum + PC[counter] + "/";
                    EleSum  = EleSum + Ele[counter] + "/";
                    MechSum = MechSum + Mech[counter] + "/";
                    NVRSum  = NVRSum + NVR[counter] + "/";
                }
                TargetsRow["DM"]   = DMSum;
                TargetsRow["PC"]   = PCSum;
                TargetsRow["Ele"]  = EleSum;
                TargetsRow["Mech"] = MechSum;
                TargetsRow["NVR"]  = NVRSum;
            }
            else
            {
                string Begining;
                string End;

                TargetsRow = Targets.NewRow();

                TargetsRow["PC"]   = ((TextBox)MainProgram.Self.TabControl.Controls.Find("Tb_AdminTargetsPercent", true).First()).Text.Replace(" ", "");
                TargetsRow["Ele"]  = ((TextBox)MainProgram.Self.TabControl.Controls.Find("Tb_AdminTargetsElePercent", true).First()).Text.Replace(" ", "");
                TargetsRow["Mech"] = ((TextBox)MainProgram.Self.TabControl.Controls.Find("Tb_AdminTargetsMechPercent", true).First()).Text.Replace(" ", "");
                TargetsRow["NVR"]  = ((TextBox)MainProgram.Self.TabControl.Controls.Find("Tb_AdminTargetsNVRPercent", true).First()).Text.Replace(" ", "");

                Revision = ((ComboBox)MainProgram.Self.TabControl.Controls.Find("Comb_AdminTargetsRewizja", true).First()).SelectedIndex;

                switch (Revision)
                {
                case 0:
                    Begining = "";
                    End      = "/////";
                    break;

                case 1:
                    Begining = "/";
                    End      = "////";
                    break;

                case 2:
                    Begining = "//";
                    End      = "///";
                    break;

                case 3:
                    Begining = "///";
                    End      = "//";
                    break;

                case 4:
                    Begining = "////";
                    End      = "/";
                    break;

                default:
                    Begining = "";
                    End      = "";
                    break;
                }
                TargetsRow["DM"]   = Begining + ((TextBox)MainProgram.Self.TabControl.Controls.Find("Tb_AdminTargetsDM", true).First()).Text.Replace(" ", "") + End;
                TargetsRow["PC"]   = Begining + ((TextBox)MainProgram.Self.TabControl.Controls.Find("Tb_AdminTargetsPercent", true).First()).Text.Replace(" ", "") + End;
                TargetsRow["Ele"]  = Begining + ((TextBox)MainProgram.Self.TabControl.Controls.Find("Tb_AdminTargetsElePercent", true).First()).Text.Replace(" ", "") + End;
                TargetsRow["Mech"] = Begining + ((TextBox)MainProgram.Self.TabControl.Controls.Find("Tb_AdminTargetsMechPercent", true).First()).Text.Replace(" ", "") + End;
                TargetsRow["NVR"]  = Begining + ((TextBox)MainProgram.Self.TabControl.Controls.Find("Tb_AdminTargetsNVRPercent", true).First()).Text.Replace(" ", "") + End;

                Targets.Rows.Add(TargetsRow);
            }
            Data_Import.Singleton().Save_DataTableToTXT2(ref Targets, "Kurs");
        }
Beispiel #27
0
 public SentTo()
 {
     _Import = Data_Import.Singleton();
 }
Beispiel #28
0
        public SDReportingApproval(string Devision)
        {
            DataTable Frozen = new DataTable();
            DataRow   FrozenRow;
            decimal   Year = MainProgram.Self.sdOptions1.GetYear();
            string    MailTo;
            string    ToReject;

            Data_Import.Singleton().Load_TxtToDataTable2(ref Frozen, "Frozen");
            FrozenRow = Frozen.Select(string.Format("Year LIKE '%{0}%'", Year.ToString())).First();

            ToReject = WhatIsToApprove(FrozenRow);

            if (FrozenRow != null)
            {
                if (Devision == "Electronic Rejected")
                {
                    FrozenRow["EleApp"] = "Close";
                    MailTo = new SentTo(true, false, false, false).SentToList();
                    SentEmail.Instance.Sent_Email(MailTo, new MailInfo().ReportRejected_Devision_Topic(), new MailInfo().ReportRejected_Devision_Body(ToReject));
                }
                else if (Devision == "Mechanic Rejected")
                {
                    FrozenRow["MechApp"] = "Close";
                    MailTo = new SentTo(false, true, false, false).SentToList();
                    SentEmail.Instance.Sent_Email(MailTo, new MailInfo().ReportRejected_Devision_Topic(), new MailInfo().ReportRejected_Devision_Body(ToReject));
                }
                else if (Devision == "NVR Rejected")
                {
                    FrozenRow["NVRApp"] = "Close";
                    MailTo = new SentTo(false, false, true, false).SentToList();
                    SentEmail.Instance.Sent_Email(MailTo, new MailInfo().ReportRejected_Devision_Topic(), new MailInfo().ReportRejected_Devision_Body(ToReject));
                }
                else if (Devision == "Electronic Approve")
                {
                    FrozenRow["EleApp"] = "Approve";
                    MailTo = new SentTo().SentToAdmin();
                    SentEmail.Instance.Sent_Email(MailTo, new MailInfo().RaportApprove_Devision_Topic("Electronic"), new MailInfo().RaportApprove_Devision_Body("Electronic", ToReject));
                    CheckIfAllDevisionApprove(FrozenRow, ToReject);
                }
                else if (Devision == "Mechanic Approve")
                {
                    FrozenRow["MechApp"] = "Approve";
                    MailTo = new SentTo().SentToAdmin();
                    SentEmail.Instance.Sent_Email(MailTo, new MailInfo().RaportApprove_Devision_Topic("Mechanic"), new MailInfo().RaportApprove_Devision_Body("Mechanic", ToReject));
                    CheckIfAllDevisionApprove(FrozenRow, ToReject);
                }
                else if (Devision == "NVR Approve")
                {
                    FrozenRow["NVRApp"] = "Approve";
                    MailTo = new SentTo().SentToAdmin();
                    SentEmail.Instance.Sent_Email(MailTo, new MailInfo().RaportApprove_Devision_Topic("NVR"), new MailInfo().RaportApprove_Devision_Body("NVR", ToReject));
                    CheckIfAllDevisionApprove(FrozenRow, ToReject);
                }
                else if (Devision == "Product Care Approve")
                {
                    FrozenRow["EleApp"]  = "Close";
                    FrozenRow["MechApp"] = "Close";
                    FrozenRow["NVRApp"]  = "Close";
                    FrozenRow[ToReject]  = "Approve";
                    MailTo = new SentTo(true, true, true, true).SentToList();
                    SentEmail.Instance.Sent_Email(MailTo, new MailInfo().RaportApprove_PC_Topic(ToReject), new MailInfo().RaportApprove_PC_Body(ToReject));
                }
            }
            Data_Import.Singleton().Save_DataTableToTXT2(ref Frozen, "Frozen");
        }