示例#1
0
        public HttpResponseMessage Delete(int id)
        {
            try
            {
                using (APIDemoEmployeeDBEntities entities = new APIDemoEmployeeDBEntities())
                {
                    var entity = entities.Employees.FirstOrDefault(e => e.ID == id);

                    if (entity == null)
                    {
                        return(Request.CreateErrorResponse(HttpStatusCode.NotFound, $"Employee with id {id} was not found DH "));
                    }
                    else
                    {
                        entities.Employees.Remove(entity);
                        entities.SaveChanges();
                        return(Request.CreateResponse(HttpStatusCode.OK));
                    }
                }
            }
            catch (Exception ex)
            {
                return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, $"{ex}"));
            }
        }
示例#2
0
        public HttpResponseMessage Get(string gender = "all")
        {
            string username = Thread.CurrentPrincipal.Identity.Name;

            using (APIDemoEmployeeDBEntities entities = new APIDemoEmployeeDBEntities())
            {
                switch (username.ToLower())
                {
                case "all":
                    return(Request.CreateResponse(HttpStatusCode.OK,
                                                  entities.Employees.ToList()));

                case "male":
                    return(Request.CreateResponse(HttpStatusCode.OK,
                                                  entities.Employees.Where(e => e.Gender.ToLower() == "male").ToList()));

                case "female":
                    return(Request.CreateResponse(HttpStatusCode.OK,
                                                  entities.Employees.Where(e => e.Gender.ToLower() == "female").ToList()));

                default:
                    return(Request.CreateResponse(HttpStatusCode.BadRequest));
                }
            }
        }
示例#3
0
        public HttpResponseMessage Put(int id, [FromBody] Employee employee)
        {
            try
            {
                using (APIDemoEmployeeDBEntities entities = new APIDemoEmployeeDBEntities())
                {
                    var entity = entities.Employees.FirstOrDefault(e => e.ID == id);

                    if (entity == null)
                    {
                        return(Request.CreateErrorResponse(HttpStatusCode.NotFound, $"Employee with id {id} not found "));
                    }
                    else
                    {
                        entity.FirstName = employee.FirstName;
                        entity.LastName  = employee.LastName;
                        entity.Salary    = employee.Salary;
                        entity.Gender    = employee.Gender;

                        entities.SaveChanges();

                        return(Request.CreateResponse(HttpStatusCode.OK, entity));
                    }
                }
            }
            catch (Exception ex)
            {
                return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, $"{ex}"));
            }
        }
示例#4
0
 public static bool Login(string username, string password)
 {
     using (APIDemoEmployeeDBEntities entities = new APIDemoEmployeeDBEntities())
     {
         return(entities.Users.Any(user => user.Username.Equals(username,
                                                                StringComparison.OrdinalIgnoreCase) && user.Password == password));
     }
 }
示例#5
0
 public HttpResponseMessage Get(int id)
 {
     using (APIDemoEmployeeDBEntities entities = new APIDemoEmployeeDBEntities())
     {
         var entity = entities.Employees.FirstOrDefault(e => e.ID == id);
         if (entity != null)
         {
             return(Request.CreateResponse(HttpStatusCode.OK, entity));
         }
         else
         {
             return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Employee with id = " + id.ToString() + " not found"));
         }
     }
 }
示例#6
0
 public HttpResponseMessage Post([FromBody] Employee employee)
 {
     try
     {
         using (APIDemoEmployeeDBEntities entities = new APIDemoEmployeeDBEntities())
         {
             entities.Employees.Add(employee);
             entities.SaveChanges();
         }
         var message = Request.CreateResponse(HttpStatusCode.Created, employee);
         message.Headers.Location = new Uri(Request.RequestUri + employee.ID.ToString());
         return(message);
     }
     catch (Exception ex)
     {
         return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
     }
 }