public IEnumerable <Models.Employee> GetAllEmployees() { using (var context = new WebAPIDemoDBEntities()) { return(MapFromDAL(context.Employees.ToList())); } }
public IHttpActionResult Get() { using (var context = new WebAPIDemoDBEntities()) { return(Ok(MapFromDAL(context.Employees.ToList()))); } }
// GET api/<controller> public async Task <IHttpActionResult> Get() { using (var context = new WebAPIDemoDBEntities()) { var employees = await context.Employees.ToListAsync(); return(Ok(MapFromDAL(employees))); } }
/// <summary> /// USage: /// Make a post request to /// http://[Server]:[port]/token /// Body type: x-www-form-urlencoded /// Key - Values /// username - [username] /// password - [password] /// grant_type - password /// </summary> /// <param name="context"></param> /// <returns> /// { /// "access_token": [actual token here], /// "token_type": "bearer", /// "expires_in": 1199 /// } /// </returns> public override async Task GrantResourceOwnerCredentials(OAuthGrantResourceOwnerCredentialsContext context) { var identity = new ClaimsIdentity(context.Options.AuthenticationType); //var res = context.OwinContext.Response; //res.Headers.Add("Access-Control-Allow-Origin", new[] { "*" }); //res.Headers.Add("Access-Control-Allow-Methods", new[] { "HEAD", "GET", "POST", "PUT", "PATCH", "DELETE", "OPTIONS" }); //res.Headers.Add("Access-Control-Allow-Headers", new[] { "Origin", "Content-Type", "X-Auth-Token" }); //Models.Employee authenticatedEmployee = new EmployeeService().Authenticate(context.UserName, context.Password); // if (authenticatedEmployee == null) // { // return BadRequest("Username or password is incorrect"); // } using (var db = new WebAPIDemoDBEntities()) { if (db != null) { var empl = db.Employees.ToList(); //var user = db.Users.ToList(); if (empl != null) { if (!string.IsNullOrEmpty(empl.Where(u => u.Username == context.UserName && u.Password == context.Password).FirstOrDefault().Name)) { identity.AddClaim(new Claim("Age", "16")); var props = new AuthenticationProperties(new Dictionary <string, string> { { "userdisplayname", context.UserName }, { "role", "admin" } }); var ticket = new AuthenticationTicket(identity, props); context.Validated(ticket); } else { context.SetError("invalid_grant", "Provided username and password is incorrect"); context.Rejected(); } } } else { context.SetError("invalid_grant", "Provided username and password is incorrect"); context.Rejected(); } return; } }
public IHttpActionResult GetEmployee(int id) { using (var context = new WebAPIDemoDBEntities()) { var employee = context.Employees.ToList().FirstOrDefault((p) => p.Id == id); if (employee == null) { return(NotFound()); } return(Ok(MapFromDAL(employee))); } }
// GET api/<controller>/5 public async Task <IHttpActionResult> Get(int id) { using (var context = new WebAPIDemoDBEntities()) { var employees = await context.Employees.ToListAsync(); var employee = employees.FirstOrDefault((p) => p.Id == id); if (employee == null) { return(NotFound()); } return(Ok(MapFromDAL(employee))); } }
public IHttpActionResult UpdateEmployee(Models.Employee emp) { using (var context = new WebAPIDemoDBEntities()) { var employee = context.Employees.ToList().FirstOrDefault((p) => p.Id == emp.Id); employee = MapToDAL(emp, employee); context.SaveChanges(); //var employee = context.Employees.ToList().FirstOrDefault((p) => p.Id == id); //if (employee == null) //{ // return NotFound(); //} return(Ok(employee)); } }
public override async Task GrantResourceOwnerCredentials(OAuthGrantResourceOwnerCredentialsContext context) { var identity = new ClaimsIdentity(context.Options.AuthenticationType); context.OwinContext.Response.Headers.Add("Access-Control-Allow-Origin", new[] { "*" }); using (var db = new WebAPIDemoDBEntities()) { if (db != null) { var empl = db.Employees.ToList(); //var user = db.Users.ToList(); if (empl != null) { if (!string.IsNullOrEmpty(empl.Where(u => u.Username == context.UserName && u.Password == context.Password).FirstOrDefault().Name)) { identity.AddClaim(new Claim("Age", "16")); var props = new AuthenticationProperties(new Dictionary <string, string> { { "userdisplayname", context.UserName }, { "role", "admin" } }); var ticket = new AuthenticationTicket(identity, props); context.Validated(ticket); } else { context.SetError("invalid_grant", "Provided username and password is incorrect"); context.Rejected(); } } } else { context.SetError("invalid_grant", "Provided username and password is incorrect"); context.Rejected(); } return; } }
//[Route("api/Employees/Login")] //[HttpPost] //public IHttpActionResult Login([FromBody] Models.Employee emp) //{ // return Ok("Reacher here"); //} // POST api/<controller> //public void Post([FromBody]string value) //{ // string s = value; //} // PUT api/<controller>/5 //public void Put(int id, [FromBody]Models.Employee emp) //{ // string text = emp.Name; //} // DELETE api/<controller>/5 public async Task <IHttpActionResult> Delete(int id) { using (var context = new WebAPIDemoDBEntities()) { var employee = context.Employees.ToList().FirstOrDefault((p) => p.Id == id); if (employee == null) { return(NotFound()); } else { context.Employees.Remove(employee); await context.SaveChangesAsync(); return(Ok(MapFromDAL(employee))); } } }
// POST api/<controller> //public void Post([FromBody]string value) //{ // string s = value; //} // PUT api/<controller>/5 //public void Put(int id, [FromBody]Models.Employee emp) //{ // string text = emp.Name; //} // DELETE api/<controller>/5 public IHttpActionResult Delete(int id) { using (var context = new WebAPIDemoDBEntities()) { var employee = context.Employees.ToList().FirstOrDefault((p) => p.Id == id); if (employee == null) { return(NotFound()); } else { context.Employees.Remove(employee); context.SaveChanges(); return(Get()); } } }
public async Task <IHttpActionResult> PostEmployee([FromBody] Models.Employee emp) { //string s = employee.Name; //return Ok(employee); using (var context = new WebAPIDemoDBEntities()) { WebAPI_DB.Employee employee = null; if (emp.Id == 0) //Add employee { employee = new WebAPI_DB.Employee(); employee = MapToDAL(emp, employee); //employee.Id = DBNull.Value; context.Employees.Add(employee); } else { employee = context.Employees.ToList().FirstOrDefault((p) => p.Id == emp.Id); employee = MapToDAL(emp, employee); } await context.SaveChangesAsync(); //var employee = context.Employees.ToList().FirstOrDefault((p) => p.Id == id); //if (employee == null) //{ // return NotFound(); //} return(Ok(employee)); } //if (!ModelState.IsValid) //{ // return BadRequest(ModelState); //} //_context.employee.Add(employee); //await _context.SaveChangesAsync(); //return CreatedAtAction("GetEmployee", new //{ // id = employee.ID //}, employee); }
//private DataContext _context; //public UserService(DataContext context) //{ // _context = context; //} public Models.Employee Authenticate(string username, string password) { if (string.IsNullOrEmpty(username) || string.IsNullOrEmpty(password)) { return(null); } using (var context = new WebAPIDemoDBEntities()) { var emp = context.Employees.SingleOrDefault(x => x.Username == username && x.Password == password); // check if user exists if (emp == null) { return(null); } // authentication successful return(MapFromDAL(emp)); } }