private CloudApplicationsServer CollectDataForCloudApplicationsServer() { try { //Cluster Settings CloudApplicationsServer CloudApplicationsServerObject = new CloudApplicationsServer(); //12/9/2013 NS added CloudApplicationsServerObject.ID = ID; CloudApplicationsServerObject.Name = CredentialsComboBox.Text; CloudApplicationsServerObject.Category = CategoryTextBox.Text; CloudApplicationsServerObject.Enabled = EnabledCheckBox.Checked; //URLsObject.First_Alert_Threshold = int.Parse(AlertTextBox.Text); CloudApplicationsServerObject.OffHoursScanInterval = int.Parse(OffScanTextBox.Text); CloudApplicationsServerObject.ScanInterval = int.Parse(ScanTextBox.Text); CloudApplicationsServerObject.RetryInterval = int.Parse(RetryTextBox.Text); CloudApplicationsServerObject.ResponseThreshold = int.Parse(RespThrTextBox.Text); CloudApplicationsServerObject.SearchStringNotFound = RequiredTextBox.Text; CloudApplicationsServerObject.SearchStringFound = txtSearch.Text; CloudApplicationsServerObject.URL = IPAddressTextBox.Text; CloudApplicationsServerObject.imageurl = Image1.ImageUrl; CloudApplicationsServerObject.UserName = UserNameTextBox.Text; if (PasswordTextBox.Text != "") { if (PasswordTextBox.Text == " ") { PasswordTextBox.Text = ViewState["PWD"].ToString(); } TripleDES tripleDES = new TripleDES(); byte[] encryptedPass = tripleDES.Encrypt(PasswordTextBox.Text); string encryptedPassAsString = string.Join(", ", encryptedPass.Select(s => s.ToString()).ToArray()); CloudApplicationsServerObject.PW = encryptedPassAsString; } // CloudApplicationsServerObject.PW = PasswordTextBox.Text; Locations LOCobject = new Locations(); ServerTypes STypeobject = new ServerTypes(); STypeobject.ServerType = "Cloud"; ServerTypes ReturnValue = VSWebBL.SecurityBL.ServerTypesBL.Ins.GetDataForServerType(STypeobject); CloudApplicationsServerObject.ServerTypeId = ReturnValue.ID; Locations ReturnLocValue = VSWebBL.SecurityBL.LocationsBL.Ins.GetDataForLocation(LOCobject); CloudApplicationsServerObject.LocationId = ReturnLocValue.ID; CloudApplicationsServerObject.Location = ReturnLocValue.Location; CloudApplicationsServerObject.FailureThreshold = int.Parse(SrvAtrFailBefAlertTextBox.Text); return(CloudApplicationsServerObject); } catch (Exception ex) { //6/27/2014 NS added for VSPLUS-634 Log.Entry.Ins.WriteHistoryEntry(DateTime.Now.ToString() + " Exception - " + ex); throw ex; } finally { } }
private void InsertCloudApplicationsServer() { try { CloudApplicationsServer UrlObj = new CloudApplicationsServer(); UrlObj.URL = IPAddressTextBox.Text; UrlObj.Name = CredentialsComboBox.Text; UrlObj.Category = CategoryTextBox.Text; DataTable returntable = VSWebBL.ConfiguratorBL.CloudApplicationsServerBL.Ins.GetIPAddress(UrlObj, "Insert"); if (returntable.Rows.Count > 0) { //ErrorMessageLabel.Text = "This URL Address/Name is already being monitored. Please enter another IP Address/Name."; //ErrorMessagePopupControl.ShowOnPageLoad = true; //10/8/2014 NS modified for VSPLUS-990 errorDiv.InnerHtml = "This CloudApplicationsServer Address/Name is already being monitored. Please enter another IP Address/Name." + "<button type=\"button\" class=\"close\" data-dismiss=\"alert\"><span aria-hidden=\"true\">×</span><span class=\"sr-only\">Close</span></button>"; errorDiv.Style.Value = "display: block"; flag = true; //IPAddressTextBox.Focus(); } else { try { object ReturnValue = VSWebBL.ConfiguratorBL.CloudApplicationsServerBL.Ins.InsertData(CollectDataForCloudApplicationsServer()); SetFocusOnError(ReturnValue); if (ReturnValue.ToString() == "True") { //3/19/2014 NS modified /* * ErrorMessageLabel.Text = "The URL has been successfully updated."; * ErrorMessagePopupControl.HeaderText = "Information"; * ErrorMessagePopupControl.ShowCloseButton = false; * ValidationUpdatedButton.Visible = true; * ValidationOkButton.Visible = false; * ErrorMessagePopupControl.ShowOnPageLoad = true; */ Session["CloudApplicationsServerUpdateStatus"] = CredentialsComboBox.Text; Response.Redirect("CloudApplicationsServerGrid.aspx", false); //Mukund, 05Aug14, VSPLUS-844:Page redirect on callback Context.ApplicationInstance.CompleteRequest(); } } catch (Exception ex) { //6/27/2014 NS added for VSPLUS-634 Log.Entry.Ins.WriteHistoryEntry(DateTime.Now.ToString() + " Exception - " + ex); throw ex; } finally { } } } catch (Exception ex) { //6/27/2014 NS added for VSPLUS-634 Log.Entry.Ins.WriteHistoryEntry(DateTime.Now.ToString() + " Exception - " + ex); throw ex; } }
public DataTable GetIPAddress(CloudApplicationsServer UrlObj, string mode) { DataTable UrlTable = new DataTable(); try { if (mode == "Insert") { string sqlQuery = "Select * from CloudDetails where URL= @URL"; SqlCommand cmd = new SqlCommand(sqlQuery); cmd.Parameters.AddWithValue("@URL", (object)UrlObj.URL ?? DBNull.Value); UrlTable = objAdaptor.FetchDatafromcommand(cmd); // UrlTable = objAdaptor.FetchData(sqlQuery); } else { string sqlQuery = "Select * from CloudDetails where ID<> @ID AND URL= @URL "; SqlCommand cmd = new SqlCommand(sqlQuery); cmd.Parameters.AddWithValue("@URL", (object)UrlObj.URL ?? DBNull.Value); cmd.Parameters.AddWithValue("@ID", (object)UrlObj.ID ?? DBNull.Value); UrlTable = objAdaptor.FetchDatafromcommand(cmd); // UrlTable = objAdaptor.FetchData(sqlQuery); } } catch (Exception ex) { throw ex; } return(UrlTable); }
/// <summary> /// Get Data from CloudApplicationsServer based on Key /// </summary> public CloudApplicationsServer GetData(CloudApplicationsServer URLObject) { DataTable CloudApplicationsServerDataTable = new DataTable(); CloudApplicationsServer ReturnObject = new CloudApplicationsServer(); try { string SqlQuery = "Select * from CloudDetails where ID=" + URLObject.ID; CloudApplicationsServerDataTable = objAdaptor.FetchData(SqlQuery); //populate & return data object //11/19/2013 NS added ReturnObject.ID = CloudApplicationsServerDataTable.Rows[0]["ID"].ToString(); ReturnObject.Name = CloudApplicationsServerDataTable.Rows[0]["Name"].ToString(); if (CloudApplicationsServerDataTable.Rows[0]["ScanInterval"].ToString() != "") { ReturnObject.ScanInterval = int.Parse(CloudApplicationsServerDataTable.Rows[0]["ScanInterval"].ToString()); } if (CloudApplicationsServerDataTable.Rows[0]["OffHoursScanInterval"].ToString() != "") { ReturnObject.OffHoursScanInterval = int.Parse(CloudApplicationsServerDataTable.Rows[0]["OffHoursScanInterval"].ToString()); } ReturnObject.Category = CloudApplicationsServerDataTable.Rows[0]["Category"].ToString(); if (CloudApplicationsServerDataTable.Rows[0]["Enabled"].ToString() != "") { ReturnObject.Enabled = bool.Parse(CloudApplicationsServerDataTable.Rows[0]["Enabled"].ToString()); } if (CloudApplicationsServerDataTable.Rows[0]["RetryInterval"].ToString() != "") { ReturnObject.RetryInterval = int.Parse(CloudApplicationsServerDataTable.Rows[0]["RetryInterval"].ToString()); } if (CloudApplicationsServerDataTable.Rows[0]["ResponseThreshold"].ToString() != "") { ReturnObject.ResponseThreshold = int.Parse(CloudApplicationsServerDataTable.Rows[0]["ResponseThreshold"].ToString()); } ReturnObject.URL = CloudApplicationsServerDataTable.Rows[0]["URL"].ToString(); ReturnObject.SearchStringNotFound = CloudApplicationsServerDataTable.Rows[0]["SearchString"].ToString(); ReturnObject.UserName = CloudApplicationsServerDataTable.Rows[0]["UserName"].ToString(); ReturnObject.PW = CloudApplicationsServerDataTable.Rows[0]["PW"].ToString(); ReturnObject.Location = CloudApplicationsServerDataTable.Rows[0]["Location"].ToString(); ReturnObject.imageurl = CloudApplicationsServerDataTable.Rows[0]["imageurl"].ToString(); if (CloudApplicationsServerDataTable.Rows[0]["FailureThreshold"].ToString() != null) { ReturnObject.FailureThreshold = Convert.ToInt32(CloudApplicationsServerDataTable.Rows[0]["FailureThreshold"]); } } catch (Exception ex) { throw ex; } finally { } return(ReturnObject); }
public DataTable GetIPAddress(CloudApplicationsServer UrlObj, string mode) { try { return(VSWebDAL.ConfiguratorDAL.CloudApplicationsServerDAL.Ins.GetIPAddress(UrlObj, mode)); } catch (Exception ex) { throw ex; } }
/// <summary> /// Call DAL Delete Data /// </summary> /// <param name="URLObject"></param> /// <returns></returns> public Object DeleteData(CloudApplicationsServer CloudApplicationsServerObject) { try { return(VSWebDAL.ConfiguratorDAL.CloudApplicationsServerDAL.Ins.DeleteData(CloudApplicationsServerObject)); } catch (Exception ex) { throw ex; } }
/// <param name="URLsObject"></param> /// <returns></returns> public Object ValidateUpdate(CloudApplicationsServer CloudApplicationsServerObject) { Object ReturnValue = ""; try { if (CloudApplicationsServerObject.Name == null || CloudApplicationsServerObject.Name == "") { return("ER#Please enter a value in the Name field."); } if (CloudApplicationsServerObject.Category == null || CloudApplicationsServerObject.Category == " ") { return("ER#Please enter a value in the Category field."); } if (CloudApplicationsServerObject.ResponseThreshold == null) { return("ER#Please enter a value in the Response Threshold field."); } if (CloudApplicationsServerObject.ScanInterval.ToString() == "") { return("ER#Please enter a value in the Scan Interval field."); } if (CloudApplicationsServerObject.OffHoursScanInterval.ToString() == " ") { return("ER#Please enter a value in the Off-Hours Scan Interval field."); } if (CloudApplicationsServerObject.RetryInterval.ToString() == "") { return("ER#Please enter a value in the Retry Interval field."); } if (CloudApplicationsServerObject.URL == "" || CloudApplicationsServerObject.URL == null) { return("ER#Please enter a value in the Address field, such as 'http://www.IBM.com'."); } //if ((CloudApplicationsServerObject.RetryInterval) > (CloudApplicationsServerObject.ScanInterval)) //{ // return "ER#Please enter a value in the Retry Interval field that is less than the Scan Interval value."; //} } catch (Exception ex) { throw ex; } finally { } return(""); }
protected void CloudApplicationsServerGridView_RowDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e) { CloudApplicationsServer CloudApplicationsServerObject = new CloudApplicationsServer(); //11/19/2013 NS modified //URLObject.TheURL = (e.Keys[0]).ToString(); CloudApplicationsServerObject.ID = (e.Keys[0]).ToString(); //Delete row from DB Object ReturnValue = VSWebBL.ConfiguratorBL.CloudApplicationsServerBL.Ins.DeleteData(CloudApplicationsServerObject); //Update Grid after inserting new row, refresh grid as in page load ASPxGridView gridView = (ASPxGridView)sender; gridView.CancelEdit(); e.Cancel = true; FillCloudApplicationsServerGrid(); }
/// <summary> /// Update data into URLs table /// </summary> /// <param name="DSObject">DominoServers object</param> /// <returns></returns> public Object UpdateData(CloudApplicationsServer CloudApplicationsServerObject) { Object Update; try { //11/19/2013 NS modified //string SqlQuery = "UPDATE URLs SET Name='" + URLObject.Name + "',Category='" + URLObject.Category + "',ScanInterval=" + URLObject.ScanInterval + //",ResponseThreshold=" + URLObject.ResponseThreshold + ",Enabled='" + URLObject.Enabled + "',OffHoursScanInterval=" + URLObject.OffHoursScanInterval + //",RetryInterval=" + URLObject.RetryInterval +",SearchString='" + URLObject.SearchString +"',UserName='******',PW='" + URLObject.PW+ //"',LocationId=" + URLObject.LocationId + ",ServerTypeId=" + URLObject.ServerTypeId + ",FailureThreshold=" + URLObject.FailureThreshold + " WHERE [TheURL]='" + URLObject.TheURL + "'"; string SqlQuery = "UPDATE CloudDetails SET Name=@Name,Url=@URL,Category=@Category,ScanInterval=@ScanInterval" + ",ResponseThreshold=@ResponseThreshold,Enabled=@Enabled,OffHoursScanInterval=@OffHoursScanInterval" + ",RetryInterval=@RetryInterval,SearchString=@SearchString,AlertStringFound=@AlertStringFound,UserName=@UserName,PW=@PW" + "',Location=@Location,ServerTypeId=@ServerTypeId,FailureThreshold=@FailureThreshold" + " WHERE [ID]=@ID"; SqlCommand cmd = new SqlCommand(SqlQuery); cmd.Parameters.AddWithValue("@ID", (object)CloudApplicationsServerObject.ID ?? DBNull.Value); cmd.Parameters.AddWithValue("@URL", (object)CloudApplicationsServerObject.URL ?? DBNull.Value); cmd.Parameters.AddWithValue("@Name", (object)CloudApplicationsServerObject.Name ?? DBNull.Value); cmd.Parameters.AddWithValue("@Category", (object)CloudApplicationsServerObject.Category ?? DBNull.Value); cmd.Parameters.AddWithValue("@ScanInterval", (object)CloudApplicationsServerObject.ScanInterval ?? DBNull.Value); cmd.Parameters.AddWithValue("@OffHoursScanInterval", (object)CloudApplicationsServerObject.OffHoursScanInterval ?? DBNull.Value); cmd.Parameters.AddWithValue("@Enabled", (object)CloudApplicationsServerObject.Enabled ?? DBNull.Value); cmd.Parameters.AddWithValue("@ResponseThreshold", (object)CloudApplicationsServerObject.ResponseThreshold ?? DBNull.Value); cmd.Parameters.AddWithValue("@RetryInterval", (object)CloudApplicationsServerObject.RetryInterval ?? DBNull.Value); cmd.Parameters.AddWithValue("@SearchString", (object)CloudApplicationsServerObject.SearchStringNotFound ?? DBNull.Value); cmd.Parameters.AddWithValue("@AlertStringFound", (object)CloudApplicationsServerObject.SearchStringFound ?? DBNull.Value); cmd.Parameters.AddWithValue("@UserName", (object)CloudApplicationsServerObject.UserName ?? DBNull.Value); cmd.Parameters.AddWithValue("@PW", (object)CloudApplicationsServerObject.PW ?? DBNull.Value); cmd.Parameters.AddWithValue("@Location", (object)CloudApplicationsServerObject.LocationId ?? DBNull.Value); cmd.Parameters.AddWithValue("@ServerTypeId", (object)CloudApplicationsServerObject.ServerTypeId ?? DBNull.Value); cmd.Parameters.AddWithValue("@FailureThreshold", (object)CloudApplicationsServerObject.FailureThreshold ?? DBNull.Value); //cmd.Parameters.AddWithValue("@Imageurl", (object)CloudApplicationsServerObject.imageurl ?? DBNull.Value); Update = objAdaptor.ExecuteNonQuerywithcmd(cmd); //Update = objAdaptor.ExecuteNonQuery(SqlQuery); } catch { Update = false; } finally { } return(Update); }
/// <summary> /// Call to Update Data of DominoServers based on Key /// </summary> /// <param name="URLsObject">DominoServers object</param> /// <returns>Object</returns> public Object UpdateData(CloudApplicationsServer CloudApplicationsServerObject) { Object ReturnValue = ValidateUpdate(CloudApplicationsServerObject); try { if (ReturnValue.ToString() == "") { return(VSWebDAL.ConfiguratorDAL.CloudApplicationsServerDAL.Ins.UpdateData(CloudApplicationsServerObject)); } } catch (Exception ex) { throw ex; } return(ReturnValue); }
/// <summary> /// Insert data into URLs table /// </summary> /// <param name="DSObject">URLs object</param> /// <returns></returns> public bool InsertData(CloudApplicationsServer CloudApplicationsServerObject) { bool Insert = false; try { string SqlQuery = "INSERT INTO CloudDetails (URL,Name,Category,ScanInterval,OffHoursScanInterval,Enabled" + ",ResponseThreshold,RetryInterval,SearchString,AlertStringFound,UserName,PW,Location,ServerTypeId,FailureThreshold,Imageurl)" + "VALUES(@URL,@Name,@Category,@ScanInterval" + ",@OffHoursScanInterval,@Enabled,@ResponseThreshold,@RetryInterval" + ",@SearchString,@AlertStringFound,@UserName,@PW" + ", @Location,@ServerTypeId,@FailureThreshold,@Imageurl)"; SqlCommand cmd = new SqlCommand(SqlQuery); cmd.Parameters.AddWithValue("@URL", (object)CloudApplicationsServerObject.URL ?? DBNull.Value); cmd.Parameters.AddWithValue("@Name", (object)CloudApplicationsServerObject.Name ?? DBNull.Value); cmd.Parameters.AddWithValue("@Category", (object)CloudApplicationsServerObject.Category ?? DBNull.Value); cmd.Parameters.AddWithValue("@ScanInterval", (object)CloudApplicationsServerObject.ScanInterval ?? DBNull.Value); cmd.Parameters.AddWithValue("@OffHoursScanInterval", (object)CloudApplicationsServerObject.OffHoursScanInterval ?? DBNull.Value); cmd.Parameters.AddWithValue("@Enabled", (object)CloudApplicationsServerObject.Enabled ?? DBNull.Value); cmd.Parameters.AddWithValue("@ResponseThreshold", (object)CloudApplicationsServerObject.ResponseThreshold ?? DBNull.Value); cmd.Parameters.AddWithValue("@RetryInterval", (object)CloudApplicationsServerObject.RetryInterval ?? DBNull.Value); cmd.Parameters.AddWithValue("@SearchString", (object)CloudApplicationsServerObject.SearchStringNotFound ?? DBNull.Value); cmd.Parameters.AddWithValue("@AlertStringFound", (object)CloudApplicationsServerObject.SearchStringFound ?? DBNull.Value); cmd.Parameters.AddWithValue("@UserName", (object)CloudApplicationsServerObject.UserName ?? DBNull.Value); cmd.Parameters.AddWithValue("@PW", (object)CloudApplicationsServerObject.PW ?? DBNull.Value); cmd.Parameters.AddWithValue("@Location", (object)CloudApplicationsServerObject.LocationId ?? DBNull.Value); cmd.Parameters.AddWithValue("@ServerTypeId", (object)CloudApplicationsServerObject.ServerTypeId ?? DBNull.Value); cmd.Parameters.AddWithValue("@FailureThreshold", (object)CloudApplicationsServerObject.FailureThreshold ?? DBNull.Value); cmd.Parameters.AddWithValue("@Imageurl", (object)CloudApplicationsServerObject.imageurl ?? DBNull.Value); Insert = objAdaptor.ExecuteNonQuerywithcmd(cmd); } catch { Insert = false; } finally { } return(Insert); }
//delete Data from URLs Table public Object DeleteData(CloudApplicationsServer CloudApplicationsServerObject) { Object Update; try { //11/19/2013 NS modified //string SqlQuery = "Delete URLs Where TheURL='" + URLObject.TheURL+"'"; string SqlQuery = "Delete CloudDetails Where ID = @ID"; SqlCommand cmd = new SqlCommand(SqlQuery); cmd.Parameters.AddWithValue("@ID", (object)CloudApplicationsServerObject.ID ?? DBNull.Value); Update = objAdaptor.ExecuteNonQuerywithcmd(cmd); } catch { Update = false; } finally { } return(Update); }
//11/19/2013 NS modified //private void FillData(string URL) private void FillData(string ID) { try { CloudApplicationsServer CloudApplicationsServerObject = new CloudApplicationsServer(); CloudApplicationsServer ReturnDCObject = new CloudApplicationsServer(); //11/19/2013 NS modified //URLsObject.TheURL = URL; CloudApplicationsServerObject.ID = ID; ReturnDCObject = VSWebBL.ConfiguratorBL.CloudApplicationsServerBL.Ins.GetData(CloudApplicationsServerObject); //Cluster Setting fields CredentialsComboBox.Text = ReturnDCObject.Name.ToString(); CategoryTextBox.Text = ReturnDCObject.Category.ToString(); ScanTextBox.Text = ReturnDCObject.ScanInterval.ToString(); OffScanTextBox.Text = ReturnDCObject.OffHoursScanInterval.ToString(); EnabledCheckBox.Checked = ReturnDCObject.Enabled; //(ScanTextBox.Text != null ? true : false); RetryTextBox.Text = ReturnDCObject.RetryInterval.ToString(); RespThrTextBox.Text = ReturnDCObject.ResponseThreshold.ToString(); IPAddressTextBox.Text = ReturnDCObject.URL; Image1.ImageUrl = ReturnDCObject.imageurl; RequiredTextBox.Text = ReturnDCObject.SearchStringNotFound; txtSearch.Text = ReturnDCObject.SearchStringFound; UserNameTextBox.Text = ReturnDCObject.UserName; PasswordTextBox.Text = ReturnDCObject.PW; if (PasswordTextBox.Text != "" && PasswordTextBox.Text != null) { PasswordTextBox.Text = " "; } else { PasswordTextBox.Text = ""; } MyObjPwd = ReturnDCObject.PW.ToString(); if (MyObjPwd != "") { MyObjPwdArr = MyObjPwd.Split(','); MyPass = new byte[MyObjPwdArr.Length]; try { for (int j = 0; j < MyObjPwdArr.Length; j++) { MyPass[j] = Byte.Parse(MyObjPwdArr[j]); } ViewState["PWD"] = tripleDes.Decrypt(MyPass); } catch (Exception ex) { if (ex.Message == "Input string was not in a correct format.") { ViewState["PWD"] = MyObjPwd; } } } SrvAtrFailBefAlertTextBox.Text = ReturnDCObject.FailureThreshold.ToString(); //11/19/2013 NS modified //Session["ReturnUrl"] = "URLProperties.aspx?TheURL=" + URL + "tab=1"; //Mukund 11Apr14 -missing "&" Session["ReturnUrl"] = "CloudApplicationsServerProperties.aspx?ID=" + ID + "&tab=1"; } catch (Exception ex) { //6/27/2014 NS added for VSPLUS-634 Log.Entry.Ins.WriteHistoryEntry(DateTime.Now.ToString() + " Exception - " + ex); throw ex; } finally { } }
/// <summary> /// Call to Get Data from URLs based on Primary key /// </summary> /// <param name="URLsObject">URLsObject object</param> /// <returns></returns> public CloudApplicationsServer GetData(CloudApplicationsServer CloudApplicationsServerObject) { return(VSWebDAL.ConfiguratorDAL.CloudApplicationsServerDAL.Ins.GetData(CloudApplicationsServerObject)); }