예제 #1
0
 public void TestMethod1() {
     using (MinerContext db = new MinerContext()) {
         var emps = db.Employees;
         Array.ForEach<Employee>(emps.ToArray<Employee>(), x => {
             Trace.WriteLine(x.Email);
         });
     }
 }
예제 #2
0
파일: Repo.cs 프로젝트: engiacad/spde.edu
 public HttpResponseMessage EmployeeOfId(int id){
     if (id > 0) {
         using (MinerContext db = new MinerContext()) {
             var emp = db.Employees.Where(x => x.Id == id).FirstOrDefault();
             if (emp == null) {
                 return Request.CreateErrorResponse(HttpStatusCode.BadRequest, new ArgumentException("employee requested could not be found"));
             }
             emp.SkillStatus = EmpSkillStatus(emp);
             return Request.CreateResponse(HttpStatusCode.OK, Negotiator.Employee(emp));
         }
     }
     else {
         return Request.CreateErrorResponse(HttpStatusCode.BadRequest, new ArgumentException("the id of the employee to be found cannot be negative or zero"));
     }
 }
예제 #3
0
파일: Repo.cs 프로젝트: engiacad/spde.edu
        /// <summary>
        /// this gets the manager for the email, returns http failure message when the manager is not found
        /// </summary>
        /// <param name="email">email of the manager being sought</param>
        /// <returns>httpreponsemessage</returns>
        public HttpResponseMessage GetManagerOfEmail(string email) {
            if (!String.IsNullOrEmpty(email)) {
                using (MinerContext db = new MinerContext()) {

                    var manager = db.Managers.Where(x => x.Email.ToLower() == email.ToLower()).FirstOrDefault();
                    if (manager == null) {
                        //this is when though the employee is present he / she is not the manager
                        return Request.CreateErrorResponse(HttpStatusCode.BadRequest, new ArgumentException("manager of the email not registered"));
                    }
                    return Request.CreateResponse<Object>(HttpStatusCode.OK, Negotiator.Manager(manager));
                }
            }
            else {
                //send the error response from here
                return Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Invalid");
            }
        }
예제 #4
0
파일: Repo.cs 프로젝트: engiacad/spde.edu
        /// <summary>
        /// this function takes in the employee object and returns the skill completion status
        /// </summary>
        /// <param name="emp">employee for which the status is to be procured</param>
        /// <returns>skill completion status</returns>
        private int EmpSkillStatus(Employee emp) {
            if (emp != null) {
                using (MinerContext db = new MinerContext()) {
                    //getting the employee in the context again
                    var inStore = db.Employees.Where(x => x.Id == emp.Id).FirstOrDefault();

                    int total = inStore.Maps.Count;
                    if (inStore != null && total != 0) {
                        int complete = inStore.Maps.Where(x => x.Level.Level != 0).Count();
                        double denom = (complete * 100) / total;
                        return (int)Math.Round(denom);
                    }
                    else {
                        return 0;
                    }
                }
            }
            else {
                return 0;
            }
        }
예제 #5
0
파일: Repo.cs 프로젝트: engiacad/spde.edu
 public HttpResponseMessage GetSkillLevels() {
     using (MinerContext db = new MinerContext()) {
         return Request.CreateResponse(HttpStatusCode.OK, Negotiator.SkillLevels(db.SkillLevels.ToArray<SkillLevel>()));
     }
 }
예제 #6
0
파일: Repo.cs 프로젝트: engiacad/spde.edu
 public HttpResponseMessage DeleteMaps(JsonMap[] maps) {
     if (maps==null) {
         return Request.CreateErrorResponse(HttpStatusCode.BadRequest, new ArgumentException("maps to remove cannot be null"));
     }
     using (MinerContext db = new MinerContext()) {
         Array.ForEach(maps, m => {
             var skillmap = db.Maps.Where(x => x.Id == m.id).FirstOrDefault();
             if (skillmap!=null) {
                 db.Maps.Remove(skillmap);
                 db.SaveChanges();
             }
         });
         return Request.CreateResponse(HttpStatusCode.NoContent);
     }
 }
