public static WebServiceClient.Generic.OfficeClipGeneric CreateConnection()
{
 // create an instance of the web service client
 WebServiceClient.Generic.OfficeClipGeneric ofg = 
    new WebServiceClient.Generic.OfficeClipGeneric();
 // Create a cookie container so that the session can persist on the server
 ofg.CookieContainer = new System.Net.CookieContainer();
 return ofg;
}

public static void Login(
 WebServiceClient.Generic.OfficeClipGeneric ofg, string emailAddress, string password
 )
{
 try
 {
    // try using the webservice to validate the user, if successful,
    // an user session will be created
     string msg = ofg.ValidateUser(emailAddress, password);
    if (msg == string.Empty)
     Console.WriteLine("Login Successful");
    else
     Console.WriteLine("Login Failed: " + msg);
 }
 catch (SoapException ex)
 {
    Console.WriteLine(ex.Message);
 }
}

public static DataSet GetOrganizationData(
 WebServiceClient.Generic.OfficeClipGeneric ofg
 )
{
 DataSet ds = null;
 try
 {
    // Service Type 13 is for organization data
    ds = ofg.GetDataSet(13, -1, string.Empty, string.Empty, string.Empty, -1);
 }
 catch (SoapException ex)
 {
    Console.WriteLine(ex.Message);
 }
 return ds;
}

public static DataSet GetTemplateParentChild(
 WebServiceClient.Generic.OfficeClipGeneric ofg
 )
{
 DataSet ds = null;
 try
 {
    // Service Type 23 is for parent child template
    // Service sub type of 15 is for template type contact
    ds = ofg.GetDataSet(23, 15, string.Empty, string.Empty, string.Empty, -1);
 }
 catch (SoapException ex)
 {
    Console.WriteLine(ex.Message);
 }
 return ds;
}

public static DataSet GetAllContacts(
 WebServiceClient.Generic.OfficeClipGeneric ofg, string filter
 )
{
 DataSet ds = null;
 try
 {
  // Service Type 18 is for Contact
  // it also returns the columns firstName, lastName and title
     ds = ofg.GetDataSet(18, -1, "", filter, string.Empty, -1);
    // ds = ofg.GetDataSet(18, -1, "firstName,lastName,title", string.Empty, string.Empty, -1);
 }
 catch (SoapException ex)
 {
  Console.WriteLine(ex.Message);
 }
 return ds;
}

/// <summary>
///  Inserts a campaign. The campaign is previously saved as c:\temp\test.doc
///  This will insert the campaign document in OfficeClip via the web service.
/// A mailmerge campaign will be stored in OfficeClip as attachemtn
/// </summary>
/// <param name="ofg">Reference to the web service proxy</param>
public static void InsertCampaignAttachment(
 WebServiceClient.Generic.OfficeClipGeneric ofg,
 string sid
 )
{
 DataSet ds = null;
 try
 {
    // Retrieve the schema for service type 24 (attachments)
    StringReader sr = new StringReader(ofg.GetXmlSchema(24));
    ds = new DataSet();
    ds.ReadXmlSchema(sr);
    sr.Close();
    // This schema will be used to create a dataset to insert value
    // in OfficeClip.
    ds.Tables.Add(new DataTable());
    DataTable dt = ds.Tables[0];
    DataRow dr = dt.NewRow();
    dr["sid"] = "1";
    dr["fileName"] = "test.doc";
    dr["documentKey"] = "";
    dr["documentDescription"] = "";
    dr["applicationId"] = 27; // The application id 27 is the application id of the campaign
    dr["applicationSecondaryId"] = 1; // secondary id of 1 denotes attachment for mailmerge campaigns
    dr["id"] = sid;
    dr["isZipped"] = false; 
    // Open the campaign from the local drive for reading
    FileStream fs = new FileStream(
     @"c:\temp\test.doc",
     FileMode.Open,
     FileAccess.Read
    );
    // Read the file as a set of bytes so it can be serialized by the webservices interface
    // and sent. The webservice will reconstruct the file at the server.
    BinaryReader br = new BinaryReader(fs);
    dr["bytes"] = br.ReadBytes((int)br.BaseStream.Length);
    dt.Rows.Add(dr);
    // Send the file as attachment
    DataSet dsResult = ofg.Insert(24, ds);
    // The schema of the returning dataset can be extracted using the GetSchema call
    // with service type 25 (Return value). For this example we know that there are
    // two columns called sid (unique service id) and errorDescription.
    Console.WriteLine("Serial Id: " + (string)dsResult.Tables[0].Rows[0]["sid"]);
    Console.WriteLine("Error: " + (string)dsResult.Tables[0].Rows[0]["errorDescription"]);
 }
 catch (SoapException ex)
 {
    Console.WriteLine(ex.Message);
 }
}

public static DataSet DeleteCampaignAttachment(
 WebServiceClient.Generic.OfficeClipGeneric ofg,
 string sid
 )
{
 DataSet ds = null;
 try
 {
    // Service Type 24 is for campaign data
    bool status = ofg.Delete(24, sid);
    Console.WriteLine((status) ? "Delete Successful" : "Delete Failed");
 }
 catch (SoapException ex)
 {
    Console.WriteLine(ex.Message);
 }
 return ds;
}

public static void IsSessionExists(
 WebServiceClient.Generic.OfficeClipGeneric ofg
 )
{
 try
 {
    bool exists = ofg.IsSessionExists();
    Console.WriteLine((exists) ? "Session Found" : "Session could not be found");
 }
 catch (SoapException ex)
 {
    Console.WriteLine(ex.Message);
 }
}

public static void EndConnection(
 WebServiceClient.Generic.OfficeClipGeneric ofg
 )
{
 try
 {
    ofg.SessionOver();
 }
 catch (SoapException ex)
 {
    Console.WriteLine(ex.Message);
 }
}