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");
}
}
// 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");
}
}
/// <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");
}
}
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");
}
}
