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)); }