public User Get(int id) { using (UsersDbEntities entities = new UsersDbEntities()) { return(entities.Users.FirstOrDefault <User>(e => e.UserID == id)); } }
public HttpResponseMessage IHttpActionResult([FromBody] RegisterModel model) { _mapper = new RegisterMapper(); _valid = new RegisterValidator(); HttpResponseMessage response = new HttpResponseMessage(); UsersDbEntities usersDbEntities = new UsersDbEntities(); if (_valid.Valid(model)) { usersDbEntities.users.Add(_mapper.MapToUser(model)); usersDbEntities.SaveChanges(); response.Content = new StringContent("ok", Encoding.Unicode); response.StatusCode = HttpStatusCode.OK; return(response); } else { response.Content = new StringContent("user already exist", Encoding.Unicode); response.StatusCode = HttpStatusCode.Conflict; return(response); } //catch (Exception ex) //{ // // return error message if there was an exception // return response; //} }
public HttpResponseMessage Delete(int id, [FromBody] User user) { try { using (UsersDbEntities entities = new UsersDbEntities()) { var entity = entities.Users.FirstOrDefault(e => e.UserID == id); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "User with UserID = " + id + " not found to update.")); } else { entity.LoginID = user.LoginID; entity.FirstName = user.FirstName; entity.LastName = user.LastName; entity.CheckFirstTimeLogin = user.CheckFirstTimeLogin; entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, entity)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public IEnumerable <User> Get() { using (UsersDbEntities entities = new UsersDbEntities()) { return(entities.Users.ToList()); } }
private HttpResponseMessage Get() { using (UsersDbEntities dc = new UsersDbEntities()) { _usersList = dc.users.OrderBy(a => a.username).ToList(); HttpResponseMessage response; response = Request.CreateResponse(HttpStatusCode.OK, _usersList); return(response); } }
public users MapToUser(RegisterModel register) { UsersDbEntities usersDbEntities = new UsersDbEntities(); users user = new users() { password = register.Password, username = register.UserName, }; return(user); }
public HttpResponseMessage IHttpActionResult([FromBody] RegisterModel model) { // map model to entity HttpResponseMessage response = new HttpResponseMessage(); UsersDbEntities usersDbEntities = new UsersDbEntities(); try { // create user usersDbEntities.users.Add(_mapper.MapToUser(model)); usersDbEntities.SaveChanges(); return(response); } catch (Exception ex) { // return error message if there was an exception return(response); } }
public HttpResponseMessage Post([FromBody] User user) { try { using (UsersDbEntities entities = new UsersDbEntities()) { entities.Users.Add(user); entities.SaveChanges(); var message = Request.CreateResponse(HttpStatusCode.Created, user); message.Headers.Location = new Uri(Request.RequestUri + user.UserID.ToString()); return(message); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public HttpResponseMessage Delete(int id) { try { using (UsersDbEntities entities = new UsersDbEntities()) { var entity = entities.Users.FirstOrDefault(e => e.UserID == id); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "User with UserID = " + id + " is not found.")); } else { entities.Users.Remove(entity); entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public AdminPanel(Form login) { InitializeComponent(); _db = new UsersDbEntities(); _login = login; }
public Login() { InitializeComponent(); _db = new UsersDbEntities(); }
public Register(Form login) { InitializeComponent(); _login = login; _db = new UsersDbEntities(); }
public CreateType() { InitializeComponent(); _db = new UsersDbEntities(); }
public bool Valid(RegisterModel model) { UsersDbEntities Db = new UsersDbEntities(); return(!Db.users.Any(x => x.username.Equals(model.UserName))); }