예제 #7
0
파일: Repo.cs 프로젝트: engiacad/spde.edu
 public HttpResponseMessage AddMaps(JsonMap[] maps) {
     if (maps == null) {
         return Request.CreateErrorResponse(HttpStatusCode.BadRequest, new ArgumentException("maps to be altered cannot be null"));
     }
     using (MinerContext db = new MinerContext()) {
         bool hasFlag = false;
         Array.ForEach(maps, m => {
             var emp = db.Employees.Where(e => e.Id == m.emp.id).FirstOrDefault();
             var skill = db.Skills.Where(s => s.Id == m.skill.id).FirstOrDefault();
             var explevel = db.ExpLevels.Where(xp => xp.Id == m.exp.id).FirstOrDefault();
             var level = db.SkillLevels.Where(l => l.Level == m.level.id).FirstOrDefault();
             if (emp != null && skill != null && explevel != null && level !=null) {
                 //this is the condition when the map is ok to be added to the database
                 db.Maps.Add(new SkillMap() {
                     Employee= emp,
                     ExpLevel = explevel,
                     Level = level,
                     Skill = skill
                 });
                 db.SaveChanges();
             }
             else {
                 hasFlag = true;//this is to denote that there was some error when saving one of the maps to the database
             }
         });
         return Request.CreateResponse(HttpStatusCode.Created);
     }
 }
예제 #8
0
파일: Repo.cs 프로젝트: engiacad/spde.edu
 public HttpResponseMessage AlterMaps(JsonMap[] maps) {
     if (maps == null) {
         return Request.CreateErrorResponse(HttpStatusCode.BadRequest, new ArgumentException("maps to be altered cannot be null"));
     }
     using (MinerContext db = new MinerContext()) {
         Array.ForEach(maps, m => {
             var skillmap = db.Maps.Where(x => x.Id == m.id).FirstOrDefault();
             if (skillmap != null) {
                 var lvl = db.SkillLevels.Where(l => l.Level == m.level.id).FirstOrDefault();
                 var explvl = db.ExpLevels.Where(e => e.Id == m.exp.id).FirstOrDefault();
                 skillmap.Level = lvl != null ? lvl : skillmap.Level;//assigning only if the new level is found else restoring the same
                 skillmap.ExpLevel = explvl != null ? explvl : skillmap.ExpLevel;
                 //assigning the exp level if the new exp level is found else restoring
                 db.SaveChanges();//persisting the records to the database
             }
         });
         return Request.CreateResponse(HttpStatusCode.NoContent);
     }
 }
예제 #9
0
파일: Repo.cs 프로젝트: engiacad/spde.edu
 /// <summary>
 /// this is the helper function that would take the negotiated json content and emit the same object with hydrated complex object foreign keys
 /// </summary>
 /// <param name="maps">neogitiated json content</param>
 /// <returns></returns>
 private JsonMap[] HydrateComplexFks(JsonMap[] maps) {
     List<JsonMap> result = new List<JsonMap>();//this is the result preparation
     if (maps == null || maps.Count() == 0) {
         return new JsonMap[] { };//error condition
     }
     using (MinerContext db = new MinerContext()) {
         Array.ForEach(maps, m => {
             var inContext = db.Maps.Where(x => x.Id == m.id).FirstOrDefault();
             m.emp = Negotiator.Employee(inContext.Employee);//hydrating the employee for the map
             m.skill = Negotiator.Skill(inContext.Skill);//hydrating the skill object for the map
             m.level = Negotiator.SkillLevel(inContext.Level);//hydrating the skill level object for the map
             m.exp = Negotiator.ExpLevel(inContext.ExpLevel);//hydrating the exp level in the map
             result.Add(m);
         });
     }
     return result.ToArray<JsonMap>();//sending back the object
 }
