public async Task <ServiceActionResult <TaskModel> > CreateTask(TaskModel model)
{
using (var db = new ThingsToDo.DAL.ThingsToDoAppContext())
{
var entity = new Tasks
{
Title = model.Title,
Description = model.Description,
FromDate = Convert.ToDateTime(model.FromDate),
ToDate = Convert.ToDateTime(model.ToDate),
CategoryId = model.CategoryId,
Priority = model.Priority,
};
db.Tasks.Add(entity);
var result = await db.SaveChangesAsync();
if (result > 0)
{
model.isFinished = false;
return(new ServiceActionResult <TaskModel>(model, ServiceActionStatus.Created));
}
else
{
return(new ServiceActionResult <TaskModel>(model, ServiceActionStatus.Error, Resources.ThingsToDo.Global_InternalServerError));
}
}
}
public async Task <bool> DeleteTask(jQueryDataTableParamModel param)
{
using (var db = new ThingsToDo.DAL.ThingsToDoAppContext())
{
var entity = await db.Tasks.Where(x => x.Id == param.DT_RowId).FirstOrDefaultAsync();
if (entity != null)
{
db.Tasks.Remove(entity);
}
var result = await db.SaveChangesAsync();
return(result > 0 ? true : false);
}
}
protected void Application_Start()
{
System.Data.Entity.Database.SetInitializer(new DropCreateDatabaseIfModelChanges <ThingsToDoAppContext>());
using (var context = new ThingsToDo.DAL.ThingsToDoAppContext())
{
context.Database.Initialize(force: true);
}
AreaRegistration.RegisterAllAreas();
FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters);
RouteConfig.RegisterRoutes(RouteTable.Routes);
BundleConfig.RegisterBundles(BundleTable.Bundles);
var container = SimpleInjectorBindings.GetContainer();
// This is an extension method from the integration package.
container.RegisterMvcControllers(Assembly.GetExecutingAssembly());
container.Verify();
DependencyResolver.SetResolver(new SimpleInjectorDependencyResolver(container));
}
public async Task <bool> Update(int Id, string column, string value)
{
using (var db = new ThingsToDo.DAL.ThingsToDoAppContext())
{
var task = await db.Tasks.Where(x => x.Id == Id && !x.FinishedDate.HasValue).FirstOrDefaultAsync();
if (column == Resources.ThingsToDo.lblTitle)
{
task.Title = value;
}
else if (column == Resources.ThingsToDo.lblDescription)
{
task.Description = value;
}
else
{
task.ToDate = Convert.ToDateTime(value);
}
var result = await db.SaveChangesAsync();
return(result > 0 ? true : false);
}
}
