public bool DeleteServerThreshold(ServerThresholds srt)
{
try
{
return(VSWebDAL.ConfiguratorDAL.MSServerDAL.Ins.DeleteServerThreshold(srt));
}
catch (Exception ex)
{
throw ex;
}
}
public bool DeleteServerThreshold(ServerThresholds srt)
{
bool result = false;
try
{
string SqlQuery = "Delete from ServerThresholds where ID=" + srt.ID + "";
result = objAdaptor.ExecuteNonQuery(SqlQuery);
}
catch
{
}
finally
{
}
return(result);
}
public bool InsertServerThreshold(ServerThresholds srt)
{
bool result = false;
try
{
string SqlQuery = "insert into ServerThresholds(ServerID,ParameterID,Threshold,Type,ApplyAlert,PSID) " +
" values(" + srt.ServerID + "," + srt.ParameterID + "," + srt.Threshold + ",'" + srt.Type + "','" + srt.ApplyAlert + "'," + srt.PSID + ")";
result = objAdaptor.ExecuteNonQuery(SqlQuery);
}
catch
{
}
finally
{
}
return(result);
}
public bool UpdateServerThreshold(ServerThresholds srt)
{
bool result = false;
try
{
string SqlQuery = "Update ServerThresholds set ServerID=" + srt.ServerID + ",ParameterID=" + srt.ParameterID + ",Threshold=" + srt.Threshold +
",Type='" + srt.Type + "',ApplyAlert='" + srt.ApplyAlert + "',PSID=" + srt.PSID + " where ID=" + srt.ID + "";
result = objAdaptor.ExecuteNonQuery(SqlQuery);
}
catch
{
}
finally
{
}
return(result);
}
