public static int ToZoho(string sql)
{
const string connectionString = "security token=fe85458c694b2c124e2c161f8e2b834b;";
int result = 0;
using (ZohoConnection connection = new ZohoConnection(connectionString))
{
connection.Open();
using (ZohoCommand command = connection.CreateCommand())
{
command.CommandText = sql;
result = command.ExecuteNonQuery();
}
}
return(result);
}
private static DataTable GetInfo(string sql)
{
const string connectionString = "security token=fe85458c694b2c124e2c161f8e2b834b;";
DataTable dt = new DataTable();
using (ZohoConnection connection = new ZohoConnection(connectionString))
{
connection.Open();
using (ZohoCommand command = connection.CreateCommand())
{
command.CommandText = sql;
using (ZohoDataAdapter adapter = new ZohoDataAdapter(command))
{
adapter.Fill(dt);
}
}
}
return(dt);
}
public static DataTable GetDtByOwnID(string OwnID)
{
const string connectionString = "security token=fe85458c694b2c124e2c161f8e2b834b;";
//const string sql = "SELECT * FROM Contacts";
DataTable dt = new DataTable();
using (ZohoConnection connection = new ZohoConnection(connectionString))
{
connection.Open();
using (ZohoCommand command = connection.CreateCommand())
{
command.CommandText = $"select CONTACTID,Email from Contacts where SMOWNERID=" + OwnID.Replace("\"", "");
using (ZohoDataAdapter adapter = new ZohoDataAdapter(command))
{
adapter.Fill(dt);
}
}
}
return(dt);
}
