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);
}
}
