Ejemplo n.º 1
0
        void EnteredAdminUser(User check_user)
        {
            flag        = true;
            num_table   = check_user.Id_WorkArea;
            currrent_id = check_user.Id;
            List <UsersSessions> list = null;

            try
            {
                list = ReadFromDatabase.AllUsersSessions(num_table).ToList();
            }
            catch { }
            if (list == null)
            {
                db.Database.ExecuteSqlCommand(
                    $"CREATE TABLE [dbo].[UserSessions_{num_table}] (" +
                    $"[Id]          INT           IDENTITY(1, 1) NOT NULL," +
                    $"[CurLogin]    NVARCHAR(50) NULL," +
                    $"[CurPassword] NVARCHAR(50)    NULL," +
                    $"[RememberMe]  Bit NULL," +
                    $"[IsActive]    Bit NULL," +
                    $"[AccessToken]    uniqueidentifier NULL," +
                    $"[DateEnter]   datetime NULL," +
                    $"[DateLeave]   datetime NULL)");

                session             = new UsersSessions();
                session.CurLogin    = login_txt.Text;
                session.CurPassword = passwd_txt.Password;
                session.RememberMe  = Convert.ToBoolean(remeber_check.IsChecked);
                session.DateEnter   = DateTime.Now;
                session.AccessToken = Guid.NewGuid();

                WorkAreas area_window = new WorkAreas(check_user.Id_WorkArea, check_user.Role, $"{check_user.First_Name} {check_user.Last_Name}", this);
                area_window.Owner = this;
                area_window.ShowDialog();
            }
            else
            {
                session             = new UsersSessions();
                session.CurLogin    = login_txt.Text;
                session.CurPassword = passwd_txt.Password;
                session.RememberMe  = Convert.ToBoolean(remeber_check.IsChecked);
                session.DateEnter   = DateTime.Now;
                session.AccessToken = Guid.NewGuid();

                new WorkAreas(check_user.Id_WorkArea, check_user.Role, $"{check_user.First_Name} {check_user.Last_Name}", this).ShowDialog();
            }
        }
Ejemplo n.º 2
0
        public async Task <Response> FindById(int id)
        {
            WorkAreas result = await _workAreaRepository.FindById(id);

            if (result.Id > 0)
            {
                return(new Response
                {
                    IsSuccess = true,
                    Message = "Se consulto exitosamente",
                    Result = result
                });
            }
            else
            {
                return(new Response
                {
                    IsSuccess = false,
                    Message = "Error"
                });
            }
        }
Ejemplo n.º 3
0
        public async Task <WorkAreas> FindById(int id)
        {
            using (SqlConnection sql = new SqlConnection(_connectionString))
            {
                using (SqlCommand cmd = new SqlCommand("usp_WorkSubArea_FindById", sql))
                {
                    cmd.CommandType = System.Data.CommandType.StoredProcedure;
                    cmd.Parameters.Add(new SqlParameter("@Id", id));
                    WorkAreas response = null;
                    await sql.OpenAsync();

                    using (var reader = await cmd.ExecuteReaderAsync())
                    {
                        if (reader != null)
                        {
                            response = reader.Translate <WorkAreas>().FirstOrDefault();
                        }
                    }

                    return(response);
                }
            }
        }