public virtual List <AgendaItem> GetCurrentMonthAgendas()
{
using (var context = new AgendaDbContext())
{
return(context.AgendaItems.Where(x => x.FinishDate.Month == DateTime.UtcNow.Month).ToList());
}
}
public virtual List <AgendaItem> GetSelectedMonthAgendas(int selectedMonth)
{
using (var context = new AgendaDbContext())
{
return(context.AgendaItems.Where(x => x.FinishDate.Month == selectedMonth).ToList());
}
}
public AgendaService(AgendaDbContext context, UserManager <ApplicationUser> userManager, IHttpContextAccessor httpContextAccessor)
{
this.context = context;
var user = httpContextAccessor.HttpContext.User;
userId = userManager.GetUserId(user);
}
public virtual List <AgendaItem> GetAllAgendas()
{
using (var context = new AgendaDbContext())
{
return(context.AgendaItems.ToList());
}
}
public virtual AgendaItem GetAgenda(int id)
{
using (var context = new AgendaDbContext())
{
return(context.AgendaItems.FirstOrDefault(x => x.Id == id));
}
}
public virtual AgendaItem GetNewlyCreatedAgenda()
{
using (var context = new AgendaDbContext())
{
return(context.AgendaItems.OrderByDescending(x => x.Id).FirstOrDefault());
}
}
public AgendaController(AgendaDbContext context, IAgendaService agendaService, ICategoryService categoryService, IItemService itemService, IMapper mapper)
{
this.context = context;
this.agendaService = agendaService;
this.categoryService = categoryService;
this.itemService = itemService;
this.mapper = mapper;
}
public UserRepository(AgendaDbContext dbContext)
{
DbContext = dbContext;
// Configurate the mapper
var config = new MapperConfiguration(cfg => cfg.CreateMap <User, UserDto>());
DbMapper = new Mapper(config);
}
public TaskRepository(AgendaDbContext dbContext)
{
DbContext = dbContext;
// Configurate the mapper
var config = new MapperConfiguration(cfg => cfg.CreateMap <Models.Task, TaskDto>());
DbMapper = new Mapper(config);
}
public CategoryRepository(AgendaDbContext dbContext)
{
DbContext = dbContext;
// Configure the mapper
var config = new MapperConfiguration(cfg => cfg.CreateMap <Category, CategoryDto>());
DbMapper = new Mapper(config);
}
public virtual void CreateAgenda(AgendaItem item)
{
using (var context = new AgendaDbContext())
{
context.AgendaItems.Add(item);
context.SaveChanges();
}
}
public AccountController(AgendaDbContext context, UserManager <ApplicationUser> userManager, SignInManager <ApplicationUser> signInManager, IHttpContextAccessor httpContextAccessor)
{
this.context = context;
this.userManager = userManager;
this.signInManager = signInManager;
var user = httpContextAccessor.HttpContext.User;
userId = userManager.GetUserId(user);
}
public ArchivesController(AgendaDbContext context, IAgendaService agendaService, UserManager <ApplicationUser> userManager, SignInManager <ApplicationUser> signInManager, IMapper mapper, IHttpContextAccessor httpContextAccessor)
{
this.context = context;
this.agendaService = agendaService;
this.userManager = userManager;
this.signInManager = signInManager;
this.mapper = mapper;
var user = httpContextAccessor.HttpContext.User;
userId = userManager.GetUserId(user);
}
public static void SeedHostDb(AgendaDbContext context)
{
context.SuppressAutoSetTenantId = true;
// Host seed
new InitialHostDbBuilder(context).Create();
// Default tenant seed (in host database).
new DefaultTenantBuilder(context).Create();
new TenantRoleAndUserBuilder(context, 1).Create();
}
public List <agenda> ListaCitasDia()
{
using (var db = new AgendaDbContext())
{
string s_fecha = DateTime.Today.ToString("yyyy-mm-dd");
string s_select = "select * from agenda order by fecha, hora;";
List <agenda> s_lista = db.Database.SqlQuery <agenda>(s_select).ToList();
foreach (var elemento in s_lista)
{
elemento.horafecha = Convert.ToDateTime("01/01/0001 " + elemento.hora.ToString(@"hh\:mm\:ss"));
elemento.horastr = elemento.hora.ToString(@"hh\:mm");
}
return(s_lista);
}
}
public virtual AgendaItem ModifyAgendaItem(AgendaItem agendaItem)
{
using (var context = new AgendaDbContext())
{
var item = context.AgendaItems.FirstOrDefault(x => x.Id == agendaItem.Id);
if (item != null)
{
item.Description = agendaItem.Description;
item.Title = agendaItem.Title;
item.FinishDate = agendaItem.FinishDate;
item.Priority = agendaItem.Priority;
item.IsCompleted = agendaItem.IsCompleted;
}
context.SaveChanges();
return(item);
}
}
public EncomendaController(AgendaDbContext agendaDbContext)
{
_agendaDbContext = agendaDbContext;
_dbSet = agendaDbContext.Set <Encomenda>();
}
public DefaultLanguagesCreator(AgendaDbContext context)
{
_context = context;
}
public ContatoRepository(AgendaDbContext context) : base(context)
{
}
public TpDoceController(AgendaDbContext agendaDbContext)
{
_agendaDbContext = agendaDbContext;
_dbSet = agendaDbContext.Set <TpDoce>();
}
public TarefasController(AgendaDbContext dbContext)
{
_dbContext = dbContext;
}
public AppointmentRepository(AgendaDbContext context) : base(context)
{
}
protected Repository(AgendaDbContext db)
{
Db = db;
DbSet = db.Set <TEntidadeBase>();
}
public ClientRepository(AgendaDbContext context) : base(context)
{
}
public DefaultEditionCreator(AgendaDbContext context)
{
_context = context;
}
public ClienteController(AgendaDbContext agendaDbContext)
{
_agendaDbContext = agendaDbContext;
_dbSet = agendaDbContext.Set <Cliente>();
}
public CalendarioRepository(AgendaDbContext context) : base(context)
{
}
public HostRoleAndUserCreator(AgendaDbContext context)
{
_context = context;
}
public ValuesController(AgendaDbContext db)
{
this.db = db;
}
public AcessoController(AgendaDbContext dbContext)
{
_dbContext = dbContext;
}
