Example #1
0
 public IQueryable <Branches> GetBranchesViaID(int ID)
 {
     ctx = new TaskManagerDBEntities();
     return(ctx.Branches.Where(i => i.id == ID));
 }
Example #2
0
 public IQueryable <Branches> GetBranchesViaName(string name)
 {
     ctx = new TaskManagerDBEntities();
     return(ctx.Branches.Where(i => i.branchname.Equals(name)));
 }
Example #3
0
 public IQueryable <Tasks> GetTaskViaExecutorID(int ID)
 {
     ctx = new TaskManagerDBEntities();
     return(ctx.Tasks.Where(i => i.executor_id == ID));
 }
Example #4
0
 public IQueryable <Branches> GetAllBranches()
 {
     ctx = new TaskManagerDBEntities();
     return(ctx.Branches);
 }
Example #5
0
 public IQueryable <Tasks> GetTaskViaID(DateTime end)
 {
     ctx = new TaskManagerDBEntities();
     return(ctx.Tasks.Where(i => i.date_end == end));
 }
Example #6
0
 public IQueryable <Tasks> GetTaskViaStatus(string s)
 {
     ctx = new TaskManagerDBEntities();
     return(ctx.Tasks.Where(i => i.status.Equals(s)));
 }
Example #7
0
 public IQueryable <Tasks> GetTaskViaName(string name)
 {
     ctx = new TaskManagerDBEntities();
     return(ctx.Tasks.Where(i => i.taskname.Equals(name)));
 }
Example #8
0
 public IQueryable <Tasks> GetTaskViaBeginTime(DateTime begin)
 {
     ctx = new TaskManagerDBEntities();
     return(ctx.Tasks.Where(i => i.date_begin == begin));
 }
Example #9
0
 public IQueryable <Users> GetUserViaName(string name)
 {
     ctx = new TaskManagerDBEntities();
     return(ctx.Users.Where(i => i.username.Equals(name)).Select(e => e));
 }
Example #10
0
 public IQueryable <Users> GetUserViaPassword(string pass)
 {
     ctx = new TaskManagerDBEntities();
     return(ctx.Users.Where(i => i.password.Equals(pass)).Select(e => e));
 }
Example #11
0
 public IQueryable <Users> GetUserViaID(int ID)
 {
     ctx = new TaskManagerDBEntities();
     return(ctx.Users.Where(i => i.id == ID));
 }
Example #12
0
 public IQueryable <Tasks> GetAllTasks()
 {
     ctx = new TaskManagerDBEntities();
     return(ctx.Tasks);
 }
Example #13
0
 public IQueryable <Branches> GetBranchesViaBeginTime(DateTime begin)
 {
     ctx = new TaskManagerDBEntities();
     return(ctx.Branches.Where(i => i.created_date == begin));
 }
Example #14
0
 public IQueryable <Users> GetAllUsers()
 {
     ctx = new TaskManagerDBEntities();
     return(ctx.Users);
 }
Example #15
0
 public IQueryable <Branches> GetBranchesViaDesc(string name)
 {
     ctx = new TaskManagerDBEntities();
     return(ctx.Branches.Where(i => i.description.Equals(name)));
 }