private string CalcAlertPosition(AlertInstance alert)
{
var sb = new StringBuilder();
var step = 60;
var alertNumber = _alerts.IndexOf(alert) + 1;
if (Top.HasValue)
{
var top = Top.Value;
top += (alertNumber - 1) * step;
sb.Append($"top: {top}px;");
}
else if (Bottom.HasValue)
{
var bottom = Bottom.Value;
bottom += (alertNumber - 1) * step;
sb.Append($"bottom: {bottom}px;");
}
if (Left.HasValue)
{
sb.Append($"left: {Left.Value}px;");
}
if (Right.HasValue)
{
sb.Append($"right: {Right.Value}px;");
}
return(sb.ToString());
}
public void Add(string text, BootstrapColors color, int dismissTimeSeconds = 5)
{
var newAlert = new AlertInstance(text, color, dismissTimeSeconds);
if (OnAlertAdd != null)
{
OnAlertAdd(newAlert);
}
}
private void OnAlertAdd(AlertInstance alert)
{
_alerts.Add(alert);
this.StateHasChanged();
if (alert.DismissTimeSeconds > 0)
{
alert.OnAlertHide -= OnAlertHide;
alert.OnAlertHide += OnAlertHide;
}
}
private void OnAlertHide(AlertInstance alert)
{
_alerts.Remove(alert);
InvokeAsync(() => { this.StateHasChanged(); });
}
private void OnCloseClick(MouseEventArgs e, AlertInstance alert)
{
_alerts.Remove(alert);
this.StateHasChanged();
}
public string LoadAlert(string AlertID, string SessionID)
{
//don't allow iOS 6 (or any browsers) to cache responses
System.Web.HttpContext.Current.Response.Cache.SetCacheability(HttpCacheability.NoCache);
AlertResult Result = new AlertResult();
Result.Success = false;
//first, validate session
if (!ValidateSession(SessionID))
{
Result.Message = sInvalidSession;
}
else
{
try
{
using (SqlConnection oCN = new SqlConnection(ConfigurationManager.ConnectionStrings["CN_INSIDER"].ConnectionString))
{
oCN.Open();
using (SqlCommand oCMD = new SqlCommand("", oCN))
{
oCMD.CommandText = "SELECT AlertID, DA.Name, DAT.Name As AlertTypeName, DAT.AlertClass As AlertTypeClass, DA.AlertTypeID, Active, SendTo, Frequency, DaysToRun, '' As LastRun, '' As NextRun, ParamJSON"
+ " FROM DataAlerts_Alert DA"
+ " INNER JOIN DataAlerts_AlertType DAT"
+ " ON DAT.AlertTypeID = DA.AlertTypeID"
+ " WHERE AlertID = @AlertID"
+ " ORDER BY AlertID";
oCMD.Parameters.Add("@AlertID", AlertID);
AlertInstance Alert = new AlertInstance();
using (SqlDataReader oDR = oCMD.ExecuteReader())
{
while (oDR.Read())
{
Alert.AlertID = Convert.ToInt32(oDR["AlertID"].ToString());
Alert.Name = oDR["Name"].ToString();
Alert.AlertTypeClass = oDR["AlertTypeClass"].ToString();
Alert.AlertTypeName = oDR["AlertTypeName"].ToString();
Alert.Active = Convert.ToBoolean(oDR["Active"]);
Alert.SendTo = oDR["SendTo"].ToString();
Alert.Frequency = oDR["Frequency"].ToString();
Alert.DaysToRun = oDR["DaysToRun"].ToString();
Alert.LastRun = oDR["LastRun"].ToString();
Alert.NextRun = oDR["NextRun"].ToString();
Alert.ParamJSON = oDR["ParamJSON"].ToString();
}
}
Result.Success = true;
Result.Message = new JavaScriptSerializer().Serialize(Alert);
}
}
}
catch (Exception ex)
{ return(ExHandler(ex)); }
}
return(new JavaScriptSerializer().Serialize(Result));
}
