Пример #1
0
        /// <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);
        }
Пример #2
0
        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);
        }
Пример #3
0
        /// <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);
        }
Пример #4
0
 /// <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;
     }
 }
Пример #5
0
 /// <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;
     }
 }
Пример #6
0
 // 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;
     }
 }
Пример #7
0
 public DataTable GetAllDataByName(NotesMailProbe NotesMailProbeObject)
 {
     try
     {
         return(VSWebDAL.ConfiguratorDAL.NotesMailProbeDAL.Ins.GetAllDataByName(NotesMailProbeObject));
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
Пример #8
0
        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 { }
            }
        }
Пример #9
0
        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 { }
        }
Пример #10
0
        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 { }
            }
        }
Пример #11
0
        //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);
        }
Пример #12
0
        /// <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;
            }
        }
Пример #13
0
        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);
        }
Пример #14
0
        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);
        }
Пример #15
0
 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 { }
 }
Пример #16
0
        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;
            }
        }
Пример #17
0
        /// <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("");
        }
Пример #18
0
        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();
                }
            }
        }
Пример #19
0
        /// <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);
        }