public ActionResult ClicksJson(Models.PeriodModel model)
{
using (var db = new Db.TipTraceEntities())
{
return(Json((from item in FillDateGaps(db.StatsClicksPerDay(CurrentClientId, model.StartDate, model.EndDate).ToList(), model.StartDate, model.EndDate) orderby item.Date select new { Year = item.Date.Value.Year, Month = item.Date.Value.Month, Day = item.Date.Value.Day, Count = item.Count })));
}
}
public ActionResult SignUp(Models.SignUpModel model)
{
using (var db = new Db.TipTraceEntities())
{
if (ModelState.IsValid)
{
//double email check
if ((from item in db.Clients where item.Email.Equals(model.Email) select item.Email).Count() > 0)
{
ModelState.AddModelError("", "This email you provided is already known");
}
else
{
//save the client
string ValidateHash = db.SaveClient(1, model.Name, model.Url, model.Email, model.Password).FirstOrDefault();
//send email
string EmailBody = (from setting in db.Settings where setting.Name == "template_email_admin" select setting.Value).FirstOrDefault();
//string EmailBody = "Welcome to tiptrace,<br/><br/>You are almost set up!<br/><br/>Click on the following link to activate your account:<br/>";
EmailBody = EmailBody.Replace("{Link}", string.Format("http://{0}/Account/Validate/{1}", Request.Url.DnsSafeHost, ValidateHash));
//EmailBody += string.Format("http://{0}/Account/Validate/{1}", Request.Url.DnsSafeHost, ValidateHash);
Utility.Email.SendEmail("*****@*****.**", "TipTrace", model.Email, model.Name, "Welcome to TipTrace", EmailBody);
return(RedirectToAction("SignUpFinished"));
}
}
}
return(View(model));
}
public ActionResult Parameters()
{
using (var db = new Db.TipTraceEntities())
{
return(View((from item in db.Settings select item).ToList()));
}
}
public ActionResult Client(Db.Client model)
{
Db.Client client = new Db.Client();
using (var db = new Db.TipTraceEntities())
{
if (ModelState.IsValid)
{
client = (from item in db.Clients where item.ClientId.Equals(model.ClientId) select item).FirstOrDefault();
client.TypeId = model.TypeId;
db.SaveChanges();
var ClientTypeList = (from d in db.ClientTypes
orderby d.Level
select d).ToList();
ViewBag.ClientTypeList = new SelectList(ClientTypeList, "ClientTypeId", "Name", client.TypeId);
ViewData["Message"] = "Saved";
}
}
return(View(client));
}
//
// GET: /Implementation/
public ActionResult Index()
{
using (var db = new Db.TipTraceEntities())
{
ViewBag.ClientHash = (from item in db.Clients where item.ClientId.Equals(CurrentClient.ClientId) select item.Hash).FirstOrDefault();
}
return(View());
}
public ActionResult Parameter(int id)
{
using (var db = new Db.TipTraceEntities())
{
return(View((from item in db.Settings where item.SettingId.Equals(id) select new Models.AdminSettings {
SettingId = item.SettingId, Name = item.Name, Value = item.Value
}).FirstOrDefault()));
}
}
public ActionResult Url(int id)
{
using (var db = new Db.TipTraceEntities())
{
ViewBag.Url = (from item in db.Urls where item.UrlId == id select item).FirstOrDefault();
ViewBag.ViewCount = db.StatsViewsTotal(CurrentClientId, null, null, id).FirstOrDefault();
ViewBag.ShareCount = db.StatsSharesTotal(CurrentClientId, null, null, id).FirstOrDefault();
ViewBag.ClickCount = db.StatsClicksTotal(CurrentClientId, null, null, id).FirstOrDefault();
}
return(View());
}
public ActionResult IndexOutput(Models.PeriodModel model)
{
using (var db = new Db.TipTraceEntities())
{
ViewBag.ViewsTotal = db.StatsViewsTotal(CurrentClientId, model.StartDate, model.EndDate, 0).FirstOrDefault();
ViewBag.SharesTotal = db.StatsSharesTotal(CurrentClientId, model.StartDate, model.EndDate, 0).FirstOrDefault();
ViewBag.ClicksTotal = db.StatsClicksTotal(CurrentClientId, model.StartDate, model.EndDate, 0).FirstOrDefault();
ViewBag.ViewsTop = db.StatsViewsTop(10, CurrentClientId, model.StartDate, model.EndDate).ToList();
ViewBag.SharesTop = db.StatsSharesTop(10, CurrentClientId, model.StartDate, model.EndDate).ToList();
ViewBag.ClicksTop = db.StatsClicksTop(10, CurrentClientId, model.StartDate, model.EndDate).ToList();
}
return(View(model));
}
public ActionResult Manage()
{
using (var db = new Db.TipTraceEntities())
{
Models.PersonalModel client = (from item in db.Clients
where item.ClientId.Equals(CurrentClient.ClientId)
select new Models.PersonalModel
{
ClientId = item.ClientId,
Name = item.Name,
Url = item.WebsiteUrl
}).FirstOrDefault();
return(View(client));
}
}
public ActionResult ClientsOuput(Manage.Models.ClientFilter model)
{
using (var db = new Db.TipTraceEntities())
{
if (string.IsNullOrEmpty(model.Filter))
{
ViewBag.Clients = (from item in db.Clients.Include("ClientType").Include("UrlViews") select item).ToList();
}
else
{
ViewBag.Clients = (from item in db.Clients.Include("ClientType").Include("UrlViews") where item.Name.Contains(model.Filter) select item).ToList();
}
}
return(View(model));
}
public ActionResult Manage(Models.PersonalModel model)
{
using (var db = new Db.TipTraceEntities())
{
if (ModelState.IsValid)
{
Db.Client client = (from item in db.Clients where item.ClientId.Equals(CurrentClient.ClientId) select item).FirstOrDefault();
client.Name = model.Name;
client.WebsiteUrl = model.Url;
db.SaveChanges();
ViewData["Message"] = "Saved";
}
}
return(View(model));
}
public ActionResult Parameter(Models.AdminSettings model)
{
using (var db = new Db.TipTraceEntities())
{
if (ModelState.IsValid)
{
Db.Setting setting = (from item in db.Settings where item.SettingId.Equals(model.SettingId) select item).FirstOrDefault();
setting.Name = model.Name;
setting.Value = model.Value;
db.SaveChanges();
ViewData["Message"] = "Saved";
}
}
return(View(model));
}
public ActionResult Validate(string id)
{
using (var db = new Db.TipTraceEntities())
{
Db.Client client = (from item in db.Clients where item.ValidateHash.Equals(id) select item).FirstOrDefault();
if (client == null)
{
//verkeerde code, niks doen, maar wel melding geven
ViewData["ErrorMessage"] = "Message";
}
else
{
//goede code, updaten
client.IsValidated = true;
client.DateEdited = DateTime.Now;
db.SaveChanges();
}
}
return(View());
}
public ActionResult Client(int id)
{
Db.Client client;
using (var db = new Db.TipTraceEntities())
{
client = (from item in db.Clients.Include("ClientType") where item.ClientId == id select item).FirstOrDefault();
var ClientTypeList = (from d in db.ClientTypes
orderby d.Level
select d).ToList();
ViewBag.ClientTypeList = new SelectList(ClientTypeList, "ClientTypeId", "Name", client.TypeId);
}
if (client == null)
{
return(HttpNotFound());
}
return(View(client));
}
public ActionResult Login(Models.LoginModel model, string returnUrl)
{
using (var db = new Db.TipTraceEntities())
{
if (ModelState.IsValid && Membership.ValidateUser(model.Email, model.Password))
{
if ((from item in db.Clients where item.Email.Equals(model.Email) && item.IsValidated select item).Count() > 0)
{
FormsAuthentication.RedirectFromLoginPage(model.Email, model.RememberMe);
}
else
{
ModelState.AddModelError("", "Your account has not been activated yet; click the link you recieved in your email");
}
}
else
{
ModelState.AddModelError("", "The user name or password provided is incorrect.");
}
}
return(View(model));
}
