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