public IHttpActionResult Login(UserLogin objLogin)
{
UserDataAccessLayer objUserDAL = new UserDataAccessLayer();
UserLogin obj = objUserDAL.Login(objLogin);
return(Ok(obj));
}
public IActionResult UserHome(TransferDetails transferDetails)
{
ViewData["Balance"] = GetBalance();
if (transferDetails.Amount != null)
{
var userData = new UserDataAccessLayer();
var FromAddress = LoginController.email;
var ToAddress = transferDetails.Address;
var Amount = decimal.Parse(transferDetails.Amount);
var Type = "transaction";
var LoginStatus = userData.ValidateUserEmail(ToAddress);
if (GetBalance() >= Amount && LoginStatus == "Success")
{
using (WebSocket web = new WebSocket(url))
{
web.Connect();
web.Send(JsonConvert.SerializeObject(new { Type, FromAddress, ToAddress, Amount }));
Thread.Sleep(5000);
web.Close();
}
}
else
{
TempData["UserEmailFailed"] = "The email you’ve entered doesn’t match any account";
}
}
return(View());
}
//public static IApplicationBuilder UseJwtValidationAtDatabase(this IApplicationBuilder app)
//{
// return app.UseMiddleware<JwtMidddleware>();
//}
public static void UseJwtValidationAtDatabase(this IApplicationBuilder app, IConfiguration config)
{
app.Use(async delegate(HttpContext context, Func <Task> next)
{
if (context.Request.Headers.ContainsKey("Authorization"))
{
var claims = context.User.Claims;
string name = claims.Single(x => x.Type == ClaimTypes.Name).Value;
string role = claims.Single(x => x.Type == ClaimTypes.Role).Value;
string ConnectionString = config.GetSection("ConnectionStrings").GetSection(Connection.ConnectionName).Value;
UserDataAccessLayer dal = new UserDataAccessLayer(ConnectionString);
User _model = new User {
userName = name
};
TitleValidationStatus _titleValidate = await dal.getUserTitle(_model);
if (role != _titleValidate.validateMessage)
{
context.Response.ContentType = "text/plain";
context.Response.StatusCode = StatusCodes.Status403Forbidden;
var message = new { validateResult = "403db", validateMessage = "" };
await context.Response.WriteAsync(JsonConvert.SerializeObject(message));
return;
}
}
await next.Invoke();
});
}
private async Task <bool> ManualValidateRole(string token, string _role)
{
var tokenHandler = new JwtSecurityTokenHandler();
var securityToken = tokenHandler.ReadToken(token) as JwtSecurityToken;
var claims = securityToken.Claims;
string name = claims.First(x => x.Type == "unique_name").Value;
string role = claims.First(x => x.Type == "role").Value;
if (String.IsNullOrEmpty(name) || String.IsNullOrEmpty(role))
{
return(false);
}
string ConnectionString = Configuration.GetSection("ConnectionStrings").GetSection(Connection.ConnectionName).Value;
UserDataAccessLayer dal = new UserDataAccessLayer(ConnectionString);
User _model = new User {
userName = name
};
TitleValidationStatus _titleValidate = await dal.getUserTitle(_model);
if (role != _titleValidate.validateMessage || role != _role)
{
return(false);
}
return(true);
}
public HttpResponseMessage CreateUser(User user)
{
UserDataAccessLayer userDAL = new UserDataAccessLayer();
var dynObj = new { result = userDAL.Create(user.Username, user.Pwd, user.Email) };
HttpResponseMessage message = Request.CreateResponse(HttpStatusCode.OK, dynObj);
return(message);
}
public bool RegisterUser(User userModel)
{
using (UserDataAccessLayer userDL = new UserDataAccessLayer())
{
var responseModel = userDL.RegisterUser(userModel);
}
return(true);
}
public UserController(IConfiguration _config, IJwtService _jwtService, IEmailSender _sender)
{
sender = _sender;
ConnectionString = _config.GetSection("ConnectionStrings").GetSection(Connection.ConnectionName).Value;
DefautltPageSize = Convert.ToInt64(_config.GetSection("DbPaging").GetSection("DefaultPageSize").Value);
DefaultRequestPage = Convert.ToInt64(_config.GetSection("DbPaging").GetSection("DefaultRequestPage").Value);
SecurityKey = _config.GetSection("SecuritySettings").GetSection("Secret").Value;
jwtService = _jwtService;
dal = new UserDataAccessLayer(ConnectionString);
}
public void InsertUser()
{
var u = new User();
u.Email = "UNITTEST";
u.Password = "******";
var d = new UserDataAccessLayer();
d.AddUser(u.Email, u.Password);
Assert.True(d.AddUser(u.Email, u.Password));
}
protected void adminGrid_Sorting(object sender, GridViewSortEventArgs e)
{
SortDirection sortDirection = SortDirection.Ascending;
string sortField = string.Empty;
SortGridview((GridView)sender, e, out sortDirection, out sortField);
string strSortDirection = sortDirection == SortDirection.Ascending ? "ASC" : "DESC";
adminGrid.DataSource = UserDataAccessLayer.GetAllUsers(e.SortExpression + " " + strSortDirection);
adminGrid.DataBind();
}
private decimal GetBalance()
{
TransferDetails transferDetails = new TransferDetails();
using (SqlConnection connection = new SqlConnection(UserDataAccessLayer.GetConnectionString()))
{
SqlCommand commandBalance = new SqlCommand("select dbo.ValidateUserEmail(@address)", connection);
commandBalance.Parameters.Add("@address", SqlDbType.VarChar);
commandBalance.Parameters["@address"].Value = LoginController.email;
connection.Open();
transferDetails.Balance = (decimal)commandBalance.ExecuteScalar();
}
return(transferDetails.Balance);
}
public int Post([FromBody] Login model)
{
int returnVal = 0;
ExceptionDataAccessLayer ExcData = new ExceptionDataAccessLayer();
try
{
returnVal = new UserDataAccessLayer().Login(model.Email, model.Password);
}
catch (Exception ex)
{
ExcData.RegisterException((int)ExceptionDataAccessLayer.ExceptionEnum.Error, ex.Message);
}
return(returnVal);
}
public UserController(IConfiguration config)
{
this.configuration = config;
objUserModel = new UserDataAccessLayer(configuration);
objRoleModel = new RoleDataAccessLayer(configuration);
}
public UserBusinessLogic()
{
_userDataAccessLayer = new UserDataAccessLayer();
}
public UserController(APIContext apicontext)
{
objUser = new UserDataAccessLayer(apicontext);
}
public User GetUserInfo(string username, string pwd)
{
UserDataAccessLayer userDAL = new UserDataAccessLayer();
return(userDAL.GetUserInfo(username, pwd));
}
public UserStore(IConfiguration configuration)
{
this.configuration = configuration;
objuser = new UserDataAccessLayer(configuration);
objRole = new RoleDataAccessLayer(configuration);
}
