/// <summary> /// Update data into NotesMailProbe table /// </summary> /// <param name="ProbeObject">NotesMailProbe object</param> /// <returns></returns> public Object UpdateData(NotesMailProbe ProbeObject, string name) { Object Update; try { string SqlQuery = "UPDATE NotesMailProbe SET Enabled='" + ProbeObject.Enabled + "',NotesMailAddress='" + ProbeObject.NotesMailAddress + "',Category='" + ProbeObject.Category + "',ScanInterval=" + ProbeObject.ScanInterval + ",OffHoursScanInterval=" + ProbeObject.OffHoursScanInterval + ",RetryInterval=" + ProbeObject.RetryInterval + ",DeliveryThreshold=" + ProbeObject.DeliveryThreshold + ",DestinationServerID='" + ProbeObject.DestinationServerID + "',SourceServer='" + ProbeObject.SourceServer + "',Name='" + ProbeObject.Name + "',EchoService='" + ProbeObject.EchoService + "',ReplyTo='" + ProbeObject.ReplyTo + "',Filename='" + ProbeObject.Filename + "',DestinationDatabase='" + ProbeObject.DestinationDatabase + "' WHERE Name= '" + name + "'"; Update = objAdaptor.ExecuteNonQuery(SqlQuery); } catch { Update = false; } finally { } return(Update); }
public DataTable GetIPAddress(NotesMailProbe MailObj, string name) { //SametimeServers SametimeObj = new SametimeServers(); DataTable MailProbTable = new DataTable(); try { string sqlQuery = ""; if (name == "") { sqlQuery = "Select * from NotesMailProbe where Name='" + MailObj.Name + "'"; } else { sqlQuery = "Select * from NotesMailProbe where Name='" + MailObj.Name + "' and name<>'" + name + "'"; } MailProbTable = objAdaptor.FetchData(sqlQuery); //if (MailObj.NotesMailAddress == "" && MailObj.NotesMailAddress!=null) //{ // string sqlQuery = "Select * from NotesMailProbe where NotesMailAddress='" + MailObj.NotesMailAddress + "' or Name='"+MailObj.Name+"'"; // MailProbTable = objAdaptor.FetchData(sqlQuery); //} //else //{ // string sqlQuery = "Select * from NotesMailProbe where (Name='" + MailObj.Name + "' and NotesMailAddress!='" + MailObj.NotesMailAddress + "') " + // " or (Name!='" + MailObj.Name + "' and NotesMailAddress='" + MailObj.NotesMailAddress + "') "; // MailProbTable = objAdaptor.FetchData(sqlQuery); //} } catch (Exception ex) { throw ex; } return(MailProbTable); }
/// <summary> /// Insert data into NotesMailProbe table /// </summary> /// <param name="DSObject">NotesMailProbe object</param> /// <returns></returns> public bool InsertData(NotesMailProbe ProbeObject) { bool Insert = false; try { string SqlQuery = "INSERT INTO NotesMailProbe (Enabled,Name,NotesMailAddress,Category,ScanInterval" + ",OffHoursScanInterval,DeliveryThreshold,RetryInterval,DestinationServerID,DestinationDatabase" + ",SourceServer,EchoService,ReplyTo,Filename)" + "VALUES('" + ProbeObject.Enabled + "','" + ProbeObject.Name + "','" + ProbeObject.NotesMailAddress + "','" + ProbeObject.Category + "','" + ProbeObject.ScanInterval + "','" + ProbeObject.OffHoursScanInterval + "'," + ProbeObject.DeliveryThreshold + "," + ProbeObject.RetryInterval + ",'" + ProbeObject.DestinationServerID + "','" + ProbeObject.DestinationDatabase + "','" + ProbeObject.SourceServer + "','" + ProbeObject.EchoService + "','" + ProbeObject.ReplyTo + "','" + ProbeObject.Filename + "')"; Insert = objAdaptor.ExecuteNonQuery(SqlQuery); } catch { Insert = false; } finally { } return(Insert); }
/// <summary> /// Call to Get Data from NotesMailProbe based on Primary key /// </summary> /// <param name="NotesMailProbeObject">NotesMailProbeObject object</param> /// <returns></returns> public NotesMailProbe GetData(NotesMailProbe NotesMailProbeObject) { try { return(VSWebDAL.ConfiguratorDAL.NotesMailProbeDAL.Ins.GetData(NotesMailProbeObject)); } catch (Exception ex) { throw ex; } }
/// <summary> /// Call DAL Delete Data /// </summary> /// <param name="ProbeObject"></param> /// <returns></returns> public Object DeleteData(NotesMailProbe ProbeObject) { try { return(VSWebDAL.ConfiguratorDAL.NotesMailProbeDAL.Ins.DeleteData(ProbeObject)); } catch (Exception ex) { throw ex; } }
// To Check Unique MailAddress public DataTable GetMailAddress(NotesMailProbe MailObj, string name) { try { return(VSWebDAL.ConfiguratorDAL.NotesMailProbeDAL.Ins.GetIPAddress(MailObj, name)); } catch (Exception ex) { throw ex; } }
public DataTable GetAllDataByName(NotesMailProbe NotesMailProbeObject) { try { return(VSWebDAL.ConfiguratorDAL.NotesMailProbeDAL.Ins.GetAllDataByName(NotesMailProbeObject)); } catch (Exception ex) { throw ex; } }
private void InsertNotesMailProbe() { //This is called if defining a new Mail Probe //See if this name is already used NotesMailProbe mailObj = new NotesMailProbe(); //7/26/2013 NS modified //If it's a new probe, set MailId to the value of SendToTextBox if (MailID == null || MailID == "") { MailID = SendToTextBox.Text; } mailObj.NotesMailAddress = MailID; mailObj.Name = NameTextBox.Text; DataTable returntable = VSWebBL.ConfiguratorBL.NotesMailProbeBL.Ins.GetMailAddress(mailObj, ""); if (returntable.Rows.Count > 0) { ErrorMessageLabel.Text = "There is already a probe being mailed for this name. Please enter a different probe name."; ErrorMessagePopupControl.ShowOnPageLoad = true; flag = true; } else { try { object ReturnValue = VSWebBL.ConfiguratorBL.NotesMailProbeBL.Ins.InsertData(CollectDataForNotesMailProbe()); SetFocusOnError(ReturnValue); if (ReturnValue.ToString() == "True") { /* * ErrorMessageLabel.Text = "New mail probe created successfully."; * ErrorMessagePopupControl.HeaderText = "Information"; * ErrorMessagePopupControl.ShowCloseButton = false; * ValidationUpdatedButton.Visible = true; * ValidationOkButton.Visible = false; * ErrorMessagePopupControl.ShowOnPageLoad = true; */ flag = false; } } catch (Exception ex) { //6/27/2014 NS added for VSPLUS-634 Log.Entry.Ins.WriteHistoryEntry(DateTime.Now.ToString() + " Exception - " + ex); throw ex; } finally { } } }
private NotesMailProbe CollectDataForNotesMailProbe() { try { NotesMailProbe NotesMailProbeObject = new NotesMailProbe(); NotesMailProbeObject.Name = NameTextBox.Text; NotesMailProbeObject.Enabled = EnableCheckBox.Checked; NotesMailProbeObject.Category = CategoryComboBox.Text; NotesMailProbeObject.ScanInterval = int.Parse(ScanIntervalTextBox.Text); NotesMailProbeObject.OffHoursScanInterval = int.Parse(offScanTextBox.Text); NotesMailProbeObject.DeliveryThreshold = int.Parse(DeliveryThresholdTextBox.Text); NotesMailProbeObject.DestinationDatabase = DestinationTextBox.Text; if (TargetComboBox.Value != null) { NotesMailProbeObject.DestinationServerID = int.Parse(TargetComboBox.Value.ToString()); } NotesMailProbeObject.EchoService = EchoServiceCheckBox.Checked; //string filename = FileUploadControl.UploadedFiles[0].FileName; //string filename1 = + '^' + filename; //string fpath = Server.MapPath("~/files/"); //FileUploadControl.UploadedFiles[0].PostedFile.SaveAs(fpath + filename); // UploadDirectory = fpath + filename; FilePathHyperLink.Text = savedfile; FilePathHyperLink.NavigateUrl = savedfile; // NotesMailProbeObject.Filename = FileNameTextBox.Text; NotesMailProbeObject.Filename = FilePathHyperLink.NavigateUrl;//FileUploadControl.UploadedFiles[0].FileName.ToString(); NotesMailProbeObject.NotesMailAddress = SendToTextBox.Text; NotesMailProbeObject.RetryInterval = int.Parse(RetryTextBox.Text); NotesMailProbeObject.SourceServer = SourceServerComboBox.Text; NotesMailProbeObject.ReplyTo = ReplyToTextBox.Text; return(NotesMailProbeObject); } 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 UpdateNotesMailProbeData() { NotesMailProbe mailObj = new NotesMailProbe(); mailObj.NotesMailAddress = MailID; mailObj.Name = NameTextBox.Text; DataTable returntable = VSWebBL.ConfiguratorBL.NotesMailProbeBL.Ins.GetMailAddress(mailObj, NotesName); if (returntable.Rows.Count > 0) { ErrorMessageLabel.Text = "There is already a probe being mailed for this name. Please enter another probe name."; ErrorMessagePopupControl.ShowOnPageLoad = true; flag = true; } else { try { Object ReturnValue = VSWebBL.ConfiguratorBL.NotesMailProbeBL.Ins.UpdateData(CollectDataForNotesMailProbe(), NotesName); SetFocusOnError(ReturnValue); if (ReturnValue.ToString() == "True") { //2/20/2014 NS modified to redirect to the server grid page Session["NotesMailProbeUpdateStatus"] = NameTextBox.Text; Response.Redirect("NotesMailprobeGrid.aspx", false);//Mukund, 05Aug14, VSPLUS-844:Page redirect on callback Context.ApplicationInstance.CompleteRequest(); /* * ErrorMessageLabel.Text = "Mail probe information update completed successfully."; * ErrorMessagePopupControl.HeaderText = "Information"; * ErrorMessagePopupControl.ShowCloseButton = false; * ValidationUpdatedButton.Visible = true; * ValidationOkButton.Visible = false; * ErrorMessagePopupControl.ShowOnPageLoad = true; */ } } catch (Exception ex) { //6/27/2014 NS added for VSPLUS-634 Log.Entry.Ins.WriteHistoryEntry(DateTime.Now.ToString() + " Exception - " + ex); throw ex; } finally { } } }
//delete Data from NotesMailProbe Table public Object DeleteData(NotesMailProbe ProbObject) { Object Update; try { string SqlQuery = "Delete NotesMailProbe Where Name='" + ProbObject.Name + "'"; Update = objAdaptor.ExecuteNonQuery(SqlQuery); } catch { Update = false; } finally { } return(Update); }
/// <summary> /// Call to Update Data of NotesMailProbe based on Key /// </summary> /// <param name="NotesMailProbeObject">DominoServers object</param> /// <returns>Object</returns> public Object UpdateData(NotesMailProbe NotesMailProbeObject, string name) { Object ReturnValue = ValidateDCUpdate(NotesMailProbeObject); try { if (ReturnValue.ToString() == "") { return(VSWebDAL.ConfiguratorDAL.NotesMailProbeDAL.Ins.UpdateData(NotesMailProbeObject, name)); } else { return(ReturnValue); } } catch (Exception ex) { throw ex; } }
public DataTable GetDominoServerNames() { DataTable ProbeDataTable = new DataTable(); NotesMailProbe ReturnObject = new NotesMailProbe(); try { //1/29/2013 NS modified - added sort and distinct to make sure server names are not duplicated in the drop down list string SqlQuery = "SELECT DISTINCT ServerName,ID,LocationID FROM Servers WHERE ServerTypeID = 1 ORDER BY ServerName"; ProbeDataTable = objAdaptor.FetchData(SqlQuery); } catch (Exception ex) { throw ex; } finally { } return(ProbeDataTable); }
public DataTable GetAllDataByName(NotesMailProbe MailObj) { DataTable ProbeDataTable = new DataTable(); NotesMailProbe ReturnObject = new NotesMailProbe(); try { string SqlQuery = "SELECT Enabled,Name,NotesMailAddress,Category,ScanInterval,OffHoursScanInterval,DeliveryThreshold," + "RetryInterval,(select ServerName from Servers where ID= DestinationServerID) as DestinationServer,DestinationDatabase,SourceServer,EchoService,ReplyTo,Filename FROM NotesMailProbe where Name='" + MailObj.Name + "'"; ProbeDataTable = objAdaptor.FetchData(SqlQuery); } catch (Exception ex) { throw ex; } finally { } return(ProbeDataTable); }
private void FillData(string Name) { try { NotesMailProbe NotesMailProbeObject = new NotesMailProbe(); NotesMailProbe ReturnObject = new NotesMailProbe(); //NotesMailProbeObject.NotesMailAddress = MailID; NotesMailProbeObject.Name = Name; ReturnObject = VSWebBL.ConfiguratorBL.NotesMailProbeBL.Ins.GetData(NotesMailProbeObject); //Cluster Setting fields NameTextBox.Text = ReturnObject.Name.ToString(); CategoryComboBox.Text = ReturnObject.Category.ToString(); ScanIntervalTextBox.Text = ReturnObject.ScanInterval.ToString(); offScanTextBox.Text = ReturnObject.OffHoursScanInterval.ToString(); EnableCheckBox.Checked = ReturnObject.Enabled;//(ScanTextBox.Text != null ? true : false); EchoServiceCheckBox.Checked = ReturnObject.EchoService; SourceServerComboBox.Text = ReturnObject.SourceServer; SendToTextBox.Text = ReturnObject.NotesMailAddress; ReplyToTextBox.Text = ReturnObject.ReplyTo; //FileNameTextBox.Text = ReturnObject.Filename; FilePathHyperLink.NavigateUrl = ReturnObject.Filename; FilePathHyperLink.Text = ReturnObject.Filename; //12/7/2012 NS modified //TargetComboBox.Text = ReturnObject.DestinationServerID.ToString(); TargetComboBox.Text = ReturnObject.ServerName; TargetComboBox.Value = ReturnObject.DestinationServerID.ToString(); DestinationTextBox.Text = ReturnObject.DestinationDatabase; RetryTextBox.Text = ReturnObject.RetryInterval.ToString(); DeliveryThresholdTextBox.Text = ReturnObject.DeliveryThreshold.ToString(); Session["ReturnUrl"] = "EditNotesMailProbe.aspx?Name=" + Name + "&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 { } }
protected void NotesMailProbeGridView_RowDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e) { try { NotesMailProbe MailProbObject = new NotesMailProbe(); MailProbObject.Name = e.Keys[0].ToString(); //Delete row from DB Object ReturnValue = VSWebBL.ConfiguratorBL.NotesMailProbeBL.Ins.DeleteData(MailProbObject); //Update Grid after inserting new row, refresh grid as in page load ASPxGridView gridView = (ASPxGridView)sender; gridView.CancelEdit(); e.Cancel = true; //this.NotesMailProbeGridView.UpdateEdit(); //Response.Redirect("~/Configurator/ NotesMailprobeGrid.aspx"); FillNotesMailProbeGrid(); } catch (Exception ex) { //6/27/2014 NS added for VSPLUS-634 Log.Entry.Ins.WriteHistoryEntry(DateTime.Now.ToString() + " Exception - " + ex); throw ex; } }
/// <summary> /// Validation before submitting data for Server tab /// </summary> /// <param name="NotesMailProbeObject"></param> /// <returns></returns> public Object ValidateDCUpdate(NotesMailProbe NotesMailProbeObject) { Object ReturnValue = ""; try { if (NotesMailProbeObject.Name == null || NotesMailProbeObject.Name == "") { return("ER#Please enter a short, unique, name for this NotesMail probe."); } if (NotesMailProbeObject.EchoService == true) { if (NotesMailProbeObject.ReplyTo == "") { return("ER#Please enter a valid ReplyTo address to which the Echo Server will send a reply message. This address should resolve to the target server and database specified."); } } if (NotesMailProbeObject.NotesMailAddress == null || NotesMailProbeObject.NotesMailAddress == " ") { return("ER#Please enter a valid NotesMail address to which this test message will be delivered."); } //12/10/2012 NS commented out the error message below - there is no Filename field on the form. //The error is thrown whenever a new mail probe is created even when all fields are set. //if ((NotesMailProbeObject.Filename == "") || (NotesMailProbeObject.Filename == "")) //{ // return "ER#Please enter the FILENAME of the Notes database to which the message will be delivered, if successful.'"; //} if (NotesMailProbeObject.DestinationServerID == 0 || NotesMailProbeObject.DestinationServerID.ToString() == "") { return("ER#Please enter the Domino SERVER which hosts the Notes database to which the message will be delivered, if successful."); } if (NotesMailProbeObject.SourceServer == " " || NotesMailProbeObject.SourceServer == null) { return("ER#Please enter the Source SERVER, on which the test message will be deposited for delivery."); } if (NotesMailProbeObject.DeliveryThreshold.ToString() == " " || NotesMailProbeObject.DeliveryThreshold == null) { return("ER#Please enter a Delivery Threshold, in minutes, over which the delivery to the device will be considered a failure."); } if (NotesMailProbeObject.RetryInterval == null || NotesMailProbeObject.RetryInterval.ToString() == " ") { return("ER#Please enter a Retry Interval, to be used when the device is down."); } if (NotesMailProbeObject.ScanInterval.ToString() == "") { return("ER#Please a scan Interval"); } if (NotesMailProbeObject.OffHoursScanInterval.ToString() == " ") { return("ER#Please enter an off-hours Scan Interval"); } //if ((NotesMailProbeObject.RetryInterval) > (NotesMailProbeObject.ScanInterval)) //{ // return "ER#Please enter a Retry Interval that is less than the Scan Interval."; //} // If Not (Array.IndexOf(DominoServerlist, Me.cmbSourceServer.Text) >= 0) And Me.cmbSourceServer.Text <> "SMTP Server" Then // MessageBox.Show("Please select a licensed server.", "Validation Failure", MessageBoxButtons.OK, MessageBoxIcon.Error) // Me.cmbSourceServer.Focus() // Exit Sub // End If // If Not (Array.IndexOf(DominoServerlist, Me.cmbTargetServer.Text) >= 0) Then // MessageBox.Show("Please select a licensed server.", "Validation Failure", MessageBoxButtons.OK, MessageBoxIcon.Error) // Me.cmbTargetServer.Focus() // Exit Sub // End If //Catch ex As Exception } catch (Exception ex) { throw ex; } finally { } return(""); }
protected void Page_Load(object sender, EventArgs e) { //11/7/2014 NS modified for VSPLUS-1153 performanceWebChartControl.Width = new Unit(Convert.ToInt32(chartWidth.Value)); SetGraph("hh", Request.QueryString["Name"].ToString()); if (!IsPostBack) { HtmlGenericControl body = (HtmlGenericControl)Master.FindControl("Body1"); body.Attributes.Add("onload", "DoCallback()"); body.Attributes.Add("onResize", "Resized()"); //11/7/2014 NS added for VSPLUS-1153 if (Request.QueryString["Type"] != "" && Request.QueryString["Type"] != null) { lblServerType.Text = Request.QueryString["Type"].ToString() + ": "; } if (Request.QueryString["Status"] != "" && Request.QueryString["Status"] != null) { serverstatus.InnerHtml = Request.QueryString["Status"]; if (Request.QueryString["Status"] == "OK" || Request.QueryString["Status"] == "Scanning") { serverstatus.Attributes["class"] = "OK"; } else if (Request.QueryString["Status"] == "Not Responding") { serverstatus.Attributes["class"] = "NotResponding"; } else if (Request.QueryString["Status"] == "Maintenance") { serverstatus.Attributes["class"] = "Maintenance"; } else if (Request.QueryString["Status"] == "Not Scanned") { serverstatus.Attributes["class"] = "NotScanned"; } else { serverstatus.Attributes["class"] = "Issue"; } } //performanceASPxRoundPanel.Width = 1000; if (Request.QueryString["Server"] != "" && Request.QueryString["Server"] != null) { SetGridFromQString(Request.QueryString["Server"]); } else { servernamelbl.Text = Request.QueryString["Name"]; //11/7/2014 NS modified for VSPLUS-1153 //Lastscanned.Text = Request.QueryString["LastDate"].ToString(); servernamelbldisp.InnerHtml = lblServerType.Text + servernamelbl.Text; Lastscanned.InnerHtml = "Last scan date: " + Request.QueryString["LastDate"].ToString(); NotesMailProbe MailObj = new NotesMailProbe(); MailObj.NotesMailAddress = ""; MailObj.Name = servernamelbl.Text; DataTable dtNotes = VSWebBL.ConfiguratorBL.NotesMailProbeBL.Ins.GetAllDataByName(MailObj); if (dtNotes.Rows.Count > 0) { lblSource.Text = dtNotes.Rows[0]["SourceServer"].ToString(); lblDestination.Text = dtNotes.Rows[0]["DestinationServer"].ToString(); lblDestination0.Text = lblDestination.Text; lblDestination1.Text = lblDestination.Text; lblNotesMailAddress.Text = dtNotes.Rows[0]["NotesMailAddress"].ToString(); lblDeliveryThreshold.Text = dtNotes.Rows[0]["DeliveryThreshold"].ToString(); lblScanInterval.Text = dtNotes.Rows[0]["ScanInterval"].ToString(); lblOffHoursScanInterval.Text = dtNotes.Rows[0]["OffHoursScanInterval"].ToString(); lblDestinationDatabase.Text = dtNotes.Rows[0]["DestinationDatabase"].ToString(); } else { NotesInfo.Visible = false; } SetGrid(); } if (Session["UserPreferences"] != null) { DataTable UserPreferences = (DataTable)Session["UserPreferences"]; foreach (DataRow dr in UserPreferences.Rows) { if (dr[1].ToString() == "NotesMailProbeDetailsPage|DiskHealthGrid") { DiskHealthGrid.SettingsPager.PageSize = Convert.ToInt32(dr[2]); } } } } else { if (Request.QueryString["Server"] != "" && Request.QueryString["Server"] != null) { SetGridFromQString(Request.QueryString["Server"]); } else { SetGridFromSession(); } } }
/// <summary> /// Get Data from NotesMailProbe based on mail-Id /// </summary> public NotesMailProbe GetData(NotesMailProbe ProbObject) { DataTable NotesMailProbeDataTable = new DataTable(); NotesMailProbe ReturnObject = new NotesMailProbe(); try { //12/7/2012 NS modified - need to return Server Name, it will be used in the Target Server combo box. //Currently, the combo box erroneously displays Server ID value string SqlQuery = "SELECT *, ServerName FROM NotesMailProbe " + "INNER JOIN Servers ON ID = DestinationServerID where [Name]='" + ProbObject.Name + "'"; NotesMailProbeDataTable = objAdaptor.FetchData(SqlQuery); //populate & return data object ReturnObject.Name = NotesMailProbeDataTable.Rows[0]["Name"].ToString(); if (NotesMailProbeDataTable.Rows[0]["Enabled"].ToString() != "") { ReturnObject.Enabled = bool.Parse(NotesMailProbeDataTable.Rows[0]["Enabled"].ToString()); } if (NotesMailProbeDataTable.Rows[0]["ScanInterval"].ToString() != "") { ReturnObject.ScanInterval = int.Parse(NotesMailProbeDataTable.Rows[0]["ScanInterval"].ToString()); } if (NotesMailProbeDataTable.Rows[0]["OffHoursScanInterval"].ToString() != "") { ReturnObject.OffHoursScanInterval = int.Parse(NotesMailProbeDataTable.Rows[0]["OffHoursScanInterval"].ToString()); } if (NotesMailProbeDataTable.Rows[0]["RetryInterval"].ToString() != "") { ReturnObject.RetryInterval = int.Parse(NotesMailProbeDataTable.Rows[0]["RetryInterval"].ToString()); } ReturnObject.Category = NotesMailProbeDataTable.Rows[0]["Category"].ToString(); ReturnObject.Filename = NotesMailProbeDataTable.Rows[0]["Filename"].ToString(); if (NotesMailProbeDataTable.Rows[0]["EchoService"].ToString() != "") { ReturnObject.EchoService = bool.Parse(NotesMailProbeDataTable.Rows[0]["EchoService"].ToString()); } ReturnObject.NotesMailAddress = NotesMailProbeDataTable.Rows[0]["NotesMailAddress"].ToString(); if (NotesMailProbeDataTable.Rows[0]["DestinationServerID"].ToString() != "" && NotesMailProbeDataTable.Rows[0]["DestinationServerID"].ToString() != null) { ReturnObject.DestinationServerID = int.Parse(NotesMailProbeDataTable.Rows[0]["DestinationServerID"].ToString()); } ReturnObject.DestinationDatabase = NotesMailProbeDataTable.Rows[0]["DestinationDatabase"].ToString(); if (NotesMailProbeDataTable.Rows[0]["DeliveryThreshold"].ToString() != "") { ReturnObject.DeliveryThreshold = int.Parse(NotesMailProbeDataTable.Rows[0]["DeliveryThreshold"].ToString()); } ReturnObject.SourceServer = NotesMailProbeDataTable.Rows[0]["SourceServer"].ToString(); ReturnObject.ReplyTo = NotesMailProbeDataTable.Rows[0]["ReplyTo"].ToString(); ReturnObject.ServerName = NotesMailProbeDataTable.Rows[0]["ServerName"].ToString(); } catch (Exception ex) { throw ex; } finally { } return(ReturnObject); }