namespace primemobilebase.PrimeClasses
{
public class PrimeCommand
{


    //string resultString;
    public async Task<string> PrimeMethod(string commandtext, string content)
    {
        using (var client = new HttpClient())
        {
            var contents = new StringContent(content);
            var response = await client.PostAsync(Api.base_url + commandtext, contents);
            var responseString = await response.Content.ReadAsStringAsync();
            return responseString;
        }
    }

    public async Task<string> PrimeLogin(string username, string password)
    {
        using (var client = new HttpClient())
        {
            var newLogin = new LoginObject();

            // var jsonResultString = JsonConvert.SerializeObject(newLogin);
            newLogin.UserName = username;
            newLogin.Password = password;
            var contentObject = JsonConvert.SerializeObject(newLogin);
            var content = new StringContent(contentObject);

            var response = await client.PostAsync(Api.base_url+Api.url_login, content);
            var responseString = await response.Content.ReadAsStringAsync();

            //reading SessionID in JSON response
            dynamic responseObject = JsonConvert.DeserializeObject(responseString);
            var sessionID = responseObject.result.SessionID;

            var searchObj = new SimpleSearchObject
            {
                SessionID = sessionID
            };
            var UserPage = new UserPage();

            return sessionID;
        }
    }
    public async Task<string> PrimeLogout(string sessionId)
    {
        using (var client = new HttpClient())
        {
            var content = new StringContent(sessionId);
            var response = await client.PostAsync(Api.base_url+Api.url_logout, content);
            var responseString = await response.Content.ReadAsStringAsync();

            return responseString;
        }
    }

    public static SQLiteConnection _sqLiteConnection;

    public void SqliteCon()
    {

        try
        {
            _sqLiteConnection = DependencyService.Get<ISQLite>().GetConnection();
            _sqLiteConnection.CreateTable<LoginObject>();
            _sqLiteConnection.CreateTable<SalesInvoiceLine>();
            _sqLiteConnection.CreateTable<SalesInvoiceHeader>();
            _sqLiteConnection.CreateTable<SaleTransactions>();
        }
        catch (Exception ex)
        {
            //("Alert", ex.InnerException.Message, "OK");
        }
    }

    public void insertDb(dynamic e)
    {


        _sqLiteConnection.Insert(new SalesInvoiceHeader
        {
            customerName = "" + ((Debtor)e.SelectedItem).debtor_name,
            price_level_id = ((Debtor)e.SelectedItem).price_level_id,

        });
    }

    public void insertItm(dynamic e)
    {


        _sqLiteConnection.Insert(new SalesInvoiceLine
        {
            itemDescription = "" + ((ItemModel)e.SelectedItem).item_desc,

        });
    }
    public dynamic connectSOL()
    {
        return _sqLiteConnection.Table<SalesInvoiceLine>();
    }
    public dynamic connectCR()
    {
        return _sqLiteConnection.Table<Currency>();
    }

    public dynamic connectSOH()
    {
        return _sqLiteConnection.Table<SalesInvoiceHeader>();
    }
    public dynamic connectWH()
    {
        return _sqLiteConnection.Table<Warehouse>();
    }
    public dynamic connectSR()
    {
        return _sqLiteConnection.Table<SalesRepresentative>();
    }
    public dynamic connectUser()
    {
        return _sqLiteConnection.Table<LoginObject>();
    }
    public dynamic connectST()
    {
        return _sqLiteConnection.Table<SaleTransactions>();
    }
    public void insertST(DateTime date, string jsonString, bool sent)
    {
        _sqLiteConnection.Insert(new SaleTransactions
        {
            date = date,
            jsonString = jsonString,
            sent = sent,
        });

    }

    public void deleteSql(string obj)
    {

        if (obj == "LoginObject")
        {
            _sqLiteConnection.DeleteAll<LoginObject>();
        }
        else if (obj == "SalesInvoiceHeader")
        {
            _sqLiteConnection.DeleteAll<SalesInvoiceHeader>();
        }
        else if (obj == "SalesInvoiceLine")
        {
            _sqLiteConnection.DeleteAll<SalesInvoiceLine>();
        }
        else if (obj == "Warehouse")
        {
            _sqLiteConnection.DeleteAll<Warehouse>();
        }
        else if (obj == "SalesRepresentative")
        {
            _sqLiteConnection.DeleteAll<SalesRepresentative>();
        }


    }
    public void deleteSql(string obj, string itemDesc)
    {

        if (obj == "SalesOrderLine")
        {
            _sqLiteConnection.ExecuteScalar<SalesInvoiceLine>("DELETE FROM SalesInvoiceLine WHERE itemDescription = ?", itemDesc);

        }
    }

    public void insertLogin(string username, string password, string responseString)
    {
        _sqLiteConnection.Insert(new LoginObject
        {
            UserName = username,
            Password = password,
            SessionID = responseString,
        });
    }
    public bool checkInternet()
    {
        try
        {
            if (CrossConnectivity.Current.IsConnected)
            {
                //MainPage = new NavigationPage(new LoginPage());
                return true;
            }
        }
        catch (Exception e)
        {
        }
        return false;
    }
    public SalesInvoiceHeader GetSoh()
    {
        return _sqLiteConnection.Table<SalesInvoiceHeader>().FirstOrDefault();
    }
    public SalesRepresentative GetSR()
    {
        return _sqLiteConnection.Table<SalesRepresentative>().FirstOrDefault();
    }
    public Warehouse GetWH()
    {
        return _sqLiteConnection.Table<Warehouse>().FirstOrDefault();
    }
    public List<SalesInvoiceLine> GetSol()
    {
        return _sqLiteConnection.Table<SalesInvoiceLine>().ToList();
    }




    public async Task<string> PrimePassingValue(string jsonstring)
    {
        try
        {
            Debug.WriteLine("Prime Passing");

            using (var client = new HttpClient())
            {
                var httpContent = new StringContent(jsonstring, Encoding.UTF8, "application/json");

                var response = await client.PostAsync(Api.base_url+"/SalesOrder/Add", httpContent);
                var responseString = await response.Content.ReadAsStringAsync();

                Debug.WriteLine("resp (pc):" + responseString);
                return responseString;
            }
        }
        catch (Exception err)
        {
            //Debug.WriteLine("Error Prime Passing: " + err.InnerException.Message);
            return null;
        }
    }

}
}