public void insertDeviceRouting(DeviceRoutingEntity devRoutingEntity)
{
validateTargetId(devRoutingEntity);
string sqltext = "INSERT INTO RBFX.DeviceRouting ("
+ "DeviceId,RoutingKeyword,TargetType,TargetDeviceGroupId,TargetDeviceId,"
+ "Status,Description,Registered_DateTime"
+ ") VALUES "
+ "(@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8)";
SqlConnection conn = new SqlConnection(this.sqlConnectionString);
try
{
conn.Open();
SqlCommand cmd = new SqlCommand(sqltext, conn);
AddSqlParameter(ref cmd, "@p1", SqlDbType.NVarChar, devRoutingEntity.DeviceId);
AddSqlParameter(ref cmd, "@p2", SqlDbType.NVarChar, devRoutingEntity.RoutingKeyword);
AddSqlParameter(ref cmd, "@p3", SqlDbType.NVarChar, devRoutingEntity.TargetType);
AddSqlParameter(ref cmd, "@p4", SqlDbType.NVarChar, devRoutingEntity.TargetDeviceGroupId);
AddSqlParameter(ref cmd, "@p5", SqlDbType.NVarChar, devRoutingEntity.TargetDeviceId);
AddSqlParameter(ref cmd, "@p6", SqlDbType.NVarChar, devRoutingEntity.Status);
AddSqlParameter(ref cmd, "@p7", SqlDbType.NVarChar, devRoutingEntity.Description);
AddSqlParameter(ref cmd, "@p8", SqlDbType.DateTime, devRoutingEntity.Registered_DateTime);
cmd.ExecuteNonQuery();
conn.Close();
}
catch (Exception ex)
{
conn.Close();
throw ex;
}
}
public EditDevRoutingForm(string sqlConnectionString)
{
InitializeComponent();
this.sqlConnectionString = sqlConnectionString;
devRoutingEntity = new DeviceRoutingEntity();
devRoutingEntity.DeviceId = string.Empty;
devRoutingEntity.RoutingKeyword = CRoboticsConst.RoutingKeywordDefault;
this.createStatus = true;
}
private DeviceRoutingEntity getDeviceRoutingEntity()
{
DeviceRoutingEntity devRoutingEntity = new DeviceRoutingEntity();
devRoutingEntity.DeviceId = textBoxDeviceId.Text;
devRoutingEntity.RoutingKeyword = textBoxRoutingKeyword.Text;
devRoutingEntity.TargetType = comboBoxTargetDeviceType.Text;
devRoutingEntity.TargetDeviceGroupId = textBoxTargetDevGroupId.Text;
devRoutingEntity.TargetDeviceId = textBoxTargetDeviceId.Text;
devRoutingEntity.Status = comboBoxStatus.Text;
devRoutingEntity.Description = textBoxDesc.Text;
devRoutingEntity.Registered_DateTime = DateTime.Now;
return(devRoutingEntity);
}
public EditDevRoutingForm(string sqlConnectionString, DeviceRoutingEntity devRoutingEntity)
{
InitializeComponent();
this.sqlConnectionString = sqlConnectionString;
this.devRoutingEntity = devRoutingEntity;
if (devRoutingEntity.DeviceId == string.Empty)
{
throw (new ApplicationException("Device ID is nothing !!"));
}
if (devRoutingEntity.RoutingKeyword == string.Empty)
{
throw (new ApplicationException("Routing Keyword is nothing !!"));
}
this.createStatus = false;
}
private void createButton_Click(object sender, EventArgs e)
{
if (!checkInputData())
{
return;
}
try
{
DeviceRoutingEntity devRoutingEntity = getDeviceRoutingEntity();
DeviceRoutingProcessor devRouteProcessor = new DeviceRoutingProcessor(sqlConnectionString);
devRouteProcessor.insertDeviceRouting(devRoutingEntity);
MessageBox.Show("Device Routing created successfully!", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
throw ex;
}
this.Close();
}
public void updateDeviceRouting(DeviceRoutingEntity devRoutingEntity)
{
validateTargetId(devRoutingEntity);
string sqltext = "UPDATE RBFX.DeviceRouting SET "
+ "TargetType = @p3,"
+ "TargetDeviceGroupId = @p4,"
+ "TargetDeviceId = @p5,"
+ "Status = @p6,"
+ "Description = @p7,"
+ "Registered_DateTime = @p8 "
+ "WHERE DeviceId = @p1 AND RoutingKeyword = @p2";
SqlConnection conn = new SqlConnection(this.sqlConnectionString);
try
{
conn.Open();
SqlCommand cmd = new SqlCommand(sqltext, conn);
AddSqlParameter(ref cmd, "@p1", SqlDbType.NVarChar, devRoutingEntity.DeviceId);
AddSqlParameter(ref cmd, "@p2", SqlDbType.NVarChar, devRoutingEntity.RoutingKeyword);
AddSqlParameter(ref cmd, "@p3", SqlDbType.NVarChar, devRoutingEntity.TargetType);
AddSqlParameter(ref cmd, "@p4", SqlDbType.NVarChar, devRoutingEntity.TargetDeviceGroupId);
AddSqlParameter(ref cmd, "@p5", SqlDbType.NVarChar, devRoutingEntity.TargetDeviceId);
AddSqlParameter(ref cmd, "@p6", SqlDbType.NVarChar, devRoutingEntity.Status);
AddSqlParameter(ref cmd, "@p7", SqlDbType.NVarChar, devRoutingEntity.Description);
AddSqlParameter(ref cmd, "@p8", SqlDbType.DateTime, devRoutingEntity.Registered_DateTime);
cmd.ExecuteNonQuery();
conn.Close();
}
catch (Exception ex)
{
conn.Close();
throw ex;
}
}
private void validateTargetId(DeviceRoutingEntity devRoutingEntity)
{
if (devRoutingEntity.TargetType == CRoboticsConst.TypeDeviceGroup)
{
if (!existDeviceGroupId(devRoutingEntity.TargetDeviceGroupId))
{
ae = new ApplicationException("Input Device Group ID not exist in RBFX.DeviceGroup");
throw ae;
}
}
else if (devRoutingEntity.TargetType == CRoboticsConst.TypeDevice)
{
if (!existDeviceId(devRoutingEntity.TargetDeviceId))
{
ae = new ApplicationException("Input Device ID not exist in RBFX.DeviceMaster");
throw ae;
}
}
else
{
ae = new ApplicationException($"Input Target Type must be \"{CRoboticsConst.TypeDeviceGroup}\" or \"{CRoboticsConst.TypeDevice}\"");
throw ae;
}
}
public List <DeviceRoutingEntity> GetDeviceRoutings(string deviceId)
{
deviceId = deviceId.Replace("*", "%");
string sqltext = "SELECT DeviceId,RoutingKeyword,TargetType,TargetDeviceGroupId,TargetDeviceId,"
+ "Status,Description,Registered_DateTime "
+ "FROM RBFX.DeviceRouting "
+ "WHERE DeviceId LIKE @p1 ORDER BY DeviceId,RoutingKeyword";
List <DeviceRoutingEntity> listOfDeviceRoutings = new List <DeviceRoutingEntity>();
SqlConnection conn = new SqlConnection(this.sqlConnectionString);
try
{
conn.Open();
SqlCommand cmd = new SqlCommand(sqltext, conn);
AddSqlParameter(ref cmd, "@p1", SqlDbType.NVarChar, deviceId);
SqlDataReader reader = cmd.ExecuteReader();
if (!reader.HasRows)
{
ae = new ApplicationException("No record was found in RBFX.DeviceRouting");
throw ae;
}
while (reader.Read())
{
DeviceRoutingEntity devRoutingEntity = new DeviceRoutingEntity();
devRoutingEntity.DeviceId = reader.GetString(0);
devRoutingEntity.RoutingKeyword = reader.GetString(1);
devRoutingEntity.TargetType = reader.GetString(2);
if (!reader.IsDBNull(3))
{
devRoutingEntity.TargetDeviceGroupId = reader.GetString(3);
}
else
{
devRoutingEntity.TargetDeviceGroupId = string.Empty;
}
if (!reader.IsDBNull(4))
{
devRoutingEntity.TargetDeviceId = reader.GetString(4);
}
else
{
devRoutingEntity.TargetDeviceId = string.Empty;
}
devRoutingEntity.Status = reader.GetString(5);
if (!reader.IsDBNull(6))
{
devRoutingEntity.Description = reader.GetString(6);
}
else
{
devRoutingEntity.Description = string.Empty;
}
if (!reader.IsDBNull(7))
{
devRoutingEntity.Registered_DateTime = reader.GetDateTime(7);
}
listOfDeviceRoutings.Add(devRoutingEntity);
}
reader.Close();
conn.Close();
}
catch (Exception ex)
{
if (ex.GetType().Equals(ae))
{
conn.Close();
}
throw (ex);
}
return(listOfDeviceRoutings);
}