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