// GET api/<controller>/5
public string Get( )
{
using (CourseProjectContext dbContext = new CourseProjectContext())
{
return(JsonConvert.SerializeObject(dbContext.Members.Count()));
}
}
public AccountController(UserManager <User> userManager, SignInManager <User> signInManager,
CourseProjectContext context, ProjectService projectService)
{
_userManager = userManager;
_signInManager = signInManager;
_context = context;
_projectService = projectService;
}
public string Get(int id)
{
using (CourseProjectContext dbContext = new CourseProjectContext())
{
Microsoft.Data.SqlClient.SqlParameter param = new Microsoft.Data.SqlClient.SqlParameter("@id", id);
var events = dbContext.Events.FromSqlRaw("getevents @id", param).ToList();
return(JsonConvert.SerializeObject(events));
}
}
public string Get(int id)
{
using (CourseProjectContext dbContext = new CourseProjectContext())
{
Microsoft.Data.SqlClient.SqlParameter param = new Microsoft.Data.SqlClient.SqlParameter("@id", id);
var events = dbContext.Events.FromSqlRaw("getsignupevents @id", param).ToList();
return(JsonConvert.SerializeObject(events));
}
//return JsonConvert.SerializeObject(dbContext.Set<Users>().Where(b => b.Login.Contains(value)));
}
public void Delete(int id, int id2)
{
using (CourseProjectContext dbContext = new CourseProjectContext())
{
try
{
Microsoft.Data.SqlClient.SqlParameter param = new Microsoft.Data.SqlClient.SqlParameter("@eid", id);
Microsoft.Data.SqlClient.SqlParameter param2 = new Microsoft.Data.SqlClient.SqlParameter("@uid", id2);
dbContext.Events.FromSqlRaw("delmember @eid, @uid", param, param2).ToList();
}
catch (Exception e)
{
}
}
}
public ProjectController(CourseProjectContext context, ProjectService projectService)
{
_context = context;
_projectService = projectService;
}
public ProjectMemberController(CourseProjectContext context)
{
_context = context;
}
public ProjectRepository(CourseProjectContext context)
{
_context = context;
}
public SpecialtyRepository(CourseProjectContext context)
{
_context = context;
}
public SpecialtyUserController(CourseProjectContext context)
{
_context = context;
}
public UserService(CourseProjectContext context)
{
_context = context;
}
public SpecialtyController(SpecialtyService specialtyService, CourseProjectContext context)
{
_specialtyService = specialtyService;
_context = context;
}
public QuizController(CourseProjectContext context)
{
_context = context;
}
//private IMapper _mapper;
public UsersController(CourseProjectContext context, IOptions <AppSettings> appSettings)
{
_context = context;
_appSettings = appSettings.Value;
}
