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