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