public Object dagdetailsdata2(DagSettings ServerObject)
{
Object Update;
try
{
DataTable dt = GetAttributes(ServerObject.ServerID);
if (dt.Rows.Count > 0)
{
string SqlQuery = "UPDATE DagSettings SET ServerID = @ServerID,PrimaryConnection = @PrimaryConnection,BackupConnection = @BackupConnection where ServerID = @ServerID";
SqlCommand cmd = new SqlCommand(SqlQuery);
cmd.Parameters.AddWithValue("@ServerID", (object)ServerObject.ServerID ?? DBNull.Value);
cmd.Parameters.AddWithValue("@PrimaryConnection", (object)ServerObject.PrimaryConnection ?? DBNull.Value);
cmd.Parameters.AddWithValue("@BackupConnection", (object)ServerObject.BackupConnection ?? DBNull.Value);
Update = objAdaptor.ExecuteNonQuerywithcmd(cmd);
//Update = objAdaptor.ExecuteNonQuery(SqlQuery);
}
else
{
Update = InsertAttributesData(ServerObject);
}
}
catch
{
Update = false;
}
finally
{
}
return(Update);
}
public DataTable GetDagSettings(DagSettings Mobj)
{
try
{
return(VSWebDAL.ConfiguratorDAL.DAGDAL.Ins.GetDagSettings(Mobj));
}
catch (Exception ex)
{
throw ex;
}
}
public Object DagsettingsData(DagSettings ServerObject)
{
try
{
return(VSWebDAL.ConfiguratorDAL.DAGDAL.Ins.dagdetailsdata2(ServerObject));
}
catch (Exception ex)
{
throw ex;
}
}
public DataTable GetDagSettings(DagSettings objdag)
{
DataTable MSServersDataTable = new DataTable();
try
{
string SqlQuery = "select dg.ServerID,dg.ReplyQThreshold,dg.CopyQThreshold,(select sr.ServerName +'-'+ l.Location from servers sr inner join Locations l on l.ID=sr.LocationID where sr.ID=dg.PrimaryConnection) as PrimaryConnection,(select sr.ServerName +'-'+ l.Location from servers sr inner join Locations l on l.ID=sr.LocationID where sr.ID=dg.BackupConnection) as BackupConnection from DagSettings dg where ServerID=" + objdag.ServerID + "";
// select (ServerName +'-'+ Location) as Primaryname,dg.PrimaryConnection from servers sr inner join DagSettings dg on dg.PrimaryConnection=sr.ID inner join Locations l on l.ID=sr.LocationID where ServerID=34
//select (ServerName +'-'+ Location) as Backupname,dg.BackupConnection from servers sr inner join DagSettings dg on dg.BackupConnection=sr.ID inner join Locations l on l.ID=sr.LocationID where ServerID=34
MSServersDataTable = objAdaptor.FetchData(SqlQuery);
}
catch (Exception ex)
{
throw ex;
}
finally
{
}
return(MSServersDataTable);
}
public bool InsertAttributesData(DagSettings ServerObject)
{
//WS modified to fetch realistic data for the exchange servers
bool Insert = false;
try
{
string sqlStr = "select st.servertype from servertypes st where st.id=(select srv.servertypeid from servers srv where srv.id=" + ServerObject.ServerID + ")";
DataTable dt = objAdaptor.FetchData(sqlStr);
string ServerType = dt.Rows.Count == 1 ? dt.Rows[0][0].ToString() : "";
if (ServerType == "Exchange")
{
string[] exchgdefaults = new string[17];
string attrname = "";
string attrval = "";
DataTable dtattr = VSWebDAL.SecurityDAL.ServersDAL.Ins.GetServerDetailsBytype2("Exchange");
if (dtattr.Rows.Count > 0)
{
for (int i = 0; i < dtattr.Rows.Count; i++)
{
attrname = dtattr.Rows[i]["PrimaryConnection"].ToString();
attrval = dtattr.Rows[i]["DefaultValue"].ToString();
switch (attrname)
{
case "Scan Interval":
exchgdefaults[0] = attrval;
break;
case "Off Hours Scan Interval":
exchgdefaults[1] = attrval;
break;
case "PrimaryConnection":
exchgdefaults[2] = attrval;
break;
case "BackupConnection":
exchgdefaults[3] = attrval;
break;
default:
string s = attrname;
break;
}
}
string SqlQuery = "INSERT INTO [DagSettings] (ServerID,PrimaryConnection,BackupConnection) " +
" VALUES(@ServerID,@PrimaryConnection,@BackupConnection)";
SqlCommand cmd = new SqlCommand(SqlQuery);
cmd.Parameters.AddWithValue("@ServerID", (object)ServerObject.ServerID ?? DBNull.Value);
cmd.Parameters.AddWithValue("@PrimaryConnection", (object)ServerObject.PrimaryConnection ?? DBNull.Value);
cmd.Parameters.AddWithValue("@BackupConnection", (object)ServerObject.BackupConnection ?? DBNull.Value);
Insert = objAdaptor.ExecuteNonQuerywithcmd(cmd);
//Insert = objAdaptor.ExecuteNonQuery(SqlQuery);
}
}
else
{
string SqlQuery = "INSERT INTO [DagSettings] (ServerID,PrimaryConnection,BackupConnection)" +
"VALUES(@ServerID,@PrimaryConnection,@BackupConnection)";
SqlCommand cmd = new SqlCommand(SqlQuery);
cmd.Parameters.AddWithValue("@ServerID", (object)ServerObject.ServerID ?? DBNull.Value);
cmd.Parameters.AddWithValue("@PrimaryConnection", (object)ServerObject.PrimaryConnection ?? DBNull.Value);
cmd.Parameters.AddWithValue("@BackupConnection", (object)ServerObject.BackupConnection ?? DBNull.Value);
Insert = objAdaptor.ExecuteNonQuerywithcmd(cmd);
// Insert = objAdaptor.ExecuteNonQuery(SqlQuery);
}
}
catch
{
Insert = false;
}
finally
{
}
return(Insert);
}
