public User SignIn(string loginId, string password) { User objUser = new User(); try { LoginDA objLoginDA = new LoginDA(); DataTable dtResponse = objLoginDA.SignIn(loginId, password); if (dtResponse != null && dtResponse.Rows.Count > 0) { objUser.UserId = Convert.ToInt32(dtResponse.Rows[0]["UserId"]); objUser.UserTypeId = Convert.ToInt32(dtResponse.Rows[0]["UserTypeId"]); objUser.FirstName = Convert.ToString(dtResponse.Rows[0]["FirstName"]); objUser.LastName = Convert.ToString(dtResponse.Rows[0]["LastName"]); objUser.MobileNo = Convert.ToString(dtResponse.Rows[0]["MobileNo"]); objUser.EmailId = Convert.ToString(dtResponse.Rows[0]["EmailId"]); } } catch (Exception ex) { throw; } return(objUser); }
private void button1_Click(object sender, EventArgs e) { if (String.IsNullOrEmpty(textBox1.Text) || String.IsNullOrEmpty(textBox2.Text)) { MessageBox.Show("Error: Falta llenar algun campo"); } else { LoginDA login = new LoginDA(); int resultado = login.ValidarUsuario(textBox1.Text, textBox2.Text); if (resultado == 1) { Hide(); idActual = textBox1.Text; textBox2.Text = null; int nivelUsuario = login.ObtenerNivelUsuario(idActual); FormMain menu = new FormMain(idActual, nivelUsuario); menu.Show(); menu.Owner = this; } else if (resultado == 0) { MessageBox.Show("ID o contraseña incorrecta"); } else if (resultado == -1) { MessageBox.Show("Error en la conexion con la base de datos"); } } }
private void button8_Click(object sender, EventArgs e) { LoginDA cerrar = new LoginDA(); cerrar.cerrarSesion(idActual); Owner.Show(); Dispose(); }
public async Task <ActionResult> GetLocalLogin([FromBody] LoginDTO loginInfo) { StringValues clientConnectionString; try { if (HttpContext.Request.Headers.TryGetValue("ConnectionString", out clientConnectionString)) { if (ModelState.IsValid) { _loginDA = new LoginDA(); var result = _loginDA.GetLocalLogin(loginInfo, clientConnectionString); if (result.ReturnValue == -1) { return(BadRequest(new ErrorResponseDTO() { MessageCode = _messageCodePrefix + result.Result, ErrorType = "Bad Request", RequestId = HttpContext.TraceIdentifier.ToString() })); } else { //result.Table.AuthorizationToken = GenearteJWTToken.GenerateToken(result.Table.UserId.ToString()); //dynamic response = await GenearteJWTToken.GenerateToken(); //if (response.ToString() != "Token Invalid") // result.Table.AuthenticationToken = ((Newtonsoft.Json.Linq.JValue)((Newtonsoft.Json.Linq.JProperty)((Newtonsoft.Json.Linq.JContainer)response).Last).Value).Value.ToString(); //else // return BadRequest(); SuccessResponseDTO <LoginDTO> loginSuccessDTO = new SuccessResponseDTO <LoginDTO>().CreateSuccessResponse(result.Table, _messageCodePrefix + result.Result, HttpContext.TraceIdentifier.ToString()); return(Ok(loginSuccessDTO)); } } else { return(BadRequest()); } } else { return(BadRequest()); } } catch (Exception ex) { _logger.LogCritical(ex.ToString()); return(StatusCode(500, new ErrorResponseDTO() { MessageCode = "Inernal server error", RequestId = HttpContext.TraceIdentifier.ToString(), ErrorType = ex.Message.ToString() })); } }
protected void Page_Load(object sender, EventArgs e) { LoginDA loginDA = new LoginDA(); DataSet dslogin = null; dslogin = loginDA.FetchFirstname(Convert.ToInt32(Session["UserID"].ToString())); ReportDataSource rd = new ReportDataSource("DataSet1", FetchFirstname((Convert.ToInt32(Session["UserID"].ToString())))); ReportViewer1.Reset(); ReportViewer1.LocalReport.DataSources.Add(rd); ReportViewer1.LocalReport.ReportPath = "Report1.rdlc"; }
public UserViewEntity LoginOut(UserViewEntity entity) { entity.IsLoggedIn = true; int sysno = LoginDA.LointOut(ref entity); if (sysno > 0) { entity.IsLoggedIn = false; } return(entity); }
public List <LoginEntity> Get(LoginEntity loginEntity) { var result = new List <LoginEntity>(); loginEntity.Password = UtilityHelper.PasswordHash(loginEntity.Password); using (var loginDA = new LoginDA()) { result = loginDA.Get(loginEntity).ToList <LoginEntity>(); } return(result); }
private void FormMain_FormClosing(object sender, FormClosingEventArgs e) { DialogResult res = MessageBox.Show("Salir de esta ventana tambien cerrará la sesión actual ¿Seguro que desea continuar?", "Mensaje", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning); if (res == DialogResult.OK) { LoginDA cerrar = new LoginDA(); cerrar.cerrarSesion(idActual); Owner.Show(); } else { e.Cancel = true; } }
public LoginBO AuthenticateUser(string UserName, string Password) { try { DataSet ds = new DataSet(); DataTable dt1 = new DataTable(); LoginDA objLoginDA = new LoginDA(); ds = objLoginDA.AuthenticateUser(UserName, Password); dt1 = ds.Tables[0]; LoginBO objLoginBO = new LoginBO(); if (dt1.Rows.Count > 0) { if (Convert.ToInt32(dt1.Rows[0]["Result"]) > 0) { objLoginBO.Id = (Guid)dt1.Rows[0]["Id"]; objLoginBO.Email = Convert.ToString(dt1.Rows[0]["Email"]); objLoginBO.UserName = Convert.ToString(dt1.Rows[0]["UserName"]); objLoginBO.RoleId = Convert.ToInt32(dt1.Rows[0]["RoleId"]); objLoginBO.Password = Convert.ToString(dt1.Rows[0]["Password"]); } else { objLoginBO = null; } } return(objLoginBO); } catch (Exception ex) { throw ex; } finally { // objLoginDa = null; } }
public void Login(String NombreUsuario, String Contrasenia) { try { Usuario usuario = null; loginDA = new LoginDA(); DataTable dt; String cadenaCifrada = CadenaMD5.cadenaToMD5(Contrasenia); dt = loginDA.Login(NombreUsuario, cadenaCifrada); if (dt.Rows.Count > 0) { DataRow fila = dt.Rows[0]; usuario = new Usuario(); usuario.UsuarioId = Convert.ToInt32(fila["usuarioid"]); usuario.UserName = fila["username"].ToString(); usuario.ClaveAcceso = fila["claveacceso"].ToString(); if (!Convert.IsDBNull(fila["fechacreacion"])) { usuario.FechaCreacion = Convert.ToDateTime(fila["fechacreacion"]); } usuario.ColaboradorId = !Convert.IsDBNull(fila["colaboradorid"]) ? Convert.ToInt32(fila["colaboradorid"]) : 0; usuario.Activo = Convert.ToBoolean(fila["activo"]); } if (usuario != null) { SesionUsuario.Usuario = usuario; } } catch (Exception ex) { throw ex; } }
public LoginBL() { //strCnx = ConfigurationManager.ConnectionStrings["cnxChelita"].ConnectionString; strCnxRule = ConfigurationManager.ConnectionStrings["cnxRules"].ConnectionString; oLoginDA = new LoginDA(); }
public LoginFactory() { obj = new LoginDA(); }
public static UserInfo UserLogin(string userName, string userPassword) { return(LoginDA.Login(userName, userPassword)); }
public override bool FinishedLaunching(UIApplication application, NSDictionary launchOptions) { UIApplication.SharedApplication.SetMinimumBackgroundFetchInterval(UIApplication.BackgroundFetchIntervalMinimum); try { var loginDA = new LoginDA(Sqlite_IOS.DB.dataBase); InvokeOnMainThread(delegate { if (loginDA.GetInfoUsuario() == null) { autenticado = false; } else { autenticado = true; } }); } catch (Exception) { autenticado = false; } finally { #if !DEBUG var manager = BITHockeyManager.SharedHockeyManager; manager.Configure("642401fb0ca946e5ab22ab2c69cb2cb2"); manager.CrashManager.CrashManagerStatus = BITCrashManagerStatus.AutoSend; manager.StartManager(); #endif if (!autenticado) { var loginViewController = GetViewController(MainStoryboard, "Login") as LoginController; SetRootViewController(loginViewController, false); } else { var modelPDV = new MenuPdvsModel { dbGenericActivity = new GenericActDA(Sqlite_IOS.DB.dataBase), dbPdvs = new MenuPdvsDA(Sqlite_IOS.DB.dataBase) }; InvokeOnMainThread( delegate { modelPDV.infoUsuario = modelPDV.dbGenericActivity.GetUsersIDsLogged(); var visita = modelPDV.dbPdvs.GetVisitaAtual(); if (visita != null) { if (visita.Count > 0) { var TarefasViewController = GetViewController(MainStoryboard, "TarefasController") as TarefasController; SetRootViewController(TarefasViewController, false); } } }); #if !DEBUG if (modelPDV != null && modelPDV.infoUsuario[0] != null) { manager.UserId = modelPDV.infoUsuario[0].ID; manager.UserEmail = modelPDV.infoUsuario[0].SERVIDOR; manager.StartManager(); } #endif } } UNUserNotificationCenter.Current.GetNotificationSettings((settings) => { if (settings.AlertSetting != UNNotificationSetting.Enabled) { UNUserNotificationCenter.Current.RequestAuthorization(UNAuthorizationOptions.Alert, (approved, err) => { }); } if (settings.BadgeSetting != UNNotificationSetting.Enabled) { UNUserNotificationCenter.Current.RequestAuthorization(UNAuthorizationOptions.Badge, (approved, err) => { }); } if (settings.SoundSetting != UNNotificationSetting.Enabled) { UNUserNotificationCenter.Current.RequestAuthorization(UNAuthorizationOptions.Sound, (approved, err) => { }); } }); var authorizationStatus = AVCaptureDevice.GetAuthorizationStatus(AVMediaType.Video); if (authorizationStatus != AVAuthorizationStatus.Authorized) { AVCaptureDevice.RequestAccessForMediaTypeAsync(AVMediaType.Video); } UIApplication.SharedApplication.ApplicationIconBadgeNumber = 0; LocationHelper.UpdateLocation(); return(true); }
/// <summary> /// /// </summary> /// <param name="entity"></param> /// <returns></returns> public UserViewEntity Login(UserViewEntity entity) { entity = LoginDA.Login(ref entity); return(entity); }