예제 #10
0
파일: Repo.cs 프로젝트: engiacad/spde.edu
 /// <summary>
 /// gets the likely employees with the given phrase to search
 /// </summary>
 /// <param name="like">search phrase that we would be looking for</param>
 /// <returns></returns>
 public HttpResponseMessage Likely(string like) {
     if (!String.IsNullOrEmpty(like)) {
         int numResult = default(int);
         bool isNumeric = Int32.TryParse(like, out numResult);
         if (isNumeric == false) {
             string search = like.ToLower();
             //case when the parameter is ok
             using (MinerContext db = new MinerContext()) {
                 var emps = db.Employees.Where(x => x.Alias.ToLower().Contains(search) || x.Email.Contains(search));
                 Array.ForEach(emps.ToArray<Employee>(), e => {
                     //filling out all the skill status
                     e.SkillStatus = EmpSkillStatus(e);
                 });
                 return Request.CreateResponse(HttpStatusCode.OK, Negotiator.Employees(emps.ToArray<Employee>()));
             }
         }
         else {
             //this is thecase when we are trying to get employee by the emp no
             using (MinerContext db = new MinerContext()) {
                 var emp = db.Employees.Where(x => x.Id == numResult);//this is the single employee by default
                 return Request.CreateResponse(HttpStatusCode.OK, Negotiator.Employees(emp.ToArray<Employee>()));
             }
         }
     }
     return this.Top(10);//so if the search phrase is null we sent back the top employees
 }
예제 #11
0
파일: Repo.cs 프로젝트: engiacad/spde.edu
 public HttpResponseMessage GetTopSkills(int value) {
     if (value > 0) {
         using (MinerContext db = new MinerContext()) {
             var skills = db.Skills.OrderBy(x => x.Id).Take(value);
             return Request.CreateResponse(HttpStatusCode.OK, Negotiator.Skills(skills.ToArray<Skill>()));
         }
     }
     else {
         return Request.CreateErrorResponse(HttpStatusCode.BadRequest, new ArgumentException("cannot get negative number fo top results"));
     }
 }
예제 #12
0
파일: Repo.cs 프로젝트: engiacad/spde.edu
 /// <summary>
 /// gets the likely skills from the set of skills we have
 /// </summary>
 /// <param name="like">search phrase for the likely skills</param>
 /// <returns></returns>
 public HttpResponseMessage GetLikelySkills(string like) {
     if (!string.IsNullOrEmpty(like)) {
         using (MinerContext db = new MinerContext()) {
             var skills = db.Skills.Where(x => x.Title.ToLower().Contains(like.ToLower()) || x.Group.Title.ToLower().Contains(like.ToLower()) || x.Group.Genre.Title.ToLower().Contains(like.ToLower()));
             return Request.CreateResponse(HttpStatusCode.OK, Negotiator.Skills(skills.ToArray<Skill>()));
         }
     }
     else {
         return Request.CreateErrorResponse(HttpStatusCode.BadRequest, new ArgumentException("the search phrase cannot be empty"));//rather this should be replaced with top ten resulst from the skills
         //it is unlikely it woul ever reach here since the the paramter is declared as non optional
     }
 }
예제 #13
0
파일: Repo.cs 프로젝트: engiacad/spde.edu
 public HttpResponseMessage DropReportees(int id, Employee[] reportees) {
     if (id > 0 && reportees != null) {
         using (MinerContext db = new MinerContext()) {
             var manager = db.Managers.Where(m => m.Id == id).FirstOrDefault();
             if (manager == null) {
                 return Request.CreateErrorResponse(HttpStatusCode.BadRequest, new ArgumentException(String.Format(
                     "the manager of the id:{0} not found", id)));
             }
             Array.ForEach(reportees, r => {
                 manager.Reportees.Remove(db.Employees.Where(e => e.Id == r.Id).FirstOrDefault());
                 db.SaveChanges();//this will ensure we are persisting the changes to the database
             });
             return Request.CreateResponse(HttpStatusCode.NoContent);
         }
     }
     else {
         return Request.CreateErrorResponse(HttpStatusCode.BadRequest, new ArgumentException("either the manager id is invalid or the reportees are null"));
     }
 }
