/// <summary>
/// Maps the view stat to data model.
/// </summary>
/// <param name="vm">The vm.</param>
/// <param name="dataModel">The data model.</param>
internal static void MapViewStatToDataModel(HalErrorDetailViewModel vm, LogDataModel dataModel)
{
MapErrorDetailViewModelToDataModel(vm, dataModel);
dataModel.SqlQuery = HelperClass.CreateUnionQuery(dataModel.SqlQuery);
//dataModel.SqlQuery = HelperClass.ReplaceKey(dataModel.SqlQuery, "FailTs", HelperClass.convertToUKFormat(DateTime.Now.AddMonths(-5).Year, DateTime.Now.AddMonths(-5).Month));
}
//Jildert logging
private void OnRequestFrameData(Notification notification)
{
// add all frame data
LogDataModel logModel = notification.Sender as LogDataModel;
if (logModel != null)
{
logModel.SetValue(LogFrameDataColumns.LeftRaw.ToString(), lastInput1.ToString("f3"));
logModel.SetValue(LogFrameDataColumns.RightRaw.ToString(), lastInput2.ToString("f3"));
logModel.SetValue(LogFrameDataColumns.LeftNormalized.ToString(), lastNormalizedInput1.ToString("f3"));
logModel.SetValue(LogFrameDataColumns.RightNormalized.ToString(), lastNormalizedInput2.ToString("f3"));
logModel.SetValue(LogFrameDataColumns.HandPositionX.ToString(), transform.position.x.ToString("f3"));
logModel.SetValue(LogFrameDataColumns.HandPositionY.ToString(), transform.position.x.ToString("f3"));
logModel.SetValue(LogFrameDataColumns.Pressure.ToString(), squeezePressure.ToString("f3"));
if (holdingObject != null)
{
logModel.SetValue(LogFrameDataColumns.HoldingObjectName.ToString(), holdingObject.name);
logModel.SetValue(LogFrameDataColumns.MinObjectPressure.ToString(), holdingObject.minPressure.ToString("f3"));
logModel.SetValue(LogFrameDataColumns.MaxObjectPressure.ToString(), holdingObject.maxPressure.ToString("f3"));
}
else
{
logModel.SetValue(LogFrameDataColumns.HoldingObjectName.ToString(), "No Object");
logModel.SetValue(LogFrameDataColumns.MinObjectPressure.ToString(), "0");
logModel.SetValue(LogFrameDataColumns.MaxObjectPressure.ToString(), "100");
}
}
}
/// <summary>
/// Populates the connection object.
/// </summary>
/// <param name="dataModel">The data model.</param>
/// <param name="dbConnect">The db connect.</param>
private static void PopulateConnectionObject(LogDataModel dataModel, DBConnect dbConnect)
{
dbConnect.UserId = dataModel.UserId;
dbConnect.Password = dataModel.Password;
dbConnect.Region = dataModel.Region;
dbConnect.SqlQuery = dataModel.SqlQuery;
}
private void button1_Click(object sender, EventArgs e)
{
//sync biometrics data to database.
progressBar1.Maximum = lvw_GLogList.Items.Count;
progressBar1.Visible = true;
LogDataModel.syncData(ref lvw_GLogList, ref progressBar1);
}
private void ReadLog(string fileName, string groupName)
{
var logFileModel = LogFileHelper.ParseLogFile(fileName, groupName);
var readFromTime = Program.ReadFromTimes.FirstOrDefault((KeyValuePair <string, DateTime> group) => group.Key == groupName).Value;
logFileModel.LogLines = logFileModel.LogLines.Where(w => w.LogDateTime > readFromTime).ToList();
if (logFileModel.LogLines.Count() > 0)
{
Program.ReadFromTimes.Remove(groupName);
Program.ReadFromTimes.Add(groupName, logFileModel.LogLines.LastOrDefault().LogDateTime);
ClearCurrentConsoleLine();
OutputToConsole(logFileModel.LogLines);
var loggingToon = Program.GetLoggingToon(logFileModel.Logger);
var request = new LogDataModel()
{
LoggerName = loggingToon.Name,
CorporationId = loggingToon.CorporationId,
AllianceId = loggingToon.AllianceId,
LogLines = logFileModel.LogLines,
Group = groupName
};
Poll(request);
Console.WriteLine(string.Empty);
}
}
public static LogDataModel[] GetLogFileDataFromFileName(string filePath)
{
try
{
string jsonText = File.ReadAllText(filePath.ToString());
jsonText = "[" + jsonText + "]";
var logDataModels = JsonConvert.DeserializeObject <LogDataModel[]>(jsonText).OrderByDescending(date => date.dateTime);
return(logDataModels.ToArray());
}
catch (Exception ex)
{
LogDataModel logDataModel = new LogDataModel();
logDataModel.LogInformation = new LogInformation()
{
LogException = ex.Message.ToString(),
LogRequest = "Request File Found " + filePath,
LogResponse = "Please contact support"
};
LogDataModel[] logDataModels = new LogDataModel[1] {
logDataModel
};
return(logDataModels);
}
}
/// <summary>
/// Gets the edd details.
/// </summary>
/// <param name="logDataModel">The log data model.</param>
public static void GetDetailsPrint(LogDataModel dataModel)
{
DBConnect dbConnect = new DBConnect();
PopulateConnectionObject(dataModel, dbConnect);
DataTable formattedDataTable = null;
if (dataModel.dataSet == null)
{
dataModel.dataSet = new DataSet();
}
if (dataModel.dataSet.Tables["Formatted_POL_BIL_MQ_AUDIT_V"] != null)
{
dataModel.dataSet.Tables.Remove("Formatted_POL_BIL_MQ_AUDIT_V");
}
DataTable dataTable = dbConnect.GetData();
if (dataTable != null)
{
formattedDataTable = FormatEDDMessagePrint(dataTable);
}
if (formattedDataTable != null)
{
dataModel.dataSet.Tables.Add(formattedDataTable);
}
}
public static void GetEddDetails(LogDataModel dataModel)
{
DBConnect dbConnect = new DBConnect();
PopulateConnectionObject(dataModel, dbConnect);
DataTable formattedDataTable = null;
if (dataModel.dataSet == null)
{
dataModel.dataSet = new DataSet();
}
if (dataModel.dataSet.Tables["Formatted_TXAMDET"] != null)
{
dataModel.dataSet.Tables.Remove("Formatted_TXAMDET");
}
DataTable dataTable = dbConnect.GetData();
if (dataTable != null)
{
formattedDataTable = FormatEDDMessage(dataTable);
}
if (formattedDataTable != null)
{
dataModel.dataSet.Tables.Add(formattedDataTable);
}
}
public bool Match(LogDataModel model)
{
if (model is null)
{
throw new ArgumentNullException(nameof(model));
}
return(this.MatchCore(model));
}
public bool Match(SearchFilterNode value, LogDataModel model)
{
if (value is TokenNode node &&
node.Token.GetText().TryToDateTime(out var left) &&
model.Timestamp.TryToDateTime(out var right))
{
return(left <= right);
}
/// <summary>
/// Maps the EDD rating query to data model.
/// </summary>
/// <param name="vm">The vm.</param>
/// <param name="logDataModel">The log data model.</param>
internal static void MapEDDRatingQueryToDataModel(EDDViewModel vm, LogDataModel dataModel)
{
dataModel.SqlQuery = vm.SqlQuery;
dataModel.SqlQuery = HelperClass.ReplaceKey(dataModel.SqlQuery, "Region", dataModel.Region);
dataModel.SqlQuery = HelperClass.ReplaceKey(dataModel.SqlQuery, "LOBCODE", dataModel.LOBCD);
dataModel.SqlQuery = HelperClass.ReplaceKey(dataModel.SqlQuery, "IOCHAR", dataModel.EddKey.Split('-')[1]);
dataModel.SqlQuery = HelperClass.ReplaceKey(dataModel.SqlQuery, "PolarisIds", dataModel.PolarisIds);
}
/// <summary>
/// Maps the login detais to data model.
/// </summary>
/// <param name="vm">The vm.</param>
/// <param name="dataModel">The data model.</param>
internal static void MapLoginDetaisToDataModel(LoginDetailsViewModel vm, LogDataModel dataModel)
{
dataModel.UserId = vm.UserId;
dataModel.Password = vm.Password;
dataModel.Region = vm.LoginRegion;
dataModel.SqlQuery = vm.LoginQuery;
dataModel.SqlQuery = HelperClass.ReplaceKey(dataModel.SqlQuery, "Region", dataModel.Region);
}
private void Poll(LogDataModel request)
{
while (Program.HubConnection.State != ConnectionState.Connected)
{
Program.StartSignalR();
}
Program.HubProxy.Invoke <LogDataModel>("reportIntel", request);
}
private void OnRequestGameData(Notification notification)
{
LogDataModel logModel = notification.Sender as LogDataModel;
if (logModel != null)
{
logModel.SetValue(LogGameDataColumn.CurrentFrame.ToString(), Time.frameCount.ToString());
}
}
/// <summary>
/// Maps the EDD polaris I ds to data model.
/// </summary>
/// <param name="eDDViewModel">The e DD view model.</param>
/// <param name="logDataModel">The log data model.</param>
internal static void MapEDDPolarisIDsToDataModel(EDDViewModel vm, LogDataModel dataModel)
{
string polarisIds = string.Empty;
if (vm.PolarisIds != null && vm.PolarisIds.Count > 0)
{
vm.PolarisIds.ForEach(x => polarisIds += "'" + x + "',");
dataModel.PolarisIds = polarisIds.Substring(0, polarisIds.Length - 1);
}
}
protected override bool MatchCore(LogDataModel model)
{
int count = this.Nodes.Count;
bool result = false;
for (int i = 0; i < count; ++i)
{
result ^= this.Nodes[i].Match(model);
}
return(result);
}
protected override bool MatchCore(LogDataModel model)
{
string text = this.Token.GetText();
return(model.Timestamp.Contains(text) ||
model.Level.Contains(text) ||
model.OriginalMessage.Contains(text) ||
model.TransformedMessage.Contains(text) ||
model.Method.Contains(text) ||
model.FilePath.Contains(text));
}
protected override bool MatchCore(LogDataModel model)
{
if (this.Key is TokenNode node)
{
return(SearchFilterRegistry.Get(node.Token.GetText())?.Match(this.Value, model) ?? false);
}
else
{
return(false);
}
}
public void StopLog()
{
if (!loggingEnabled)
{
return;
}
frameFile.Close();
// stop current logger
loggingEnabled = false;
frameDataLogModel = null;
}
/*
* public void LogGameData(Item item) {
* Hashtable table = new Hashtable();
* table["item"] = item;
* gameDataLogModel.LogValues(EventRequestGameData, table);
* }
*/
public void StartLog()
{
string path = GetPath();
// Setup data models for the logger
frameFile = new LogWriter(path + "framedata.txt");
gameFile = new LogWriter(path + "gamedata.txt");
frameDataLogModel = new LogDataModel(frameFile, Enum.GetNames(typeof(LogFrameDataColumns)));
gameDataLogModel = new LogDataModel(gameFile, Enum.GetNames(typeof(LogGameDataColumn)));
// set logging file to enabled
loggingEnabled = true;
}
protected override bool MatchCore(LogDataModel model)
{
int count = this.Nodes.Count;
for (int i = 0; i < count; ++i)
{
if (this.Nodes[i].Match(model))
{
return(true);
}
}
return(false);
}
protected override bool MatchCore(LogDataModel model)
{
int count = this.Nodes.Count;
double match = 0;
for (int i = 0; i < count; ++i)
{
if (this.Nodes[i].Match(model))
{
++match;
}
}
return((match / count) >= 0.5D);
}
} = 0; //итератор сессии логирования для гарантии уникального Id лог-записи в БД
internal override object CreateLogEntry(LogData logData, object outputPattern)
{
LogDataModel model = new LogDataModel();
if (logData.exception != null)
{
model.exception = new LogDataModel.ExceptionInfo();
}
foreach (var action in outputPattern as List <Action <LogData, LogDataModel> > )
{
action.Invoke(logData, model);
}
model._id = GenerateLogEntryID(logData);
return(model);
}
public static void LogEntry(LogDataModel logDataModel)
{
LogInit();
using (StreamWriter sw = File.AppendText(filePath))
{
try
{
logDataModel.userID = CustomHttpContextInterceptor.Current.User.Claims.FirstOrDefault(x => x.Type == JwtConstant.UserIdText).Value;
}
catch (Exception ex)
{
logDataModel.userID = "Not Found";
}
sw.WriteLine(JsonConvert.SerializeObject(logDataModel) + ",");
}
}
private string GetGroupName(LogDataModel request)
{
var group = new Group();
if (_databaseContext.GroupMemberships.Any(w => w.EntityTypeId == (int)EntityType.Corporation && w.EntityId == request.CorporationId))
{
group.Id = _databaseContext.GroupMemberships.First(w => w.EntityTypeId == (int)EntityType.Corporation &&
w.EntityId == request.CorporationId).GroupId;
}
else if (request.AllianceId.HasValue && _databaseContext.GroupMemberships.Any(w => w.EntityTypeId == (int)EntityType.Alliance && w.EntityId == request.AllianceId))
{
group.Id = _databaseContext.GroupMemberships.First(w => w.EntityTypeId == (int)EntityType.Alliance &&
w.EntityId == request.AllianceId).GroupId;
}
group = _databaseContext.Groups.First(w => w.Id == group.Id && !w.Disabled);
return(group.Name);
}
/// <summary>
/// Maps the EDD initial data to data model.
/// </summary>
/// <param name="vm">The vm.</param>
/// <param name="dataModel">The data model.</param>
internal static void MapEDDInitialDataToDataModel(EDDViewModel vm, LogDataModel dataModel)
{
dataModel.Region = vm.ExceedRegion.CurrentRegion;
dataModel.SqlQuery = vm.SqlQuery;
dataModel.SqlQuery = HelperClass.ReplaceKey(dataModel.SqlQuery, "Region", dataModel.Region);
if (!string.IsNullOrEmpty(vm.PolicyNumber))
{
dataModel.PolicyNumber = vm.PolicyNumber;
dataModel.SqlQuery = HelperClass.ReplaceKey(dataModel.SqlQuery, "PolicyNbr", dataModel.PolicyNumber);
}
if (!string.IsNullOrEmpty(vm.PolicyID))
{
dataModel.PolicyId = vm.PolicyID;
dataModel.SqlQuery = HelperClass.ReplaceKey(dataModel.SqlQuery, "PolicyId", dataModel.PolicyId);
}
}
public List <LogDataModel> Get_Log_Data()
{
string logLen = ConfigurationManager.AppSettings.Get("LogLength");
List <LogDataModel> lst = new List <LogDataModel>();
SqlCommand cmd = new SqlCommand();
SqlDataReader rdr = default(SqlDataReader);
SqlConnection conn = new SqlConnection(STRATIXDataConnString);
using (conn)
{
conn.Open();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select top " + logLen + " * from Log order by LogID desc";
cmd.Connection = conn;
rdr = cmd.ExecuteReader();
using (rdr)
{
while (rdr.Read())
{
LogDataModel r = new LogDataModel();
r.rptID = Convert.ToInt32(rdr["LogID"]);
r.dt = Convert.ToDateTime(rdr["LogDate"]);
r.typ = (string)rdr["Typ"];
r.app = (string)rdr["AppName"];
r.msg = (string)rdr["Msg"];
r.src = (string)rdr["Src"];
r.stk = (string)rdr["StkTrc"];
r.trgt = (string)rdr["Trgt"];
lst.Add(r);
}
}
}
return(lst);
}
/// <summary>
/// Gets the error details.
/// </summary>
/// <param name="dataModel">The data model.</param>
public static void GetErrorDetails(LogDataModel dataModel)
{
DBConnect dbConnect = new DBConnect();
PopulateConnectionObject(dataModel, dbConnect);
if (dataModel.dataSet == null)
{
dataModel.dataSet = new DataSet();
}
if (dataModel.dataSet.Tables["HAL_ERR_LOG_DTL"] != null)
{
dataModel.dataSet.Tables.Remove("HAL_ERR_LOG_DTL");
}
DataTable dataTable = dbConnect.GetData();
if (dataTable != null)
{
dataModel.dataSet.Tables.Add(dataTable);
}
}
/// <summary>
/// Verifies the login.
/// </summary>
/// <param name="dataModel">The data model.</param>
/// <returns></returns>
public static bool VerifyLogin(LogDataModel dataModel)
{
DBConnect dbConnect = new DBConnect();
PopulateConnectionObject(dataModel, dbConnect);
if (dataModel.dataSet == null)
{
dataModel.dataSet = new DataSet();
}
DataTable dataTable = dbConnect.GetData();
if (dataTable == null)
{
return(false);
}
else
{
return(true);
}
}
/// <summary>
/// Gets the LOB cd.
/// </summary>
/// <param name="dataModel">The data model.</param>
public static void GetPolicyTabDetails(LogDataModel dataModel)
{
DBConnect dbConnect = new DBConnect();
PopulateConnectionObject(dataModel, dbConnect);
if (dataModel.dataSet == null)
{
dataModel.dataSet = new DataSet();
}
if (dataModel.dataSet.Tables["POLICY_TAB"] != null)
{
dataModel.dataSet.Tables.Remove("POLICY_TAB");
}
DataTable dataTable = dbConnect.GetData();
if (dataTable != null)
{
dataModel.dataSet.Tables.Add(dataTable);
}
}
