public int CovertTableLogger()
{
int nRows = 0;
GetDataLoggerTableOlDBAction getDataLoggerTableOlDBAction = new GetDataLoggerTableOlDBAction();
GetChannelOldDBAction getChannelOldDBAction = new GetChannelOldDBAction();
List <t_Channel_Configurations> list = getChannelOldDBAction.GetChannelConfiguration();
InsertDataLoggerTableNewDBAction insertDataLoggerTableNewDBAction = new InsertDataLoggerTableNewDBAction();
foreach (var item in list)
{
List <DataLoggerModel> temp = getDataLoggerTableOlDBAction.GetDataLogger(item.ChannelId);
nRows += insertDataLoggerTableNewDBAction.Insert(item.ChannelId, temp);
}
return(nRows);
}
public int ConvertChannel()
{
int nRows = 0;
GetChannelOldDBAction getChannelOldDBAction = new GetChannelOldDBAction();
List <t_Channel_Configurations> list = getChannelOldDBAction.GetChannelConfiguration();
InsertChannelNewDBAction insertChannelNewDBAction = new InsertChannelNewDBAction();
List <t_Devices_ChannelsConfigs> listNew = new List <t_Devices_ChannelsConfigs>();
List <string> listChannel = new List <string>();
foreach (var item in list)
{
t_Devices_ChannelsConfigs el = new t_Devices_ChannelsConfigs();
el.Id = item.ChannelId;
el.LoggerId = item.LoggerId;
el.Name = item.ChannelName;
el.Unit = item.Unit;
listChannel.Add(item.ChannelId);
listNew.Add(el);
}
nRows += insertChannelNewDBAction.Insert(listNew);
CreateDataLoggerTableAction createDataLoggerTableAction = new CreateDataLoggerTableAction();
nRows += createDataLoggerTableAction.CreateDataLoggerTable(listChannel);
return(nRows);
}