public DashboardsController(TeamProjectContext context, UserManager <ApplicationUser> userManager,
IUserService userService)
{
_context = context;
_userManager = userManager;
_userService = userService;
}
protected override WorkItem GetEntity(TeamProjectContext entityContext, int id)
{
var query = (from e in entityContext.WorkItemSet
where e.WorkItemId == id
select e);
return(query.FirstOrDefault());
}
public ProductsController(TeamProjectContext context, UserManager <ApplicationUser> userManager,
IUserService userService, ILogger <ProductsController> log)
{
_context = context;
_userManager = userManager;
_userService = userService;
_logger = log;
}
public void TestSimpleQuery()
{
TeamProjectContext teamProject = new TeamProjectContext(new System.Uri("https://nkdagility.visualstudio.com"), "vsts-sync-migration");
WorkItemStoreContext sourceStore = new WorkItemStoreContext(teamProject, WorkItemStoreFlags.BypassRules);
TfsQueryContext tfsqc = new TfsQueryContext(sourceStore);
tfsqc.AddParameter("TeamProject", teamProject.Name);
tfsqc.Query = string.Format(@"SELECT [System.Id], [System.Tags] FROM WorkItems WHERE [System.TeamProject] = @TeamProject {0} ORDER BY [System.ChangedDate] desc", "");
WorkItemCollection sourceWIS = tfsqc.Execute();
}
public int Count(int projectId, StatusEnum selectedStatus)
{
using (TeamProjectContext entityContext = new TeamProjectContext())
{
var query = (from e in entityContext.WorkItemSet
where (e.ProjectId == projectId && e.Status == (int)selectedStatus)
select e);
return(query.Count());
}
}
public AuthenticateController(UserManager <ApplicationUser> userManager, TeamProjectContext context,
RoleManager <IdentityRole> roleManager, IConfiguration configuration, IMailer mailer,
IUserService userService, ILogger <AuthenticateController> log)
{
_userManager = userManager;
_context = context;
_roleManager = roleManager;
_configuration = configuration;
_mailer = mailer;
_userService = userService;
_logger = log;
}
public JsonResult LoginControl(string name, string password)
{
TeamProjectContext db = new TeamProjectContext();
var sorgu = from U in db.UserLogins where U.UserName == name & U.Password == password select U;
var User1 = sorgu.FirstOrDefault();
if (User != null)
{
Session["id"] = User1.UserID;
return(Json(User1.UserID));
}
return(Json(false));
}
public SubCategoryTypesController(TeamProjectContext context, ILogger <ProductsController> log)
{
_context = context;
_logger = log;
}
public ShoppingItemsController(TeamProjectContext context)
{
_context = context;
}
protected override IEnumerable <WorkItem> GetEntities(TeamProjectContext entityContext)
{
return((from e in entityContext.WorkItemSet select e).ToArray());
}
protected override WorkItem UpdateEntity(TeamProjectContext entityContext, WorkItem entity)
{
return((from e in entityContext.WorkItemSet
where e.WorkItemId == entity.WorkItemId
select e).FirstOrDefault());
}
protected override WorkItem AddEntity(TeamProjectContext entityContext, WorkItem entity)
{
return(entityContext.WorkItemSet.Add(entity));
}
public CategoriesController(TeamProjectContext context, ILogger <CategoriesController> log)
{
_context = context;
_logger = log;
}
public AttributesController(TeamProjectContext context, ILogger <AttributesController> log)
{
_context = context;
_logger = log;
}
public ProductAttributesController(TeamProjectContext context)
{
_context = context;
}
