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

                    if (entity == null)
                    {
                        return(Request.CreateResponse(HttpStatusCode.NotFound, "Employee with id =" + id.ToString() + "not found"));
                    }
                    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 Put(int id, [FromBody] Employee employee)
        {
            try
            {
                using (WEBAPIEntities entities = new WEBAPIEntities())
                {
                    var entity = entities.Employees.FirstOrDefault(e => e.ID == id);

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

                        entities.SaveChanges();
                        return(Request.CreateResponse(HttpStatusCode.OK, entity));
                    }
                }
            }
            catch (Exception ex)
            {
                return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
            }
        }
示例#3
0
 public static bool Login(string username, string password)
 {
     using (WEBAPIEntities entities = new WEBAPIEntities())
     {
         return(entities.Users.Any(user => user.Username.Equals(username,
                                                                StringComparison.OrdinalIgnoreCase) && user.Password == password));
     }
 }
示例#4
0
        public HttpResponseMessage Get(int id)
        {
            using (WEBAPIEntities entities = new WEBAPIEntities())
            {
                var entity = entities.Employees.FirstOrDefault(e => e.ID == id);

                if (entity != null)
                {
                    return(Request.CreateResponse(HttpStatusCode.OK, entity));
                }
                else
                {
                    return(Request.CreateResponse(HttpStatusCode.NotFound, "Employee with id =" + id.ToString() + "not found"));
                }
            }
        }
示例#5
0
        public HttpResponseMessage Post([FromBody] Employee employee)
        {
            try
            {
                using (WEBAPIEntities entities = new WEBAPIEntities())
                {
                    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));
            }
        }
示例#6
0
        public HttpResponseMessage Get(string gender = "All")
        {
            string username = Thread.CurrentPrincipal.Identity.Name;

            using (WEBAPIEntities entities = new WEBAPIEntities())
            {
                switch (username.ToLower())
                {
                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));
                }
            }
        }