Dificuldade de enviar os dados na base de dados local, obtidas atravez do json da WebApi,e visualizada no windows form no c#

[Pedro João 0]

Boa tarde Pessoal,  sou novato na programação  , estou uma dificuldade de enviar na base de dados local (Sql Server), lembrando que existe um metodo

 private void PopulateallFields() que me permite visualizar alguns dados na textbox, mas os dados são solicitado apartir de um ficheiro json na WebAPi

 

public class BranchMethod
    {
     public List<Branches> GetBranchList(string url, string authtoken, string passkey, out string ReasonPhrase,Guid pkorganization)
     {
         try
         {
             List<Branches> list = new List<Branches>();
             url = "http://" + url + "/webapi";
             HttpClient clientorg = new HttpClient();
             clientorg.BaseAddress = new Uri(url);
             clientorg.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("bearer", authtoken);
             clientorg.DefaultRequestHeaders.Add("passkey", passkey);
             string webapi = "WebApi/v1.0/Branches";
             HttpResponseMessage getresponses = clientorg.GetAsync(webapi).Result;
             if (getresponses.IsSuccessStatusCode)
             {
                var branches = JObject.Parse(getresponses.Content.ReadAsStringAsync().Result);
                    if (branches["value"].ToString() != "" && branches["value"] != null)
                 {
                     var organisation = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Branches>>(branches["value"].ToString()).Where(p => p.PkOrganization == pkorganization).ToList();
                     list = organisation;
                 }
             }
             ReasonPhrase = getresponses.ReasonPhrase;
             return list;
         }
         catch (Exception ex)
         {
             throw ex;
         }
     }
    }

Método  de Inserir os valores na textbox atravez das chamadas Web

 private void PopulateallFields()
        {
            try
            {
                TokenMethods objtoken = new TokenMethods();
                LoginMethod objlogin = new LoginMethod();
                CompanyMethod objcmp = new CompanyMethod();
                BranchMethod objbranch = new BranchMethod();
                DeviceTypesMethod objdevicetypes = new DeviceTypesMethod();
                ddlNetlogiaUrl.SelectedItem = Url;
                if (TokenMethods.authtoken != "")
                {
                    string val = "";
                    List<Companies> listcmp = objcmp.GetCompanyList(Url, TokenMethods.authtoken, LoginMethod.Passkey, out val);
                    if (val == "OK")
                    {

                       // Listar todas empresas criada na Internet.
                        if (listcmp.Count > 0)
                        {
                            cmbOrganization.DisplayMember = "Nome";
                            cmbOrganization.ValueMember = "ID";

                            // Listar a empresa
                            cmbOrganization.DataSource = listcmp;
                            btnRefreshOrg.Enabled = true; ;
                            if (cmbOrganization.SelectedValue.ToString() != "")
                            {
                                List<Branches> listbranch = objbranch.GetBranchList(Url, TokenMethods.authtoken, LoginMethod.Passkey, out val, Guid.Parse(cmbOrganization.SelectedValue.ToString()));
                                if (val == "OK")
                                {

                                    if (listbranch.Count > 0)
                                    {
                                         //Class_Conection connection = new Class_Conection();
                                   //      connection.conn.Open();
                                   //      SqlDataAdapter da = new SqlDataAdapter();
                                  //             int X;

                                //                string insertData = " Insert into ORGBranches  (Pk, Name) values  (@Pk, @Name)";
                                                                                
                                     
                                     cmbBranch.DisplayMember = "Name";
                                       cmbBranch.ValueMember = "Pk";
                                        cmbBranch.DataSource = listbranch;

                                        SqlCommand cmd = new SqlCommand(insertData, connection.conn);
                                        cmd.CommandText = insertData;
                                        cmd.CommandType = CommandType.Text;

                                        cmd.Parameters.AddWithValue("@Code",3);
                                        cmd.Parameters.AddWithValue("@Name", cmbBranch.Text);
                                        X = cmd.ExecuteNonQuery();


                                        // Listar as Filiares.


                                        btnRefreshBranch.Enabled = true;
                                        List<DeviceTypes> listDeviceTypes = objdevicetypes.GetDevicetypeList(Url, TokenMethods.authtoken, LoginMethod.Passkey, out val);
                                        if (val == "OK")
                                        {
                                            if (listDeviceTypes.Count > 0)
                                            {
                                                cmbDeviceType.DisplayMember = "Nome";
                                                cmbDeviceType.ValueMember = "ID";
                                                cmbDeviceType.DataSource = listDeviceTypes;
                                                //btnRefreshDeviceType.Enabled = true;
                                                //btnRefreshDevice.Enabled = true;
                                                btnFilter.Enabled = true;
                                                 btnApplyDevice.Enabled = true;

                                            }

                                            else { MessageBox.Show("No Devicetypes Found "); }
                                        }
                     
                      
            }

            catch (Exception ex)
            {
                throw ex;
            }
        }

Muito obrigado.

[quintelab 91]

O que acontece ? Qual sua dificuldade ? Algum erro ?
 

Aquela parte da conexão comentada não é necessária ?

[Pedro João 0]

Em 09/07/2018 at 14:45, quintelab disse:

O que acontece ? Qual sua dificuldade ? Algum erro ?
 

Aquela parte da conexão comentada não é necessária ?

Peço desculpa não ter respondido antes.