public List <Bridge.ResultObject> EventlogObjectForRig(Bridge.EventType eventType, Bridge.FilterParameters filterParameters)
{
List <Bridge.ResultObject> result = new List <Bridge.ResultObject>();
//DateTime.Now.ToString("MMMM", CultureInfo.InvariantCulture);
switch (filterParameters.WithGrouping)
{
case Bridge.FilterParameters.GroupByOperator.Month:
var data = m_LmsContext.DbEventLog.GroupBy(p => p.EventLogTime.Month).ToList();
string qry = "P_EventCountByMonth @start";
SqlParameter[] sqls = new SqlParameter[]
{
new SqlParameter {
ParameterName = "@start", Value = DateTime.Now.AddDays(-2000), Direction = System.Data.ParameterDirection.Input
}
};
List <MonthReply> replys = m_LmsContext.Database.SqlQuery <MonthReply>(qry, sqls).ToList();
foreach (MonthReply reply in replys)
{
result.Add(new Bridge.ResultObject {
myValue = reply.Quantity, Text = reply.Month.ToString("MMMM")
});
}
break;
default:
break;
}
return(result);
}
public List <Bridge.ResultObject> EventlogObjectForRig(Bridge.EventType eventType, FilterParameters filterParameters)
{
ReportDaoManager daoManager = new ReportDaoManager();
List <Bridge.ResultObject> result = daoManager.EventlogObjectForRig(eventType, filterParameters);
return(result);
}
public Dictionary <DateTime, int> EventLogForRig(Bridge.EventType eventType, FilterParameters filterParameters)
{
ReportDaoManager daoManager = new ReportDaoManager();
Dictionary <DateTime, int> result = daoManager.GetEventLogByEvent(eventType, filterParameters);
Console.WriteLine($"Accessing EventLogforRig: {result.Count.ToString()} records returned.");
Console.WriteLine($"FilterParams: startDate ={filterParameters.StartDate} stopDate={filterParameters.StopDate} groupby={filterParameters.WithGrouping.ToString()}");
return(result);
}
public bool SaveEventType(Bridge.EventType eventType)
{
m_LmsContext.DbEventType.Add(
new EventType
{
EventTypeDescription = eventType.EventTypeDescription,
EventTypeSubId = eventType.EventTypeSubId,
});
int p = m_LmsContext.SaveChanges();
return(p > 0);
}
public List <SimpleResultObject> EventLogDummy(Bridge.EventType eventType, FilterParameters filterParameters)
{
var lstModel = new List <SimpleResultObject>();
Random rnd = new Random();
lstModel.Add(new SimpleResultObject
{
text = "Technology",
myValue = rnd.Next(10)
});
lstModel.Add(new SimpleResultObject
{
text = "Sales",
myValue = rnd.Next(10)
});
lstModel.Add(new SimpleResultObject
{
text = "Marketing",
myValue = rnd.Next(10)
});
lstModel.Add(new SimpleResultObject
{
text = "Human Resource",
myValue = rnd.Next(10)
});
lstModel.Add(new SimpleResultObject
{
text = "Research and Development",
myValue = rnd.Next(10)
});
lstModel.Add(new SimpleResultObject
{
text = "Acconting",
myValue = rnd.Next(10)
});
lstModel.Add(new SimpleResultObject
{
text = "Support",
myValue = rnd.Next(10)
});
lstModel.Add(new SimpleResultObject
{
text = "Logistics",
myValue = rnd.Next(10)
});
return(lstModel);
}
public Dictionary <DateTime, int> GetEventLogByEvent(Bridge.EventType eventType, Bridge.FilterParameters filterParamteters)
{
Dictionary <DateTime, int> result = new Dictionary <DateTime, int>();
switch (filterParamteters.WithGrouping)
{
case Bridge.FilterParameters.GroupByOperator.Date:
var data = m_LmsContext.DbEventLog
.Where(p => p.EventTypeId.Equals(eventType.EventTypeId))
.Where(u => u.EventLogTime >= filterParamteters.StartDate && u.EventLogTime <= filterParamteters.StopDate)
.ToList()
.OrderBy(c => c.EventLogTime)
.GroupBy(o => o.EventLogTime.Date)
.ToList();
foreach (var v in data)
{
result.Add(v.Select(p => p.EventLogTime).First(), v.Select(p => p.EventLogTime).Count());
}
break;
case Bridge.FilterParameters.GroupByOperator.Day:
var data2 = m_LmsContext.DbEventLog
.Where(p => p.EventTypeId.Equals(eventType.EventTypeId))
.Where(u => u.EventLogTime >= filterParamteters.StartDate && u.EventLogTime <= filterParamteters.StopDate)
.ToList()
.GroupBy(o => o.EventLogTime.Day)
.ToList();
foreach (var v in data2)
{
result.Add(v.Select(p => p.EventLogTime).First(), v.Select(p => p.EventLogTime).Count());
}
break;
case Bridge.FilterParameters.GroupByOperator.Month:
var data3 = m_LmsContext.DbEventLog
.Where(p => p.EventTypeId.Equals(eventType.EventTypeId))
.Where(u => u.EventLogTime >= filterParamteters.StartDate && u.EventLogTime <= filterParamteters.StopDate)
.ToList()
.GroupBy(o => o.EventLogTime.Month)
.ToList();
foreach (var v in data3)
{
result.Add(v.Select(p => p.EventLogTime).First(), v.Select(p => p.EventLogTime).Count());
}
break;
case Bridge.FilterParameters.GroupByOperator.Year:
var data4 = m_LmsContext.DbEventLog
.Where(p => p.EventTypeId.Equals(eventType.EventTypeId))
.Where(u => u.EventLogTime >= filterParamteters.StartDate && u.EventLogTime <= filterParamteters.StopDate)
.ToList()
.GroupBy(o => o.EventLogTime.Year)
.ToList();
foreach (var v in data4)
{
result.Add(v.Select(p => p.EventLogTime).First(), v.Select(p => p.EventLogTime).Count());
}
break;
case Bridge.FilterParameters.GroupByOperator.Week:
break;
}
return(result);
}
public bool SaveEventType(Bridge.EventType eventType)
{
return(new ReportDaoManager().SaveEventType(eventType));
}
