public static void DFT_MoveRoomTypeDataForSHGroup()
{
var sourceCon = PMSDBManager.GetPMSConnectionString();
var destinationCon = CRMDBManager.GetCRMConnectionString();
var tableName = "dbo.L_Data_Dictionary";
var sql = PMSDBManager.SQL_GetRoomTypeDataForSHGroup;
var lSql = CRMDBManager.SQL_GetRoomTypesForSHGroup;
var lKeys = new Dictionary <string, string>();
lKeys.Add("CendynPropertyID", "CendynPropertyID");
lKeys.Add("FieldValue", "FieldValue");
lKeys.Add("FieldName", "FieldName");
var lMapping = new Dictionary <string, string>();
lMapping.Add("PropertyCode", "PropertyCode");
var primaryKeys = new List <string>()
{
"PropertyCode", "FieldValue", "FieldName"
};
var updateFields = new List <string>()
{
"Description", "Notes"
};
new DataFlowTask <L_Data_Dictionary, L_Data_Dictionary, L_Data_Dictionary>().runTask(sourceCon, destinationCon, destinationCon, tableName, sql, lSql, lKeys, lMapping, null, true, false, primaryKeys, updateFields);
}
public static void DFT_UpdateShowAlphaCodeData()
{
var sourceCon = CRMDBManager.GetCRMConnectionString();
var tableName = "dbo.L_Data_Dictionary";
var sql = CRMDBManager.SQL_GetShowAlphaCodeAndShowName;
var primaryKeys = new List <string>()
{
"PropertyCode", "FieldValue", "FieldName"
};
var updateFields = new List <string>()
{
"Description"
};
new DataFlowTask <L_Data_Dictionary>().runTask(sourceCon, sourceCon, tableName, sql, true, true, primaryKeys, updateFields);
}