protected void btnOk_Click(object sender, EventArgs e)
{
try
{
if (ddlApsimFile.SelectedItem.Value == "0")
{
throw new Exception("Please select a valid Apsim FileName.");
}
if (ddlTableName.SelectedItem.Value == "0")
{
throw new Exception("Please select a valid TableName.");
}
if (txtNewTableName.Text.Trim().Length <= 0)
{
throw new Exception("Please enter a New TableName.");
}
if (ddlTableName.SelectedItem.Text.Trim() == txtNewTableName.Text.Trim())
{
throw new Exception("The New Tablename cannot be the same as the old TableName.");
}
PORename rename = new PORename();
rename.SubmitUser = txtUserName.Text;
rename.Type = "TableRename";
rename.FileName = ddlApsimFile.SelectedItem.Text;
rename.TableName = ddlTableName.SelectedItem.Text;
rename.NewTableName = txtNewTableName.Text;
WebAP_Interactions.RenamePredictedObservedTable(rename);
}
catch (Exception ex)
{
lblErrors.Text = "Error: " + ex.Message.ToString();
}
}
//#if DEBUG
// httpClient.BaseAddress = new Uri("http://localhost:53187/");
//#endif
public static void RenamePredictedObservedTable(PORename objRename)
{
HttpClient httpClient = new HttpClient();
string serviceUrl = ConfigurationManager.AppSettings["serviceAddress"].ToString() + "APSIM.PerformanceTests.Service/";
httpClient.BaseAddress = new Uri(serviceUrl);
httpClient.DefaultRequestHeaders.Accept.Clear();
httpClient.DefaultRequestHeaders.Accept.Add(new System.Net.Http.Headers.MediaTypeWithQualityHeaderValue("application/json"));
HttpResponseMessage response = new HttpResponseMessage();
response = httpClient.PostAsJsonAsync("api/PORename", objRename).Result;
response.EnsureSuccessStatusCode();
if (response.IsSuccessStatusCode)
{
}
}
public async Task <IHttpActionResult> PostPORename(PORename renameObj)
{
string errHelper = string.Empty;
try
{
errHelper = string.Format("Rename of Table {0} to {1} for Apsim File {2}", renameObj.TableName, renameObj.NewTableName, renameObj.FileName);
string authenCode = Utilities.GetStatsAcceptedToken();
if (renameObj.SubmitUser == authenCode)
{
string connectStr = Utilities.GetConnectionString();
using (SqlConnection sqlCon = new SqlConnection(connectStr))
{
sqlCon.Open();
if (renameObj.Type == "TableRename")
{
DBFunctions.RenamePOTable(sqlCon, renameObj.FileName, renameObj.TableName, renameObj.NewTableName);
Utilities.WriteToLogFile(" " + errHelper + " competed successfully!");
}
else if (renameObj.Type == "VariableRename")
{
//using (SqlCommand commandENQ = new SqlCommand("usp_UpdatePredictedObservedVariableName", sqlCon))
//{
// //Now update the database with the test results
// // Configure the command and parameter.
// commandENQ.CommandType = CommandType.StoredProcedure;
// commandENQ.Parameters.AddWithValue("@FileName", renameObj.FileName);
// commandENQ.Parameters.AddWithValue("@TableName", renameObj.TableName);
// commandENQ.Parameters.AddWithValue("@VariableName", renameObj.VariableName);
// commandENQ.Parameters.AddWithValue("@NewVariableName", renameObj.NewVariableName);
// commandENQ.ExecuteNonQuery();
//}
//Utilities.WriteToLogFile(" " + errHelper + " competed successfully!");
}
}
}
}
catch (Exception ex)
{
Utilities.WriteToLogFile(string.Format("ERROR: {0} Failed: {1}", errHelper, ex.Message.ToString()));;
}
return(StatusCode(HttpStatusCode.NoContent));
}
