public ActionResult Login(Login_Model MyModel) { Login_DTO MyLogin_DTO = MyRepository.AuthenticationUser(MyModel); if (MyLogin_DTO != null && MyLogin_DTO.Result.StartsWith("success")) { MyLogin_DTO.Result = MyLogin_DTO.Result.Replace("success:", ""); SessionComponent.UID = MyLogin_DTO.ID; SessionComponent.UName = MyLogin_DTO.vName; SessionComponent.SessionID = Session.SessionID; return(RedirectToAction("Index", "Travel")); } else if (MyLogin_DTO != null && MyLogin_DTO.Result.StartsWith("fail")) { MyLogin_DTO.Result = MyLogin_DTO.Result.Replace("fail:", ""); TempData["msg"] = MyLogin_DTO.Result; TempData["Notification"] = Notification_Component.SetNotification((int)Notification_Component.Result.Info, MyLogin_DTO.Result); return(RedirectToAction("Login")); } else { TempData["msg"] = "Invalid credentials,Please try again!"; TempData["Notification"] = Notification_Component.SetNotification((int)Notification_Component.Result.Info, "Invalid credentials,Please try again!"); return(RedirectToAction("Login")); // TempData["Notification"] = Notification_Component.SetNotification((int)Notification_Component.Result.Info, "Invalid credentials,Please try again!"); } }
public ActionResult Login(Login_Model lm) { if (lm.Email == "*****@*****.**" && lm.password == "Admin") { Session["adminId"] = 1; return(RedirectToAction("category", "Default1")); } MasterHotelRegistration_model hotl = db.MasterHotelRegistrations.Where(x => x.EmailID == lm.Email).Where(x => x.Password == lm.password).Select(x => new MasterHotelRegistration_model() { HotelID = x.HotelID, HotelName = x.HotelName }).SingleOrDefault(); if (hotl != null) { Session["HotelId"] = hotl.HotelID; Session["HotelName"] = hotl.HotelName; return(RedirectToAction("Edit", "HotelRegistration")); } else { ViewBag.Message = "Enter Valid Username Or Password"; return(View()); } }
public void User() { var loginModel = new Login_Model(); loginModel.Email = "*****@*****.**"; loginModel.password = "******"; var validation1 = new Validation(); var LoginTrueOrNot = validation1.CheckWhetherUserIdOrNot(loginModel); Assert.IsTrue(LoginTrueOrNot); }
public void HotelAdminLogIn() { var loginModel = new Login_Model(); loginModel.Email = "*****@*****.**"; loginModel.password = "******"; var validation1 = new Validation(); var LoginTrueOrNot = validation1.CheckWhetherAdminHotelIdOrNot(loginModel); Assert.IsTrue(LoginTrueOrNot); }
public static List <Login_Model> getUserInformation(SqlConnection connection, string user_domain) { var returnvalue = new List <Login_Model>(); StringBuilder sQuery = new StringBuilder(); sQuery.Append(@"SELECT u.User_Name ,u.User_Email ,u.User_Access ,u.idUser FROM a_Users as u LEFT JOIN a_User_Product as up ON u.idUser = up.idUser WHERE User_Domain = @user_domain"); connection.Open(); using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = connection; cmd.CommandText = sQuery.ToString(); cmd.CommandType = CommandType.Text; SqlParameter parm1 = new SqlParameter { ParameterName = "@user_domain", SqlDbType = SqlDbType.NVarChar, Value = user_domain }; cmd.Parameters.Add(parm1); var oreader = cmd.ExecuteReader(); while (oreader.Read()) { Login_Model oModel = new Login_Model { User_Name = (string)oreader["User_Name"], User_Email = (string)oreader["User_Email"], User_Access = (string)oreader["User_Access"], idUser = (int)oreader["idUser"] }; returnvalue.Add(oModel); } oreader.Close(); cmd.Dispose(); } connection.Close(); return(returnvalue); }
public bool CheckWhetherUserIdOrNot(Login_Model lm) { UserRegistration_model user = db.UserRegistrations.Where(x => x.UserName == lm.Email).Where(x => x.Password == lm.password).Select(x => new UserRegistration_model() { UserID = x.UserID, UserName = x.UserName }).FirstOrDefault(); if (user != null) { return(true); } return(false); }
public bool CheckWhetherAdminHotelIdOrNot(Login_Model lm) { if (lm.Email == "*****@*****.**" && lm.password == "Admin") { return(true); } MasterHotelRegistration_model hotl = db.MasterHotelRegistrations.Where(x => x.EmailID == lm.Email).Where(x => x.Password == lm.password).Select(x => new MasterHotelRegistration_model() { HotelID = x.HotelID, HotelName = x.HotelName }).FirstOrDefault(); if (hotl != null) { return(true); } return(false); }
/******Método para Login de los Usuarios******/ public static List <Login_Model> Login(string v1, string v2) { var Usuario = new List <Login_Model>(); SqlConnection SqlCon = new SqlConnection(Conexion_Data.Cn); try { DataTable UsuariosRegistrados = new DataTable("Usuario_Logueado"); SqlCon.Open(); SqlCommand SqlCmd = new SqlCommand("spUsuario_Login", SqlCon); SqlCmd.CommandType = CommandType.StoredProcedure; SqlParameter SqlParUsername = new SqlParameter("@username", v1); SqlCmd.Parameters.Add(SqlParUsername); SqlParameter ParPassword = new SqlParameter("@password", v2); SqlCmd.Parameters.Add(ParPassword); SqlDataAdapter SqlDa = new SqlDataAdapter(SqlCmd); SqlDa.Fill(UsuariosRegistrados); foreach (DataRow row in UsuariosRegistrados.Rows) { var obj = new Login_Model() { IdUsuario = (int)row["id"], UserName = (string)row["username"], TipoUsuario = (string)row["tipousuario"], Imagen = row["img"].Equals("") ? Accesoria.ByteToImage((byte[])row["img"]) : new BitmapImage(new Uri("pack://application:,,,/Resource/Images/Background/userDefault.png", UriKind.Absolute)) }; Usuario.Add(obj); } return(Usuario); } catch (Exception ex) { MessageBox.Show(ex.ToString(), "SAIP Bismarck franco Hoyos", MessageBoxButton.OK, MessageBoxImage.Error); return(Usuario = null); } finally { if (SqlCon.State == ConnectionState.Open) { SqlCon.Close(); } } }
public static int authentication(Login_Model login) { int count = 0; string connString = ConfigurationManager.ConnectionStrings["pos"].ConnectionString; SqlConnection conn = new SqlConnection(connString); SqlCommand cmd = new SqlCommand("sp_auth", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@username", SqlDbType.NVarChar, 50).Value = login.username; cmd.Parameters.Add("@password", SqlDbType.NVarChar, 100).Value = login.password; conn.Open(); count = (int)cmd.ExecuteScalar(); conn.Close(); return(count); }
public async Task <IActionResult> Login([FromBody] Login_Model model) { var user = await _userManager.FindByNameAsync(model.Username); if (user != null && await _userManager.CheckPasswordAsync(user, model.Password)) { var userRoles = await _userManager.GetRolesAsync(user); var authClaims = new List <Claim> { new Claim(ClaimTypes.Name, user.UserName), new Claim(JwtRegisteredClaimNames.Jti, Guid.NewGuid().ToString()), }; foreach (var userRole in userRoles) { authClaims.Add(new Claim(ClaimTypes.Role, userRole)); } var authSigningKey = new SymmetricSecurityKey(Encoding.UTF8.GetBytes(_configuration["JWT:Secret"])); var token = new JwtSecurityToken( issuer: _configuration["JWT:ValidIssuer"], audience: _configuration["JWT:ValidAudience"], expires: DateTime.Now.AddHours(3), claims: authClaims, signingCredentials: new SigningCredentials(authSigningKey, SecurityAlgorithms.HmacSha256) ); return(Ok(new { token = new JwtSecurityTokenHandler().WriteToken(token), expiration = token.ValidTo, UserName = user.UserName, Roles = userRoles, Status = "success" })); } return(Ok(new Response { Status = "failed", Message = "invalid username or password." })); }
private void btn_login_Click(object sender, EventArgs e) { Login_Model login = new Login_Model() { username = txt_username.Text, password = txt_password.Text }; int is_auth = Login_Bus.authentication(login); if (is_auth == 1) { // User Authentiacated this.Hide(); Dashboard dashboard = new Dashboard(); dashboard.Show(); } else { MessageBox.Show("Invalid Credentials!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public Login_DTO AuthenticationUser(Login_Model MyModel) { Login_DTO MyModelList = new Login_DTO(); try { using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["MyConnection"].ConnectionString)) { DynamicParameters MyDynamicParameters = new DynamicParameters(); MyDynamicParameters.Add("@LoginID", MyModel.vLoginID); MyDynamicParameters.Add("@Password", MyModel.vPassword); MyModelList = con.Query <Login_DTO>("ProcLoginUser", MyDynamicParameters, commandType: CommandType.StoredProcedure).FirstOrDefault(); } } catch (Exception Exc) { // Error_Component.ManageError(new Error_DTO { vAction_Type = "Repository", vController = "Account_Repository", vAction = "AuthenticationUser", vError_Message = Exc.Message, vError_Line = "", vInput_Values = "", vRemarks = "" }); } return(MyModelList); }
public ActionResult Login(Login_Model model) { if (ModelState.IsValid) { using (testEntities1 dataContext = new testEntities1()) { RegisterUser user = dataContext.RegisterUsers.Where(query => query.Email.Equals(model.Email) && query.Password.Equals(model.Password)).SingleOrDefault(); if (user != null) { FormsAuthentication.SetAuthCookie(model.Email, false); Session["Email"] = user.Email.ToString(); return(RedirectToAction("Index")); } else { //If the username and password combination is not present in DB then error message is shown. ModelState.AddModelError("Failure", "Wrong Username and password combination !"); return(View()); } } } return(View(model)); }
public static int authentication(Login_Model login) { int is_auth = Login_DB.authentication(login); return(is_auth); }
public ActionResult Login() { Login_Model MyModel = new Login_Model(); return(View(MyModel)); }
public void resp() { Login_Model obj = new Login_Model(); obj.login(); }