public IQueryable <Branches> GetBranchesViaID(int ID)
{
ctx = new TaskManagerDBEntities();
return(ctx.Branches.Where(i => i.id == ID));
}
public IQueryable <Branches> GetBranchesViaName(string name)
{
ctx = new TaskManagerDBEntities();
return(ctx.Branches.Where(i => i.branchname.Equals(name)));
}
public IQueryable <Tasks> GetTaskViaExecutorID(int ID)
{
ctx = new TaskManagerDBEntities();
return(ctx.Tasks.Where(i => i.executor_id == ID));
}
public IQueryable <Branches> GetAllBranches()
{
ctx = new TaskManagerDBEntities();
return(ctx.Branches);
}
public IQueryable <Tasks> GetTaskViaID(DateTime end)
{
ctx = new TaskManagerDBEntities();
return(ctx.Tasks.Where(i => i.date_end == end));
}
public IQueryable <Tasks> GetTaskViaStatus(string s)
{
ctx = new TaskManagerDBEntities();
return(ctx.Tasks.Where(i => i.status.Equals(s)));
}
public IQueryable <Tasks> GetTaskViaName(string name)
{
ctx = new TaskManagerDBEntities();
return(ctx.Tasks.Where(i => i.taskname.Equals(name)));
}
public IQueryable <Tasks> GetTaskViaBeginTime(DateTime begin)
{
ctx = new TaskManagerDBEntities();
return(ctx.Tasks.Where(i => i.date_begin == begin));
}
public IQueryable <Users> GetUserViaName(string name)
{
ctx = new TaskManagerDBEntities();
return(ctx.Users.Where(i => i.username.Equals(name)).Select(e => e));
}
public IQueryable <Users> GetUserViaPassword(string pass)
{
ctx = new TaskManagerDBEntities();
return(ctx.Users.Where(i => i.password.Equals(pass)).Select(e => e));
}
public IQueryable <Users> GetUserViaID(int ID)
{
ctx = new TaskManagerDBEntities();
return(ctx.Users.Where(i => i.id == ID));
}
public IQueryable <Tasks> GetAllTasks()
{
ctx = new TaskManagerDBEntities();
return(ctx.Tasks);
}
public IQueryable <Branches> GetBranchesViaBeginTime(DateTime begin)
{
ctx = new TaskManagerDBEntities();
return(ctx.Branches.Where(i => i.created_date == begin));
}
public IQueryable <Users> GetAllUsers()
{
ctx = new TaskManagerDBEntities();
return(ctx.Users);
}
public IQueryable <Branches> GetBranchesViaDesc(string name)
{
ctx = new TaskManagerDBEntities();
return(ctx.Branches.Where(i => i.description.Equals(name)));
}