public UserStore(MakeItContext db) { if (db == null) { throw new ArgumentNullException("db"); } this.db = db; }
/// <summary> /// Disposes all external resources. /// </summary> /// <param name="disposing">The dispose indicator.</param> private void Dispose(bool disposing) { if (disposing) { if (_dbContext != null) { _dbContext.Dispose(); _dbContext = null; } } }
public void OnException(ExceptionContext filterContext) { var exceptionDetail = new ExceptionDetail() { ExceptionMessage = filterContext.Exception.Message, StackTrace = filterContext.Exception.StackTrace, ControllerName = filterContext.RouteData.Values["controller"].ToString(), ActionName = filterContext.RouteData.Values["action"].ToString(), Date = DateTime.Now }; using (var db = new MakeItContext()) { db.ExceptionDetails.Add(exceptionDetail); db.SaveChanges(); } filterContext.ExceptionHandled = true; }
public override void OnActionExecuting(ActionExecutingContext filterContext) { var request = filterContext.HttpContext.Request; Visitor visitor = new Visitor() { Login = (request.IsAuthenticated) ? filterContext.HttpContext.User.Identity.Name : "null", Ip = request.ServerVariables["HTTP_X_FORWARDED_FOR"] ?? request.UserHostAddress, Url = request.RawUrl, Date = DateTime.UtcNow }; using (var db = new MakeItContext()) { db.Visitors.Add(visitor); db.SaveChanges(); } base.OnActionExecuting(filterContext); }
public async Task <JsonResult> TaskListViewData(int draw, int start, int length) { var userId = User.Identity.GetUserId <int>(); // get the search string var searchString = Request.QueryString["search[value]"]; var recordsTotal = await _taskService.GetRecordsTotalAsync(); //var recordsFiltered = await _taskService.GetRecordsFilteredAsync(searchString); // to create with use stored procedure // analogy to // GetPagedSortedFilteredListAsync(start, length, orderColumnName, orderDirection, searchString) var listTasks = new List <GetTaskSelectedPage_sp_Result>(); using (var db = new MakeItContext()) { listTasks = db.Database.SqlQuery <GetTaskSelectedPage_sp_Result>("GetTaskSelectedPage_sp @SearchValue, @PageNo, @PageSize, @SortColumn, @SortOrder, @AssignedUserId", new SqlParameter("@SearchValue", searchString), new SqlParameter("@PageNo", start), new SqlParameter("@PageSize", length), new SqlParameter("@SortColumn", "Id"), new SqlParameter("@SortOrder", "Asc"), new SqlParameter("@AssignedUserId", userId)).ToList(); } var recordsFiltered = listTasks.Any()? listTasks[0].RecordsTotal ?? 0 : 0; var response = new DataTablesResponse <GetTaskSelectedPage_sp_Result>() { draw = draw, recordsTotal = recordsTotal, recordsFiltered = recordsFiltered, data = listTasks }; // serialize response object to json string var jsonResponse = Json(response, JsonRequestBehavior.AllowGet); return(jsonResponse); }
public UserStore(MakeItContext db) : base(db) { }
public RoleStore(MakeItContext context) : base(context) { }
public RoleStore(MakeItContext db) { this.db = db; }