예제 #14
0
파일: Repo.cs 프로젝트: engiacad/spde.edu
        public HttpResponseMessage AddReporteesOf(int id, Employee[] reportees) {
            if (id > 0 && reportees != null) {
                using (MinerContext db = new MinerContext()) {
                    Array.ForEach(reportees, x => {
                        Employee emp = db.Employees.Where(e => e.Id == x.Id).FirstOrDefault();
                        emp.Manager = db.Managers.Where(m => m.Id == id).FirstOrDefault();
                        db.SaveChanges();//saves the new manager for the employee
                    });

                    return Request.CreateResponse(HttpStatusCode.NoContent);
                }
            }
            else {
                return Request.CreateErrorResponse(HttpStatusCode.BadRequest, new ArgumentException("either the manager id is invalid or the reportees are null"));
            }
        }
예제 #15
0
파일: Repo.cs 프로젝트: engiacad/spde.edu
 public HttpResponseMessage GetReporteesOf(int id) {
     if (id > 0) {
         using (MinerContext db = new MinerContext()) {
             var manager = db.Managers.Where(x => x.Id == id).FirstOrDefault();
             if (manager == null) {
                 return Request.CreateErrorResponse(HttpStatusCode.BadRequest, new ArgumentException(string.Format(
                     "manager of the id:{0} not found"
                     )));
             }
             //here we continue getting the reportees of the manager
             var reportees = manager.Reportees;
             Array.ForEach(reportees.ToArray<Employee>(), e => {
                 //filling out all the skill status
                 e.SkillStatus = EmpSkillStatus(e);
             });
             return Request.CreateResponse(HttpStatusCode.OK, Negotiator.Employees(reportees.ToArray<Employee>()));
         }
     }
     else {
         //this is the case of the invalid id
         return Request.CreateErrorResponse(HttpStatusCode.BadRequest, new ArgumentException("the id of the manager cannot be zero or less than"));
     }
 }
예제 #16
0
파일: Repo.cs 프로젝트: engiacad/spde.edu
 /// <summary>
 /// this methd return the top employees when arraned ascending with their employee numbers
 /// </summary>
 /// <param name="value">number of top employees to be returned</param>
 /// <returns>httpresponse message</returns>
 public HttpResponseMessage Top(int value) {
     if (value > 0) {
         using (MinerContext db = new MinerContext()) {
             var emps = db.Employees.OrderBy(x => x.Id).Take(value);
             Array.ForEach(emps.ToArray<Employee>(), e => {
                 //filling out all the skill status
                 e.SkillStatus = EmpSkillStatus(e);
             });
             //returns from the repository - everything is ok
             return Request.CreateResponse(HttpStatusCode.OK, Negotiator.Employees(emps.ToList<Employee>()));
         }
     }
     else {
         return Request.CreateErrorResponse(HttpStatusCode.BadRequest, new ArgumentException("the number of top entries requested expected to be greater than zero"));
     }
 }
예제 #17
0
파일: Repo.cs 프로젝트: engiacad/spde.edu
 public HttpResponseMessage MapsOfEmployee(int id) {
     if (id > 0) {
         using (MinerContext db = new MinerContext()) {
             var emp = db.Employees.Where(x => x.Id == id).FirstOrDefault();
             if (emp == null) {
                 return Request.CreateErrorResponse(HttpStatusCode.BadRequest, new ArgumentException(String.Format("employee of the id {0} could not be foudn", id)));
             }
             var maps = emp.Maps;
             JsonMap[] jsonMaps = HydrateComplexFks(Negotiator.Maps(maps.ToArray<SkillMap>()));
             return Request.CreateResponse(HttpStatusCode.OK, jsonMaps);
         }
     }
     else {
         return Request.CreateErrorResponse(HttpStatusCode.BadRequest, new ArgumentException("maps of the employee with negative id cannot be found"));
     }
 }