public IActionResult viewAgent(string id)
        {
            SuplierModel sp = new SuplierModel();

            sp.select_suplier("sup_id = '" + id + "'");

            ViewData["sup_code"]         = sp.sup_code;
            ViewData["sup_name"]         = sp.sup_name;
            ViewData["sup_name_contact"] = sp.sup_name_contact;
            ViewData["sup_tel"]          = sp.sup_tel;
            ViewData["sup_fax"]          = sp.sup_fax;
            ViewData["sup_email"]        = sp.sup_email;
            ViewData["sup_web"]          = sp.sup_web;
            ViewData["sup_trade"]        = sp.sup_trade;
            ViewData["sup_tax"]          = sp.sup_tax;
            ViewData["sup_num"]          = sp.sup_num;
            ViewData["sup_road"]         = sp.sup_road;
            ViewData["sup_postcode"]     = sp.sup_postcode;
            ViewData["sup_credit_money"] = sp.sup_credit_money;
            ViewData["sup_credit"]       = sp.credit_name;
            ViewData["sup_district"]     = sp.district_name;
            ViewData["sup_amphur"]       = sp.amphur_name;
            ViewData["sup_province"]     = sp.province_name;
            ViewData["sup_prefix"]       = sp.prefix_name;
            ViewData["sup_prefix_end"]   = sp.prefix_end;

            return(View());
        }
        public IActionResult editAgent(string id)
        {
            SuplierModel sp = new SuplierModel();

            sp.select_suplier("sup_id = '" + id + "'");

            ViewData["sup_id"]           = id;
            ViewData["sup_code"]         = sp.sup_code;
            ViewData["sup_name"]         = sp.sup_name;
            ViewData["sup_name_contact"] = sp.sup_name_contact;
            ViewData["sup_tel"]          = sp.sup_tel;
            ViewData["sup_fax"]          = sp.sup_fax;
            ViewData["sup_email"]        = sp.sup_email;
            ViewData["sup_web"]          = sp.sup_web;
            ViewData["sup_trade"]        = sp.sup_trade;
            ViewData["sup_tax"]          = sp.sup_tax;
            ViewData["sup_num"]          = sp.sup_num;
            ViewData["sup_road"]         = sp.sup_road;
            ViewData["sup_postcode"]     = sp.sup_postcode;
            ViewData["sup_credit_money"] = sp.sup_credit_money;
            ViewData["sup_credit"]       = sp.credit_name;
            ViewData["sup_distict"]      = sp.district_name;
            ViewData["sup_amphur"]       = sp.amphur_name;
            ViewData["sup_province"]     = sp.province_name;
            ViewData["sup_prefix"]       = sp.prefix_name;
            ViewData["sup_prefix_end"]   = sp.prefix_end;

            conditionPayModel cd = new conditionPayModel();

            ViewData["credit"] = cd.drop_con_pay(sp.sup_credit_id);

            prefixModel px = new prefixModel();

            ViewData["prefix"] = px.drop_prefix(sp.sup_prefix_id);

            districts dt = new districts();

            ViewData["distict"] = dt.drop_district(sp.sup_district);

            ampuresModel am = new ampuresModel();

            ViewData["amphur"] = am.dorp_amphur(sp.sup_amphur);

            provinceModel pv = new provinceModel();

            ViewData["province"] = pv.drop_province(sp.sup_province);

            return(View());
        }