Beispiel #1
0
        public ActionResult Index()
        {
            MainModel      mainModel            = new MainModel();
            HomeController home                 = new HomeController();
            DataTable      userDetailsDataTable = new DataTable();
            DB             dbConn               = new DB();



            if (Session["user"] == null)
            {
                return(RedirectToAction("Login", "UserLogin"));
            }
            else
            {
                ///////////////////////Safety Tokens/////////////////////////////////
                DataTable dataTableRepairCount_FactoryEng    = new DataTable();
                DataTable dataTableRepairCount_ProductionEng = new DataTable();
                DataTable dataTableRepairCount_Autonomation  = new DataTable();

                DataTable dataTableRepairCount_MOS     = new DataTable();
                DataTable dataTableRepairCount_RM      = new DataTable();
                DataTable dataTableRepairCount_Quality = new DataTable();
                DataTable dataTableRepairCount_FG      = new DataTable();

                DataTable dataTableRepairCount_Technical = new DataTable();
                DataTable dataTableRepairCount_Cutting   = new DataTable();
                DataTable dataTableRepairCount_HR        = new DataTable();

                DataTable dataTableRepairCount_Operation = new DataTable();

                DataTable dataTableRepairCount_VSM1 = new DataTable();
                DataTable dataTableRepairCount_VSM2 = new DataTable();
                DataTable dataTableRepairCount_VSM3 = new DataTable();
                DataTable dataTableRepairCount_VSM4 = new DataTable();

                DataTable dataTableRepairCount_PreSewing   = new DataTable();
                DataTable dataTableRepairCount_Emblishment = new DataTable();
                DataTable dataTableRepairCount_IE          = new DataTable();
                //////////////////////Sfety Tokens/////////////////////////////////


                //////////////////////Sustainability Tokens/////////////////////////////
                DataTable dataTableRepairCount_FactoryEng_SUS    = new DataTable();
                DataTable dataTableRepairCount_ProductionEng_SUS = new DataTable();
                DataTable dataTableRepairCount_Autonomation_SUS  = new DataTable();

                DataTable dataTableRepairCount_MOS_SUS     = new DataTable();
                DataTable dataTableRepairCount_RM_SUS      = new DataTable();
                DataTable dataTableRepairCount_Quality_SUS = new DataTable();
                DataTable dataTableRepairCount_FG_SUS      = new DataTable();

                DataTable dataTableRepairCount_Technical_SUS = new DataTable();
                DataTable dataTableRepairCount_Cutting_SUS   = new DataTable();
                DataTable dataTableRepairCount_HR_SUS        = new DataTable();

                DataTable dataTableRepairCount_Operation_SUS = new DataTable();

                DataTable dataTableRepairCount_VSM1_SUS = new DataTable();
                DataTable dataTableRepairCount_VSM2_SUS = new DataTable();
                DataTable dataTableRepairCount_VSM3_SUS = new DataTable();
                DataTable dataTableRepairCount_VSM4_SUS = new DataTable();

                DataTable dataTableRepairCount_PreSewing_SUS   = new DataTable();
                DataTable dataTableRepairCount_Emblishment_SUS = new DataTable();
                DataTable dataTableRepairCount_IE_SUS          = new DataTable();
                //////////////////////Sustainability Tokens/////////////////////////////



                using (MySqlConnection mySqlCon = dbConn.DBConnection())
                {
                    mySqlCon.Open();

                    String           qry_listOfTokens = "SELECT UserName,UserType,UserID,UserImage FROM users WHERE UserEmail = '" + Session["user"] + "'";
                    MySqlDataAdapter mySqlDa          = new MySqlDataAdapter(qry_listOfTokens, mySqlCon);
                    mySqlDa.Fill(userDetailsDataTable);



                    String           FacEng             = getReparationDepartmentCount("Factory Engineering", "Safety");
                    MySqlDataAdapter mySqlDa_FactoryEng = new MySqlDataAdapter(FacEng, mySqlCon);
                    mySqlDa_FactoryEng.Fill(dataTableRepairCount_FactoryEng);

                    String           ProdEng = getReparationDepartmentCount("Production Engineering", "Safety");
                    MySqlDataAdapter mySqlDa_ProductionEng = new MySqlDataAdapter(ProdEng, mySqlCon);
                    mySqlDa_ProductionEng.Fill(dataTableRepairCount_ProductionEng);

                    String           Autonomation         = getReparationDepartmentCount("Autonomation", "Safety");
                    MySqlDataAdapter mySqlDa_Autonomation = new MySqlDataAdapter(Autonomation, mySqlCon);
                    mySqlDa_Autonomation.Fill(dataTableRepairCount_Autonomation);


                    ///////////////////////////////////////////////////////////////////////////////////////////////////////
                    String           MOS         = getReparationDepartmentCount("MOS", "Safety");
                    MySqlDataAdapter mySqlDa_MOS = new MySqlDataAdapter(MOS, mySqlCon);
                    mySqlDa_MOS.Fill(dataTableRepairCount_MOS);

                    String           RM         = getReparationDepartmentCount("RM", "Safety");
                    MySqlDataAdapter mySqlDa_RM = new MySqlDataAdapter(RM, mySqlCon);
                    mySqlDa_RM.Fill(dataTableRepairCount_RM);

                    String           Quality         = getReparationDepartmentCount("Quality", "Safety");
                    MySqlDataAdapter mySqlDa_Quality = new MySqlDataAdapter(Quality, mySqlCon);
                    mySqlDa_Quality.Fill(dataTableRepairCount_Quality);

                    String           FG         = getReparationDepartmentCount("FG", "Safety");
                    MySqlDataAdapter mySqlDa_FG = new MySqlDataAdapter(FG, mySqlCon);
                    mySqlDa_FG.Fill(dataTableRepairCount_FG);
                    /////////////////////////////////////////////////////////////////////////////////////////////////////


                    ///////////////////////////////////////////////////////////////////////////////////////////////////////
                    String           Technical         = getReparationDepartmentCount("Technical", "Safety");
                    MySqlDataAdapter mySqlDa_Technical = new MySqlDataAdapter(Technical, mySqlCon);
                    mySqlDa_Technical.Fill(dataTableRepairCount_Technical);

                    String           Cutting         = getReparationDepartmentCount("Cutting", "Safety");
                    MySqlDataAdapter mySqlDa_Cutting = new MySqlDataAdapter(Cutting, mySqlCon);
                    mySqlDa_Cutting.Fill(dataTableRepairCount_Cutting);

                    String           HR         = getReparationDepartmentCount("HR", "Safety");
                    MySqlDataAdapter mySqlDa_HR = new MySqlDataAdapter(HR, mySqlCon);
                    mySqlDa_HR.Fill(dataTableRepairCount_HR);
                    /////////////////////////////////////////////////////////////////////////////////////////////////////


                    /////////////////////////////////////////////////////////////////////////////////////////////////////
                    String           Operation         = getReparationDepartmentCount("Operation", "Safety");
                    MySqlDataAdapter mySqlDa_Operation = new MySqlDataAdapter(Operation, mySqlCon);
                    mySqlDa_Operation.Fill(dataTableRepairCount_Operation);
                    ////////////////////////////////////////////////////////////////////////////////////////////////////
                    ///


                    /////////////////////////////////////////////////////////////////////////////////////////////////////
                    String           VSM1         = getReparationDepartmentCount("Production VSM 01", "Safety");
                    MySqlDataAdapter mySqlDa_VSM1 = new MySqlDataAdapter(VSM1, mySqlCon);
                    mySqlDa_VSM1.Fill(dataTableRepairCount_VSM1);


                    String           VSM2         = getReparationDepartmentCount("Production VSM 02", "Safety");
                    MySqlDataAdapter mySqlDa_VSM2 = new MySqlDataAdapter(VSM2, mySqlCon);
                    mySqlDa_VSM2.Fill(dataTableRepairCount_VSM2);


                    String           VSM3         = getReparationDepartmentCount("Production VSM 03", "Safety");
                    MySqlDataAdapter mySqlDa_VSM3 = new MySqlDataAdapter(VSM3, mySqlCon);
                    mySqlDa_VSM3.Fill(dataTableRepairCount_VSM3);


                    String           VSM4         = getReparationDepartmentCount("Production VSM 04", "Safety");
                    MySqlDataAdapter mySqlDa_VSM4 = new MySqlDataAdapter(VSM4, mySqlCon);
                    mySqlDa_VSM4.Fill(dataTableRepairCount_VSM4);
                    ////////////////////////////////////////////////////////////////////////////////////////////////////


                    //////////////////////////////////////////////////////////////////////////////////////////////////
                    String           PreSweing         = getReparationDepartmentCount("Pre-Sweing", "Safety");
                    MySqlDataAdapter mySqlDa_PreSweing = new MySqlDataAdapter(PreSweing, mySqlCon);
                    mySqlDa_PreSweing.Fill(dataTableRepairCount_PreSewing);


                    String           Emblishment         = getReparationDepartmentCount("Emblishment", "Safety");
                    MySqlDataAdapter mySqlDa_Emblishment = new MySqlDataAdapter(Emblishment, mySqlCon);
                    mySqlDa_Emblishment.Fill(dataTableRepairCount_Emblishment);


                    String           IE         = getReparationDepartmentCount("IE", "Safety");
                    MySqlDataAdapter mySqlDa_IE = new MySqlDataAdapter(IE, mySqlCon);
                    mySqlDa_IE.Fill(dataTableRepairCount_IE);
                    //////////////////////////////////////////////////////////////////////////////////////////////////
                    ///



                    /////////////////////////////////////////////////////////////////////Sustainability Tokens/////////////////////////////////

                    String           FacEng_SUS             = getReparationDepartmentCount("Factory Engineering", "Sustainability");
                    MySqlDataAdapter mySqlDa_FactoryEng_SUS = new MySqlDataAdapter(FacEng_SUS, mySqlCon);
                    mySqlDa_FactoryEng_SUS.Fill(dataTableRepairCount_FactoryEng_SUS);

                    String           ProdEng_SUS = getReparationDepartmentCount("Production Engineering", "Sustainability");
                    MySqlDataAdapter mySqlDa_ProductionEng_SUS = new MySqlDataAdapter(ProdEng_SUS, mySqlCon);
                    mySqlDa_ProductionEng_SUS.Fill(dataTableRepairCount_ProductionEng_SUS);

                    String           Autonomation_SUS         = getReparationDepartmentCount("Autonomation", "Sustainability");
                    MySqlDataAdapter mySqlDa_Autonomation_SUS = new MySqlDataAdapter(Autonomation_SUS, mySqlCon);
                    mySqlDa_Autonomation_SUS.Fill(dataTableRepairCount_Autonomation_SUS);


                    ///////////////////////////////////////////////////////////////////////////////////////////////////////
                    String           MOS_SUS         = getReparationDepartmentCount("MOS", "Sustainability");
                    MySqlDataAdapter mySqlDa_MOS_SUS = new MySqlDataAdapter(MOS_SUS, mySqlCon);
                    mySqlDa_MOS_SUS.Fill(dataTableRepairCount_MOS_SUS);

                    String           RM_SUS         = getReparationDepartmentCount("RM", "Sustainability");
                    MySqlDataAdapter mySqlDa_RM_SUS = new MySqlDataAdapter(RM_SUS, mySqlCon);
                    mySqlDa_RM_SUS.Fill(dataTableRepairCount_RM_SUS);

                    String           Quality_SUS         = getReparationDepartmentCount("Quality", "Sustainability");
                    MySqlDataAdapter mySqlDa_Quality_SUS = new MySqlDataAdapter(Quality_SUS, mySqlCon);
                    mySqlDa_Quality_SUS.Fill(dataTableRepairCount_Quality_SUS);

                    String           FG_SUS         = getReparationDepartmentCount("FG", "Sustainability");
                    MySqlDataAdapter mySqlDa_FG_SUS = new MySqlDataAdapter(FG_SUS, mySqlCon);
                    mySqlDa_FG_SUS.Fill(dataTableRepairCount_FG_SUS);
                    /////////////////////////////////////////////////////////////////////////////////////////////////////


                    ///////////////////////////////////////////////////////////////////////////////////////////////////////
                    String           Technical_SUS         = getReparationDepartmentCount("Technical", "Safety");
                    MySqlDataAdapter mySqlDa_Technical_SUS = new MySqlDataAdapter(Technical_SUS, mySqlCon);
                    mySqlDa_Technical_SUS.Fill(dataTableRepairCount_Technical_SUS);

                    String           Cutting_SUS         = getReparationDepartmentCount("Cutting", "Sustainability");
                    MySqlDataAdapter mySqlDa_Cutting_SUS = new MySqlDataAdapter(Cutting_SUS, mySqlCon);
                    mySqlDa_Cutting_SUS.Fill(dataTableRepairCount_Cutting_SUS);

                    String           HR_SUS         = getReparationDepartmentCount("HR", "Sustainability");
                    MySqlDataAdapter mySqlDa_HR_SUS = new MySqlDataAdapter(HR_SUS, mySqlCon);
                    mySqlDa_HR_SUS.Fill(dataTableRepairCount_HR_SUS);
                    /////////////////////////////////////////////////////////////////////////////////////////////////////


                    /////////////////////////////////////////////////////////////////////////////////////////////////////
                    String           Operation_SUS         = getReparationDepartmentCount("Operation", "Sustainability");
                    MySqlDataAdapter mySqlDa_Operation_SUS = new MySqlDataAdapter(Operation_SUS, mySqlCon);
                    mySqlDa_Operation_SUS.Fill(dataTableRepairCount_Operation_SUS);
                    ////////////////////////////////////////////////////////////////////////////////////////////////////
                    ///


                    /////////////////////////////////////////////////////////////////////////////////////////////////////
                    String           VSM1_SUS         = getReparationDepartmentCount("Production VSM 01", "Sustainability");
                    MySqlDataAdapter mySqlDa_VSM1_SUS = new MySqlDataAdapter(VSM1_SUS, mySqlCon);
                    mySqlDa_VSM1_SUS.Fill(dataTableRepairCount_VSM1_SUS);


                    String           VSM2_SUS         = getReparationDepartmentCount("Production VSM 02", "Sustainability");
                    MySqlDataAdapter mySqlDa_VSM2_SUS = new MySqlDataAdapter(VSM2_SUS, mySqlCon);
                    mySqlDa_VSM2_SUS.Fill(dataTableRepairCount_VSM2_SUS);


                    String           VSM3_SUS         = getReparationDepartmentCount("Production VSM 03", "Sustainability");
                    MySqlDataAdapter mySqlDa_VSM3_SUS = new MySqlDataAdapter(VSM3_SUS, mySqlCon);
                    mySqlDa_VSM3_SUS.Fill(dataTableRepairCount_VSM3_SUS);


                    String           VSM4_SUS         = getReparationDepartmentCount("Production VSM 04", "Sustainability");
                    MySqlDataAdapter mySqlDa_VSM4_SUS = new MySqlDataAdapter(VSM4_SUS, mySqlCon);
                    mySqlDa_VSM4_SUS.Fill(dataTableRepairCount_VSM4_SUS);
                    ////////////////////////////////////////////////////////////////////////////////////////////////////


                    //////////////////////////////////////////////////////////////////////////////////////////////////
                    String           PreSweing_SUS         = getReparationDepartmentCount("Pre-Sweing", "Sustainability");
                    MySqlDataAdapter mySqlDa_PreSweing_SUS = new MySqlDataAdapter(PreSweing_SUS, mySqlCon);
                    mySqlDa_PreSweing_SUS.Fill(dataTableRepairCount_PreSewing_SUS);


                    String           Emblishment_SUS         = getReparationDepartmentCount("Emblishment", "Sustainability");
                    MySqlDataAdapter mySqlDa_Emblishment_SUS = new MySqlDataAdapter(Emblishment_SUS, mySqlCon);
                    mySqlDa_Emblishment_SUS.Fill(dataTableRepairCount_Emblishment_SUS);


                    String           IE_SUS         = getReparationDepartmentCount("IE", "Sustainability");
                    MySqlDataAdapter mySqlDa_IE_SUS = new MySqlDataAdapter(IE_SUS, mySqlCon);
                    mySqlDa_IE_SUS.Fill(dataTableRepairCount_IE_SUS);
                }

                ///////////////////////////////////////////////////////Safety//////////////////////////////////////////////////////////////////////////
                mainModel.DepartmentReparationCount_FacEng       = Convert.ToInt32(dataTableRepairCount_FactoryEng.Rows[0][0].ToString());
                mainModel.DepartmentReparationCount_ProdEng      = Convert.ToInt32(dataTableRepairCount_ProductionEng.Rows[0][0].ToString());
                mainModel.DepartmentReparationCount_Autonomation = Convert.ToInt32(dataTableRepairCount_Autonomation.Rows[0][0].ToString());


                mainModel.DepartmentReparationCount_MOS     = Convert.ToInt32(dataTableRepairCount_MOS.Rows[0][0].ToString());
                mainModel.DepartmentReparationCount_RM      = Convert.ToInt32(dataTableRepairCount_RM.Rows[0][0].ToString());
                mainModel.DepartmentReparationCount_Quality = Convert.ToInt32(dataTableRepairCount_Quality.Rows[0][0].ToString());
                mainModel.DepartmentReparationCount_FG      = Convert.ToInt32(dataTableRepairCount_FG.Rows[0][0].ToString());


                mainModel.DepartmentReparationCount_Technical = Convert.ToInt32(dataTableRepairCount_Technical.Rows[0][0].ToString());
                mainModel.DepartmentReparationCount_Cutting   = Convert.ToInt32(dataTableRepairCount_Cutting.Rows[0][0].ToString());
                mainModel.DepartmentReparationCount_HR        = Convert.ToInt32(dataTableRepairCount_HR.Rows[0][0].ToString());


                mainModel.DepartmentReparationCount_Operation = Convert.ToInt32(dataTableRepairCount_Operation.Rows[0][0].ToString());


                mainModel.DepartmentReparationCount_VSM1 = Convert.ToInt32(dataTableRepairCount_VSM1.Rows[0][0].ToString());
                mainModel.DepartmentReparationCount_VSM2 = Convert.ToInt32(dataTableRepairCount_VSM2.Rows[0][0].ToString());
                mainModel.DepartmentReparationCount_VSM3 = Convert.ToInt32(dataTableRepairCount_VSM3.Rows[0][0].ToString());
                mainModel.DepartmentReparationCount_VSM4 = Convert.ToInt32(dataTableRepairCount_VSM4.Rows[0][0].ToString());


                mainModel.DepartmentReparationCount_PreSewing   = Convert.ToInt32(dataTableRepairCount_PreSewing.Rows[0][0].ToString());
                mainModel.DepartmentReparationCount_Emblishment = Convert.ToInt32(dataTableRepairCount_Emblishment.Rows[0][0].ToString());
                mainModel.DepartmentReparationCount_IE          = Convert.ToInt32(dataTableRepairCount_IE.Rows[0][0].ToString());



                ///////////////////////////////////////////////////////Sustainability//////////////////////////////////////////////////////////////////////////
                mainModel.DepartmentReparationCount_FacEng_SUS       = Convert.ToInt32(dataTableRepairCount_FactoryEng_SUS.Rows[0][0].ToString());
                mainModel.DepartmentReparationCount_ProdEng_SUS      = Convert.ToInt32(dataTableRepairCount_ProductionEng_SUS.Rows[0][0].ToString());
                mainModel.DepartmentReparationCount_Autonomation_SUS = Convert.ToInt32(dataTableRepairCount_Autonomation_SUS.Rows[0][0].ToString());


                mainModel.DepartmentReparationCount_MOS_SUS     = Convert.ToInt32(dataTableRepairCount_MOS_SUS.Rows[0][0].ToString());
                mainModel.DepartmentReparationCount_RM_SUS      = Convert.ToInt32(dataTableRepairCount_RM_SUS.Rows[0][0].ToString());
                mainModel.DepartmentReparationCount_Quality_SUS = Convert.ToInt32(dataTableRepairCount_Quality_SUS.Rows[0][0].ToString());
                mainModel.DepartmentReparationCount_FG_SUS      = Convert.ToInt32(dataTableRepairCount_FG_SUS.Rows[0][0].ToString());


                mainModel.DepartmentReparationCount_Technical_SUS = Convert.ToInt32(dataTableRepairCount_Technical_SUS.Rows[0][0].ToString());
                mainModel.DepartmentReparationCount_Cutting_SUS   = Convert.ToInt32(dataTableRepairCount_Cutting_SUS.Rows[0][0].ToString());
                mainModel.DepartmentReparationCount_HR_SUS        = Convert.ToInt32(dataTableRepairCount_HR_SUS.Rows[0][0].ToString());


                mainModel.DepartmentReparationCount_Operation_SUS = Convert.ToInt32(dataTableRepairCount_Operation_SUS.Rows[0][0].ToString());


                mainModel.DepartmentReparationCount_VSM1_SUS = Convert.ToInt32(dataTableRepairCount_VSM1_SUS.Rows[0][0].ToString());
                mainModel.DepartmentReparationCount_VSM2_SUS = Convert.ToInt32(dataTableRepairCount_VSM2_SUS.Rows[0][0].ToString());
                mainModel.DepartmentReparationCount_VSM3_SUS = Convert.ToInt32(dataTableRepairCount_VSM3_SUS.Rows[0][0].ToString());
                mainModel.DepartmentReparationCount_VSM4_SUS = Convert.ToInt32(dataTableRepairCount_VSM4_SUS.Rows[0][0].ToString());


                mainModel.DepartmentReparationCount_PreSewing_SUS   = Convert.ToInt32(dataTableRepairCount_PreSewing_SUS.Rows[0][0].ToString());
                mainModel.DepartmentReparationCount_Emblishment_SUS = Convert.ToInt32(dataTableRepairCount_Emblishment_SUS.Rows[0][0].ToString());
                mainModel.DepartmentReparationCount_IE_SUS          = Convert.ToInt32(dataTableRepairCount_IE_SUS.Rows[0][0].ToString());



                if (userDetailsDataTable.Rows.Count == 1)
                {
                    SetDashbordStatCounts();
                    mainModel.TokenManagerStatusPending = TokenController.TokenManagerPendingSattusCount();

                    mainModel.LoggedUserName = userDetailsDataTable.Rows[0][0].ToString();
                    mainModel.LoggedUserType = userDetailsDataTable.Rows[0][1].ToString();
                    mainModel.LoggedUserID   = Convert.ToInt32(userDetailsDataTable.Rows[0][2]);
                    mainModel.UserImagePath  = userDetailsDataTable.Rows[0][3].ToString();
                }



                ///////////////////////Safety Tokens/////////////////////////////////
                DataTable dataTableRepairCount_Complete_FactoryEng    = new DataTable();
                DataTable dataTableRepairCount_Complete_ProductionEng = new DataTable();
                DataTable dataTableRepairCount_Complete_Autonomation  = new DataTable();

                DataTable dataTableRepairCount_Complete_MOS     = new DataTable();
                DataTable dataTableRepairCount_Complete_RM      = new DataTable();
                DataTable dataTableRepairCount_Complete_Quality = new DataTable();
                DataTable dataTableRepairCount_Complete_FG      = new DataTable();

                DataTable dataTableRepairCount_Complete_Technical = new DataTable();
                DataTable dataTableRepairCount_Complete_Cutting   = new DataTable();
                DataTable dataTableRepairCount_Complete_HR        = new DataTable();

                DataTable dataTableRepairCount_Complete_Operation = new DataTable();

                DataTable dataTableRepairCount_Complete_VSM1 = new DataTable();
                DataTable dataTableRepairCount_Complete_VSM2 = new DataTable();
                DataTable dataTableRepairCount_Complete_VSM3 = new DataTable();
                DataTable dataTableRepairCount_Complete_VSM4 = new DataTable();

                DataTable dataTableRepairCount_Complete_PreSewing   = new DataTable();
                DataTable dataTableRepairCount_Complete_Emblishment = new DataTable();
                DataTable dataTableRepairCount_Complete_IE          = new DataTable();
                //////////////////////Sfety Tokens/////////////////////////////////


                //////////////////////Sustainability Tokens/////////////////////////////
                DataTable dataTableRepairCount_Complete_FactoryEng_SUS    = new DataTable();
                DataTable dataTableRepairCount_Complete_ProductionEng_SUS = new DataTable();
                DataTable dataTableRepairCount_Complete_Autonomation_SUS  = new DataTable();

                DataTable dataTableRepairCount_Complete_MOS_SUS     = new DataTable();
                DataTable dataTableRepairCount_Complete_RM_SUS      = new DataTable();
                DataTable dataTableRepairCount_Complete_Quality_SUS = new DataTable();
                DataTable dataTableRepairCount_Complete_FG_SUS      = new DataTable();

                DataTable dataTableRepairCount_Complete_Technical_SUS = new DataTable();
                DataTable dataTableRepairCount_Complete_Cutting_SUS   = new DataTable();
                DataTable dataTableRepairCount_Complete_HR_SUS        = new DataTable();

                DataTable dataTableRepairCount_Complete_Operation_SUS = new DataTable();

                DataTable dataTableRepairCount_Complete_VSM1_SUS = new DataTable();
                DataTable dataTableRepairCount_Complete_VSM2_SUS = new DataTable();
                DataTable dataTableRepairCount_Complete_VSM3_SUS = new DataTable();
                DataTable dataTableRepairCount_Complete_VSM4_SUS = new DataTable();

                DataTable dataTableRepairCount_Complete_PreSewing_SUS   = new DataTable();
                DataTable dataTableRepairCount_Complete_Emblishment_SUS = new DataTable();
                DataTable dataTableRepairCount_Complete_IE_SUS          = new DataTable();
                //////////////////////Sustainability Tokens/////////////////////////////



                return(View(mainModel));
            }
        }
        public HomeController()
        {
            MainModel mainModel = new MainModel();

            mainModel.TokenManagerStatusPending = TokenController.TokenManagerPendingSattusCount();
        }