public void insertAppRouting(AppRoutingEntity appRoutingEntity)
{
string sqltext = "INSERT INTO RBFX.AppRouting2 ("
+ "AppId,AppProcessingId,HttpUri,"
+ "Status,Description,Registered_DateTime"
+ ") VALUES ("
+ "@p1,@p2,@p3,@p4,@p5,@p6)";
SqlConnection conn = new SqlConnection(this.sqlConnectionString);
try
{
conn.Open();
SqlCommand cmd = new SqlCommand(sqltext, conn);
AddSqlParameter(ref cmd, "@p1", SqlDbType.NVarChar, appRoutingEntity.AppId);
AddSqlParameter(ref cmd, "@p2", SqlDbType.NVarChar, appRoutingEntity.AppProcessingId);
AddSqlParameter(ref cmd, "@p3", SqlDbType.NVarChar, appRoutingEntity.HttpUri);
AddSqlParameter(ref cmd, "@p4", SqlDbType.NVarChar, appRoutingEntity.Status);
AddSqlParameter(ref cmd, "@p5", SqlDbType.NVarChar, appRoutingEntity.Description);
AddSqlParameter(ref cmd, "@p6", SqlDbType.DateTime, appRoutingEntity.Registered_DateTime);
cmd.ExecuteNonQuery();
conn.Close();
}
catch (Exception ex)
{
conn.Close();
throw ex;
}
}
public void insertAppRouting(AppRoutingEntity appRoutingEntity)
{
string sqltext = "INSERT INTO RBFX.AppRouting ("
+ "AppId,AppProcessingId,BlobContainer,FileName,ClassName,"
+ "Status,DevMode,DevLocalDir,Description,Registered_DateTime"
+ ") VALUES ("
+ "@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)";
SqlConnection conn = new SqlConnection(this.sqlConnectionString);
try
{
conn.Open();
SqlCommand cmd = new SqlCommand(sqltext, conn);
AddSqlParameter(ref cmd, "@p1", SqlDbType.NVarChar, appRoutingEntity.AppId);
AddSqlParameter(ref cmd, "@p2", SqlDbType.NVarChar, appRoutingEntity.AppProcessingId);
AddSqlParameter(ref cmd, "@p3", SqlDbType.NVarChar, appRoutingEntity.BlobContainer);
AddSqlParameter(ref cmd, "@p4", SqlDbType.NVarChar, appRoutingEntity.FileName);
AddSqlParameter(ref cmd, "@p5", SqlDbType.NVarChar, appRoutingEntity.ClassName);
AddSqlParameter(ref cmd, "@p6", SqlDbType.NVarChar, appRoutingEntity.Status);
AddSqlParameter(ref cmd, "@p7", SqlDbType.NVarChar, appRoutingEntity.DevMode);
AddSqlParameter(ref cmd, "@p8", SqlDbType.NVarChar, appRoutingEntity.DevLocalDir);
AddSqlParameter(ref cmd, "@p9", SqlDbType.NVarChar, appRoutingEntity.Description);
AddSqlParameter(ref cmd, "@p10", SqlDbType.DateTime, appRoutingEntity.Registered_DateTime);
cmd.ExecuteNonQuery();
conn.Close();
}
catch (Exception ex)
{
conn.Close();
throw ex;
}
}
private void createButton_Click(object sender, EventArgs e)
{
if (!checkInputData())
{
return;
}
// Upload DLL file
if (checkBoxUploadToBlob.Checked)
{
if (!uploadDllFileToBlob())
{
return;
}
}
try
{
AppRoutingEntity appRoutingEntity = getAppRoutingEntity();
AppRoutingProcessor appRoutingProcessor = new AppRoutingProcessor(sqlConnectionString);
appRoutingProcessor.insertAppRouting(appRoutingEntity);
MessageBox.Show("App Routing created successfully!", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
throw ex;
}
this.Close();
}
public void updateAppRouting(AppRoutingEntity appRoutingEntity)
{
string sqltext = "UPDATE RBFX.AppRouting2 SET "
+ "HttpUri = @p3,"
+ "Status = @p4,"
+ "Description = @p5,"
+ "Registered_DateTime = @p6 "
+ "WHERE AppId = @p1 AND AppProcessingId = @p2";
SqlConnection conn = new SqlConnection(this.sqlConnectionString);
try
{
conn.Open();
SqlCommand cmd = new SqlCommand(sqltext, conn);
AddSqlParameter(ref cmd, "@p1", SqlDbType.NVarChar, appRoutingEntity.AppId);
AddSqlParameter(ref cmd, "@p2", SqlDbType.NVarChar, appRoutingEntity.AppProcessingId);
AddSqlParameter(ref cmd, "@p3", SqlDbType.NVarChar, appRoutingEntity.HttpUri);
AddSqlParameter(ref cmd, "@p4", SqlDbType.NVarChar, appRoutingEntity.Status);
AddSqlParameter(ref cmd, "@p5", SqlDbType.NVarChar, appRoutingEntity.Description);
AddSqlParameter(ref cmd, "@p6", SqlDbType.DateTime, appRoutingEntity.Registered_DateTime);
cmd.ExecuteNonQuery();
conn.Close();
}
catch (Exception ex)
{
conn.Close();
throw ex;
}
}
public EditAppRoutingForm(string sqlConnectionString, string encPassPhrase)
{
InitializeComponent();
this.sqlConnectionString = sqlConnectionString;
this.encPassPhrase = encPassPhrase;
appRoutingEntity = new AppRoutingEntity();
this.createStatus = true;
}
private AppRoutingEntity getAppRoutingEntity()
{
AppRoutingEntity appRoutingEntity = new AppRoutingEntity();
appRoutingEntity.AppId = textBoxAppId.Text;
appRoutingEntity.AppProcessingId = textBoxAppProcessingId.Text;
appRoutingEntity.HttpUri = textBoxHttpUri.Text;
appRoutingEntity.Status = comboBoxStatus.Text;
appRoutingEntity.Description = textBoxDesc.Text;
appRoutingEntity.Registered_DateTime = DateTime.Now;
return(appRoutingEntity);
}
private AppRoutingEntity getAppRoutingEntity()
{
AppRoutingEntity appRoutingEntity = new AppRoutingEntity();
appRoutingEntity.AppId = textBoxAppId.Text;
appRoutingEntity.AppProcessingId = textBoxAppProcessingId.Text;
appRoutingEntity.BlobContainer = textBoxBlobContainer.Text;
appRoutingEntity.FileName = textBoxFileName.Text;
appRoutingEntity.ClassName = textBoxClassName.Text;
appRoutingEntity.Status = comboBoxStatus.Text;
appRoutingEntity.DevMode = comboBoxDevMode.Text;
appRoutingEntity.DevLocalDir = textBoxDevLocalDir.Text;
appRoutingEntity.Description = textBoxDesc.Text;
appRoutingEntity.Registered_DateTime = DateTime.Now;
return(appRoutingEntity);
}
public EditAppRoutingForm(string sqlConnectionString, string encPassPhrase, AppRoutingEntity appRoutingEntity)
{
InitializeComponent();
this.sqlConnectionString = sqlConnectionString;
this.encPassPhrase = encPassPhrase;
this.appRoutingEntity = appRoutingEntity;
if (appRoutingEntity.AppId == string.Empty)
{
throw (new ApplicationException("App ID is nothing !!"));
}
if (appRoutingEntity.AppProcessingId == string.Empty)
{
throw (new ApplicationException("App Processing ID is nothing !!"));
}
this.createStatus = false;
}
public void updateAppRouting(AppRoutingEntity appRoutingEntity)
{
string sqltext = "UPDATE RBFX.AppRouting SET "
+ "BlobContainer = @p3,"
+ "FileName = @p4,"
+ "ClassName = @p5,"
+ "Status = @p6,"
+ "DevMode = @p7,"
+ "DevLocalDir = @p8,"
+ "Description = @p9,"
+ "Registered_DateTime = @p10 "
+ "WHERE AppId = @p1 AND AppProcessingId = @p2";
SqlConnection conn = new SqlConnection(this.sqlConnectionString);
try
{
conn.Open();
SqlCommand cmd = new SqlCommand(sqltext, conn);
AddSqlParameter(ref cmd, "@p1", SqlDbType.NVarChar, appRoutingEntity.AppId);
AddSqlParameter(ref cmd, "@p2", SqlDbType.NVarChar, appRoutingEntity.AppProcessingId);
AddSqlParameter(ref cmd, "@p3", SqlDbType.NVarChar, appRoutingEntity.BlobContainer);
AddSqlParameter(ref cmd, "@p4", SqlDbType.NVarChar, appRoutingEntity.FileName);
AddSqlParameter(ref cmd, "@p5", SqlDbType.NVarChar, appRoutingEntity.ClassName);
AddSqlParameter(ref cmd, "@p6", SqlDbType.NVarChar, appRoutingEntity.Status);
AddSqlParameter(ref cmd, "@p7", SqlDbType.NVarChar, appRoutingEntity.DevMode);
AddSqlParameter(ref cmd, "@p8", SqlDbType.NVarChar, appRoutingEntity.DevLocalDir);
AddSqlParameter(ref cmd, "@p9", SqlDbType.NVarChar, appRoutingEntity.Description);
AddSqlParameter(ref cmd, "@p10", SqlDbType.DateTime, appRoutingEntity.Registered_DateTime);
cmd.ExecuteNonQuery();
conn.Close();
}
catch (Exception ex)
{
conn.Close();
throw ex;
}
}
private void updateButton_Click(object sender, EventArgs e)
{
if (!checkInputData())
{
return;
}
try
{
AppRoutingEntity appRoutingEntity = getAppRoutingEntity();
AppRoutingProcessor appRoutingProcessor = new AppRoutingProcessor(sqlConnectionString);
appRoutingProcessor.updateAppRouting(appRoutingEntity);
MessageBox.Show("App Routing updated successfully!", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
throw ex;
}
this.Close();
}
public List <AppRoutingEntity> GetAppRoutings(string appId)
{
appId = appId.Replace("*", "%");
string sqltext = "SELECT AppId,AppProcessingId,BlobContainer,FileName,ClassName,"
+ "Status,DevMode,DevLocalDir,Description,Registered_DateTime "
+ "FROM RBFX.AppRouting "
+ "WHERE AppId LIKE @p1 ORDER BY AppId,AppProcessingId";
List <AppRoutingEntity> listOfAppRoutings = new List <AppRoutingEntity>();
SqlConnection conn = new SqlConnection(this.sqlConnectionString);
try
{
conn.Open();
SqlCommand cmd = new SqlCommand(sqltext, conn);
AddSqlParameter(ref cmd, "@p1", SqlDbType.NVarChar, appId);
SqlDataReader reader = cmd.ExecuteReader();
if (!reader.HasRows)
{
ae = new ApplicationException("No record was found in RBFX.AppRouting");
throw ae;
}
while (reader.Read())
{
AppRoutingEntity appRoutingEntity = new AppRoutingEntity();
appRoutingEntity.AppId = reader.GetString(0);
appRoutingEntity.AppProcessingId = reader.GetString(1);
appRoutingEntity.BlobContainer = reader.GetString(2);
appRoutingEntity.FileName = reader.GetString(3);
appRoutingEntity.ClassName = reader.GetString(4);
appRoutingEntity.Status = reader.GetString(5);
if (!reader.IsDBNull(6))
{
appRoutingEntity.DevMode = reader.GetString(6);
}
else
{
appRoutingEntity.DevMode = string.Empty;
}
if (!reader.IsDBNull(7))
{
appRoutingEntity.DevLocalDir = reader.GetString(7);
}
else
{
appRoutingEntity.DevLocalDir = string.Empty;
}
if (!reader.IsDBNull(8))
{
appRoutingEntity.Description = reader.GetString(8);
}
else
{
appRoutingEntity.Description = string.Empty;
}
if (!reader.IsDBNull(9))
{
appRoutingEntity.Registered_DateTime = reader.GetDateTime(9);
}
listOfAppRoutings.Add(appRoutingEntity);
}
reader.Close();
conn.Close();
}
catch (Exception ex)
{
if (ex.GetType().Equals(ae))
{
conn.Close();
}
throw (ex);
}
return(listOfAppRoutings);
}
