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)); }