public JsonResult check_track_by_lot(FOL_DATA access)
        {
            IDictionary <string, string> results = new Dictionary <string, string>();

            results = promisAssyObject.check_track_by_lot(access.lotNo);

            return(Json(results));
        }
        //[HttpPost] //Posting in C#
        //[ValidateInput(true)] // Checks if inputs are true
        //public JsonResult update_machine_history(FOL_DATA access)
        //{
        //    IDictionary<string, string> results = new Dictionary<string, string>();

        //    promisAssyObject.insert_Data_History(access.machineID, access.stsDes, access.date1, access.date2, access.user, access.remarks, access.prodName, access.lotNo, access.uph, access.stsOwner, access.group, access.pkgType,
        //    access.usl_1_impendance, access.nominal_1_impendance, access.lsl_1_impendance, access.usl_2_impendance, access.nominal_2_impendance, access.lsl_2_impendance, access.usl_1_bf_igbt,
        //    access.nominal_1_bf_igbt, access.lsl_1_bf_igbt, access.usl_2_bf_igbt, access.nominal_2_bf_igbt, access.lsl_2_bf_igbt,
        //    access.usl_1_bf_mid_stitch, access.nominal_1_bf_mid_stitch, access.lsl_1_bf_mid_stitch, access.usl_2_bf_mid_stitch, access.nominal_2_bf_mid_stitch,
        //    access.lsl_2_bf_mid_stitch, access.usl_1_bf_lead, access.nominal_1_bf_lead, access.lsl_1_bf_lead, access.usl_2_bf_lead, access.nominal_2_bf_lead,
        //    access.lsl_2_bf_lead);

        //    results["done"] = "TRUE";
        //    results["msg"] = "<strong class='success'>UPDATE HISTORY SUCCESSFULLY</strong>";
        //    return Json(results);

        //}

        //[HttpPost] //Posting in C#
        //[ValidateInput(true)] // Checks if inputs are true
        //public JsonResult update_machine_history_track(FOL_DATA access)
        //{
        //    IDictionary<string, string> results = new Dictionary<string, string>();

        //    promisAssyObject.insert_Data_History(access.machineID, access.stsDes, access.date1, access.date2, access.user, access.remarks, access.prodName, access.lotNo, access.uph, access.stsOwner, access.group, access.pkgType,
        //    access.usl_1_impendance, access.nominal_1_impendance, access.lsl_1_impendance, access.usl_2_impendance, access.nominal_2_impendance, access.lsl_2_impendance, access.usl_1_bf_igbt,
        //    access.nominal_1_bf_igbt, access.lsl_1_bf_igbt, access.usl_2_bf_igbt, access.nominal_2_bf_igbt, access.lsl_2_bf_igbt,
        //    access.usl_1_bf_mid_stitch, access.nominal_1_bf_mid_stitch, access.lsl_1_bf_mid_stitch, access.usl_2_bf_mid_stitch, access.nominal_2_bf_mid_stitch,
        //    access.lsl_2_bf_mid_stitch, access.usl_1_bf_lead, access.nominal_1_bf_lead, access.lsl_1_bf_lead, access.usl_2_bf_lead, access.nominal_2_bf_lead,
        //    access.lsl_2_bf_lead);

        //    results["done"] = "TRUE";
        //    results["msg"] = "<strong class='success'>UPDATE HISTORY SUCCESSFULLY</strong>";
        //    return Json(results);

        //}

        //iTV

        public JsonResult check_existing_equiphistory(FOL_DATA access)
        {
            IDictionary <string, string> results = new Dictionary <string, string>();

            results = promisAssyObject.check_existing_equiphistory(access.machineID, access.stsOwner, access.stsDes);

            return(Json(results));
        }
        public JsonResult insert_equiphistory(FOL_DATA access)
        {
            IDictionary <string, string> results = new Dictionary <string, string>();

            results = promisAssyObject.insert_equiphistory(access.machineID, access.stsOwner, access.stsDes, access.remarks, access.itvdate, access.user, access.userID);

            return(Json(results));
        }
        [ValidateInput(true)] // Checks if inputs are true
        public JsonResult track_lot(FOL_DATA access)
        {
            IDictionary <string, string> results = new Dictionary <string, string>();

            promisAssyObject.track_lot(access.machineID, access.track_in, access.track_out, access.lotNo, access.user);

            //if (access.track_out == "1")
            //{
            //    promisObject.pbft_reset(access.machineID);
            //}

            results["done"] = "TRUE";
            results["msg"]  = "<strong class='success'>UPDATE TRACK DATA SUCCESSFULLY</strong>";
            return(Json(results));
        }
        [ValidateInput(true)] // Checks if inputs are true
        public JsonResult update_machine_track(FOL_DATA access)
        {
            IDictionary <string, string> results = new Dictionary <string, string>();

            promisAssyObject.insert_Data(access.machineID, access.machinePF, access.stsOwner, access.stsDes, access.prodName, access.lotNo, access.uph, access.pkgType,
                                         access.remarks, access.group, access.user, access.material_id, access.date3, access.userID, access.stsDwn, access.setup_to_qa, access.qa_to_process,
                                         access.usl_1_impendance, access.nominal_1_impendance, access.lsl_1_impendance, access.usl_2_impendance, access.nominal_2_impendance, access.lsl_2_impendance, access.usl_1_bf_igbt,
                                         access.nominal_1_bf_igbt, access.lsl_1_bf_igbt, access.usl_2_bf_igbt, access.nominal_2_bf_igbt, access.lsl_2_bf_igbt,
                                         access.usl_1_bf_mid_stitch, access.nominal_1_bf_mid_stitch, access.lsl_1_bf_mid_stitch, access.usl_2_bf_mid_stitch, access.nominal_2_bf_mid_stitch,
                                         access.lsl_2_bf_mid_stitch, access.usl_1_bf_lead, access.nominal_1_bf_lead, access.lsl_1_bf_lead, access.usl_2_bf_lead, access.nominal_2_bf_lead,
                                         access.lsl_2_bf_lead, access.track_status, access.ipcc_value, access.IPCC_reset);

            promisAssyObject.insert_Data_History(access.machineID, access.stsDes, access.date1, access.date2, access.user, access.remarks, access.prodName, access.lotNo, access.uph, access.stsOwner, access.group, access.pkgType,
                                                 access.usl_1_impendance, access.nominal_1_impendance, access.lsl_1_impendance, access.usl_2_impendance, access.nominal_2_impendance, access.lsl_2_impendance, access.usl_1_bf_igbt,
                                                 access.nominal_1_bf_igbt, access.lsl_1_bf_igbt, access.usl_2_bf_igbt, access.nominal_2_bf_igbt, access.lsl_2_bf_igbt,
                                                 access.usl_1_bf_mid_stitch, access.nominal_1_bf_mid_stitch, access.lsl_1_bf_mid_stitch, access.usl_2_bf_mid_stitch, access.nominal_2_bf_mid_stitch,
                                                 access.lsl_2_bf_mid_stitch, access.usl_1_bf_lead, access.nominal_1_bf_lead, access.lsl_1_bf_lead, access.usl_2_bf_lead, access.nominal_2_bf_lead,
                                                 access.lsl_2_bf_lead);

            results["done"] = "TRUE";
            results["msg"]  = "<strong class='success'>UPDATE SUCCESSFULLY</strong>";
            return(Json(results));
        }