public void insertBlackBerryService() { BlackBerryServers BlackBerryServerObject = new BlackBerryServers(); Object inserObject; try { inserObject = VSWebBL.ConfiguratorBL.BlackBerryServersBL.Ins.insertBlackBerryServer(getdataBlackservice()); SetFocusOnError(inserObject); if (inserObject.ToString() == "True") { //3/19/2014 NS modified to redirect to the BB grid page /* * ErrorMessageLabel.Text = "Data inserted successfully."; * ErrorMessagePopupControl.HeaderText = "Information"; * ErrorMessagePopupControl.ShowCloseButton = false; * ValidationUpdatedButton.Visible = true; * ValidationOkButton.Visible = false; * ErrorMessagePopupControl.ShowOnPageLoad = true; */ Session["BlackberryUpdateStatus"] = NameTextBox.Text; Response.Redirect("BlackBerry.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); } }
public DataTable filldatabyid(BlackBerryServers BlackBerryserversObject) { DataTable dt = new DataTable(); try { //string s = "Select * from BlackBerryServers where [key]="+BlackBerryserversObject.key; //dt=objAdaptor.FetchData(s); System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection(ConfigurationManager.ConnectionStrings["VitalSignsConnectionString"].ToString()); System.Data.SqlClient.SqlCommand da = new System.Data.SqlClient.SqlCommand("select max(serverID) from BlackBerryServers", con); string maxid = string.Empty; try { con.Open(); object maxsid = da.ExecuteScalar(); maxid = maxsid.ToString(); } catch { } // int mi = Convert.ToInt16(maxid); finally { con.Close(); } if (!string.IsNullOrEmpty(maxid)) { if (int.Parse(maxid) > BlackBerryserversObject.key || int.Parse(maxid) == BlackBerryserversObject.key) { string q = "select *,ServerName as Name,ID as SID,LocationID,Description,IPAddress from servers left join BlackBerryServers on servers.ID=BlackBerryServers.ServerID where BlackBerryServers.ServerID=@Key"; SqlCommand cmd = new SqlCommand(q); cmd.Parameters.AddWithValue("@Key", BlackBerryserversObject.key); dt = objAdaptor.FetchDatafromcommand(cmd); //dt = objAdaptor.FetchData(q); } else { string s = "select *,ServerName as Name,ID as SID,LocationID,Description,IPAddress from servers left join BlackBerryServers on servers.ID=BlackBerryServers.ServerID where Servers.ID=@Key"; SqlCommand cmd = new SqlCommand(s); cmd.Parameters.AddWithValue("@Key", BlackBerryserversObject.key); dt = objAdaptor.FetchDatafromcommand(cmd); // dt = objAdaptor.FetchData(s); BlackBerryserversObject.Category = ""; } } else { string s = "select *,ServerName as Name,ID as SID,LocationID,Description,IPAddress from servers left join BlackBerryServers on servers.ID=BlackBerryServers.ServerID where Servers.ID=@Key"; SqlCommand cmd = new SqlCommand(s); cmd.Parameters.AddWithValue("@Key", BlackBerryserversObject.key); dt = objAdaptor.FetchDatafromcommand(cmd); // dt = objAdaptor.FetchData(s); BlackBerryserversObject.Category = ""; } } catch (Exception e) { throw e; } return(dt); }
public DataTable fillcombo(BlackBerryServers BlackBerryServerObject) { try { return(VSWebDAL.ConfiguratorDAL.BlackBerryServersDAL.Ins.fillcombo1(BlackBerryServerObject)); } catch (Exception ex) { throw ex; } }
public DataTable finddatawithname(BlackBerryServers BlackBerryServerObject, string name) { try { return(VSWebDAL.ConfiguratorDAL.BlackBerryServersDAL.Ins.getthevaluewithname(BlackBerryServerObject, name)); } catch (Exception ex) { throw ex; } }
public Object deleteBlackBerryServer(BlackBerryServers BlackBerryServersObject) { try { return(VSWebDAL.ConfiguratorDAL.BlackBerryServersDAL.Ins.deletefromgrid(BlackBerryServersObject)); } catch (Exception ex) { throw ex; } }
public Object updatedetails(BlackBerryServers BlackBerryServerObject) { try { return(VSWebDAL.ConfiguratorDAL.BlackBerryServersDAL.Ins.updateBlackBerrySever(BlackBerryServerObject)); } catch (Exception ex) { throw ex; } }
public DataTable getdatawithid(BlackBerryServers BlackBerryServerObject) { try { return(VSWebDAL.ConfiguratorDAL.BlackBerryServersDAL.Ins.filldatabyid(BlackBerryServerObject)); } catch (Exception ex) { throw ex; } }
protected void BlackBerryGridView_RowDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e) { BlackBerryServers BlackBerryServerObject = new BlackBerryServers(); BlackBerryServerObject.key = Convert.ToInt32(e.Keys[0]); Object Blackberry = VSWebBL.ConfiguratorBL.BlackBerryServersBL.Ins.deleteBlackBerryServer(BlackBerryServerObject); ASPxGridView griedview = (ASPxGridView)sender; griedview.CancelEdit(); e.Cancel = true; fillgrid(); }
public Object insertBlackBerryService(BlackBerryServers BlackBerryServerObject) { Object insertBlackBerryServer; try { //string str = "insert into BlackBerryServers(Address,Name,Description,Category,ScanInterval,OffHoursScanInterval,Enabled,RetryInterval,Alert,Policy,Synchronization,Controller,Messaging,MDSServices,MDSConnection,OtherServices,BESVersion,Attachment,Router,AlertIP,RouterIP,AttachmentIP,PendingThreshold,TimeZoneAdjustment,USDateFormat,NotificationGroup) values('" + BlackBerryServerObject.Address + "','" + BlackBerryServerObject.Name + "','" + BlackBerryServerObject.Description + // "','" + BlackBerryServerObject.Category + "'," + BlackBerryServerObject.ScanInterval + "," + BlackBerryServerObject.OffHoursScanInterval + ",'" + BlackBerryServerObject.Enabled + "'," + BlackBerryServerObject.RetryInterval + ",'" + BlackBerryServerObject.Alert + "','"+BlackBerryServerObject.Policy+"','"+BlackBerryServerObject.Synchronization+"','"+BlackBerryServerObject.Controller+"','"+BlackBerryServerObject.Messaging+"','"+BlackBerryServerObject.MDSServices+"','"+BlackBerryServerObject.MDSConnection+"','"+BlackBerryServerObject.OtherServices+"','"+BlackBerryServerObject.BESVersion+"','"+BlackBerryServerObject.Attachment+"','"+BlackBerryServerObject.Router+"','"+BlackBerryServerObject.AlertIP+"','"+BlackBerryServerObject.RouterIP+"','"+BlackBerryServerObject.AttachmentIP+"',"+BlackBerryServerObject.PendingThreshold+","+BlackBerryServerObject.TimeZoneAdjustment+",'"+BlackBerryServerObject.USDateFormat+"','"+BlackBerryServerObject.NotificationGroup+"')"; string str = "insert into BlackBerryServers(ServerID,Category,ScanInterval,OffHoursScanInterval,Enabled,RetryInterval,Alert,Policy,Synchronization,Controller,Messaging,MDSServices,MDSConnection,OtherServices,BESVersion,Attachment,Router,AlertIP,RouterIP,AttachmentIP,PendingThreshold,TimeZoneAdjustment,USDateFormat,NotificationGroup,SNMPCommunity,HAOption,HAPartner) values(@ServerID , @Category ,@ScanInterval ,@OffHoursScanInterval,@Enabled ,@RetryInterval ,@Alert ,@Policy ,@Synchronization ,@Controller,@Messaging,@MDSServices ,@MDSConnection ,@OtherServices ,@BESVersion ,@Attachment ,@Router ,@AlertIP ,@RouterIP ,@AttachmentIP ,@PendingThreshold ,@TimeZoneAdjustment ,@USDateFormat ,@NotificationGroup ,@SNMPCommunity ,@HAOption,@HAPartner)"; SqlCommand cmd = new SqlCommand(str); cmd.Parameters.AddWithValue("@ServerID", BlackBerryServerObject.ServerID); cmd.Parameters.AddWithValue("@Category", BlackBerryServerObject.Category); cmd.Parameters.AddWithValue("@ScanInterval", BlackBerryServerObject.ScanInterval); cmd.Parameters.AddWithValue("@OffHoursScanInterval", BlackBerryServerObject.OffHoursScanInterval); cmd.Parameters.AddWithValue("@Enabled", BlackBerryServerObject.Enabled); cmd.Parameters.AddWithValue("@RetryInterval", BlackBerryServerObject.RetryInterval); cmd.Parameters.AddWithValue("@Alert", BlackBerryServerObject.Alert); cmd.Parameters.AddWithValue("@Policy", BlackBerryServerObject.Policy); cmd.Parameters.AddWithValue("@Synchronization", BlackBerryServerObject.Synchronization); cmd.Parameters.AddWithValue("@Controller", BlackBerryServerObject.Controller); cmd.Parameters.AddWithValue("@Messaging", BlackBerryServerObject.Messaging); cmd.Parameters.AddWithValue("@MDSServices", BlackBerryServerObject.MDSServices); cmd.Parameters.AddWithValue("@MDSConnection", BlackBerryServerObject.MDSConnection); cmd.Parameters.AddWithValue("@OtherServices", BlackBerryServerObject.OtherServices); cmd.Parameters.AddWithValue("@BESVersion", BlackBerryServerObject.BESVersion); cmd.Parameters.AddWithValue("@Attachment", BlackBerryServerObject.Attachment); cmd.Parameters.AddWithValue("@Router", BlackBerryServerObject.Router); cmd.Parameters.AddWithValue("@AlertIP", BlackBerryServerObject.AlertIP); cmd.Parameters.AddWithValue("@RouterIP", BlackBerryServerObject.RouterIP); cmd.Parameters.AddWithValue("@AttachmentIP", BlackBerryServerObject.AttachmentIP); cmd.Parameters.AddWithValue("@PendingThreshold", BlackBerryServerObject.PendingThreshold); cmd.Parameters.AddWithValue("@TimeZoneAdjustment", BlackBerryServerObject.TimeZoneAdjustment); cmd.Parameters.AddWithValue("@USDateFormat", BlackBerryServerObject.USDateFormat); cmd.Parameters.AddWithValue("@NotificationGroup", BlackBerryServerObject.NotificationGroup); cmd.Parameters.AddWithValue("@SNMPCommunity", BlackBerryServerObject.SNMPCommunity); cmd.Parameters.AddWithValue("@HAOption", BlackBerryServerObject.HAOption); cmd.Parameters.AddWithValue("@HAPartner", BlackBerryServerObject.HAPartner); insertBlackBerryServer = objAdaptor.ExecuteNonQuerywithcmd(cmd); //insertBlackBerryServer = objAdaptor.ExecuteNonQuery(str); //insertBlackBerryServer = objAdaptor.ExecuteNonQuery(str); } catch (Exception e) { throw e; } return(insertBlackBerryServer); }
public Object deletefromgrid(BlackBerryServers BlackBerryServerObject) { Object BlackBerryServer; try { string st = "delete from BlackBerryServers where [key]=" + BlackBerryServerObject.key + ""; string delServer = "delete from servers where ID=" + BlackBerryServerObject.key; BlackBerryServer = objAdaptor.ExecuteNonQuery(delServer); BlackBerryServer = objAdaptor.ExecuteNonQuery(st); } catch (Exception ex) { throw ex; } return(BlackBerryServer); }
public Object insertBlackBerryServer(BlackBerryServers BlackBerryServersObject) { //bool insert = false; Object returnvalue = ValidateBlackBerryServers(BlackBerryServersObject); try { if (returnvalue.ToString() == "") { return(VSWebDAL.ConfiguratorDAL.BlackBerryServersDAL.Ins.insertBlackBerryService(BlackBerryServersObject)); } } catch (Exception ex) { throw ex; } return(returnvalue); }
//public DataTable getkey(string name) //{ // DataTable dt = new DataTable(); // try // { // string s = "select * from BlackBerryServers where ServerID='" + name + "'"; // dt = objAdaptor.FetchData(s); // } // catch (Exception e) // { // throw e; // } // return dt; //} //public Object Insert(BlackBerryServers BlackBerryServerObject) //{ // Object insertBlackBerryServer; // try // { // //string str = "insert into BlackBerryServers(Address,Name,Description,Category,ScanInterval,OffHoursScanInterval,Enabled,RetryInterval,Alert,Policy,Synchronization,Controller,Messaging,MDSServices,MDSConnection,OtherServices,BESVersion,Attachment,Router,AlertIP,RouterIP,AttachmentIP,PendingThreshold,TimeZoneAdjustment,USDateFormat,NotificationGroup) values('" + BlackBerryServerObject.Address + "','" + BlackBerryServerObject.Name + "','" + BlackBerryServerObject.Description + // // "','" + BlackBerryServerObject.Category + "'," + BlackBerryServerObject.ScanInterval + "," + BlackBerryServerObject.OffHoursScanInterval + ",'" + BlackBerryServerObject.Enabled + "'," + BlackBerryServerObject.RetryInterval + ",'" + BlackBerryServerObject.Alert + "','"+BlackBerryServerObject.Policy+"','"+BlackBerryServerObject.Synchronization+"','"+BlackBerryServerObject.Controller+"','"+BlackBerryServerObject.Messaging+"','"+BlackBerryServerObject.MDSServices+"','"+BlackBerryServerObject.MDSConnection+"','"+BlackBerryServerObject.OtherServices+"','"+BlackBerryServerObject.BESVersion+"','"+BlackBerryServerObject.Attachment+"','"+BlackBerryServerObject.Router+"','"+BlackBerryServerObject.AlertIP+"','"+BlackBerryServerObject.RouterIP+"','"+BlackBerryServerObject.AttachmentIP+"',"+BlackBerryServerObject.PendingThreshold+","+BlackBerryServerObject.TimeZoneAdjustment+",'"+BlackBerryServerObject.USDateFormat+"','"+BlackBerryServerObject.NotificationGroup+"')"; // string str = "insert into BlackBerryServers(HAOption,HAPartner) values('" + BlackBerryServerObject.HAOption + "','" + BlackBerryServerObject.HAPartner + "')"; // insertBlackBerryServer = objAdaptor.ExecuteNonQuery(str); // //insertBlackBerryServer = objAdaptor.ExecuteNonQuery(str); // } // catch (Exception e) // { // throw e; // } // return insertBlackBerryServer; //} // 26/06/2014 public DataTable fillcombo1(BlackBerryServers BlackBerryserverObject) { DataTable dt = new DataTable(); try { // BlackBerryServers BlackBerryObject = new BlackBerryServers(); //string query = "select ServerName,ServerID from Servers s inner join BlackBerryServers b on s.ID= b.ServerID where ServerID = '"+BlackBerryserverObject.ServerID+"'"; string query = "select * from Servers where id <>" + BlackBerryserverObject.ServerID.ToString() + " and servertypeid=2 order by ServerName"; dt = objAdaptor.FetchData(query); //string finddatawithname = "select * from BlackBerryServers where Name='" +name+ "' and [key]<>"+BlackBerryserverObject.key+""; //dt = objAdaptor.FetchData(finddatawithname); } catch (Exception e) { throw e; } return(dt); }
public Object ValidateBlackBerryServers(BlackBerryServers BlackBerryServerObject) { Object returnvalue = ""; try { // if (BlackBerryServerObject.Name == null || BlackBerryServerObject.Name == "") // { // return "ER#Please enter the BlackBerryServers Name"; // } // if (BlackBerryServerObject.Description == null || BlackBerryServerObject.Description == "") // { // return "ER#Please enter a description of the device"; // } if (BlackBerryServerObject.Category == null || BlackBerryServerObject.Category == "") { return("ER#Please enter a category"); } if (BlackBerryServerObject.ScanInterval == null) { return("ER#Please enter a Scan Interval"); } if (BlackBerryServerObject.OffHoursScanInterval == null) { return("ER#Please enter a OffHoursScanInterval"); } if (BlackBerryServerObject.RetryInterval == null) { return("ER#Please enter a RetryInterval"); } // if (BlackBerryServerObject.RetryInterval > BlackBerryServerObject.ScanInterval) // { // return "ER#Please enter a ScanInterval greater than RetryInterval"; // } } catch (Exception ex) { throw ex; } return(returnvalue); }
// binding data to combo public void getcombo(BlackBerryServers BlackBerryServerObject) { DataTable dt = new DataTable(); // BlackBerryServers BlackBerryServerObject = new BlackBerryServers(); try { dt = VSWebBL.ConfiguratorBL.BlackBerryServersBL.Ins.fillcombo(BlackBerryServerObject); if (dt.Rows.Count > 0) { SrvAtrCategoryComboBox.DataSource = dt; SrvAtrCategoryComboBox.TextField = "ServerName"; SrvAtrCategoryComboBox.ValueField = "ServerName"; SrvAtrCategoryComboBox.DataBind(); } } catch (Exception ex) { //6/27/2014 NS added for VSPLUS-634 Log.Entry.Ins.WriteHistoryEntry(DateTime.Now.ToString() + " Exception - " + ex); } }
public DataTable getthevaluewithname(BlackBerryServers BlackBerryserverObject, string name) { DataTable dt = new DataTable(); try { BlackBerryServers BlackBerryObject = new BlackBerryServers(); string finddatawithname = "select * from BlackBerryServers where ServerID = @ServerID"; SqlCommand cmd = new SqlCommand(finddatawithname); cmd.Parameters.AddWithValue("@ServerID", BlackBerryObject.ServerID); dt = objAdaptor.FetchDatafromcommand(cmd); // dt = objAdaptor.FetchData(finddatawithname); //string finddatawithname = "select * from BlackBerryServers where Name='" +name+ "' and [key]<>"+BlackBerryserverObject.key+""; //dt = objAdaptor.FetchData(finddatawithname); } catch (Exception e) { throw e; } return(dt); }
public BlackBerryServers getdataBlackservice() { BlackBerryServers BlackBerryObject = new BlackBerryServers(); BlackBerryObject.Address = AddressTextBox.Text; BlackBerryObject.Category = categoryTextBox.Text; BlackBerryObject.Description = DescriptionTextBox.Text; //5/22/2015 NS modified for VSPLUS-1792 //BlackBerryObject.Enabled = Convert.ToBoolean(EnableforScanningCheckBox.Enabled); BlackBerryObject.Enabled = Convert.ToBoolean(EnableforScanningCheckBox.Checked); BlackBerryObject.Name = NameTextBox.Text; BlackBerryObject.RetryInterval = Convert.ToInt32(RetryIntervalTextBox.Text); BlackBerryObject.ScanInterval = Convert.ToInt32(ScanIntervalTextBox.Text); BlackBerryObject.OffHoursScanInterval = Convert.ToInt32(OffHoursScanIntervalTextBox.Text); BlackBerryObject.HAOption = rbtnservermode.SelectedItem.Text; // BlackBerryObject.HAOption = Session["r2"].ToString(); if (rbtnservermode.SelectedIndex.ToString() == "Stand Alone Server") { rbtnservermode.SelectedIndex = 0; } DataTable dt = new DataTable(); //6/27/2014 NS added for VSPLUS-634 - the getServerID function must be called in try/catch to trap any issues try { dt = VSWebBL.ConfiguratorBL.BlackBerryServersBL.Ins.getServerID(SrvAtrCategoryComboBox.Text); //6/27/2014 NS added for VSPLUS-634 - the data table must contain at least one row if (dt.Rows.Count > 0) { BlackBerryObject.HAPartner = Convert.ToString(dt.Rows[0]["ID"].ToString()); //Session["d2"].ToString(); } } catch (Exception ex) { //6/27/2014 NS added for VSPLUS-634 Log.Entry.Ins.WriteHistoryEntry(DateTime.Now.ToString() + " Exception - " + ex); } if (BlackBerryObject.HAOption.ToLower() == "stand alone server") { BlackBerryObject.HAPartner = "0"; } if (pendingTextBox.Text != "") { BlackBerryObject.PendingThreshold = Convert.ToInt32(pendingTextBox.Text); } if (Mode == "update") { BlackBerryObject.key = key; } BlackBerryObject.Policy = Convert.ToBoolean(BlackBerryPolicyServiceCheckBox.Checked); BlackBerryObject.Synchronization = Convert.ToBoolean(BlackBerrySychronizationServiceCheckBox.Checked); BlackBerryObject.Controller = Convert.ToBoolean(BlackBerryControllerServiceCheckBox.Checked); BlackBerryObject.Messaging = Convert.ToBoolean(BlackBerryMessagingAgentCheckBox.Checked); BlackBerryObject.Dispatcher = Convert.ToBoolean(BlackBerryDispacherServiceCheckBox.Checked); BlackBerryObject.MDS = Convert.ToBoolean(BlackBerryMobileDataServiceCheckBox.Checked); BlackBerryObject.MDSConnection = Convert.ToBoolean(BlackBerryMDSConnectionServiceCheckBox.Checked); BlackBerryObject.MDSServices = Convert.ToBoolean(BlackBerryMDSServicesCheckBox.Checked); if (OtherServicesToMonitorTextBox.Text != "") { BlackBerryObject.OtherServices = OtherServicesToMonitorTextBox.Text; } else { BlackBerryObject.OtherServices = "None"; } BlackBerryObject.SNMPCommunity = SNMPCommunityTextBox.Text; BlackBerryObject.BESVersion = BSEversionComboBox.Text; BlackBerryObject.Router = BlackBerryRouterServiceCheckBox.Checked; BlackBerryObject.Alert = BlackBerryAlertServiceCheckBox.Checked; if (BlackBerryAlertServiceTextBox.Text != "") { BlackBerryObject.AlertIP = BlackBerryAlertServiceTextBox.Text; } else { BlackBerryObject.AlertIP = AddressTextBox.Text; } if (BlackBerryRouterserviceTextBox.Text != "") { BlackBerryObject.RouterIP = BlackBerryRouterserviceTextBox.Text; } else { BlackBerryObject.RouterIP = AddressTextBox.Text; } BlackBerryObject.Attachment = BlackBerryAttachmentServiceCheckBox.Checked; if (BlackBerryAttachmTextBox.Text != "") { BlackBerryObject.AttachmentIP = BlackBerryAttachmTextBox.Text; } else { BlackBerryObject.AttachmentIP = AddressTextBox.Text; } if (TimeZoneAdjestmentTextBox.Text != null && TimeZoneAdjestmentTextBox.Text != "") { BlackBerryObject.TimeZoneAdjustment = Convert.ToInt32(TimeZoneAdjestmentTextBox.Text); } BlackBerryObject.USDateFormat = UsdateformateCheckBox.Checked; // BlackBerryObject.NotificationGroup = SendToTextBox.Text; BlackBerryObject.ServerID = int.Parse(lblSid.Text); return(BlackBerryObject); }
public BlackBerryServers filldataBlackBerryService(int key) { int serverid = 0; CmbBSEVersion(); lblprdserver.Visible = false; SrvAtrCategoryComboBox.Visible = false; BlackBerryServers BlackBerryObject = new BlackBerryServers(); BlackBerryObject.key = key; DataTable dt = new DataTable(); try { dt = VSWebBL.ConfiguratorBL.BlackBerryServersBL.Ins.getdatawithid(BlackBerryObject); //1/7/2014 NS modified if (dt.Rows.Count > 0) { serverid = int.Parse(dt.Rows[0]["ServerID"].ToString()); BlackBerryObject.ServerID = serverid; getcombo(BlackBerryObject); if (dt.Rows[0]["HAOption"].ToString() != null && dt.Rows[0]["HAOption"].ToString() != "") { rbtnservermode.Value = dt.Rows[0]["HAOption"]; } lblprdserver.Visible = true; SrvAtrCategoryComboBox.Visible = true; if (rbtnservermode.Value.ToString() == "Stand Alone Server") { lblprdserver.Visible = false; SrvAtrCategoryComboBox.Visible = false; } if (dt.Rows[0]["HAPartner"].ToString() != null && dt.Rows[0]["HAPartner"].ToString() != "") { DataTable dt1 = new DataTable(); dt1 = VSWebBL.ConfiguratorBL.BlackBerryServersBL.Ins.getHAName(dt.Rows[0]["HAPartner"].ToString()); if (dt1.Rows.Count > 0) { SrvAtrCategoryComboBox.Value = dt1.Rows[0]["ServerName"]; } } if (dt.Rows[0]["Category"].ToString() != null && dt.Rows[0]["Category"].ToString() != "") { categoryTextBox.Text = dt.Rows[0]["Category"].ToString(); } NameTextBox.Text = dt.Rows[0]["Name"].ToString(); NameTextBox.Enabled = false; AddressTextBox.Text = dt.Rows[0]["IPAddress"].ToString(); AddressTextBox.Enabled = false; if (dt.Rows[0]["Category"].ToString() != null && dt.Rows[0]["Category"].ToString() != "") { categoryTextBox.Text = dt.Rows[0]["Category"].ToString(); } //categoryTextBox.Enabled = false; DescriptionTextBox.Text = dt.Rows[0]["Description"].ToString(); DescriptionTextBox.Enabled = false; if (dt.Rows[0]["PendingThreshold"].ToString() != null && dt.Rows[0]["PendingThreshold"].ToString() != "") { pendingTextBox.Text = dt.Rows[0]["PendingThreshold"].ToString(); } if (dt.Rows[0]["ScanInterval"].ToString() != null && dt.Rows[0]["ScanInterval"].ToString() != "") { ScanIntervalTextBox.Text = dt.Rows[0]["ScanInterval"].ToString(); } if (dt.Rows[0]["RetryInterval"].ToString() != null && dt.Rows[0]["RetryInterval"].ToString() != "") { RetryIntervalTextBox.Text = dt.Rows[0]["RetryInterval"].ToString(); } if (dt.Rows[0]["Enabled"].ToString() != null && dt.Rows[0]["Enabled"].ToString() != "") { EnableforScanningCheckBox.Checked = Convert.ToBoolean(dt.Rows[0]["Enabled"]); } if (dt.Rows[0]["OffHoursScanInterval"].ToString() != null && dt.Rows[0]["OffHoursScanInterval"].ToString() != "") { OffHoursScanIntervalTextBox.Text = dt.Rows[0]["OffHoursScanInterval"].ToString(); } if (dt.Rows[0]["SNMPCommunity"].ToString() != null && dt.Rows[0]["SNMPCommunity"].ToString() != "") { SNMPCommunityTextBox.Text = dt.Rows[0]["SNMPCommunity"].ToString(); } //if (dt.Rows[0]["NotificationGroup"].ToString() != null && dt.Rows[0]["NotificationGroup"].ToString() != "") // SendToTextBox.Text = dt.Rows[0]["NotificationGroup"].ToString(); if (dt.Rows[0]["Router"].ToString() != null && dt.Rows[0]["Router"].ToString() != "") { BlackBerryRouterServiceCheckBox.Checked = Convert.ToBoolean(dt.Rows[0]["Router"].ToString()); } if (dt.Rows[0]["Alert"].ToString() != null && dt.Rows[0]["Alert"].ToString() != "") { BlackBerryAlertServiceCheckBox.Checked = Convert.ToBoolean(dt.Rows[0]["Alert"].ToString()); } if (dt.Rows[0]["Attachment"].ToString() != null && dt.Rows[0]["Attachment"].ToString() != "") { BlackBerryAttachmentServiceCheckBox.Checked = Convert.ToBoolean(dt.Rows[0]["Attachment"].ToString()); } if (dt.Rows[0]["RouterIP"].ToString() != null && dt.Rows[0]["RouterIP"].ToString() != "") { BlackBerryRouterserviceTextBox.Text = dt.Rows[0]["RouterIP"].ToString(); } if (dt.Rows[0]["AlertIP"].ToString() != null && dt.Rows[0]["AlertIP"].ToString() != "") { BlackBerryAlertServiceTextBox.Text = dt.Rows[0]["AlertIP"].ToString(); } if (dt.Rows[0]["AttachmentIP"].ToString() != null && dt.Rows[0]["AttachmentIP"].ToString() != "") { BlackBerryAttachmTextBox.Text = dt.Rows[0]["AttachmentIP"].ToString(); } if (dt.Rows[0]["TimeZoneAdjustment"].ToString() != null && dt.Rows[0]["TimeZoneAdjustment"].ToString() != "") { TimeZoneAdjestmentTextBox.Text = dt.Rows[0]["TimeZoneAdjustment"].ToString(); } if (dt.Rows[0]["USDateFormat"].ToString() != null && dt.Rows[0]["USDateFormat"].ToString() != "") { UsdateformateCheckBox.Checked = Convert.ToBoolean(dt.Rows[0]["USDateFormat"]); } lblSid.Text = dt.Rows[0]["SID"].ToString(); if (dt.Rows[0]["Messaging"].ToString() != null && dt.Rows[0]["Messaging"].ToString() != "") { BlackBerryMessagingAgentCheckBox.Checked = Convert.ToBoolean(dt.Rows[0]["Messaging"]); } if (dt.Rows[0]["Controller"].ToString() != null && dt.Rows[0]["Controller"].ToString() != "") { BlackBerryControllerServiceCheckBox.Checked = Convert.ToBoolean(dt.Rows[0]["Controller"]); } if (dt.Rows[0]["Dispatcher"].ToString() != null && dt.Rows[0]["Dispatcher"].ToString() != "") { BlackBerryDispacherServiceCheckBox.Checked = Convert.ToBoolean(dt.Rows[0]["Dispatcher"]); } if (dt.Rows[0]["Synchronization"].ToString() != null && dt.Rows[0]["Synchronization"].ToString() != "") { BlackBerrySychronizationServiceCheckBox.Checked = Convert.ToBoolean(dt.Rows[0]["Synchronization"]); } if (dt.Rows[0]["Policy"].ToString() != null && dt.Rows[0]["Policy"].ToString() != "") { BlackBerryPolicyServiceCheckBox.Checked = Convert.ToBoolean(dt.Rows[0]["Policy"]); } if (dt.Rows[0]["MDSServices"].ToString() != null && dt.Rows[0]["MDSServices"].ToString() != "") { BlackBerryMDSServicesCheckBox.Checked = Convert.ToBoolean(dt.Rows[0]["MDSServices"]); } if (dt.Rows[0]["MDSConnection"].ToString() != null && dt.Rows[0]["MDSConnection"].ToString() != "") { BlackBerryMDSConnectionServiceCheckBox.Checked = Convert.ToBoolean(dt.Rows[0]["MDSConnection"]); } if (dt.Rows[0]["MDS"].ToString() != null && dt.Rows[0]["MDS"].ToString() != "") { BlackBerryMobileDataServiceCheckBox.Checked = Convert.ToBoolean(dt.Rows[0]["MDS"]); } BlackBerryMessagingAgentCheckBox.Enabled = true; BlackBerryControllerServiceCheckBox.Enabled = true; BlackBerryDispacherServiceCheckBox.Enabled = true; BlackBerrySychronizationServiceCheckBox.Enabled = true; BlackBerryPolicyServiceCheckBox.Enabled = true; BlackBerryMDSServicesCheckBox.Enabled = true; BlackBerryMDSConnectionServiceCheckBox.Enabled = true; BlackBerryMobileDataServiceCheckBox.Enabled = true; Session["ReturnUrl"] = "BlackBerryEntertpriseServer.aspx?key=" + lblSid.Text + "&tab=3"; BSEversionComboBox.Text = dt.Rows[0]["BESVersion"].ToString(); if (BSEversionComboBox.Text == "BlackBerry 2.x") { BlackBerrySychronizationServiceCheckBox.Enabled = false; BlackBerrySychronizationServiceCheckBox.Checked = false; BlackBerryPolicyServiceCheckBox.Enabled = false; BlackBerryPolicyServiceCheckBox.Checked = false; BlackBerryMobileDataServiceCheckBox.Enabled = false; BlackBerryMobileDataServiceCheckBox.Checked = false; BlackBerryMDSServicesCheckBox.Enabled = false; BlackBerryMDSServicesCheckBox.Checked = false; BlackBerryMDSConnectionServiceCheckBox.Enabled = false; BlackBerryMDSConnectionServiceCheckBox.Checked = false; // SendToTextBox.Enabled = false; } if (BSEversionComboBox.Text == "BlackBerry 4.1x") { BlackBerryMobileDataServiceCheckBox.Enabled = false; BlackBerryMobileDataServiceCheckBox.Checked = false; BlackBerryMDSServicesCheckBox.Enabled = true; BlackBerryMessagingAgentCheckBox.Enabled = false; BlackBerryMessagingAgentCheckBox.Checked = false; BlackBerryMDSConnectionServiceCheckBox.Enabled = true; } if (BSEversionComboBox.Text == "BlackBerry 4.0x") { BlackBerryMDSConnectionServiceCheckBox.Enabled = false; BlackBerryMDSServicesCheckBox.Enabled = false; BlackBerryMDSConnectionServiceCheckBox.Checked = false; BlackBerryMDSServicesCheckBox.Checked = false; BlackBerryMobileDataServiceCheckBox.Enabled = true; } if (BSEversionComboBox.Text == "BlackBerry 5.x") { BlackBerryMobileDataServiceCheckBox.Enabled = false; BlackBerryMobileDataServiceCheckBox.Checked = false; BlackBerryMDSServicesCheckBox.Enabled = true; BlackBerryMessagingAgentCheckBox.Enabled = false; BlackBerryMessagingAgentCheckBox.Checked = false; } } } catch (Exception ex) { //6/27/2014 NS added for VSPLUS-634 Log.Entry.Ins.WriteHistoryEntry(DateTime.Now.ToString() + " Exception - " + ex); } return(BlackBerryObject); }
public Object updateBlackBerrySever(BlackBerryServers BlackBerryServerObject) { Object updateBlackBerryServer; try { // string st = "update BlackBerryServers set Address='" + BlackBerryServerObject.Address + "',Name='" + BlackBerryServerObject.Name + "',Description='" + BlackBerryServerObject.Description + "',Category='" + BlackBerryServerObject.Category + "',ScanInterval=" + BlackBerryServerObject.ScanInterval + ",OffHoursScanInterval=" + BlackBerryServerObject.OffHoursScanInterval + ",Enabled='" + BlackBerryServerObject.Enabled + "',RetryInterval=" + BlackBerryServerObject.RetryInterval + ",PendingThreshold='" + BlackBerryServerObject.PendingThreshold+ "',Policy='" + BlackBerryServerObject.Policy + "',Synchronization='" + BlackBerryServerObject.Synchronization + "',Controller='" + BlackBerryServerObject.Controller + "',Messaging='" + BlackBerryServerObject.Messaging + "',MDSServices='" + BlackBerryServerObject.MDSServices + "',MDSConnection='" + BlackBerryServerObject.MDSConnection + "',OtherServices='" + BlackBerryServerObject.OtherServices + "',BESVersion='" + BlackBerryServerObject.BESVersion + "',Attachment='" + BlackBerryServerObject.Attachment + "',Alert='" + BlackBerryServerObject.Alert + "',Router='" + BlackBerryServerObject.Router + "',AlertIP='" + BlackBerryServerObject.AlertIP + "',RouterIP='" + BlackBerryServerObject.RouterIP + "',AttachmentIP='" + BlackBerryServerObject.AttachmentIP + "',USDateFormat='" + BlackBerryServerObject.USDateFormat + "',NotificationGroup='" + BlackBerryServerObject.NotificationGroup + "' where [key]=" + BlackBerryServerObject.key + ""; // updateBlackBerryServer=objAdaptor.ExecuteNonQuery(st); System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection(ConfigurationManager.ConnectionStrings["VitalSignsConnectionString"].ToString()); System.Data.SqlClient.SqlCommand com = new System.Data.SqlClient.SqlCommand("select max(serverID) from BlackBerryServers", con); string maxid = string.Empty; try { con.Open(); object Maxserverid = com.ExecuteScalar(); maxid = Maxserverid.ToString(); } catch { } finally { con.Close(); } if (!string.IsNullOrEmpty(maxid)) { if (int.Parse(maxid) > BlackBerryServerObject.ServerID || int.Parse(maxid) == BlackBerryServerObject.ServerID) { string st = "update BlackBerryServers set Category = @Category, ScanInterval = @ScanInterval ,OffHoursScanInterval= @OffHoursScanInterval,Enabled = @Enabled ,RetryInterval = @RetryInterval,PendingThreshold = @PendingThreshold ,Policy= @Policy,Synchronization = @Synchronization,Controller = @Controller,Messaging = @Messaging,MDSServices = @MDSServices ,MDSConnection = @MDSConnection,OtherServices = @OtherServices,BESVersion = @BESVersion,Attachment = @Attachment ,Alert = @Alert ,Router = @Router,AlertIP = @AlertIP,RouterIP = @RouterIP,AttachmentIP = @AttachmentIP ,USDateFormat = @USDateFormat,NotificationGroup = @NotificationGroup , SNMPCommunity = @SNMPCommunity, Dispatcher = @Dispatcher, MDS = @MDS , TimeZoneAdjustment = @TimeZoneAdjustment ,HAOption = @HAOption,HAPartner = @HAPartner, ExpiredThreshold = @ExpiredThreshold where [ServerID] = @key"; // updateBlackBerryServer = objAdaptor.ExecuteNonQuery(st); SqlCommand cmd = new SqlCommand(st); cmd.Parameters.AddWithValue("@Key", (object)BlackBerryServerObject.key ?? DBNull.Value); cmd.Parameters.AddWithValue("@Category", (object)BlackBerryServerObject.Category ?? DBNull.Value); cmd.Parameters.AddWithValue("@ScanInterval", (object)BlackBerryServerObject.ScanInterval ?? DBNull.Value); cmd.Parameters.AddWithValue("@OffHoursScanInterval", (object)BlackBerryServerObject.OffHoursScanInterval ?? DBNull.Value); cmd.Parameters.AddWithValue("@Enabled", (object)BlackBerryServerObject.Enabled ?? DBNull.Value); cmd.Parameters.AddWithValue("@RetryInterval", (object)BlackBerryServerObject.RetryInterval ?? DBNull.Value); cmd.Parameters.AddWithValue("@PendingThreshold", (object)BlackBerryServerObject.PendingThreshold ?? DBNull.Value); cmd.Parameters.AddWithValue("@Policy", (object)BlackBerryServerObject.Policy ?? DBNull.Value); cmd.Parameters.AddWithValue("@Synchronization", (object)BlackBerryServerObject.Synchronization ?? DBNull.Value); cmd.Parameters.AddWithValue("@Controller", (object)BlackBerryServerObject.Controller ?? DBNull.Value); cmd.Parameters.AddWithValue("@Messaging", (object)BlackBerryServerObject.Messaging ?? DBNull.Value); cmd.Parameters.AddWithValue("@MDSServices", (object)BlackBerryServerObject.MDSServices ?? DBNull.Value); cmd.Parameters.AddWithValue("@MDSConnection", (object)BlackBerryServerObject.MDSConnection ?? DBNull.Value); cmd.Parameters.AddWithValue("@OtherServices", (object)BlackBerryServerObject.OtherServices ?? DBNull.Value); cmd.Parameters.AddWithValue("@BESVersion", (object)BlackBerryServerObject.BESVersion ?? DBNull.Value); cmd.Parameters.AddWithValue("@Attachment", (object)BlackBerryServerObject.Attachment ?? DBNull.Value); cmd.Parameters.AddWithValue("@Alert", (object)BlackBerryServerObject.Alert ?? DBNull.Value); cmd.Parameters.AddWithValue("@Router", (object)BlackBerryServerObject.Router ?? DBNull.Value); cmd.Parameters.AddWithValue("@AlertIP", (object)BlackBerryServerObject.AlertIP ?? DBNull.Value); cmd.Parameters.AddWithValue("@RouterIP", (object)BlackBerryServerObject.RouterIP ?? DBNull.Value); cmd.Parameters.AddWithValue("@AttachmentIP", (object)BlackBerryServerObject.AttachmentIP ?? DBNull.Value); //cmd.Parameters.AddWithValue("@USDateFormat", BlackBerryServerObject.USDateFormat); cmd.Parameters.AddWithValue("@USDateFormat", (object)BlackBerryServerObject.USDateFormat ?? DBNull.Value); cmd.Parameters.AddWithValue("@NotificationGroup", (object)BlackBerryServerObject.NotificationGroup ?? DBNull.Value); //cmd.Parameters.AddWithValue("@NotificationGroup", !String.IsNullOrEmpty(BlackBerryServerObject.NotificationGroup) ? BlackBerryServerObject.NotificationGroup : (object)DBNull.Value); //if( string.IsNullOrEmpty(BlackBerryServerObject.NotificationGroup)) // cmd.Parameters.AddWithValue("@NotificationGroup", DBNull.Value ); //else // cmd.Parameters.AddWithValue("@NotificationGroup", BlackBerryServerObject.NotificationGroup); cmd.Parameters.AddWithValue("@SNMPCommunity", (object)BlackBerryServerObject.SNMPCommunity ?? DBNull.Value); cmd.Parameters.AddWithValue("@Dispatcher", (object)BlackBerryServerObject.Dispatcher ?? DBNull.Value); cmd.Parameters.AddWithValue("@MDS", (object)BlackBerryServerObject.MDS); cmd.Parameters.AddWithValue("@TimeZoneAdjustment", (object)BlackBerryServerObject.TimeZoneAdjustment ?? DBNull.Value); cmd.Parameters.AddWithValue("@HAOption", (object)BlackBerryServerObject.HAOption ?? DBNull.Value); cmd.Parameters.AddWithValue("@HAPartner", (object)BlackBerryServerObject.HAPartner ?? DBNull.Value); cmd.Parameters.AddWithValue("@ExpiredThreshold", (object)BlackBerryServerObject.ExpiredThreshold ?? DBNull.Value); updateBlackBerryServer = objAdaptor.ExecuteNonQuerywithcmd(cmd); } else { // string str = "insert into BlackBerryServers(ServerID,Category,ScanInterval,OffHoursScanInterval,Enabled,RetryInterval,Alert,Policy,Synchronization,Controller,Messaging,MDSServices,MDSConnection,OtherServices,BESVersion,Attachment,Router,AlertIP,RouterIP,AttachmentIP,PendingThreshold,TimeZoneAdjustment,USDateFormat,NotificationGroup,HAOption,HAPartner) values('" + BlackBerryServerObject.ServerID + //"','" + BlackBerryServerObject.Category + "'," + BlackBerryServerObject.ScanInterval + "," + BlackBerryServerObject.OffHoursScanInterval + ",'" + BlackBerryServerObject.Enabled + "'," + BlackBerryServerObject.RetryInterval + ",'" + BlackBerryServerObject.Alert + "','" + BlackBerryServerObject.Policy + "','" + BlackBerryServerObject.Synchronization + "','" + BlackBerryServerObject.Controller + "','" + BlackBerryServerObject.Messaging + "','" + BlackBerryServerObject.MDSServices + "','" + BlackBerryServerObject.MDSConnection + "','" + BlackBerryServerObject.OtherServices + "','" + BlackBerryServerObject.BESVersion + "','" + BlackBerryServerObject.Attachment + "','" + BlackBerryServerObject.Router + "','" + BlackBerryServerObject.AlertIP + "','" + BlackBerryServerObject.RouterIP + "','" + BlackBerryServerObject.AttachmentIP + "'," + BlackBerryServerObject.PendingThreshold + "," + BlackBerryServerObject.TimeZoneAdjustment + ",'" + BlackBerryServerObject.USDateFormat + "','" + BlackBerryServerObject.NotificationGroup + "','" +BlackBerryServerObject.HAOption+"','" +BlackBerryServerObject.HAPartner+"')"; // updateBlackBerryServer = objAdaptor.ExecuteNonQuery(str); string str = "insert into BlackBerryServers(ServerID,Category,ScanInterval,OffHoursScanInterval,Enabled,RetryInterval,Alert,Policy,Synchronization,Controller,Messaging,MDSServices,MDSConnection,OtherServices,BESVersion,Attachment,Router,AlertIP,RouterIP,AttachmentIP,PendingThreshold,TimeZoneAdjustment,USDateFormat,NotificationGroup,HAOption,HAPartner) values(@ServerID , @Category ,@ScanInterval ,@OffHoursScanInterval,@Enabled ,@RetryInterval ,@Alert ,@Policy ,@Synchronization ,@Controller,@Messaging,@MDSServices ,@MDSConnection ,@OtherServices ,@BESVersion ,@Attachment ,@Router ,@AlertIP ,@RouterIP ,@AttachmentIP ,@PendingThreshold ,@TimeZoneAdjustment ,@USDateFormat ,@NotificationGroup ,@HAOption,@HAPartner)"; SqlCommand cmd = new SqlCommand(str); cmd.Parameters.AddWithValue("@ServerID", BlackBerryServerObject.ServerID); cmd.Parameters.AddWithValue("@Category", BlackBerryServerObject.Category); cmd.Parameters.AddWithValue("@ScanInterval", BlackBerryServerObject.ScanInterval); cmd.Parameters.AddWithValue("@OffHoursScanInterval", BlackBerryServerObject.OffHoursScanInterval); cmd.Parameters.AddWithValue("@Enabled", BlackBerryServerObject.Enabled); cmd.Parameters.AddWithValue("@RetryInterval", BlackBerryServerObject.RetryInterval); cmd.Parameters.AddWithValue("@Alert", BlackBerryServerObject.Alert); cmd.Parameters.AddWithValue("@Policy", BlackBerryServerObject.Policy); cmd.Parameters.AddWithValue("@Synchronization", BlackBerryServerObject.Synchronization); cmd.Parameters.AddWithValue("@Controller", BlackBerryServerObject.Controller); cmd.Parameters.AddWithValue("@Messaging", BlackBerryServerObject.Messaging); cmd.Parameters.AddWithValue("@MDSServices", BlackBerryServerObject.MDSServices); cmd.Parameters.AddWithValue("@MDSConnection", BlackBerryServerObject.MDSConnection); cmd.Parameters.AddWithValue("@OtherServices", BlackBerryServerObject.OtherServices); cmd.Parameters.AddWithValue("@BESVersion", BlackBerryServerObject.BESVersion); cmd.Parameters.AddWithValue("@Attachment", BlackBerryServerObject.Attachment); cmd.Parameters.AddWithValue("@Router", BlackBerryServerObject.Router); cmd.Parameters.AddWithValue("@AlertIP", BlackBerryServerObject.AlertIP); cmd.Parameters.AddWithValue("@RouterIP", BlackBerryServerObject.RouterIP); cmd.Parameters.AddWithValue("@AttachmentIP", BlackBerryServerObject.AttachmentIP); cmd.Parameters.AddWithValue("@PendingThreshold", BlackBerryServerObject.PendingThreshold); cmd.Parameters.AddWithValue("@TimeZoneAdjustment", BlackBerryServerObject.TimeZoneAdjustment); cmd.Parameters.AddWithValue("@USDateFormat", BlackBerryServerObject.USDateFormat); cmd.Parameters.AddWithValue("@NotificationGroup", BlackBerryServerObject.NotificationGroup); //cmd.Parameters.AddWithValue("@SNMPCommunity", BlackBerryServerObject.SNMPCommunity); cmd.Parameters.AddWithValue("@HAOption", BlackBerryServerObject.HAOption); cmd.Parameters.AddWithValue("@HAPartner", BlackBerryServerObject.HAPartner); updateBlackBerryServer = objAdaptor.ExecuteNonQuerywithcmd(cmd); } } else { //string str = "insert into BlackBerryServers(ServerID,Category,ScanInterval,OffHoursScanInterval,Enabled,RetryInterval,Alert,Policy,Synchronization,Controller,Messaging,MDSServices,MDSConnection,OtherServices,BESVersion,Attachment,Router,AlertIP,RouterIP,AttachmentIP,PendingThreshold,TimeZoneAdjustment,USDateFormat,NotificationGroup) values('" + BlackBerryServerObject.ServerID + //"','" + BlackBerryServerObject.Category + "'," + BlackBerryServerObject.ScanInterval + "," + BlackBerryServerObject.OffHoursScanInterval + ",'" + BlackBerryServerObject.Enabled + "'," + BlackBerryServerObject.RetryInterval + ",'" + BlackBerryServerObject.Alert + "','" + BlackBerryServerObject.Policy + "','" + BlackBerryServerObject.Synchronization + "','" + BlackBerryServerObject.Controller + "','" + BlackBerryServerObject.Messaging + "','" + BlackBerryServerObject.MDSServices + "','" + BlackBerryServerObject.MDSConnection + "','" + BlackBerryServerObject.OtherServices + "','" + BlackBerryServerObject.BESVersion + "','" + BlackBerryServerObject.Attachment + "','" + BlackBerryServerObject.Router + "','" + BlackBerryServerObject.AlertIP + "','" + BlackBerryServerObject.RouterIP + "','" + BlackBerryServerObject.AttachmentIP + "'," + BlackBerryServerObject.PendingThreshold + "," + BlackBerryServerObject.TimeZoneAdjustment + ",'" + BlackBerryServerObject.USDateFormat + "','" + BlackBerryServerObject.NotificationGroup + "','" +BlackBerryServerObject.HAOption+"','" +BlackBerryServerObject.HAPartner+ "')"; //updateBlackBerryServer = objAdaptor.ExecuteNonQuery(str); string str = "insert into BlackBerryServers(ServerID,Category,ScanInterval,OffHoursScanInterval,Enabled,RetryInterval,Alert,Policy,Synchronization,Controller,Messaging,MDSServices,MDSConnection,OtherServices,BESVersion,Attachment,Router,AlertIP,RouterIP,AttachmentIP,PendingThreshold,TimeZoneAdjustment,USDateFormat,NotificationGroup) values(@ServerID , @Category ,@ScanInterval ,@OffHoursScanInterval,@Enabled ,@RetryInterval ,@Alert ,@Policy ,@Synchronization ,@Controller,@Messaging,@MDSServices ,@MDSConnection ,@OtherServices ,@BESVersion ,@Attachment ,@Router ,@AlertIP ,@RouterIP ,@AttachmentIP ,@PendingThreshold ,@TimeZoneAdjustment ,@USDateFormat ,@NotificationGroup)"; SqlCommand cmd = new SqlCommand(str); cmd.Parameters.AddWithValue("@ServerID", BlackBerryServerObject.ServerID); cmd.Parameters.AddWithValue("@Category", BlackBerryServerObject.Category); cmd.Parameters.AddWithValue("@ScanInterval", BlackBerryServerObject.ScanInterval); cmd.Parameters.AddWithValue("@OffHoursScanInterval", BlackBerryServerObject.OffHoursScanInterval); cmd.Parameters.AddWithValue("@Enabled", BlackBerryServerObject.Enabled); cmd.Parameters.AddWithValue("@RetryInterval", BlackBerryServerObject.RetryInterval); cmd.Parameters.AddWithValue("@Alert", BlackBerryServerObject.Alert); cmd.Parameters.AddWithValue("@Policy", BlackBerryServerObject.Policy); cmd.Parameters.AddWithValue("@Synchronization", BlackBerryServerObject.Synchronization); cmd.Parameters.AddWithValue("@Controller", BlackBerryServerObject.Controller); cmd.Parameters.AddWithValue("@Messaging", BlackBerryServerObject.Messaging); cmd.Parameters.AddWithValue("@MDSServices", BlackBerryServerObject.MDSServices); cmd.Parameters.AddWithValue("@MDSConnection", BlackBerryServerObject.MDSConnection); cmd.Parameters.AddWithValue("@OtherServices", BlackBerryServerObject.OtherServices); cmd.Parameters.AddWithValue("@BESVersion", BlackBerryServerObject.BESVersion); cmd.Parameters.AddWithValue("@Attachment", BlackBerryServerObject.Attachment); cmd.Parameters.AddWithValue("@Router", BlackBerryServerObject.Router); cmd.Parameters.AddWithValue("@AlertIP", BlackBerryServerObject.AlertIP); cmd.Parameters.AddWithValue("@RouterIP", BlackBerryServerObject.RouterIP); cmd.Parameters.AddWithValue("@AttachmentIP", BlackBerryServerObject.AttachmentIP); cmd.Parameters.AddWithValue("@PendingThreshold", BlackBerryServerObject.PendingThreshold); cmd.Parameters.AddWithValue("@TimeZoneAdjustment", BlackBerryServerObject.TimeZoneAdjustment); cmd.Parameters.AddWithValue("@USDateFormat", BlackBerryServerObject.USDateFormat); cmd.Parameters.AddWithValue("@NotificationGroup", BlackBerryServerObject.NotificationGroup); //cmd.Parameters.AddWithValue("@SNMPCommunity", BlackBerryServerObject.SNMPCommunity); //cmd.Parameters.AddWithValue("@HAOption", BlackBerryServerObject.HAOption); //cmd.Parameters.AddWithValue("@HAPartner", BlackBerryServerObject.HAPartner); updateBlackBerryServer = objAdaptor.ExecuteNonQuerywithcmd(cmd); } } catch (Exception e) { throw e; } return(updateBlackBerryServer); }