public bool InsertMSSettings(MSServerSettings msobj)
{
bool result = false; string sql = "";
try
{
DataTable dt = getdata(msobj.ServerID);
if (dt.Rows.Count > 0)
{
sql = "Update MSServerSettings set ScanInterval=" + msobj.ScanInterval + ",CredentialsID=" + msobj.CredentialsID + ",Enabled='" + msobj.Enabled + "',RetryInterval=" + msobj.RetryInterval +
",ResponseThreshold=" + msobj.ResponseThreshold + ",OffscanInterval=" + msobj.OffscanInterval + ",FailuresbfrAlert=" + msobj.FailuresbfrAlert + ",DiskSpace=" + msobj.DiskSpace +
" , CpuUtilization=" + msobj.CpuUtilization + ",NetwrkConn='" + msobj.NetwrkConn + "',MemoryUsageAlert=" + msobj.MemoryUsageAlert + ",IpAddress='" + msobj.IpAddresss +
"' where ServerID=" + msobj.ServerID + "";
}
else
{
sql = "Insert into MSServerSettings (ServerID,ScanInterval,CredentialsID,Enabled,RetryInterval,ResponseThreshold,OffscanInterval,FailuresbfrAlert,DiskSpace," +
"CpuUtilization,NetwrkConn,MemoryUsageAlert,IpAddress) values(" + msobj.ServerID + "," + msobj.ScanInterval + "," + msobj.CredentialsID + ",'" + msobj.Enabled + "'," + msobj.RetryInterval +
"," + msobj.ResponseThreshold + "," + msobj.OffscanInterval + "," + msobj.FailuresbfrAlert + "," + msobj.DiskSpace +
" , " + msobj.CpuUtilization + ",'" + msobj.NetwrkConn + "'," + msobj.MemoryUsageAlert + ",'" + msobj.IpAddresss + "')";
}
result = objAdaptor.ExecuteNonQuery(sql);
}
catch (Exception)
{
throw;
}
return(result);
}
public bool InsertMSSettings(MSServerSettings msobj)
{
try
{
return(VSWebDAL.ConfiguratorDAL.MSServerDAL.Ins.InsertMSSettings(msobj));
}
catch (Exception ex)
{
throw ex;
}
}
