public void AddTrack(TrackIP data)
{
var timeId = DateTime.Now.ToUnixTimeMiliseconds();
data.TimeId = timeId;
if (!string.IsNullOrEmpty(data.Referer))
{
Uri myUri = new Uri(data.Referer);
data.Host = myUri.Host == null?"":myUri.Host;
}
using (var cnn = _connectionFactory.GetConnection)
{
string sql = "msp_UI_TrackIP";
data.Host = data.Host == null ? "" : data.Host;
SqlMapper.Execute(cnn, sql, new { data.TimeId, data.IpAddress, data.PageId, data.Link, data.Os, data.IsMobile, data.Referer, data.Host, data.SourceId, data.Params, data.IsFacebookAds, data.IsGoogleAds, TrackDate = DateTime.Now }, commandType: CommandType.StoredProcedure);
}
}
public void AddIpInfo(TrackIP tr)
{
var moreInfo = new LocationService().GetInfoByIp(tr.IpAddress);
int infoStatus = 2;
if (moreInfo.Code == System.Net.HttpStatusCode.OK)
{
var data = (Entities.Integration.LocationIPResponse)moreInfo.Data;
data.Ip = tr.IpAddress;
data.Os = data.Os;
data.IsMobile = data.IsMobile;
using (var cnn = _connectionFactory.GetConnection)
{
string sql = "msp_UI_UserInfo";
SqlMapper.Execute(cnn, sql, new { IpAddress = data.Ip, City = data.city, Country = data.country_name, Isp = data.organisation, Lat = 0, Lon = 0, RegionName = data.region, Os = data.Os }, commandType: CommandType.StoredProcedure);
}
infoStatus = 1;
}
using (var cnn = _connectionFactory.GetConnection)
{
string sql = "msp_UI_TrackIP_InfoStatus";
SqlMapper.Execute(cnn, sql, new { IpAddress = tr.IpAddress, InfoStatus = infoStatus }, commandType: CommandType.StoredProcedure);
}
}
