public async Task <ActionResult <Userdetail> > PostUserdetail(Userdetail userdetail) { _context.Userdetail.Add(userdetail); await _context.SaveChangesAsync(); return(CreatedAtAction("GetUserdetail", new { id = userdetail.Id }, userdetail)); }
public async Task <IActionResult> PutUserdetail(int userid, [FromBody] Userdetail userdetail) { //if (email != userdetail.Email) //{ // return BadRequest(); //} _context.Entry(userdetail).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { //throw e; if (!UserdetailExists(userdetail.UserId)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <ActionResult <IEnumerable <Userdetail> > > PostUserdetail(Userdetail userdetail) { try { //DateTime? datetime = userdetail.Dob; //var date = datetime.ToString();//.Replace("00:00:00", ""); //var date_format = DateTime.ParseExact(date, "dd-MM-yyyy hh:mm:ss", // CultureInfo.InvariantCulture); //var exact_date =date_format.ToString("yyyy-MM-dd"); var email_exists = _context.Userdetail.FirstOrDefault(em => em.Email.ToLower() == userdetail.Email); if (email_exists == null) { //var RegisterUserDetails = _context.Userdetail.FromSqlRaw // ("CALL RegisterUser" + "(" +"'"+ userdetail.FirstName+"'"+","+ "'" + userdetail.LastName + "'" + ","+ // "'" + userdetail.Email + "'" + "," + "'" + exact_date + "'" + "," + "'" + userdetail.Pwd + "'" + ","+ // "'" + userdetail.Telephone + "'" + "," + "'" + userdetail.SecQid + "'" + "," + "'" + userdetail.SecQa + "'"+ ")").ToList(); _context.Userdetail.Add(userdetail); await _context.SaveChangesAsync(); return(CreatedAtAction("GetUserdetail", new { id = userdetail.UserId }, userdetail)); //return RegisterUserDetails; } else { return(NotFound()); } } catch (Exception e) { throw e; } }
public async Task <IActionResult> PutUserdetail(int id, Userdetail userdetail) { if (id != userdetail.Id) { return(BadRequest()); } _context.Entry(userdetail).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!UserdetailExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public IActionResult Login(Userdetail tologin) { if (tologin == null) { errorMsg = "用户名或密码不能为空"; return(Redirect(Url.Action("Index", "Home"))); } var model = userService.ShowDetail(tologin.Uid); if (model == null || model.Passwod != tologin.Passwod) { //ViewData["errorMsg"] = "showErrorMsg(\'用户名或密码错误!\');"; errorMsg = "用户名或密码错误"; return(Redirect(Url.Action("Index", "Home"))); } model.Passwod = null; UserrelationService relationService = new UserrelationService(); var relation = relationService.ShowDetail(tologin.Uid); var user = new User() { detail = model, relation = relation }; string json = JsonConvert.SerializeObject(user); this.Response.Cookies.Append("user", json); return(Redirect(Url.Action("Privacy", "Home"))); }
public HttpResponseMessage Put(int id, [FromBody] Userdetail user) { try { using (FlightsBookingInfoDatabaseEntities entities = new FlightsBookingInfoDatabaseEntities()) { var entity = entities.Userdetails.FirstOrDefault(e => e.id == id); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Employee with Id" + id.ToString() + "not found")); } else { entity.id = user.id; entity.fullName = user.fullName; entity.gender = user.gender; entity.email = user.email; entity.phoneNumber = user.phoneNumber; entity.dateOfBirth = user.dateOfBirth; entity.roleType = user.roleType; entity.userName = user.userName; entity.passowrd = user.passowrd; entity.isActive = user.isActive; entity.photoPath = user.photoPath; entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, entity)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public int DeleteUser(int userid) { Userdetail td = _db.Userdetails.Where(c => c.id == userid).FirstOrDefault(); _db.Userdetails.Remove(td); return(_db.SaveChanges()); }
public ActionResult DeleteConfirmed(int id) { Userdetail userdetail = db.Userdetails.Find(id); db.Userdetails.Remove(userdetail); db.SaveChanges(); return(RedirectToAction("Index")); }
public int Create(Userdetail detail) { using (var dbContext = new CasemanaContext()) { dbContext.Userdetail.Add(detail); dbContext.SaveChanges(); } return(detail.Uid); }
public Userdetail ShowDetail(int?uid) { Userdetail user = null; using (var dbContext = new CasemanaContext()) { user = dbContext.Userdetail.FirstOrDefault(x => x.Uid == uid); } return(user); }
public ActionResult Edit([Bind(Include = "PKUserId,UserName,Password,FirstName,LastName,EmailId,PhoneNo,IsActive")] Userdetail userdetail) { if (ModelState.IsValid) { db.Entry(userdetail).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(userdetail)); }
public ActionResult Create([Bind(Include = "PKUserId,UserName,Password,FirstName,LastName,EmailId,PhoneNo,IsActive")] Userdetail userdetail) { if (ModelState.IsValid) { db.Userdetails.Add(userdetail); db.SaveChanges(); return(RedirectToAction("LogOn", "Login")); } return(View(userdetail)); }
public int UpdateUser(UserDetails ud) { Userdetail td = _db.Userdetails.Where(c => c.id == ud.id).FirstOrDefault(); td.FirstName = ud.FirstName; td.LastName = ud.LastName; td.Email = ud.Email; td.Username = ud.Username; td.Password = ud.Password; td.Usertype = ud.Usertype; return(_db.SaveChanges()); }
public int AddNewUser(UserDetails ud) { Userdetail td = new Userdetail(); td.FirstName = ud.FirstName; td.LastName = ud.LastName; td.Email = ud.Email; td.Username = ud.Username; td.Password = ud.Password; td.Usertype = ud.Usertype; _db.Userdetails.Add(td); return(_db.SaveChanges()); }
//更新 public IActionResult Update(Userdetail detail) { if (userService.ShowDetail(detail.Uid).Uname != detail.Uname) { var relatonService = new UserrelationService(); var relation = relatonService.ShowDetail(detail.Uid); relation.Name = detail.Uname; relatonService.Update(relation); } var id = userService.Update(detail); return(Redirect(Url.Action("Detail", "_User") + $"?uid={id}")); }
public void UpdateUserDetail(Userdetail userDetail) { try { context.Entry(userDetail).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } catch (InvalidOperationException) { Userdetail oldEntry = context.Userdetails.Find(userDetail.PKUserId); context.Entry(oldEntry).CurrentValues.SetValues(userDetail); context.SaveChanges(); } }
// GET: ManageUserdetails/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Userdetail userdetail = db.Userdetails.Find(id); if (userdetail == null) { return(HttpNotFound()); } return(View(userdetail)); }
public IActionResult Create(Userdetail detail, Userrelation relation) { int count = 0; count = userService.Create(detail); if (count > 0) { relation.Uid = count; relation.Name = detail.Uname; relation.Ename = employService.ShowDetail(relation.Eid).Ename; relation.Proname = projectService.ShowDetail((int)relation.Proid).Proname; relatonService.Create(relation); } return(Redirect(Url.Action("Index", "_Userrelation"))); //else }
public async Task <ActionResult> getuserdetail(int id) { var userdetail = new Userdetail(); user uservalue = await _Context.users.FirstOrDefaultAsync(x => x.userid == id); if (uservalue == null) { return(Ok(userdetail)); } role rolevalue = await _Context.roles.FirstOrDefaultAsync(x => x.roleid == uservalue.roleid); userdetail.userid = uservalue.userid; userdetail.username = uservalue.username; userdetail.userfirstname = uservalue.userfirstname; userdetail.userlastname = uservalue.userlastname; userdetail.rolename = rolevalue.rolename; return(Ok(userdetail)); }
public HttpResponseMessage Post([FromBody] Userdetail user) { try { using (FlightsBookingInfoDatabaseEntities entities = new FlightsBookingInfoDatabaseEntities()) { entities.Userdetails.Add(user); entities.SaveChanges(); var message = Request.CreateResponse(HttpStatusCode.Created, user); message.Headers.Location = new Uri(Request.RequestUri + user.id.ToString()); return(message); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
private string CreateToken(Userdetail user) { string role = string.Empty; if (user.Ispublisher == true) { role = Common.USERROLES.PUBLISHER.ToString(); } else if (user.Iswriter == true) { role = Common.USERROLES.WRITER.ToString(); } else { role = Common.USERROLES.USER.ToString(); } List <Claim> claims = new List <Claim> { new Claim(ClaimTypes.NameIdentifier, user.Userdetailid.ToString()), new Claim(ClaimTypes.Name, user.Username), new Claim(ClaimTypes.Role, role) //new Claim(ClaimTypes.) }; SymmetricSecurityKey key = new SymmetricSecurityKey(Encoding.UTF8 .GetBytes(_configuration.GetSection("JwtSecretKey").Value)); SigningCredentials creds = new SigningCredentials(key, SecurityAlgorithms.HmacSha512Signature); SecurityTokenDescriptor tokenDescriptor = new SecurityTokenDescriptor { Subject = new ClaimsIdentity(claims), Expires = DateTime.Now.AddHours(1), SigningCredentials = creds }; JwtSecurityTokenHandler tokenHandler = new JwtSecurityTokenHandler(); SecurityToken token = tokenHandler.CreateToken(tokenDescriptor); return(tokenHandler.WriteToken(token)); }
public ActionResult LogOn(string txtUserName, string txtPassword, string chkRememberMe, string returnUrl) { if (ModelState.IsValid) { if (chkRememberMe == null) { chkRememberMe = "false"; } else { chkRememberMe = "true"; } if (txtUserName.Trim() == "admin" && txtPassword.Trim() == "admin") { Helper.CurrentUserRole = "Admin"; string adminDetails = "0" + "^" + "Admin" + "^" + "Admin"; Helper.UserData = adminDetails; FormsAuthentication.SetAuthCookie(adminDetails, Convert.ToBoolean(chkRememberMe)); return(RedirectToAction("AdminLogin")); } else { Userdetail userdetail = objUserDetailBO.AuthenticateUser(txtUserName, txtPassword); if (userdetail != null) { //Helper.CurrentUserID = userdetail.PKUserId; string UserData = string.Empty; UserData = userdetail.PKUserId + "^" + userdetail.FirstName + "^" + "User"; Helper.UserData = UserData; FormsAuthentication.SetAuthCookie(UserData, Convert.ToBoolean(chkRememberMe)); return(RedirectToAction("UserLogin")); } else { ViewBag.message = "Invalid User Name or Password"; return(View()); } } } return(View()); }
public HttpResponseMessage GetLoginUser(HttpRequestMessage request) { try { Userdetail user = objUserDetailsBO.GetById(Helper.CurrentUserID); if (user == null) { return(request.CreateResponse(HttpStatusCode.NoContent)); } return(request.CreateResponse(HttpStatusCode.OK, user)); } catch (Exception ex) { var resp = new HttpResponseMessage(HttpStatusCode.NotFound) { Content = new StringContent(ex.Message), ReasonPhrase = ex.Message }; throw new HttpResponseException(resp); } }
/// <summary> /// This method is used to update the existing user in the database. /// </summary> /// <remarks> /// DateCreated: 24th Oct 2016 /// Edited By: Rakesh (25-Oct-2016) , Phani (2-Nov-2016) /// </remarks> /// <exception cref="HttpResponseException">Will be thrown when there is a problem in updating existed user in database</exception> /// <param name="userDetail">contains the existing UserDetail in database</param> /// <param name="request">contains current request message</param> /// <returns>list of all UserDetails if HttpStatusCode is OK</returns> public HttpResponseMessage Put(Userdetail userDetail, HttpRequestMessage request) { try { if (!ModelState.IsValid) { return(request.CreateResponse(HttpStatusCode.BadRequest, GetErrorMessages())); } objUserDetailsBO.UpdateUserDetail(userDetail); return(request.CreateResponse(HttpStatusCode.OK, objUserDetailsBO.GetUserDetails())); } catch (Exception ex) { var resp = new HttpResponseMessage(HttpStatusCode.NotFound) { Content = new StringContent(ex.Message), ReasonPhrase = ex.Message }; throw new HttpResponseException(resp); } }
public async Task <dynamic> Create(Userdetail user) { if (user != null) { //validate for duplicate username if (dbContext.Userdetails.Where(x => x.Username == user.Username).Any()) { throw new Exception(string.Format(ValidationMessages.DUPLICATE, PropertyNames.USER)); } //add lastmodified date user.Lastmodifieddate = DateTime.UtcNow; //add the user to the db and save changes dbContext.Add(user); dbContext.SaveChanges(); return(await System.Threading.Tasks.Task.FromResult(user)); } return(null); }
public async Task <dynamic> Update(Userdetail user) { if (dbContext.Userdetails.Where(x => x.Username == user.Username && x.Userdetailid != user.Userdetailid).Any()) { throw new Exception(string.Format(ValidationMessages.DUPLICATE, PropertyNames.USER)); } //var objUser = dbContext.Users.Where(x => x.Userid == user.Userid).FirstOrDefault(); if (dbContext.Userdetails.Where(x => x.Userdetailid == user.Userdetailid && x.Lastmodifieddate == user.Lastmodifieddate).Any()) { user.Lastmodifieddate = DateTime.UtcNow; dbContext.Entry(user).State = EntityState.Modified; dbContext.SaveChanges(); return(await System.Threading.Tasks.Task.FromResult(user)); } else { throw new Exception(string.Format(ValidationMessages.DELETEDORUPDATED, PropertyNames.USER)); } }
//更新 public int Update(Userdetail detail) { int count = 0; using (var dbContext = new CasemanaContext()) { var x = dbContext.Userdetail.FirstOrDefault(u => u.Uid == detail.Uid); var password = x.Passwod; foreach (PropertyInfo info in typeof(Userdetail).GetProperties()) { PropertyInfo pro = typeof(Userdetail).GetProperty(info.Name); if (pro != null) { info.SetValue(x, pro.GetValue(detail)); } } x.Passwod = password; dbContext.Userdetail.Update(x); count = dbContext.SaveChanges(); } return(detail.Uid); }
public int Del(int uid) { int count = 0; using (var dbContext = new CasemanaContext()) { var user = new Userdetail() { Uid = uid }; dbContext.Userdetail.Attach(user); dbContext.Userdetail.Remove(user); //将要删除的对象附加到EF容器中 //context.Users.Attach(user); ////Remove()起到了标记当前对象为删除状态,可以删除 //context.Users.Remove(user); //context.SaveChanges(); //Console.WriteLine("删除成功"); count = dbContext.SaveChanges(); } return(count); }
public dynamic Login(LoginRequest request) { //ISession session = _httpContextAccessor.HttpContext.Session; if (string.IsNullOrEmpty(request.username) || string.IsNullOrEmpty(request.password)) { throw new Exception("Username or Password cannot be empty"); } //search from db if any user with the given username exist or not Userdetail user = _dbContext.Userdetails.Where(x => x.Username == request.username).Include(x => x.Timezone).FirstOrDefault(); if (user != null) { if (!Argon2.Verify(user.Userpassword, request.password)) { throw new Exception("The password is incorrect"); } else { AuthenticationResponse response = new AuthenticationResponse(); response.data = CreateToken(user: user); response.success = true; //byte[] userId = Encoding.ASCII.GetBytes(user.Userdetailid.ToString()); //session.Set("UserdetailId",userId); return(response); } } else { throw new Exception("This user does not exist"); } }
/// <summary> /// This method is used for authenticating User details and returning user data in string format /// </summary> /// <remarks> /// DateCreated: 4th Nov 2016 /// Edited By: Phani (5-Nov-2016) /// </remarks> /// <exception cref="HttpResponseException">Will be thrown when there is a problem in Retrieving data of user or any exception occurs due to Helper Properties</exception> /// <param name="model">contains current user login details</param> /// <param name="request">contains currrent request message</param> /// <returns>user data</returns> // POST: api/AuthenticateAPI public HttpResponseMessage Post([FromBody]LoginModel model,HttpRequestMessage request) { try { //if login user is admin if (model.UserName.ToLower() == "admin" && model.Password.ToLower() == "admin") { string UserData = string.Empty; UserData = model.UserName.ToLower() + "^" + model.Password.ToLower(); FormsAuthentication.SetAuthCookie(UserData, Convert.ToBoolean(model.RememberMe)); return request.CreateResponse(HttpStatusCode.OK, UserData); } //if login user is not admin else { //retrieving userdetails based on username and password Userdetail userdetail = objUserDetailBO.AuthenticateUser(model.UserName, model.Password); if (userdetail != null) { //setting user details in helper properties string UserData = string.Empty; UserData = userdetail.PKUserId + "^" + userdetail.UserName + "^" + "User"; //creating auth cookie for login user FormsAuthentication.SetAuthCookie(UserData, Convert.ToBoolean(model.RememberMe)); return request.CreateResponse(HttpStatusCode.OK, UserData); } else return request.CreateResponse(HttpStatusCode.NoContent); } } catch (Exception ex) { var resp = new HttpResponseMessage(HttpStatusCode.NotFound) { Content = new StringContent(ex.Message), ReasonPhrase = ex.Message }; throw new HttpResponseException(resp); } }