public void RowChanged()
{
//fetching the changes
string[] columns = new string[7] {
"DepId", "BranchId", "empId", "DOB", "FirstName", "LastName", "LocationId",
};
object[] values = new object[7] {
33, 99, 36, DateTime.Now, "Nithin", "Chandran", 25,
};
//fetch collection if any
_docModel = GetFromMongo(null);
//set current values in attributes
for (int i = 0; i < columns.Length; i++)
{
IRelationalAttribute attr = this[columns[i]];
attr.Value = values[i];
attr.HasChange = true;
}
//creating object
_docModel = this.CreateModel();//set newly created, processed model here
//Trigger user defined events if any
if (OnRowChange != null)
{
OnRowChange(this, new EventArgs());
}
}
private void PrepareModel(object sender, EventArgs e)
{
var changedTables = ((ChangeDetectedEventArgs)e).Tables;
SqlCommand cmd = new SqlCommand();
cmd.Connection = _sqlConnection;
if (_sqlConnection.State == ConnectionState.Closed)
{
_sqlConnection.Open();
}
//loop : change detected tables-start
foreach (var Changedtable in changedTables)
{
IList <ITable> mappings = base[Changedtable.TableName, Changedtable.TableSchema];
if (mappings != null && mappings.Count != 0)
{
ITable first = mappings[0];
Type firstType = first.GetType();
IRelationalAttribute key = (IRelationalAttribute)firstType.GetMethod("GetKey").Invoke(first, null);
cmd.CommandText = _QRY_GET_TABLE_CHANGE.Replace("{#table#}", Changedtable.CDCSchema.Embrace() + "." + Changedtable.CDCTable.Embrace()).Replace("{#keycolumn#}", key.Name);
DataTable dt = new DataTable();
new SqlDataAdapter(cmd).Fill(dt);
//loop : all mappings for a single sql table-start
List <long> keyIds = new List <long>();
for (int k = 0; k < mappings.Count; k++)
{
try
{
ITable table = mappings[k];
if (table == null)
{
Message.Info($"Mapping not found", $"Mapping not found for a cdc enabled table [{Changedtable.TableSchema}].[{Changedtable.TableName}]");
continue;
}
Type tableType = table.GetType();
if (dt != null && dt.Rows.Count != 0)
{
//loop : sync to mongo for all objects of a single table-start
for (int i = 0; i < dt.Rows.Count; i++)
{
try
{
//for simulating fail on second mapping sync uncomment below line
//if (k > 0 && i > 10) throw new Exception();
var docType = (Type)(tableType.GetProperty("DocumentModelType").GetValue(table));
var row = dt.Rows[i];
table.Change = (Change)row["__$operation"];
var keyAttribute = (IRelationalAttribute)tableType.GetMethod("GetKey").Invoke(table, null);
foreach (var col in dt.Columns)
{
var column = col.ToString();
if (!column.StartsWith("__$"))
{
IRelationalAttribute attr = table[column];
if (attr != null)
{
attr.HasChange = true;
attr.Value = row[column];
}
}
}
if (table.Change == Change.Delete)
{
tableType.GetMethod("DeleteFromMongo").Invoke(table, new object[] { keyAttribute.Value });
Message.Info("Deleted from [collection : " + table.Collection + "] & [Key : " + keyAttribute.Value + "]");
}
else
{
string msg = "Inserted to";
if (table.Change == Change.AfterUpdate || table.Change == Change.BeforeUpdate)
{
tableType.GetMethod("GetFromMongo").Invoke(table, new object[] { keyAttribute.Value });
tableType.GetMethod("DeleteFromMongo").Invoke(table, new object[] { keyAttribute.Value });
msg = "Updated";
}
var model = tableType.GetMethod("CreateModel").Invoke(table, null);
var bson = model.ToBsonDocument();
// Create a MongoClient object by using the connection string
var client = new MongoClient(_mongoConnectionString);
//Use the MongoClient to access the server
var database = client.GetDatabase(Constants.NoSqlDB);
//get mongodb collection
var collection = database.GetCollection <BsonDocument>(table.Collection);
collection.InsertOne(bson);
Message.Success($"{msg} [collection : { table.Collection }] & [Key : {keyAttribute.Value}]");
}
//complete synchronization for a single object only after all mappings are done
if (k == mappings.Count - 1)
{
keyIds.Add(Convert.ToInt64(row["__$id"]));
}
}
catch (Exception ex)
{
Message.Error(ex.Message, $"Synchronisation(single) failed for {Changedtable.TableSchema.Embrace()}.{Changedtable.TableName.Embrace()}");
}
}//loop : sync to mongo for a all objects of a single table-end
}
}
catch (Exception exc)
{
Message.Error(exc.Message, $"Synchronization failed for {Changedtable.TableSchema.Embrace()}.{Changedtable.TableName.Embrace()}");
}
}//loop : all mappings for a single sql table-end
//set as synced in cdc
if (keyIds.Count != 0)
{
cmd.CommandText = _QRY_SET_AS_SYNCED.Replace("{#table#}", Changedtable.CDCSchema.Embrace() + "." + Changedtable.CDCTable.Embrace()).Replace("{#keyids#}", string.Join(",", keyIds));
cmd.ExecuteNonQuery();
}
}
}//loop : change detected tables-end
if (_sqlConnection.State == ConnectionState.Open)
{
_sqlConnection.Close();
}
}
