public void GetAgencyEventStats()
{
List <EventStat> list = new List <EventStat>();
int recordCount;
list.AddRange(EventStat.GetAgencyEventStats(5, out recordCount));
Assert.IsTrue(recordCount > 20);
Assert.AreEqual(list.Count, 10);
}
private void statsGrid_MouseDoubleClick(object sender, MouseButtonEventArgs e)
{
DataGridRow row = DataGridUtil.GetDataGridRow(e.OriginalSource) as DataGridRow;
if (row != null && row.Item is EventStat)
{
EventStat statItem = (EventStat)row.Item;
if (this.Model.EventStatSelectedCommand.CanExecute(null))
{
this.Model.EventStatSelectedCommand.Execute(statItem);
}
}
}
public ActionResult Dashboard(int page = 1, int pageSize = 10)
{
int totalRecords;
PagedItemsModel model = new PagedItemsModel();
//TODO: Create composite to handle both agencies and applicants
model.Items = EventStat.GetAgencyEventStats(Convert.ToInt32(Session["AgencyID"]), out totalRecords, page, pageSize);
model.TotalRows = totalRecords;
model.PageSize = pageSize;
if (Request.IsAjaxRequest())
{
;
}
//TODO: Create partial
return(View(model));
}
public ActionResult Dashboard(int id, int page = 1, int pageSize = 10)
{
if (User.IsInRole("AgencyAdmin") && id != Convert.ToInt32(Session["AgencyID"]))
{
throw new HttpException(401, Resources.UnauthorizedAccessMessage);
}
int totalRecords;
PagedItemsModel model = new PagedItemsModel();
//TODO: Create composite to handle both agencies and applicants
model.Items = EventStat.GetAgencyEventStats(id, out totalRecords, page, pageSize);
model.TotalRows = totalRecords;
model.PageSize = pageSize;
if (Request.IsAjaxRequest())
{
;
}
//TODO: Create partial
return(View(model));
}
private List <PQDS.MetaDataTag> PQDSMetaData(Event evt, Meter meter)
{
List <PQDS.MetaDataTag> result = new List <PQDS.MetaDataTag>();
result.Add(new PQDS.MetaDataTag <string>("DeviceName", meter.Name));
result.Add(new PQDS.MetaDataTag <string>("DeviceAlias", meter.ShortName));
result.Add(new PQDS.MetaDataTag <string>("DeviceLocation", meter.Location.Name));
result.Add(new PQDS.MetaDataTag <string>("DeviceLocationAlias", meter.Location.ShortName));
result.Add(new PQDS.MetaDataTag <string>("Latitude", Convert.ToString(meter.Location.Latitude)));
result.Add(new PQDS.MetaDataTag <string>("Longitude", Convert.ToString(meter.Location.Longitude)));
Asset asset;
double systemFrequency;
using (AdoDataConnection connection = new AdoDataConnection("dbOpenXDA"))
{
asset = (new TableOperations <Asset>(connection)).QueryRecordWhere("ID = {0}", evt.AssetID);
systemFrequency = connection.ExecuteScalar <double?>("SELECT Value FROM Setting WHERE Name = 'SystemFrequency'") ?? 60.0;
if (asset != null)
{
result.Add(new PQDS.MetaDataTag <double>("NominalVoltage-LG", asset.VoltageKV));
result.Add(new PQDS.MetaDataTag <double>("NominalFrequency", systemFrequency));
result.Add(new PQDS.MetaDataTag <string>("AssetName", asset.AssetKey));
if (asset.AssetTypeID == connection.ExecuteScalar <int>("SELECT ID FROM AssetType WHERE Name = 'Line'"))
{
result.Add(new PQDS.MetaDataTag <double>("LineLength", connection.ExecuteScalar <double>("SELECT Length FROM LineView WHERE ID = {0}", asset.ID)));
}
}
result.Add(new PQDS.MetaDataTag <string>("EventID", evt.Name));
result.Add(new PQDS.MetaDataTag <string>("EventGUID", Guid.NewGuid().ToString()));
result.Add(new PQDS.MetaDataTag <double>("EventDuration", (evt.EndTime - evt.StartTime).TotalMilliseconds));
result.Add(new PQDS.MetaDataTag <int>("EventTypeCode", PQDSEventTypeCode(evt.EventTypeID)));
EventStat stat = (new TableOperations <EventStat>(connection)).QueryRecordWhere("EventID = {0}", evt.ID);
if (stat != null)
{
if (stat.VAMax != null)
{
result.Add(new PQDS.MetaDataTag <double>("EventMaxVA", (double)stat.VAMax));
}
if (stat.VBMax != null)
{
result.Add(new PQDS.MetaDataTag <double>("EventMaxVB", (double)stat.VBMax));
}
if (stat.VCMax != null)
{
result.Add(new PQDS.MetaDataTag <double>("EventMaxVC", (double)stat.VCMax));
}
if (stat.VAMin != null)
{
result.Add(new PQDS.MetaDataTag <double>("EventMinVA", (double)stat.VAMin));
}
if (stat.VBMin != null)
{
result.Add(new PQDS.MetaDataTag <double>("EventMinVB", (double)stat.VBMin));
}
if (stat.VCMin != null)
{
result.Add(new PQDS.MetaDataTag <double>("EventMinVC", (double)stat.VCMin));
}
if (stat.IAMax != null)
{
result.Add(new PQDS.MetaDataTag <double>("EventMaxIA", (double)stat.IAMax));
}
if (stat.IBMax != null)
{
result.Add(new PQDS.MetaDataTag <double>("EventMaxIB", (double)stat.IBMax));
}
if (stat.ICMax != null)
{
result.Add(new PQDS.MetaDataTag <double>("EventMaxIC", (double)stat.ICMax));
}
}
result.Add(new PQDS.MetaDataTag <int>("EventYear", ((DateTime)evt.StartTime).Year));
result.Add(new PQDS.MetaDataTag <int>("EventMonth", (evt.StartTime).Month));
result.Add(new PQDS.MetaDataTag <int>("EventDay", (evt.StartTime).Day));
result.Add(new PQDS.MetaDataTag <int>("EventHour", (evt.StartTime).Hour));
result.Add(new PQDS.MetaDataTag <int>("EventMinute", (evt.StartTime).Minute));
result.Add(new PQDS.MetaDataTag <int>("EventSecond", (evt.StartTime).Second));
result.Add(new PQDS.MetaDataTag <int>("EventNanoSecond", Get_nanoseconds(evt.StartTime)));
String date = String.Format("{0:D2}/{1:D2}/{2:D4}", (evt.StartTime).Month, (evt.StartTime).Day, (evt.StartTime).Year);
String time = String.Format("{0:D2}:{1:D2}:{2:D2}", (evt.StartTime).Hour, (evt.StartTime).Minute, (evt.StartTime).Second);
result.Add(new PQDS.MetaDataTag <string>("EventDate", date));
result.Add(new PQDS.MetaDataTag <string>("EventTime", time));
}
return(result);
}
