public TableStatus(SqlCeClientSyncProvider _localProvider, string _TableName, string _newCondition, string _DeletedCondition)
{
localProvider = _localProvider;
TableName = _TableName;
NewCondition = _newCondition;
DeletedCondition = _DeletedCondition;
RefreshStatus();
}
public SpSyncAgent( )
{
string sqlceConnString = "Data Source=local.sdf";
LocalProvider = new SqlCeClientSyncProvider(sqlceConnString);
RemoteProvider = new SpServerSyncProvider("http://testintranet/crm3");
(RemoteProvider as SpServerSyncProvider).BatchSize = 100;
InitializeTypeMappings();
InitializeAdapters();
OnInitialized();
}
public SpSyncAgent( )
{
string sqlceConnString = "Data Source=local.sdf";
LocalProvider = new SqlCeClientSyncProvider(sqlceConnString);
RemoteProvider = new SpServerSyncProvider("http://testintranet/crm3");
(RemoteProvider as SpServerSyncProvider).BatchSize = 100;
InitializeTypeMappings();
InitializeAdapters();
OnInitialized();
}
public SampleSyncAgent()
{
SqlCeClientSyncProvider clientSyncProvider = new SqlCeClientSyncProvider(Properties.Settings.Default.ClientConnString, true);
this.LocalProvider = clientSyncProvider;
clientSyncProvider.ChangesApplied += new EventHandler <ChangesAppliedEventArgs>(clientSyncProvider_ChangesApplied);
this.RemoteProvider = new SampleServerSyncProvider();
SyncTable customerSyncTable = new SyncTable("Customer");
customerSyncTable.CreationOption = TableCreationOption.DropExistingOrCreateNewTable;
customerSyncTable.SyncDirection = SyncDirection.DownloadOnly; **
this.Configuration.SyncTables.Add(customerSyncTable);
this.Configuration.SyncParameters.Add(new SyncParameter("@CustomerName", "Sharp Bikes"));
}
public void fncActiveCallTable()
{
try
{
if (false == File.Exists(strLocalDBPath))
{
SqlCeEngine clientEngine = new SqlCeEngine(ClientConnectionString);
clientEngine.CreateDatabase();
}
if (!IsTableExits("Active_call"))
{
SqlCeClientSyncProvider sync = new SqlCeClientSyncProvider(ClientConnectionString);
SyncTable tblActive_call = new SyncTable("Active_call");
SyncSchema syncSchemaLead = new SyncSchema();
syncSchemaLead.Tables.Add("Active_call");
syncSchemaLead.Tables["Active_call"].Columns.Add("uName");
syncSchemaLead.Tables["Active_call"].Columns["uName"].ProviderDataType = SqlDbType.NVarChar.ToString();
syncSchemaLead.Tables["Active_call"].Columns["uName"].AutoIncrement = false;
syncSchemaLead.Tables["Active_call"].Columns["uName"].AutoIncrementSeed = 0;
syncSchemaLead.Tables["Active_call"].Columns["uName"].AutoIncrementStep = 1;
syncSchemaLead.Tables["Active_call"].Columns["uName"].MaxLength = 30;
syncSchemaLead.Tables["Active_call"].PrimaryKey = new string[] { "uName" };
syncSchemaLead.Tables["Active_call"].Columns.Add("Campaign_Id");
syncSchemaLead.Tables["Active_call"].Columns["Campaign_Id"].ProviderDataType = SqlDbType.NVarChar.ToString();
syncSchemaLead.Tables["Active_call"].Columns["Campaign_Id"].MaxLength = 30;
syncSchemaLead.Tables["Active_call"].Columns["Campaign_Id"].AutoIncrement = false;
syncSchemaLead.Tables["Active_call"].Columns["Campaign_Id"].AutoIncrementSeed = 0;
syncSchemaLead.Tables["Active_call"].Columns["Campaign_Id"].AutoIncrementStep = 1;
syncSchemaLead.Tables["Active_call"].Columns.Add("Status");
syncSchemaLead.Tables["Active_call"].Columns["Status"].ProviderDataType = SqlDbType.NVarChar.ToString();
syncSchemaLead.Tables["Active_call"].Columns["Status"].MaxLength = 30;
syncSchemaLead.Tables["Active_call"].Columns["Status"].AutoIncrement = false;
syncSchemaLead.Tables["Active_call"].Columns["Status"].AutoIncrementSeed = 0;
syncSchemaLead.Tables["Active_call"].Columns["Status"].AutoIncrementStep = 1;
syncSchemaLead.Tables["Active_call"].Columns.Add("Group_Name");
syncSchemaLead.Tables["Active_call"].Columns["Group_Name"].ProviderDataType = SqlDbType.NVarChar.ToString();
syncSchemaLead.Tables["Active_call"].Columns["Group_Name"].MaxLength = 30;
syncSchemaLead.Tables["Active_call"].Columns["Group_Name"].AutoIncrement = false;
syncSchemaLead.Tables["Active_call"].Columns["Group_Name"].AutoIncrementSeed = 0;
syncSchemaLead.Tables["Active_call"].Columns["Group_Name"].AutoIncrementStep = 1;
syncSchemaLead.Tables["Active_call"].Columns.Add("Phone_No");
syncSchemaLead.Tables["Active_call"].Columns["Phone_No"].ProviderDataType = SqlDbType.NVarChar.ToString();
syncSchemaLead.Tables["Active_call"].Columns["Phone_No"].MaxLength = 30;
syncSchemaLead.Tables["Active_call"].Columns["Phone_No"].AutoIncrement = false;
syncSchemaLead.Tables["Active_call"].Columns["Phone_No"].AutoIncrementSeed = 0;
syncSchemaLead.Tables["Active_call"].Columns["Phone_No"].AutoIncrementStep = 1;
syncSchemaLead.Tables["Active_call"].Columns.Add("callDuration");
syncSchemaLead.Tables["Active_call"].Columns["callDuration"].ProviderDataType = SqlDbType.NVarChar.ToString();
syncSchemaLead.Tables["Active_call"].Columns["callDuration"].MaxLength = 30;
syncSchemaLead.Tables["Active_call"].Columns["callDuration"].AutoIncrement = false;
syncSchemaLead.Tables["Active_call"].Columns["callDuration"].AutoIncrementSeed = 0;
syncSchemaLead.Tables["Active_call"].Columns["callDuration"].AutoIncrementStep = 1;
sync.CreateSchema(tblActive_call, syncSchemaLead);
}
}
catch (Exception ex)
{
VMuktiAPI.VMuktiHelper.ExceptionHandler(ex, "fncActivecallTable()", "ctlrptActiveCall.xaml.cs");
}
}
/// <summary>
/// this function will use for keeping track of supernode's node list. e.g. how many number of nodes(HTTP or P2P) is connected with perticular supernode.
/// </summary>
void fncCreateUserSuperNode_NodeInfoTable()
{
try
{
if (false == File.Exists(strLocalDBPath))
{
SqlCeEngine clientEngine = new SqlCeEngine(ClientConnectionString);
clientEngine.CreateDatabase();
}
if (!IsTableExits("SuperNode_Node_Info"))
{
SqlCeClientSyncProvider sync = new SqlCeClientSyncProvider(ClientConnectionString);
SyncTable tblSuperNode_Node_Info = new SyncTable("SuperNode_Node_Info");
SyncSchema syncSchemaLead = new SyncSchema();
syncSchemaLead.Tables.Add("SuperNode_Node_Info");
syncSchemaLead.Tables["SuperNode_Node_Info"].Columns.Add("ID");
syncSchemaLead.Tables["SuperNode_Node_Info"].Columns["ID"].ProviderDataType = SqlDbType.Int.ToString();
syncSchemaLead.Tables["SuperNode_Node_Info"].Columns["ID"].AutoIncrement = true;
syncSchemaLead.Tables["SuperNode_Node_Info"].Columns["ID"].AutoIncrementSeed = 1;
syncSchemaLead.Tables["SuperNode_Node_Info"].Columns["ID"].AutoIncrementStep = 1;
syncSchemaLead.Tables["SuperNode_Node_Info"].PrimaryKey = new string[] { "ID" };
syncSchemaLead.Tables["SuperNode_Node_Info"].Columns.Add("SuperNode_Id");
syncSchemaLead.Tables["SuperNode_Node_Info"].Columns["SuperNode_Id"].ProviderDataType = SqlDbType.NVarChar.ToString();
syncSchemaLead.Tables["SuperNode_Node_Info"].Columns["SuperNode_Id"].MaxLength = 30;
syncSchemaLead.Tables["SuperNode_Node_Info"].Columns["SuperNode_Id"].AllowNull = false;
syncSchemaLead.Tables["SuperNode_Node_Info"].Columns.Add("Node_Name");
syncSchemaLead.Tables["SuperNode_Node_Info"].Columns["Node_Name"].ProviderDataType = SqlDbType.NVarChar.ToString();
syncSchemaLead.Tables["SuperNode_Node_Info"].Columns["Node_Name"].MaxLength = 50;
syncSchemaLead.Tables["SuperNode_Node_Info"].Columns["Node_Name"].AllowNull = false;
sync.CreateSchema(tblSuperNode_Node_Info, syncSchemaLead);
}
}
catch (Exception ex)
{
VMuktiHelper.ExceptionHandler(ex, "fncCreateUserSuperNode_NodeInfoTable()", "Domains\\BootstrapServiceDomain.cs");
}
}
// Meet Code For Buddylist Implementation.
#region DataBase Creation Function
// public static string ClientConnectionString = @"Data Source=" + AppDomain.CurrentDomain.BaseDirectory + "AllocateConferenceNumber.sdf";
/// <summary>
/// this function will create Node_Status table if it is not created. Buddy_Status will contains all the users with his/her status.
/// </summary>
void fncCreateBuddyStatusTable()
{
try
{
if (false == File.Exists(strLocalDBPath))
{
SqlCeEngine clientEngine = new SqlCeEngine(ClientConnectionString);
clientEngine.CreateDatabase();
}
if (!IsTableExits("Node_Status"))
{
SqlCeClientSyncProvider sync = new SqlCeClientSyncProvider(ClientConnectionString);
SyncTable tblNode_Status = new SyncTable("Node_Status");
SyncSchema syncSchemaLead = new SyncSchema();
syncSchemaLead.Tables.Add("Node_Status");
syncSchemaLead.Tables["Node_Status"].Columns.Add("Buddy_ID");
syncSchemaLead.Tables["Node_Status"].Columns["Buddy_ID"].ProviderDataType = SqlDbType.BigInt.ToString();
syncSchemaLead.Tables["Node_Status"].Columns["Buddy_ID"].AutoIncrement = true;
syncSchemaLead.Tables["Node_Status"].Columns["Buddy_ID"].AutoIncrementSeed = 1;
syncSchemaLead.Tables["Node_Status"].Columns["Buddy_ID"].AutoIncrementStep = 1;
syncSchemaLead.Tables["Node_Status"].PrimaryKey = new string[] { "Buddy_ID" };
syncSchemaLead.Tables["Node_Status"].Columns.Add("Buddy_Name");
syncSchemaLead.Tables["Node_Status"].Columns["Buddy_Name"].ProviderDataType = SqlDbType.NVarChar.ToString();
syncSchemaLead.Tables["Node_Status"].Columns["Buddy_Name"].MaxLength = 30;
syncSchemaLead.Tables["Node_Status"].Columns.Add("Buddy_Status");
syncSchemaLead.Tables["Node_Status"].Columns["Buddy_Status"].ProviderDataType = SqlDbType.NVarChar.ToString();
syncSchemaLead.Tables["Node_Status"].Columns["Buddy_Status"].MaxLength = 30;
syncSchemaLead.Tables["Node_Status"].Columns.Add("Buddy_TimeStamp");
syncSchemaLead.Tables["Node_Status"].Columns["Buddy_TimeStamp"].ProviderDataType = SqlDbType.DateTime.ToString();
syncSchemaLead.Tables["Node_Status"].Columns["Buddy_TimeStamp"].MaxLength = 30;
sync.CreateSchema(tblNode_Status, syncSchemaLead);
}
if (VMuktiInfo.CurrentPeer.DisplayName != null && VMuktiInfo.CurrentPeer.DisplayName != string.Empty)
{
fncSNInsertBuddy(VMuktiInfo.CurrentPeer.DisplayName, "Online");
}
}
catch (Exception ex)
{
VMuktiHelper.ExceptionHandler(ex, "fncCreateBuddyStatusTable()", "Domains\\BootstrapServiceDomain.cs");
}
}
// SqlCeConnection ce = null;
public void CreateInitialLocalDB(string strConnectionString, bool isCreated)
{
try
{
strClientConnectionString = strConnectionString;
// sync = new SqlCeClientSyncProvider(strClientConnectionString);
clientSyncProvider = new SqlCeClientSyncProvider(strClientConnectionString);
if (!isCreated)
{
SqlCeEngine clientEngine = new SqlCeEngine(strClientConnectionString);
clientEngine.CreateDatabase();
clientEngine.Dispose();
tblCallTable = CreateCallTable();
tblLeadsTable = CreateLeadsTable();
tblCallBackTable = CreateCallBackTable();
}
else
{
tblCallTable = new SyncTable("Call");
tblCallTable.SyncDirection = SyncDirection.UploadOnly;
tblLeadsTable = new SyncTable("Leads");
tblLeadsTable.SyncDirection = SyncDirection.UploadOnly;
tblCallBackTable = new SyncTable("CallBack");
tblCallBackTable.SyncDirection = SyncDirection.UploadOnly;
}
strClientConnectionString = strConnectionString;
// sync = new SqlCeClientSyncProvider(strClientConnectionString);
serverSyncProvider = new DbServerSyncProvider();
syncAgent = new SyncAgent();
// syncAgent.ServerSyncProvider = serverSyncProvider;
syncAgent.RemoteProvider = serverSyncProvider;
serverConnection = new SqlConnection(VMuktiInfo.MainConnectionString);
serverSyncProvider.Connection = serverConnection;
//SqlCommand cmdAnchor = new SqlCommand();
// cmdAnchor.CommandType = CommandType.Text;
// cmdAnchor.CommandText = "SELECT @@DBTS";
// serverSyncProvider.SelectNewAnchorCommand = cmdAnchor;
// SqlCommand cmdClientId = new SqlCommand();
// cmdClientId.CommandType = CommandType.Text;
// cmdClientId.CommandText = "SELECT 1";
// serverSyncProvider.SelectClientIdCommand = cmdClientId;
//syncAgent.ClientSyncProvider = clientSyncProvider;
syncAgent.LocalProvider = clientSyncProvider;
myGroup = new SyncGroup("DialerGroup");
tblCallTable.SyncGroup = myGroup;
tblLeadsTable.SyncGroup = myGroup;
tblCallBackTable.SyncGroup = myGroup;
//syncAgent.SyncTables.Add(tblCallTable);
//syncAgent.SyncTables.Add(tblLeadsTable);
//syncAgent.SyncTables.Add(tblCallBackTable);
syncAgent.Configuration.SyncTables.Add(tblCallTable);
syncAgent.Configuration.SyncTables.Add(tblLeadsTable);
syncAgent.Configuration.SyncTables.Add(tblCallBackTable);
CallAdapter = new SqlSyncAdapterBuilder();
CallAdapter.Connection = serverConnection;
CallAdapter.SyncDirection = SyncDirection.UploadOnly;
CallAdapter.TableName = "Call";
CallAdapter.DataColumns.Add("ID");
CallAdapter.DataColumns.Add("LeadID");
CallAdapter.DataColumns.Add("CalledDate");
CallAdapter.DataColumns.Add("ModifiedDate");
CallAdapter.DataColumns.Add("ModifiedBy");
CallAdapter.DataColumns.Add("GeneratedBy");
CallAdapter.DataColumns.Add("StartDate");
CallAdapter.DataColumns.Add("StartTime");
CallAdapter.DataColumns.Add("DurationInSecond");
CallAdapter.DataColumns.Add("DespositionID");
CallAdapter.DataColumns.Add("CampaignID");
CallAdapter.DataColumns.Add("ConfID");
CallAdapter.DataColumns.Add("IsDeleted");
CallAdapter.DataColumns.Add("CallNote");
CallAdapter.DataColumns.Add("IsDNC");
CallAdapter.DataColumns.Add("IsGlobal");
CallAdapterSyncAdapter = CallAdapter.ToSyncAdapter();
CallAdapterSyncAdapter.DeleteCommand = null;
serverSyncProvider.SyncAdapters.Add(CallAdapterSyncAdapter);
LeadAdapter = new SqlSyncAdapterBuilder();
LeadAdapter.Connection = serverConnection;
LeadAdapter.SyncDirection = SyncDirection.UploadOnly;
LeadAdapter.TableName = "Leads";
LeadAdapter.DataColumns.Add("ID");
LeadAdapter.DataColumns.Add("PhoneNo");
LeadAdapter.DataColumns.Add("LeadFormatID");
LeadAdapter.DataColumns.Add("CreatedDate");
LeadAdapter.DataColumns.Add("CreatedBy");
LeadAdapter.DataColumns.Add("DeletedDate");
LeadAdapter.DataColumns.Add("DeletedBy");
LeadAdapter.DataColumns.Add("IsDeleted");
LeadAdapter.DataColumns.Add("ModifiedDate");
LeadAdapter.DataColumns.Add("ModifiedBy");
LeadAdapter.DataColumns.Add("DNCFlag");
LeadAdapter.DataColumns.Add("DNCBy");
LeadAdapter.DataColumns.Add("ListID");
LeadAdapter.DataColumns.Add("LocationID");
LeadAdapter.DataColumns.Add("RecycleCount");
LeadAdapter.DataColumns.Add("Status");
LeadAdapter.DataColumns.Add("IsGlobalDNC");
//LeadAdapter.DataColumns.Add("LastEditDate");
//LeadAdapter.DataColumns.Add("CreationDate");
LeadAdapterSyncAdapter = LeadAdapter.ToSyncAdapter();
LeadAdapterSyncAdapter.DeleteCommand = null;
LeadAdapterSyncAdapter.InsertCommand = null;
//LeadAdapterSyncAdapter.ColumnMappings.Add("Status", "Status");
//LeadAdapterSyncAdapter.ColumnMappings.Add("DNCFlag", "DNCFlag");
//LeadAdapterSyncAdapter.ColumnMappings.Add("DNCBy", "DNCBy");
serverSyncProvider.SyncAdapters.Add(LeadAdapterSyncAdapter);
CallBackAdapter = new SqlSyncAdapterBuilder();
CallBackAdapter.Connection = serverConnection;
CallBackAdapter.SyncDirection = SyncDirection.UploadOnly;
CallBackAdapter.TableName = "CallBack";
CallBackAdapter.DataColumns.Add("ID");
CallBackAdapter.DataColumns.Add("CallID");
CallBackAdapter.DataColumns.Add("CallBackDate");
CallBackAdapter.DataColumns.Add("Comment");
CallBackAdapter.DataColumns.Add("IsPublic");
CallBackAdapter.DataColumns.Add("IsDeleted");
CallBackAdapterSyncAdapter = CallBackAdapter.ToSyncAdapter();
CallBackAdapterSyncAdapter.DeleteCommand = null;
serverSyncProvider.SyncAdapters.Add(CallBackAdapterSyncAdapter);
CheckPreviousSyncWithServer();
}
catch (Exception ex)
{
VMuktiAPI.VMuktiHelper.ExceptionHandler(ex, "CreateInitialLocalDB()", "ClsUserDataService.cs");
//MessageBox.Show("CreateInitialLocalDB: " + ex.Message);
}
}
public void CreateInitialLocalDB(string strConnectionString,bool isCreated)
{
try
{
strClientConnectionString = strConnectionString;
// sync = new SqlCeClientSyncProvider(strClientConnectionString);
clientSyncProvider = new SqlCeClientSyncProvider(strClientConnectionString);
if (!isCreated)
{
SqlCeEngine clientEngine = new SqlCeEngine(strClientConnectionString);
clientEngine.CreateDatabase();
clientEngine.Dispose();
tblCallTable = CreateCallTable();
tblLeadsTable = CreateLeadsTable();
tblCallBackTable = CreateCallBackTable();
tblDispositionTable = CreateDispositionTable();
}
else
{
tblCallTable = new SyncTable("Call");
tblCallTable.SyncDirection = SyncDirection.UploadOnly;
tblLeadsTable = new SyncTable("Leads");
tblLeadsTable.SyncDirection = SyncDirection.UploadOnly;
tblCallBackTable = new SyncTable("CallBack");
tblCallBackTable.SyncDirection = SyncDirection.UploadOnly;
//Creating Disposition Table (Added by Alpa)
tblDispositionTable = new SyncTable("Disposition");
tblDispositionTable.SyncDirection = SyncDirection.UploadOnly;
}
strClientConnectionString = strConnectionString;
// sync = new SqlCeClientSyncProvider(strClientConnectionString);
serverSyncProvider = new DbServerSyncProvider();
syncAgent = new SyncAgent();
// syncAgent.ServerSyncProvider = serverSyncProvider;
syncAgent.RemoteProvider = serverSyncProvider;
serverConnection = new SqlConnection(VMuktiAPI.VMuktiInfo.MainConnectionString);
serverSyncProvider.Connection = serverConnection;
serverSyncProvider.ApplyChangeFailed += new EventHandler<ApplyChangeFailedEventArgs>(serverSyncProvider_ApplyChangeFailed);
//syncAgent.ClientSyncProvider = clientSyncProvider;
syncAgent.LocalProvider = clientSyncProvider;
myGroup = new SyncGroup("DialerGroup");
tblCallTable.SyncGroup = myGroup;
tblLeadsTable.SyncGroup = myGroup;
tblCallBackTable.SyncGroup = myGroup;
tblDispositionTable.SyncGroup = myGroup;
syncAgent.Configuration.SyncTables.Add(tblCallTable);
syncAgent.Configuration.SyncTables.Add(tblLeadsTable);
syncAgent.Configuration.SyncTables.Add(tblCallBackTable);
syncAgent.Configuration.SyncTables.Add(tblDispositionTable);
CallAdapter = new SqlSyncAdapterBuilder();
CallAdapter.Connection = serverConnection;
CallAdapter.SyncDirection = SyncDirection.UploadOnly;
CallAdapter.TableName = "Call";
// CallAdapter.DataColumns.Add("ID");
CallAdapter.DataColumns.Add("LeadID");
CallAdapter.DataColumns.Add("CalledDate");
CallAdapter.DataColumns.Add("ModifiedDate");
CallAdapter.DataColumns.Add("ModifiedBy");
CallAdapter.DataColumns.Add("GeneratedBy");
CallAdapter.DataColumns.Add("StartDate");
CallAdapter.DataColumns.Add("StartTime");
CallAdapter.DataColumns.Add("DurationInSecond");
CallAdapter.DataColumns.Add("DespositionID");
CallAdapter.DataColumns.Add("CampaignID");
CallAdapter.DataColumns.Add("ConfID");
CallAdapter.DataColumns.Add("IsDeleted");
CallAdapter.DataColumns.Add("CallNote");
CallAdapter.DataColumns.Add("IsDNC");
CallAdapter.DataColumns.Add("IsGlobal");
CallAdapter.DataColumns.Add("RecordedFileName"); //For Recording File Name
CallAdapterSyncAdapter = CallAdapter.ToSyncAdapter();
CallAdapterSyncAdapter.DeleteCommand = null;
serverSyncProvider.SyncAdapters.Add(CallAdapterSyncAdapter);
LeadAdapter = new SqlSyncAdapterBuilder();
LeadAdapter.Connection = serverConnection;
LeadAdapter.SyncDirection = SyncDirection.UploadOnly;
LeadAdapter.TableName = "Leads";
LeadAdapter.DataColumns.Add("ID");
LeadAdapter.DataColumns.Add("PhoneNo");
LeadAdapter.DataColumns.Add("LeadFormatID");
LeadAdapter.DataColumns.Add("CreatedDate");
LeadAdapter.DataColumns.Add("CreatedBy");
LeadAdapter.DataColumns.Add("DeletedDate");
LeadAdapter.DataColumns.Add("DeletedBy");
LeadAdapter.DataColumns.Add("IsDeleted");
LeadAdapter.DataColumns.Add("ModifiedDate");
LeadAdapter.DataColumns.Add("ModifiedBy");
LeadAdapter.DataColumns.Add("DNCFlag");
LeadAdapter.DataColumns.Add("DNCBy");
LeadAdapter.DataColumns.Add("ListID");
LeadAdapter.DataColumns.Add("LocationID");
LeadAdapter.DataColumns.Add("RecycleCount");
LeadAdapter.DataColumns.Add("Status");
LeadAdapter.DataColumns.Add("IsGlobalDNC");
//LeadAdapter.DataColumns.Add("LastEditDate");
//LeadAdapter.DataColumns.Add("CreationDate");
LeadAdapterSyncAdapter = LeadAdapter.ToSyncAdapter();
LeadAdapterSyncAdapter.DeleteCommand = null;
LeadAdapterSyncAdapter.InsertCommand = null;
serverSyncProvider.SyncAdapters.Add(LeadAdapterSyncAdapter);
CallBackAdapter = new SqlSyncAdapterBuilder();
CallBackAdapter.Connection = serverConnection;
CallBackAdapter.SyncDirection = SyncDirection.UploadOnly;
CallBackAdapter.TableName = "CallBack";
CallBackAdapter.DataColumns.Add("ID");
CallBackAdapter.DataColumns.Add("CallID");
CallBackAdapter.DataColumns.Add("CallBackDate");
CallBackAdapter.DataColumns.Add("Comment");
CallBackAdapter.DataColumns.Add("IsPublic");
CallBackAdapter.DataColumns.Add("IsDeleted");
CallBackAdapterSyncAdapter = CallBackAdapter.ToSyncAdapter();
CallBackAdapterSyncAdapter.DeleteCommand = null;
serverSyncProvider.SyncAdapters.Add(CallBackAdapterSyncAdapter);
//Creating Disposition Table in sdf (Added by Alpa)
DispositionAdapter = new SqlSyncAdapterBuilder();
DispositionAdapter.Connection = serverConnection;
DispositionAdapter.SyncDirection = SyncDirection.UploadOnly;
DispositionAdapter.TableName = "Disposition";
DispositionAdapter.DataColumns.Add("ID");
DispositionAdapter.DataColumns.Add("DespositionName");
DispositionAdapter.DataColumns.Add("Description");
DispositionAdapter.DataColumns.Add("IsActive");
DispositionAdapter.DataColumns.Add("IsDeleted");
DispositionAdapter.DataColumns.Add("CreatedDate");
DispositionAdapter.DataColumns.Add("CreatedBy");
DispositionAdapter.DataColumns.Add("ModifiedDate");
DispositionAdapter.DataColumns.Add("ModifiedBy");
DispositionAdapterSyncAdapter = DispositionAdapter.ToSyncAdapter();
DispositionAdapterSyncAdapter.DeleteCommand = null;
DispositionAdapterSyncAdapter.InsertCommand = null;
serverSyncProvider.SyncAdapters.Add(DispositionAdapterSyncAdapter);
ce = new SqlCeConnection(strClientConnectionString);
ce.Open();
CheckPreviousSyncWithServer();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void fncActiveCallTable()
{
try
{
if (false == File.Exists(strLocalDBPath))
{
SqlCeEngine clientEngine = new SqlCeEngine(ClientConnectionString);
clientEngine.CreateDatabase();
}
if (!IsTableExits("Active_call"))
{
SqlCeClientSyncProvider sync = new SqlCeClientSyncProvider(ClientConnectionString);
SyncTable tblActive_call = new SyncTable("Active_call");
SyncSchema syncSchemaLead = new SyncSchema();
syncSchemaLead.Tables.Add("Active_call");
syncSchemaLead.Tables["Active_call"].Columns.Add("uName");
syncSchemaLead.Tables["Active_call"].Columns["uName"].ProviderDataType = SqlDbType.NVarChar.ToString();
syncSchemaLead.Tables["Active_call"].Columns["uName"].AutoIncrement = false;
syncSchemaLead.Tables["Active_call"].Columns["uName"].AutoIncrementSeed = 0;
syncSchemaLead.Tables["Active_call"].Columns["uName"].AutoIncrementStep = 1;
syncSchemaLead.Tables["Active_call"].Columns["uName"].MaxLength = 30;
syncSchemaLead.Tables["Active_call"].PrimaryKey = new string[] { "uName" };
syncSchemaLead.Tables["Active_call"].Columns.Add("Campaign_Id");
syncSchemaLead.Tables["Active_call"].Columns["Campaign_Id"].ProviderDataType = SqlDbType.NVarChar.ToString();
syncSchemaLead.Tables["Active_call"].Columns["Campaign_Id"].MaxLength = 30;
syncSchemaLead.Tables["Active_call"].Columns["Campaign_Id"].AutoIncrement = false;
syncSchemaLead.Tables["Active_call"].Columns["Campaign_Id"].AutoIncrementSeed = 0;
syncSchemaLead.Tables["Active_call"].Columns["Campaign_Id"].AutoIncrementStep = 1;
syncSchemaLead.Tables["Active_call"].Columns.Add("Status");
syncSchemaLead.Tables["Active_call"].Columns["Status"].ProviderDataType = SqlDbType.NVarChar.ToString();
syncSchemaLead.Tables["Active_call"].Columns["Status"].MaxLength = 30;
syncSchemaLead.Tables["Active_call"].Columns["Status"].AutoIncrement = false;
syncSchemaLead.Tables["Active_call"].Columns["Status"].AutoIncrementSeed = 0;
syncSchemaLead.Tables["Active_call"].Columns["Status"].AutoIncrementStep = 1;
syncSchemaLead.Tables["Active_call"].Columns.Add("Group_Name");
syncSchemaLead.Tables["Active_call"].Columns["Group_Name"].ProviderDataType = SqlDbType.NVarChar.ToString();
syncSchemaLead.Tables["Active_call"].Columns["Group_Name"].MaxLength = 30;
syncSchemaLead.Tables["Active_call"].Columns["Group_Name"].AutoIncrement = false;
syncSchemaLead.Tables["Active_call"].Columns["Group_Name"].AutoIncrementSeed = 0;
syncSchemaLead.Tables["Active_call"].Columns["Group_Name"].AutoIncrementStep = 1;
syncSchemaLead.Tables["Active_call"].Columns.Add("Phone_No");
syncSchemaLead.Tables["Active_call"].Columns["Phone_No"].ProviderDataType = SqlDbType.NVarChar.ToString();
syncSchemaLead.Tables["Active_call"].Columns["Phone_No"].MaxLength = 30;
syncSchemaLead.Tables["Active_call"].Columns["Phone_No"].AutoIncrement = false;
syncSchemaLead.Tables["Active_call"].Columns["Phone_No"].AutoIncrementSeed = 0;
syncSchemaLead.Tables["Active_call"].Columns["Phone_No"].AutoIncrementStep = 1;
syncSchemaLead.Tables["Active_call"].Columns.Add("callDuration");
syncSchemaLead.Tables["Active_call"].Columns["callDuration"].ProviderDataType = SqlDbType.NVarChar.ToString();
syncSchemaLead.Tables["Active_call"].Columns["callDuration"].MaxLength = 30;
syncSchemaLead.Tables["Active_call"].Columns["callDuration"].AutoIncrement = false;
syncSchemaLead.Tables["Active_call"].Columns["callDuration"].AutoIncrementSeed = 0;
syncSchemaLead.Tables["Active_call"].Columns["callDuration"].AutoIncrementStep = 1;
sync.CreateSchema(tblActive_call, syncSchemaLead);
}
}
catch (Exception ex)
{
VMuktiAPI.VMuktiHelper.ExceptionHandler(ex, "fncActivecallTable()", "ctlrptActiveCall.xaml.cs");
}
}
public SyncState(SqlCeClientSyncProvider _localProvider)
{
localProvider = _localProvider;
TableStatus activityTable = new TableStatus(localProvider, "Activity", "serverid=0", "InTrash=1");
}
