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