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);
}
}
