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