public static string getQueryUpdateDevice(Device device)
{
return string.Format("UPDATE {0} SET {1}='{2}',{3}='{4}',{5}='{6}',{7}='{8}',{9}='{10}',{11}='{12}',{13}='{14}' WHERE {15}='{16}'",
ID_TABLE_DEVICE,
ID_DESCRIPTION_DEVICE, device.Description,
ID_APPLIANCEID_DEVICE,device.Appliance.Id,
ID_MANUFACTURERID_DEVICE,device.Manufacturer.Id,
ID_UPDATETIME_DEVICE, device.UpdateLocalDateTime.ToString(DATETIMEFORMATINSERT_DEVICE),
ID_UPDATEUSER_DEVICE,device.UpdateUser,
ID_OUTPUT_DEVICE,device.OutPut.ToString(),
ID_GATEWAY_DEVICE,device.Gateway.Id,
ID_DEVICEID_DEVICE,device.Id
);
}
public static string getQuerySaveDevice(Device device)
{
return string.Format("INSERT INTO {0} VALUES('{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}')", ID_TABLE_DEVICE,
device.Id,
device.Description,
device.Appliance.Id,
device.Manufacturer.Id,
device.LocalInsertTime.ToString(DATETIMEFORMATINSERT_DEVICE),
device.InsertUser,
device.UpdateLocalDateTime.ToString(DATETIMEFORMATINSERT_DEVICE),
device.UpdateUser,
device.OutPut.ToString(),
device.Gateway.Id);
}
public void Update(Device device)
{
_repositoryHelper.UpdateDevice(device);
}
public void Save(Device device)
{
_repositoryHelper.SaveDevice(device);
}
public bool Exists(Device device)
{
return Get(device.Id) != null;
}
public static IList<Device> ParseDataSetToDevice(DataTable dataTable)
{
IList<Device> deviceList = new List<Device>();
foreach (DataRow row in dataTable.Rows)
{
Device device = new Device()
{
Id = row[POSITION_DEVICEID_DEVICE].ToString(),
Description = row[POSITION_DESCRIPTION_DEVICE].ToString(),
Appliance = new Appliance(row[POSITION_APPLIANCEID_DEVICE].ToString()),
Manufacturer = new Manufacturer(row[POSITION_MANUFACTURERID_DEVICE].ToString()),
LocalInsertTime = getDateTime(row[POSITION_INSERTTIME_DEVICE].ToString(), DATETIMEFORMATINSERT_DEVICE),
InsertUser = row[POSITION_INSERTUSER_DEVICE].ToString(),
UpdateLocalDateTime = getDateTime(row[POSITION_UPDATETIME_DEVICE].ToString(), DATETIMEFORMATINSERT_DEVICE),
UpdateUser = row[POSITION_UPDATEUSER_DEVICE].ToString(),
OutPut = TryParseBoolean(row[POSITION_OUTPUT_DEVICE].ToString()),
Gateway = new Gateway(row[POSITION_GATEWAY_DEVICE].ToString())
};
deviceList.Add(device);
}
return deviceList;
}
public void SaveDevice(Device device)
{
string query = DeviceQuery.getQuerySaveDevice(device);
DeviceQuery.ParseDataSetToDevice(_provider.queryExecute(query,INSERT_TYPE));
}
public void UpdateDevice(Device device)
{
string query = DeviceQuery.getQueryUpdateDevice(device);
DeviceQuery.ParseDataSetToDevice(_provider.queryExecute(query,UPDATE_TYPE));
}
