/// <summary>
/// Transforms the object to the database schema object that can be persisted.
/// </summary>
/// <returns>Returns the transformed database schema object.</returns>
public static analytic GetDatabaseModel(AnalyticsModel model)
{
if (model == null)
{
throw new ArgumentNullException("model");
}
analytic record = new analytic();
record.NewUser = model.NewUser;
record.IsAuthenticated = model.IsAuthenticated;
record.AuthenticatedUserId = model.AuthenticatedUserId;
record.SessionId = model.SessionId;
record.BrowserId = model.BrowserId;
record.PageUrl = model.PageUrl;
record.PageTitle = model.PageTitle;
record.ServerTimeStamp = model.ServerTimeStamp.DateTime;
record.cmp_name = model.CampaignName;
record.cmp_ref = model.CampaignReferrer;
record.cmp_source = model.CampaignSource;
record.IPAddress = model.IPAddress;
record.UserAgent = model.UserAgent;
record.DeviceType = model.DeviceType;
record.EventId = model.EventId;
record.EventType = model.EventType;
record.EventInfo = model.EventInfo;
record.FlightId = model.FlightId;
return(record);
}
public ActionResult View(int id)
{
using (rvcaEntities db = new rvcaEntities())
{
analytic item = db.analytics.FirstOrDefault(x => x.id == id);
if (item == null)
{
item = new analytic();
}
return(View("ViewAnalytics", item));
}
}
// GET: AnalyticResults/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
analytic analytic = db.analytics.Find(id);
if (analytic == null)
{
return(HttpNotFound());
}
return(View(analytic));
}
public ActionResult IncrementRedirect(Result result)
{
int count = 0;
bool exists = false;
analytic dbAnalytic = null;
hit dbhit = null;
//Find out if it exists
using (var db = new iTunesSearchEntities())
{
count = db.analytics.Count();
//if the value exists, update
if (db.hits.Any(a => a.url == result.ViewURL))
{
exists = true;
dbAnalytic = db.analytics.Where(a => a.hit.url == result.ViewURL).FirstOrDefault <analytic>();
}
else //otherwise add new hit to database
{
exists = false;
dbhit = new hit
{
trackId = ++count,
url = result.ViewURL,
title = result.TrackName,
artist = result.ArtistName,
artworkurl = result.ArtworkURL100,
};
db.hits.Add(dbhit);
db.SaveChanges();
}
}
//change without DBContext or create
if (exists && dbAnalytic != null)
{
dbAnalytic.hitCount++;
}
else
{
dbAnalytic = new analytic
{
trackId = count,
hitCount = 1,
//hit = dbhit,
};
}
using (var db = new iTunesSearchEntities())
{
if (exists)
{
db.Entry(dbAnalytic).State = System.Data.Entity.EntityState.Modified;
}
else
{
db.analytics.Add(dbAnalytic);
}
db.SaveChanges();
}
return(Redirect(result.ViewURL));
}
