public int Register(string username, string password, string mail) { try { using (var db = new CoordinationDbContext()) { Model.User existingUser = db.Users.FirstOrDefault(user => user.Username == username); if (existingUser == null) { Model.User user = new Model.User(); user.Username = username; user.Password = password; user.Email = mail; db.Users.Add(user); db.SaveChanges(); } else { return(-1); } return(0); } } catch (Exception ex) { return(-2); } }
public ServiceJob GetJobByID(int ID) { using (var db = new CoordinationDbContext()) { Model.Job job = db.Jobs.FirstOrDefault(jb => jb.ID == ID); return(ConvertJob(job)); /*if (job != null) * { * * }*/ } }
public ServiceUser GetUserByID(int ID) { using (var db = new CoordinationDbContext()) { Model.User user = db.Users.FirstOrDefault(usr => usr.ID == ID); return(ConvertUser(user)); /*if (user != null) * { * * }*/ } }
public ServiceUser[] GetUsers() { using (var db = new CoordinationDbContext()) { List <ServiceUser> serviceUsers = new List <ServiceUser>(); List <Model.User> users = db.Users.Where(user => user.Latitude != null && user.Longitude != null).ToList(); foreach (Model.User user in users) { serviceUsers.Add(ConvertUser(user)); } return(serviceUsers.ToArray()); } }
public int JobAssignmentStatus(int jobID, int userID) { using (var db = new CoordinationDbContext()) { Model.JobAssignment jobAssignment = db.JobAssignments.FirstOrDefault((ja => ja.Job.ID == jobID && ja.User.ID == userID)); //na kanei jobID && userID && approved==1 tote show complete button(return 1) if (jobAssignment != null) { return(jobAssignment.Approved ? 1 : 0); } return(-1); //Model.JobAssignment user = db.JobAssignments.FirstOrDefault(usr => usr.ID == userID); // ama approved ==0 tote einai pending (return 0) alliws den to vrike kai whow assign button } }
public int JobComplete(int jobID) { using (var db = new CoordinationDbContext()) { Model.Job job = db.Jobs.FirstOrDefault(jb => jb.ID == jobID); if (job != null) { job.Completed = true; db.Entry(job).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); return(0); } return(1); } }
public int JobCancel(int jobID, int userID) { using (var db = new CoordinationDbContext()) { //Write the UserID and jobID on the db Coordination.Model.JobAssignment assignment = (db.JobAssignments.FirstOrDefault(jb => jb.Job.ID == jobID && jb.User.ID == userID)); db.JobAssignments.Remove(assignment); db.SaveChanges(); return(0); //Steile ston Android User oti tin pire } }
public int Login(string username, string password) { using (var dbContext = new CoordinationDbContext()) { var foundUsers = dbContext.Users.Where(user => user.Username == username && user.Password == password); if (foundUsers.Count() == 1) { Model.User foundUser = foundUsers.FirstOrDefault(); return(foundUser.ID); } } return(-1); }
public ServiceJob[] GetJobs() { using (var db = new CoordinationDbContext()) { List <ServiceJob> serviceJobs = new List <ServiceJob>(); List <Model.Job> jobs = db.Jobs.Where(job => job.Completed == false).ToList(); foreach (Model.Job job in jobs) { ServiceJob servicejob = ConvertJob(job); //servicejob.assigned = job.Assigned == true; TODO:get from jobAssignments and request current user as parameter serviceJobs.Add(servicejob); } return(serviceJobs.ToArray()); } }
public int SendLastKnownLocation(String latitude, String longitude, String ID) { string latitude_ = latitude; string longitude_ = longitude; int ID_ = int.Parse(ID); using (var db = new CoordinationDbContext()) { Model.User user = db.Users.FirstOrDefault(usr => usr.ID == ID_); if (user == null) { return(-1); } user.Latitude = latitude_; user.Longitude = longitude_; db.Entry(user).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); return(0); } }
public int JobAssign(int jobID, int userID) { using (var db = new CoordinationDbContext()) { //Write the UserID and jobID on the db Model.Job job = db.Jobs.FirstOrDefault(jb => jb.ID == jobID); Model.User user = db.Users.FirstOrDefault(usr => usr.ID == userID); if (job != null && user != null) { //user.Jobs.Add(job); Coordination.Model.JobAssignment assignment = new Coordination.Model.JobAssignment(); assignment.Job = job; assignment.User = user; db.JobAssignments.Add(assignment); db.SaveChanges(); return(0); } //Steile ston Android User oti tin pire return(1); } }